Count Instances when Column A = 1 & Column B = >0 in same row

[Bob McCusker]

I'm looking for the total number of times that, in the same row, Column A = 1 AND column B = >0.

 

[VoG]

Try

=SUMPRODUCT(--(A1:A100=1),--(B1:B100>0))

 

[Peter_SSs]

Bob

SUMPRODUCT has the advantage that it will work in all versions but if you have Excel 2007+, COUNTIFS is a bit more efficient.

=COUNTIFS(A1:A100,1,B1:B100,">0")

 

[ncalenti]

=SUM((A1:A6=1)*(B1:B6>0))

This is a sum array so you need to enter it by hitting ctr-****-enter after pasting it into the formula bar. It will then put these things around it {}

 

[Bob McCusker]

Worked perfect thanks a lot guys.