How: Countif greater than 1000 and less than 1500

I need to count the number of occurances between 2 values.
Eg.
How many cells' values are greater than 1000 but less than 1500
How many cells' values are greater than 950 but less than 1000

I can use =COUNTIF(T2:T90,">1000") but how to then say and less than 1500.

I know it's probably very simple, but I can't find a list of criteria examples.

Thanks.

Nicci

Hi,

Couple of ways to do this

=COUNTIF(T2:T190,">1000")-COUNTIF(T2:T190,">1500")

or

=SUMPRODUCT((T2:T90>=1001)*(T2:T90<=1499))

VBA Noob

Thank you. This is exactly what I wanted. Now I can meet my deadline.

Glad I could help

VBA Noob