Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal Grades Triptanes New Users to Excel 3 April 26th 06 07:58 AM
Figuring Grades mkingsley Excel Worksheet Functions 2 April 5th 06 08:43 PM
Find avg & Max for grades Param Excel Worksheet Functions 7 March 17th 06 04:31 PM
Grades Michael L Excel Worksheet Functions 2 October 4th 05 04:19 PM
grades Ggal Excel Discussion (Misc queries) 1 March 19th 05 09:23 PM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"