Sumif with two criterias

[leung]

How can I use sumif when I want to meet two criteria?

 

[Biff]

I'm guessing you have 2 criteria in 2 different columns?

A1 = criteria1
A2 = criteria2

=SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2),D110)

Sums D where B = A1 and C = A2

Biff