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.

Date	Product	Region	SalesRep	Customer	Sales	COGS		Gross Profit
4/19/2020	Product3	Region3	SalesRep2	Customer16	$ 14,046	$ 5,337		All products:
4/19/2020	Product7	Region4	SalesRep15	Customer72	$ 2,504	$ 1,703		Product9 only:
4/19/2020	Product2	Region4	SalesRep18	Customer71	$ 1,505	$ 843		Product3 and SalesRep16 only:
4/19/2020	Product6	Region4	SalesRep14	Customer88	$ 4,232	$ 2,793
4/19/2020	Product3	Region4	SalesRep3	Customer65	$ 5,947	$ 3,390
4/19/2020	Product1	Region8	SalesRep6	Customer100	$ 5,721	$ 3,204
4/19/2020	Product10	Region8	SalesRep16	Customer68	$ 14,744	$ 5,308
4/19/2020	Product7	Region2	SalesRep1	Customer85	$ 4,018	$ 2,371
4/19/2020	Product10	Region5	SalesRep6	Customer6	$ 6,442	$ 4,445