Sumif 2 criteria

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

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!

In article <[email protected]>,
[email protected] wrote:

> 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

worked perfect, Thanks