# 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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### 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(....)

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,661
Messages
5,838,648
Members
430,559
Latest member
jm5498

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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