Help on formula for autosum on 2 criteria in 2 ranges

[Cyn]

I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$
a 1 3.00
a 2 5.00
b 1
c 1
d 1

My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range critera) {sum_range}) but i can't make it work
I'm missing something

Help

 

[RagDyer]

One way:

=Sumif(A2:A6,"a",C2:C6)+Sumif(B2:B6,1,C2:C6)

 

[Teethless mama]

=SUMPRODUCT(--(A2:A100="a"),--(B2:B100=1),C2:C100)

 

[Pete_UK]

Try this:

=SUMPRODUCT((A1:A5="a")*(B1:B5=1)*(C1:C5))

Adjust the ranges to suit your real data.

Hope this helps.

Pete