How: Countif greater than 1000 and less than 1500

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