SUMIF function formula help

[excelbrands]

I want to be able to SUM column "E" IF VP =Brian and stage = Closed won + SUM column F IF VP=Brian and Stage DO NOT EQUAL Closed Won

Can you help with formula? I am struggling with both criteria.

 

[Peter_SSs]

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Is this what you mean?

22 01 29.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Stage	VP	Opportunity Name	Amount Calculated	Closed	VP Forecast
2	Closed Won	Brian	Opp 1	6	40	51				Brian	106
3	Closed Won	Matt	Opp 2	5	18	80				Matt	69
4	Closed Won	Gary	Opp 3	4	91	65				Gary	208
5	Closed Won	Tom	Opp 4	8	67	40				Tom	203
6	Closed Won	Brian	Opp 5	6	14	9
7	Closed Won	Matt	Opp 6	3	27	31
8	Closed Won	Gary	Opp 7	2	58	1
9	Closed Won	Tom	Opp 8	1	62	75
10	Closed Won	Brian	Opp 9	5	52	43
11	Commit (90%)	Matt	Opp 10	4	16	24
12	Commit (90%)	Gary	Opp 11	6	81	59
13	Commit (90%)	Tom	Opp 12	5	98	34
14	Commit (90%)	Tom	Opp 13	4	58	40
15
Sheet2 (2)

Cell Formulas
Range	Formula
K2:K5	K2	=SUMIFS(Table1[Closed],Table1[Stage],"Closed Won",Table1[VP],J2)+SUMIFS(Table1[VP Forecast],Table1[Stage],"<>Closed Won",Table1[VP],J2)

 

[excelbrands]

@Peter_SSs You save me so much time! Thank you so much for your help!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.