• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count col based on other column

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
 
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.
 
Back
Top