You can use this method and adapt it to your grades

http://www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)


"Gatester" wrote in message
...
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...