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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"sally nbct ''02" wrote in message
...
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.

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"sally nbct ''02" wrote:

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.