summing with multiple criteria

[Turi]

I am trying to sum a list such as the following:

a1: cat b1: black c1:3
a2: cat b2: white c2:2
a3: cat b3: black c3:5
a4: dog b4: white c4:1
a5: dog b5: white c5:1
a6: dog b6: black c6:5

What I want in my final spreadsheet is the sum of all
black cats in one cell, the sum of all white cats in the
next, etc. How do I sum using 2 sets of criteria? I've
tried sum(if(a1:a6=cat)and(b1:b6=black),c1:c6,0)) and all
I get is zero when I should get 8. Please help, Thanks!

 

[Aladin Akyurek]

=SUMPRODUCT(($A$1:$A$6="cat")*($B$1:$B$6="black"),$C$1:$C$6)