Need help with my assignment, got the right answer and the right formula written , I have just 16 hours, to solve it .

Find attached Pivot table and sumIF assignment .

Calculate the followings by using sumIF or sumifs and pivot table :

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Date Region Sales Rep Sales 10/20/19 West Gigi $620 10/20/19 Northwes Gigi $484 10/21/19 West Freddy $376 10/22/19 Northwest Freddy $1,141 10/23/19 Northwes Chin $725 10/24/19 West Chin $222 10/25/19 West June $1,038 10/21/19 Northwes Chin $154 10/22/19 Northwes Gigi $205 10/23/19 Southwes Gigi $895 10/24/19 West Chin $1.254 10/25/19 Northwest June $596 10/24/19 Southwes Gigi $799 10/24/19 Northwes Gigi $651 10/24/19 West June $1,235 10/24/19 Southwes Chin $684 10/25/19 Northwest June $127 10/26/19 West June $269 10/25/19 Southwes 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 Northwes Gigi $484 10/20/19 West Freddy $376 10/20/19 Northwes 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 Northwes Gigi $205 10/21/19 Southwes Gigi $895 10/21/19 West Chin $1,254 10/22/19 Northwest June $596 10/24/19 Southwes Gigi $799 10/24/19 Northwest Gigi $651 10/24/19 West June $1,235 10/24/19 Southwes Chin $684 10/24/19 Northwes June $127 10/24/19 West June $269 10/25/19 Southwes Chin $739 10/25/19 West Gigi $1,201 10/25/19 Northwest June $546 10/25/19 Northwes 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 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Date Region Sales Rep Sales 10/20/19 West Gigi $620 10/20/19 Northwes Gigi $484 10/21/19 West Freddy $376 10/22/19 Northwest Freddy $1,141 10/23/19 Northwes Chin $725 10/24/19 West Chin $222 10/25/19 West June $1,038 10/21/19 Northwes Chin $154 10/22/19 Northwes Gigi $205 10/23/19 Southwes Gigi $895 10/24/19 West Chin $1.254 10/25/19 Northwest June $596 10/24/19 Southwes Gigi $799 10/24/19 Northwes Gigi $651 10/24/19 West June $1,235 10/24/19 Southwes Chin $684 10/25/19 Northwest June $127 10/26/19 West June $269 10/25/19 Southwes 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 Northwes Gigi $484 10/20/19 West Freddy $376 10/20/19 Northwes 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 Northwes Gigi $205 10/21/19 Southwes Gigi $895 10/21/19 West Chin $1,254 10/22/19 Northwest June $596 10/24/19 Southwes Gigi $799 10/24/19 Northwest Gigi $651 10/24/19 West June $1,235 10/24/19 Southwes Chin $684 10/24/19 Northwes June $127 10/24/19 West June $269 10/25/19 Southwes Chin $739 10/25/19 West Gigi $1,201 10/25/19 Northwest June $546 10/25/19 Northwes 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