# sumif mulpitle criteria

#### psrs0810

##### Well-known Member
I want to do a sumif the values equal 1, 5 and 102 - how do I do a sumif with all three?

Thanks

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Firefly2012

##### Well-known Member
Hi

Try:

=SUM(SUMIF(A:A,{1,5,102}))

which will add all the 1s, 5s and 102s in the A column

#### Akashwani

##### Well-known Member
Hi,

You could also try SUMPRODUCT.......

Excel Workbook
ABCD
1Data1Result
21324
35
4102
51000
61
75
8102
91000
101
115
12102
13
Sheet1

I hope that helps.

Ak

Replies
2
Views
139
Replies
3
Views
1K
Replies
3
Views
377
Replies
2
Views
89
Replies
1
Views
280

1,195,617
Messages
6,010,728
Members
441,565
Latest member
menangterus556

### 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