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.
 
Back
Top