Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF
Hi all,
I have a huge data range with values between -5 and +4. I would like to count the values with the following groups: -5 to -4 -4 to -3 -3 to -2 -2 to -1 -1 to 0 0 to 1 1 to 2 2 to 3 3 to 4 e.g. The value 0.5 would go into the group "0 to 1". The value 1 would still go into the group "0 to 1" and not into the group "1 to 2". I tried to find a workable solution with the COUNTIF function, but I had no luck. Does anybody know a solution for this problem? Kind regards, Simon Minder |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf Function Help Needed | Excel Worksheet Functions | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |