| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I average my grades for my students
I have 20 students with 6 grades entered for most of them-How do I average
them? -- sally nbct '02 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I average my grades for my students
Hi,
Suppose the 6 grades are in B1:G1 and the student name in A1, enter =AVERAGE(B1:G1) copy it down for all the students. If this helps, please click the Yes button Cheers, Shane Devenshire "sally nbct '02" <sally nbct wrote in message ... I have 20 students with 6 grades entered for most of them-How do I average them? -- sally nbct '02 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I average my grades for my students
And have a look at SUMPRODUCT if you want a final grade based on different
weighting for each mark. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "sally nbct '02" <sally nbct wrote in message ... I have 20 students with 6 grades entered for most of them-How do I average them? -- sally nbct '02 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Letter grades average | Excel Discussion (Misc queries) | |||
| howdo i make a chart showing grades for male and female students | New Users to Excel | |||
| Average Grades and drop the lowest score | Excel Worksheet Functions | |||
| average student grades | New Users to Excel | |||
| students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions | |||
Linear Mode
