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")

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")