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

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.

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Indyj" wrote in message
...
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.