Question

EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is greater than or equal to its average.

Date	Product	Region	SalesRep	Customer	Sales	COGS		Sum of Sales:
4/19/2020	Product3	Region3	SalesRep2	Customer16	$           14,046	$             5,337
4/19/2020	Product7	Region4	SalesRep15	Customer72	$             2,504	$             1,703
4/19/2020	Product2	Region4	SalesRep18	Customer71	$             1,505	$                 843
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
4/19/2020	Product6	Region4	SalesRep7	Customer1	$             8,160	$             3,509
4/19/2020	Product7	Region2	SalesRep17	Customer28	$             7,520	$             4,738

Answer 1

In cell I4 insert the following formula to get the sum of Sales where COGS is greater than or equal to its average:

=IF(H2>=$H$14,G2,0)

H2 is the amount under head 'COGS'

H14 is the average of COGS

G2 is the respective sales amount

- image of excel is also uploaded along with this.

Date	Product	Region	SalesRep	Customer		Sales	COGS	Sum of Sales:
4/19/2020	Product3	Region3	SalesRep2	Customer16	$	14,046	5,337	14046
4/19/2020	Product7	Region4	SalesRep15	Customer72	$	2,504	1,703	0
4/19/2020	Product2	Region4	SalesRep18	Customer71	$	1,505	843	0
4/19/2020	Product6	Region4	SalesRep14	Customer88	$	4,232	2,793	0
4/19/2020	Product3	Region4	SalesRep3	Customer65	$	5,947	3,390	0
4/19/2020	Product1	Region8	SalesRep6	Customer100	$	5,721	3,204	0
4/19/2020	Product10	Region8	SalesRep16	Customer68	$	14,744	5,308	14744
4/19/2020	Product7	Region2	SalesRep1	Customer85	$	4,018	2,371	0
4/19/2020	Product10	Region5	SalesRep6	Customer6	$	6,442	4,445	6442
4/19/2020	Product6	Region4	SalesRep7	Customer1	$	8,160	3,509	8160
4/19/2020	Product7	Region2	SalesRep17	Customer28	$	7,520	4,738	7520
				Total		74,839	37,641	50912
				Average		6,804	3,422

Note: The formula computes value of sales where COGS is >/= average COGS.