Subtotal Grades

  • Thread starter Thread starter Triptanes
  • Start date Start date
T

Triptanes

I have a list of names with grades blah blah, and have calculated their
number grade. ALso, I used Vlookup and a lookup table to calculate
their letter grade.

NOW:
Use the subtotal feature to determine the number of As, Bs, Cs, Ds and
Fs.

:confused:

Data--->Subtotals I click some stuff in that menu, but none of it
displays the number of As, Bs, Cs, Ds and Fs.

Any help would be greatly appreciated.
 
Hi!
Data--->Subtotals
Click to expand...

That's for numeric data.

List your letter grades somewhere, assume D1:D5 = A;B;C;D;F

The students letter grades are in column A.

Enter this formula in E1 and copy down to E5:

=COUNTIF(A:A,D1)

Biff
 
Back
Top