LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default need quick help averaging multiple rows

Hello, and thanks for reading. I am relatively new to Excel in the workplace
and need to find the answer for this as quickly as possible for a project I
am working on (due tomorrow!!!).

Basically, I have a worksheet with eight columns and about 2500 numbers
(rows) in each column. I need to have another column that is made of of the
average of the 8 columns for each row. I know there must be an easier way to
do this than to go down row by row and find the average of the 8 columns for
that particular row. Essentially, I need to find a way to turn the normal
average function =average(D3:K3) into a formula I can fill down a column
where the number (3 in this case) changes depending on the row it is inserted
to.

Is there any way to do this? I have well over two thousand rows and simply
dont have the time to insert the average function and change the row number
each time. I would be eternally grateful if anyone can help me with this.
Thanks sooo much!
 
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
multiple minimums, quick ? Texas10 Excel Discussion (Misc queries) 1 September 15th 09 04:16 PM
Can Quick Access Toolbar be expanded to 2 rows? Mike Excel Discussion (Misc queries) 1 May 19th 09 07:06 AM
Averaging multiple ranges with #n/a values Anne Excel Discussion (Misc queries) 0 August 13th 08 05:20 PM
Is there a quick way to delete all duplicate rows in a column? Jellaby Excel Discussion (Misc queries) 3 May 16th 05 10:47 PM
averaging specific rows in multiple arrays GJR3599 Excel Worksheet Functions 2 March 3rd 05 12:24 PM


All times are GMT +1. The time now is 03:00 PM.

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"