Countif

[Joyce]

Hi,

I would like a formula to count if the range is greater
then 1 but smaller then 2.

example :
A1 = 0.5
A2 = 1
A3 = 1.5
A4 = 2
A5 = 1.7
A6 = 2.2

The answer is 3

Thanks
Joyce

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A10>=1)*(A1:A10<2))