Can Excel count the number of scores within a range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70.
Any suggestions? I am sure it can be done...
 
If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1:

=IF(A1>89,"A",IF(A1>79,"B",IF(A1>74,"C",IF(A1>70,"D","F"))))
and copy down. This will convert the grades to letters. Elsewhere enter:

=COUNTIF(B:B,"A")
=COUNTIF(B:B,"B")
=COUNTIF(B:B,"C")
=COUNTIF(B:B,"D")
=COUNTIF(B:B,"F")
to get the count of As,Ab,Cs,Ds, and Fs
 
Gary's Student -

Thank you very much for taking the time to reply. It was exactly what I
needed, and easily implemented.

:-)

Gatester
 
You are very welcome.
--
Gary's Student


Gatester said:
Gary's Student -

Thank you very much for taking the time to reply. It was exactly what I
needed, and easily implemented.

:-)

Gatester
Click to expand...
 
Back
Top