counting values within given interval - countif?

A

A_F

in a column L i have values that range from 1,3 to 3,5,.
I want to count how many values are between lets say 2 and 2,5.
i tried with this expression: =COUNTIF(L2:L450;AND(">2";"<2,5"))and it
returns me 0.
is it possible to count just how many values lies between given
interval (2<2,5) and how can i do this?
 
F

Franz

A_F said:
in a column L i have values that range from 1,3 to 3,5,.
I want to count how many values are between lets say 2 and 2,5.
i tried with this expression: =COUNTIF(L2:L450;AND(">2";"<2,5"))and it
returns me 0.
is it possible to count just how many values lies between given
interval (2<2,5) and how can i do this?
Click to expand...


Youi can try this formula:

=SUMPRODUCT((L2:L450>2)*(L2:L450<2,5))


--
Hoping to be helpful...

Regards

Franz
 
Top