How do I average my grades for my students

S

sally nbct '02

I have 20 students with 6 grades entered for most of them-How do I average
them?
 
S

Shane Devenshire

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
 
B

Bernard Liengme

And have a look at SUMPRODUCT if you want a final grade based on different
weighting for each mark.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averaging class grades 2
Automatic emailing Excel content via Outlook (for Student grading) 2
average student grades 4
Counting multiple memberships 1
Newbie question 6
Linking Excel and Word 1
Complicated search and complete analysis on results 4
Formulas 2

Top