Countif problem.

D

dlbeiler

I have a column that I need to count the occurances of the word "yes" when
the value in the next column over is greater than zero.
Thank you for your assistance.
 
D

dlbeiler

Thank you very much Mr. Liengme. I had to make a simple edit and it now
works to perfection. It needed a parenthese after the "yes".
=sumproduct(--(a1:a100="yes"),--(b1:b100>0)
 
Top