Google Spreadsheet SUM based on Multiple Criterion

Excel has a tip by using SUMPRODUCT. However, in google spreadsheets if you use that you will only get the first element. Here I use Filter and then wrap it in a Sum function in order to Sum numbers based on more than one condition. As far as I know if you use CountIf you can only have one criteria.

Category:

People & Blogs

Tags:

• google spreadsheet
• google docs
• excel
• multiple criteria

[Maikeelify]

thank you so much it helped me to save the time......keep going.

[arthurjsk]

Great tip! Thanks a lot!!!

[mikesonlinechannel]

works well ...

[pulidom4n]

Thank you

[TheBabarules]

Dude, thank you.

[lukenicolaides]

Thanks for a very useful post, I was totally stuck until I found this. It works with a Count function too, e.g. =Count(Filter(G:G,C:C="High"))

[paulsarmiento]

Thanks for the wonderful post... :)

[priceyjp1]

I've been trying to find a proper explanation of this for MONTHS (and oddly, the vid didn't come up in search results till recently)

[jdchambless]

Nice work.

[dampez]

you are a ROCKSTAR!!!