Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
averaging class grades
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
averaging class grades
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
averaging class grades
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal Grades | New Users to Excel | |||
Figuring Grades | Excel Worksheet Functions | |||
Find avg & Max for grades | Excel Worksheet Functions | |||
Grades | Excel Worksheet Functions | |||
grades | Excel Discussion (Misc queries) |