Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal Grades
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. 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. -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536260 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal Grades
Hi
Have a look at pivot tables and use "count" of grades Regards Michael "Triptanes" wrote: 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. 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. -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536260 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal Grades
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 "Triptanes" wrote in message ... 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. 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. -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536260 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal Grades
Thanks again Biff and Michael! -- Triptanes ------------------------------------------------------------------------ Triptanes's Profile: http://www.excelforum.com/member.php...o&userid=33849 View this thread: http://www.excelforum.com/showthread...hreadid=536260 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |