# Sumif function with multiple criteria in Google Sheets

#### MarissaB

##### New Member
Hi all,

I have a dataset on which I applied a SUM.IF function, in combination with an IF function. In the attachment you find how I did this searching for one criteria.
However, now I would like to search for multiple criteria. I would like to see the amount for the sum of 6 different criteria, without copy+paste the formula 6 times.

So, I know I can do:

Can I solve this with an array function? And If so, how do I do this?

Thanks a lot!!
Marissa

#### Attachments

• AFE37968-2004-462A-AEC2-C46601B9BC43.jpeg
92 KB · Views: 5
Last edited by a moderator:

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### MarissaB

##### New Member
Thanks for your reply. However, this is not working as it gives an error unfortunately.

#### MarissaB

##### New Member
Or at least - it is working in Excel but not in google sheets. Do you know if there are differences with this formula between those two?

#### Fluff

##### MrExcel MVP, Moderator
I know nothing about Sheets so cannot help.
If you are wanting formulae for Sheets, rather than Excel, you should clearly state that in your question & the thread should be posted in the "General Discussion & Other Applications" section of the site.

#### jasonb75

##### Well-known Member
it is working in Excel but not in google sheets.
You can't use array constants as sumifs criteria with google sheets, you will have to do it the long way, sumifs(....)+sumifs(....)+sumifs(....)

Replies
0
Views
56
Replies
11
Views
868
Replies
9
Views
524
Replies
4
Views
809
Replies
1
Views
230

1,127,610
Messages
5,625,795
Members
416,138
Latest member
Pizzaman22

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