Archive of Mr Excel Message Board
Back to Pivot Tables in Excel archive index
Back to archive home
Averaging
Posted by Lynda on January 16, 2001 11:11 AM
Help! I have entered all of my students grades into Excel and now I totally forget how to even begin to average them!
Re: Averaging
Posted by Aladin Akyurek on January 16, 2001 11:21 AM
What is a grade: a number or a letter code?
How many grades do you have per student? That is, are you trying to average per student or all students taken together?
Aladin
Another Question...
Posted by Mark W. on January 16, 2001 2:33 PM
Did you put all the grades in 1 column like...
Name Test# Grade
Tom 1 80
Jane 1 86
Bill 1 95
Tom 2 79
Jane 2 100
Bill 2 90
If you did all you need to do is create a PivotTable
with the Name field in the Row Area and the Grade
in the Data Area and its summary function set to
Average.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.