averaging class grades

  • Thread starter Thread starter sally nbct ''02
  • Start date Start date
S

sally nbct ''02

All I could get it to do was average 3 weeks grades instead of the 6 weeks I
put in for (from G1:M1) and by highlighting the whole area-I used the
=AVERAGE,etc. I'm not sure what I did wrong still.
 
Please stay with one thread.

Let's say you have the data like this
John 6 8 9 5 6 7
Mary 6 8 3 7 8 9
....
Zak 5 6 7 8 4 7
....
And that John's name is in A2 and his marks are in B2:G7 and Zak's in
B22:G22
The average of John's marks is found with =AVERAGE(B2:G7)
The average of week 1 marks with =AVERAGE(B2:B22)

best wishes
 
Hi,

What does your data look like? what is the formula you are currently using,
what do you want the formula to return. Show us an example of the data.
 

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

Counting multiple memberships 1
average student grades 4
Automatic emailing Excel content via Outlook (for Student grading) 2
Omit empty cells? 0
Weighted grades 2
Where to put the Grade Average? 9
averaging a column of letter grades into a numeric GPA 3
Averaging a series of written text grades i.e. Dist*, Dist, Merit,Pass and Fail 3

Back
Top