E
Elliott Alterman
I have a table that has a column of values (range from 50 to 100000). I would
like to summarize the range of values in that column. For example, I would like
to know how many are between 50 and 100, between 51 and 200, etc.
The values for the ranges (e.g., 50 to 100, 101 to 200, etc.) will have to be
changed frequently so I don't want them to be embedded in the function - I'd
rather just type them in specific cells that the functions can refer to:
For example
range 100 300 850
counts 4 5 3
In the above, I'd like to know how many cells have values less than 100, from
101 to 300, from 301 to 850. The values 100, 300, 850, etc are the ones that
change frequently.
Suggestions are appreciated.
"Z"
like to summarize the range of values in that column. For example, I would like
to know how many are between 50 and 100, between 51 and 200, etc.
The values for the ranges (e.g., 50 to 100, 101 to 200, etc.) will have to be
changed frequently so I don't want them to be embedded in the function - I'd
rather just type them in specific cells that the functions can refer to:
For example
range 100 300 850
counts 4 5 3
In the above, I'd like to know how many cells have values less than 100, from
101 to 300, from 301 to 850. The values 100, 300, 850, etc are the ones that
change frequently.
Suggestions are appreciated.
"Z"