SUMIF With Two Criteria

[Alec Kolundzic]

From the following table, how can I sum the number of
occurances of DI from column A, only on the condition that
the cell in Column B has the text TEST1.

Any Ideas
Thanks
Alec

DO TEST1
DI TEST1
DI TEST1
DO TEST1
DO TEST1
DI TEST2
DI TEST2
DI TEST2
DI TEST2
AI TEST1
DO TEST1
DO TEST1
DO TEST2
AI TEST2

 

[JulieD]

Hi Alec

not sure what you mean by "SUM" the occurances, but if you want to COUNT how
many times the combination of DI and TEST1 occur then this should give you
it

=SUMPRODUCT((A1:A14="DI")*(B1:B14="TEST1"))

Hope this helps
Regards
JulieD

 

[Andy B]

Alec

Try this:

=SUMPRODUCT((A2:A50="DI")*(B2:B50="TEST1"))

Andy.

 

[Alec Kolundzic]

Thanks Andy

This works fine

-----Original Message-----
Alec

Try this:

=SUMPRODUCT((A2:A50="DI")*(B2:B50="TEST1"))

Andy.




.

 

[Alec Kolundzic]

Thanks Julie

This Works Fine

-----Original Message-----
Hi Alec

not sure what you mean by "SUM" the occurances, but if you want to COUNT how
many times the combination of DI and TEST1 occur then this should give you
it

=SUMPRODUCT((A1:A14="DI")*(B1:B14="TEST1"))

Hope this helps
Regards
JulieD




.