| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Greater than Less Than | Excel Discussion (Misc queries) | |||
| Greater than Less than formula | Excel Discussion (Misc queries) | |||
| FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT | Excel Worksheet Functions | |||
| Greater than formula | Excel Worksheet Functions | |||
| formula for Greater of C or D X E | Excel Discussion (Misc queries) | |||
Linear Mode
