Google Spreadsheet SUM based on Multiple Criterion

[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!!!

[oleoleo2]

Thank you very much! What if you wan't to check eg. if the word 'income' is in the collum as part of the text and not only the exact phrase? like 'Red Income', 'Blue Income' (Sorry for the meaningless example:)

[vygandas1024]

THANK YOU, its so clear to me now.

[hydrofal78]

thank you

[rvpetta]

Great video, thanks. You solved my problem.

[interbene]

Good stuff!, simple and quick demo I needed for Filter function, thanks Chris UK.

[coimbradomondego]

That's amazing! Thank you for sharing it! I really appreciated such function on Google Spreeadsheet. May God bless you!