Greater than or less than formula
 

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.

Greater than or less than formula
 

You could just subtract out those that are 0 :
=COUNTIF(Terminations!O:O,"<=29")-COUNTIF(Terminations!O:O,0)

"Cindy" wrote:

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.

Greater than or less than formula
 

simply subtract the zeroes

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

Mike

"Cindy" wrote:

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.

Greater than or less than formula
 

A different aproach:
=SUMPRODUCT(N($O:$O<=29),N($O$O=1))
--
Adilson Soledade


"Mike H" wrote:

simply subtract the zeroes

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

Mike

"Cindy" wrote:

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.