View Single Post
  #4  
Old April 27th, 2010, 06:31 AM posted to microsoft.public.excel.worksheet.functions
David Heaton[_2_]
external usenet poster
 
Posts: 7
Default 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