Subtotal Grades

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Triptanes - 26 Apr 2006 04:55 GMT

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.

Signature

Triptanes

Reply to this Message

Michael M - 26 Apr 2006 06:43 GMT

Hi
Have a look at pivot tables and use "count" of grades

Regards
Michael

> 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
[quoted text clipped - 10 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

Biff - 26 Apr 2006 06:50 GMT

Hi!

>Data--->Subtotals

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

Reply to this Message

Triptanes - 26 Apr 2006 07:58 GMT

Thanks again Biff and Michael!

Signature

Triptanes

Reply to this Message