Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting values within given interval - countif?
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? |
#2
|
|||
|
|||
"A_F" ha scritto nel messaggio
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? Youi can try this formula: =SUMPRODUCT((L2:L4502)*(L2:L450<2,5)) -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
#3
|
|||
|
|||
Franz wrote: Youi can try this formula: =SUMPRODUCT((L2:L4502)*(L2:L450<2,5)) yes, it works, thanks a lot |
#4
|
|||
|
|||
=COUNTIF(L2:L450;"<2,5")-COUNTIF(L2:L450;"<=2")
-- HTH Bob Phillips "A_F" wrote in message ... 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? |
#5
|
|||
|
|||
"A_F" ha scritto nel messaggio
Franz wrote: Youi can try this formula: =SUMPRODUCT((L2:L4502)*(L2:L450<2,5)) yes, it works, thanks a lot You're welcome. Thanks for the feedback -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Values | Excel Worksheet Functions | |||
Using COUNTIF to check values in multiple columns | Excel Worksheet Functions | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Counting values | Excel Worksheet Functions |