# SUMIF function formula help

#### excelbrands

##### New Member
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.

#### Attachments

• forecast example.JPG
104 KB · Views: 5

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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
ABCDEFGHIJK
1StageVPOpportunity NameAmount CalculatedClosedVP Forecast
2Closed WonBrianOpp 164051Brian106
3Closed WonMattOpp 251880Matt69
4Closed WonGaryOpp 349165Gary208
5Closed WonTomOpp 486740Tom203
6Closed WonBrianOpp 56149
7Closed WonMattOpp 632731
8Closed WonGaryOpp 72581
9Closed WonTomOpp 816275
10Closed WonBrianOpp 955243
11Commit (90%)MattOpp 1041624
12Commit (90%)GaryOpp 1168159
13Commit (90%)TomOpp 1259834
14Commit (90%)TomOpp 1345840
15
Sheet2 (2)
Cell Formulas
RangeFormula
K2:K5K2=SUMIFS(Table1[Closed],Table1[Stage],"Closed Won",Table1[VP],J2)+SUMIFS(Table1[VP Forecast],Table1[Stage],"<>Closed Won",Table1[VP],J2)

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

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

Replies
3
Views
240
Replies
2
Views
187
Replies
9
Views
222
Replies
1
Views
128
Replies
1
Views
155

1,203,114
Messages
6,053,585
Members
444,674
Latest member
DWriter9

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back