averaging class grades

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.
 
B

Bernard Liengme

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
 
S

Shane Devenshire

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