Directions are to not use helper column, filters, or Pivot Tables.

In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables - w Gross Profit All products: Product9 only: Product10 and Sales Rep15 only: Date 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 Product Region Product3 Region3 Product Region4 Product2 Region4 Producto Region4 Products Region4 Producti Region8 Product10 Regions Product7 Region2 Product10 | Region5 Product6 | Region4 Product Region2 Product2 Region4 Product Region4 Product Region2 Product2 Region8 Products Region8 Product101 Region3 Product4 Region6 Product4 | Regioni 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Sales Rep Customer SalesRep2 Customer16 SalesRep15 Customer72 SalesRep18 Customer71 SalesRep14 Customer88 SalesRep3 | Customer65 SalesRep6 Customer 100 SalesRep16 Customer68 SalesRepl Customer85 SalesRep6 | Customer6 SalesRep7 Customer1 SalesRep17 Customer28 SalesReps Customer16 SalesRep1 Customer95 SalesRep6 | Customer65 SalesRep16 Customer69 SalesRep10 Customer 10 SalesRep15 Customer14 SalesRep3 | Customer74 SalesRep17 Customer69 COGS 5,337 1,703 843 2,793 3,390 3,204 5,308 2,371 4,445 3,509 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Sales 14,046 $ 2,504 $ 1,505 $ 4,232 $ 5,947 $ 5,721 $ 14,744 $ 4,018 $ 6,442 $ 8,160 $ 7,520 $ 11,981 $ 2,468 $ 14,239 $ 2,455 $ 11,538 $ 4,341 $ 9,948 $ 6,525 $ 1 8,387 1,209 7,120 1,056 3,577 1,823 5,670 2,675