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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF for 2 columns 6
Excel Need Countifs Formula Help 0
Two Criteria COUNTIF 7
countif comparing two columns 4
COUNTIF? DCOUNT? 9
Coutnif 4
countifs Function not giving desired result with date criteria 2
Countif, plus ? 8

Back
Top