how do i count the freqency of values between certain ranges?

[Paul]

i have a set of 10 bin ranges i need to calculate the frequnecy that a set of
numbers occur, i tried using the freqency function but cant get it to work
correctly

 

[Gary''s Student]

Here is an example using equally spaced bins. Say we have values from 0 thru
99 in column A in cells A1 thru A1000 and the bins are:

0-9 1
10-19 2
20-29 3
30-39 4
40-49 5
50-59 6
60-69 7
70-79 8
80-89 9
90-99 10

In B1 enter:
=ROUNDDOWN(A1/10,0)+1 and copy down
each value in A has the bin number next to it.

In C1 enter:
=COUNTIF(B1:B1000,ROW()) and copy down thru C10
C1 thru C10 tell you how many values are in each bin.

 

[Sandy Mann]

It is always better to give the formula that you used to let people see what
you ahve tried ang also give the results that you got. *can't get it to
work* is not very helpful.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk