How do you total the number of each letter grade in my math class

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

Guest

I have a spreadsheet which totals all grades and assigns a letter grade for
each student ("A", "B", "C", "D" "F"). What I would like to do is to
automatically tally how many of each grade has been received. i.e. how many
A's B's etc.
 
Say the letter grades were in Column D, from D2 to D100.

In, say E1 to E5, enter;
A, B, C, D, E -

Then in F1 enter this formula:

=Countif($D$2:$D$100,E1)
And copy down to F5.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top