excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
whats wrong with my formula?
i need to know if the number of zeros in the range are greater then 0 and smaller then 5,
but as you can see it return TRUE for 6 zeros and also for no zeros
whats wrong with my formula?
i need to know if the number of zeros in the range are greater then 0 and smaller then 5,
but as you can see it return TRUE for 6 zeros and also for no zeros
Excel Formula:
=COUNTIF(N19:S19,0)>0 - COUNTIF(N19:S19,0)>5
Cell Formulas | ||
---|---|---|
Range | Formula | |
N17:N18 | N17 | =COUNTIF(N19:S19,0)>0 - COUNTIF(N19:S19,0)>5 |