excel: How to set up a formula for a range of numbers ie. 3.5-5..
On Apr 27, 5:09*am, LadyK974
wrote:
in a spreadsheet i have a range of numbers that needed to be counted ie. *
phos levels between 3.5-5.5 *I can't find a formula to support this. Can you
help
Maybe have a look at the frequency formula.
It takes the range of values you have then a range of bins (interval
values, 2.5,3,3.5,4,4.5, etc) and returns the number of values that
fall within each bin
Regards
David
|