janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 155
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I have no idea why my basic COUNTIF formulas won't work here.
It is frustrating me because I rewrote them so many times and no luck.
I am just counting cells if their values are greater than, equal, and in some cases in between a set number. See my first two formulas below that didn't work. Screenshots also attached.
They just keep returning a zero.
=COUNTIF(T2:T102," >=1")
=COUNTIF(T2:T102,">0.94)-COUNTIF(T2:T102,"<="0.99")
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
I am just counting cells if their values are greater than, equal, and in some cases in between a set number. See my first two formulas below that didn't work. Screenshots also attached.
They just keep returning a zero.
=COUNTIF(T2:T102," >=1")
=COUNTIF(T2:T102,">0.94)-COUNTIF(T2:T102,"<="0.99")