View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Heaton[_2_] David Heaton[_2_] is offline
external usenet poster
 
Posts: 6
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