Need help with my assignment, got the right answer and the right formula written , In Excel File , I have just 6 hours, to solve it .Find attached Pivot table and sumIF assignment . Calculate the followings by using sumIF or sumifs and pivot table:

Date	Region	SalesRep	Sales
10/20/19	West	Gigi	$620
10/20/19	Northwest	Gigi	$484
10/21/19	West	Freddy	$376
10/22/19	Northwest	Freddy	$1,141
10/23/19	Northwest	Chin	$725
10/24/19	West	Chin	$222
10/25/19	West	June	$1,038
10/21/19	Northwest	Chin	$154
10/22/19	Northwest	Gigi	$205
10/23/19	Southwest	Gigi	$895
10/24/19	West	Chin	$1,254
10/25/19	Northwest	June	$596
10/24/19	Southwest	Gigi	$799
10/24/19	Northwest	Gigi	$651
10/24/19	West	June	$1,235
10/24/19	Southwest	Chin	$684
10/25/19	Northwest	June	$127
10/26/19	West	June	$269
10/25/19	Southwest	Chin	$739
10/26/19	West	Gigi	$1,201
10/26/19	Northwest	June	$546
10/26/19	Northwest	Chin	$162
10/20/19	West	Gigi	$620
10/20/19	Northwest	Gigi	$484
10/20/19	West	Freddy	$376
10/20/19	Northwest	Freddy	$1,141
10/20/19	Northwest	Chin	$725
10/20/19	West	Chin	$222
10/20/19	West	June	$1,038
10/21/19	Northwest	Chin	$154
10/21/19	Northwest	Gigi	$205
10/21/19	Southwest	Gigi	$895
10/21/19	West	Chin	$1,254
10/22/19	Northwest	June	$596
10/24/19	Southwest	Gigi	$799
10/24/19	Northwest	Gigi	$651
10/24/19	West	June	$1,235
10/24/19	Southwest	Chin	$684
10/24/19	Northwest	June	$127
10/24/19	West	June	$269
10/25/19	Southwest	Chin	$739
10/25/19	West	Gigi	$1,201
10/25/19	Northwest	June	$546
10/25/19	Northwest	Chin	$162

F G . Region Total Sales Northwest Southwest West J K Date Total Sales 10/20/19 10/21/19 10/22/19 10/23/19 10/24/19 10/25/19 10/26/19 N O SalesRep Total Sales June Chin Freddy Gigi calculate the followings by using Sumif or sumifs and pivot table Total Sales Region Northwest Southwest West Date Total Sales 201109 21/10/19 22/1019 2010 24/10/191 2571019 2619 SalesRep Toul Sales June Chin Freddy Gie Dale Region SalesRep Sales 2010/19 Wol 5620 20/10/19 Northwest $184 21/10/19 West Freddy 5376 22/10/19 Northwest Freddy $1.141 23/10/19 Northwest Chin $723 24/10/19 West Chin $223 25/10/19 Wet June S103 21/10/19 Northwest Chin $154 23/10/19 Northwest Gigi 5205 211019 Southwest Gigi $95 24/10/19 West Chin SI 254 25/10/19 Northwest une $596 24 10/19 Southwest Cingi $799 24/10/19 Northwest Gie $651 24/10/19 West June S1235 24/10/19 Southwest Chun $684 251W19 Northwest Pune $123 16/10/19 West June 5269 25/10/191 Southwest Chun $710 26/10/19 West Chigi $1.201 26/10/19 Northwest June 5546 26/10/19 Northwest Chin $162 2071019 West Gigi $620 20/10/19 Northwest Gies 5444 20/10/19 West Freddy $376 20/10/19 Northwest Freddy $1,141 201019Northwest Chun 5725 2010/19 West Chin 5222 20/10/19 West June $1.039 211019Northwest Chin 1154 21/10/19 Northwest Glei $205 21/10/19 Southwest Chi $895 21 10/19 West Chin SI 12/10/19 Northwest June 5596 24/10/19 Southwest Chi $799 211019 Northwest Gigi $651 14/10/19 West June S1.235 34/19/19 Southwest Chin 36x4 10/10/191 Northwest une 24/1019 West June $269 25/10/191 Southwest Chin 5739 25/1019 West IGIE S1.201 25/10/19 Northwest June $546 25/10/19 Northwest Chin 3162 $127