Greater than or less than formula

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I need a formula that picks up anything 1-29 (not zero). At least 1, but
less than 29. I had =COUNTIF(Terminations!O:O,"<=29") was working fine,
except another formula is creating 0's (zeros) to come into this column. The
zeros can be there, I just don't want them counted.
 
You could just subtract out those that are 0 :
=COUNTIF(Terminations!O:O,"<=29")-COUNTIF(Terminations!O:O,0)
 
simply subtract the zeroes

=COUNTIF(terminations!O:O,"<=29")-COUNTIF(terminations!O:O,"=0")

Mike
 
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

Formula Greater than Less Than 4
Highlight MAX Cell Greater Than Zero 4
Excel Excel 2007 Formula Help Needed 1
Excel Need Countifs Formula Help 0
Nested Greater than or less than Formula 4
Greater and less than 4
Escel: Count students >=20 and <=29 1
Greater than Less than formula 2

Back
Top