Formula Problem

[VbaHell]

Hello All

I am trying to use a SUMPRODUCT formula for multiple critera but I cannot get anything to work

A B C
1 Dog Yes 10.00
2 Cat Yes 15.00
3 Dog No 11.00
4 Dog Yes 22.00
5 Cat No 17.80

What I need is
A1:A5="Dog"
B1:B5="Yes"
Then add C1:C5

Could anyone help please

 

[Domenic]

Try...

=SUMPRODUCT(--(A1:A5="Dog"),--(B1:B5="Yes"),C1:C5)

Or, if you're using Excel 2007 or later version, use SUMIFS instead.

 

[VbaHell]

That works a treat, The more I learn then show how little I know
Many Thanks

 

[Domenic]

You're welcome! And thanks for the feedback!