Sumif 2 criteria

A

atrscomputers

Hey,

I'm having some difficulty extracting some of the information I need
from my database. What I need to do is do a count based on 2 criteria
in 2 columns. HELP please :)
This is totaly incorrect code but it will help get the idea across

sumif(a1:a5600, 3) & sumif(b1:b5600, 1)

Thanks
Andrew
 
D

Domenic

Try...

=SUMPRODUCT(--(A1:A5600=3),--(B1:B5600=1))

or

=SUMPRODUCT(--(A1:A5600=D1),--(B1:B5600=E1))

....where D1 contains your first criterion, such as 3, and E1 contains
your second criterion, such as 1.

Hope this helps!
 
Top