Simple COUNTIF formulas not working

[janema]

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

 

[dreid1011]

How are your values entered into col T? Perhaps they are numbers stored as text instead of numeric.

These seem to work for me:

Book1
	T	U	V	W	X	Y	Z
2	0.87
3	0.87
4	0.92
5	0.92					Market Ratio 1.00 and above	4
6	0.94					Market Ratio between 0.95 and 0.99	6
7	0.94					Market Ratio between 0.90 and 0.94	4
8	0.95					Market Ratio between 0.80 and 0.89	2
9	0.96					Market Ration below 0.79	0
10	0.96
11	0.98
12	0.98
13	0.98
14	1
15	1
16	1
17	1.01
Sheet2

Cell Formulas
Range	Formula
Z5	Z5	=COUNTIF(T2:T102,">=1")
Z6	Z6	=COUNTIFS(T2:T102,"<=.99",T2:T102,">.94")
Z7	Z7	=COUNTIFS(T2:T102,"<=.94",T2:T102,">.89")
Z8	Z8	=COUNTIFS(T2:T102,"<=.89",T2:T102,">.79")
Z9	Z9	=COUNTIF(T2:T102,"<=.79")

 

[janema]

How are your values entered into col T? Perhaps they are numbers stored as text instead of numeric.

I did check that, and they are stored as a number.

 

[Fluff]

In the 1st formula remove the space before the > sign.
In the 2nd your quotes are in the wrong place, you can also do it using countifs

=COUNTIFS(T2:T102,">0.94",T2:T102,"<0.99")

 

[dreid1011]

I did check that, and they are stored as a number.

View attachment 100592

I added the formulas I am using and the results I get to my first reply. See above.

Edit: nvm, Fluff's corrections to your formulas should sort you out.

 

[janema]

In the 1st formula remove the space before the > sign.
In the 2nd your quotes are in the wrong place, you can also do it using countifs

=COUNTIFS(T2:T102,">0.94",T2:T102,"<0.99")

THANK YOU SO MUCH! That worked perfectly!

 

[Fluff]

Glad we could help & thanks for the feedback.