Countif problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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