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