On Sat, 14 Oct 2006 17:07:02 -0700, barrie
wrote:

I am definately confused! I used the same type of formula in my worksheets
last year and had no problem. My understanding is that column c (40, 50, 60
etc) is providing the grade range to count the number of grades in the range
(40 - 49, 50-50 etc.) If I want to count the number of grades in the range,
can you help me set up the data/formula correctly? I REALLY appreciate the
help.


You just need to understand that the Bin EXcludes the bottom of the bin and
INcludes the top of the bin. (It has to exclude one or the other, else there
would be an overlap).

So:

39
49
59
....

should do what you want, I think.

79 39 0 Less than or Equal to 39
80 49 2 Greater than 39 and less than or Equal to 49
56 59 2 Greater than 49 and less than or Equal to 59
72 69 4 Greater than 59 and less than or Equal to 69
70 79 6 Greater than 69 and less than or Equal to 79
47 89 1 Greater than 79 and less than or Equal to 89
57 99 0 Greater than 89 and less than or Equal to 99
63 0 Greater than 99
44
67
76
70
66
74
61


By the way, if there might be decimal grade numbers, you might want to change
the bins to something like:

39.9
49.9
59.9
....
--ron