Count col based on other column

[jackmanjls]

Assume I have the following ss


A B

L -2

S 3

L 5

L 3

S -1


If colA = "L" and colB > 0 then count += 1

if colA = "S" and colB > 0 then count += 1

else do nothing


The answer for "L" = 2

The answer for "S" = 1


Thanks for your time,

Jake

 

[Hui]

Jake

=SUMPRODUCT(1*($A$1:$A$5="L")*($B$1:$B$5>0))

or

=COUNTIFS(A1:A5,"L",B1:B5,">0")


will do the job


Change ranges and Letters as required.

 

[jackmanjls]

Hui,

Thanks for your response. This helps me a bunch.