Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need quick help averaging multiple rows
Hi,
Enter you first average formula in L3 and then select the cell and double click the fill handle (The little black box on the bottom right) and your formula will automatically fill down as far as there are data in column K with the row number auto incrementing. Mike "drums787" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need quick help averaging multiple rows
Wow, it was that easy huh? I feel embarrassed for not trying that in the
first place. Thanks a lot man. "Mike H" wrote: Hi, Enter you first average formula in L3 and then select the cell and double click the fill handle (The little black box on the bottom right) and your formula will automatically fill down as far as there are data in column K with the row number auto incrementing. Mike "drums787" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need quick help averaging multiple rows
Glad I could help but it only becomes easy when you know the answer!!
"drums787" wrote: Wow, it was that easy huh? I feel embarrassed for not trying that in the first place. Thanks a lot man. "Mike H" wrote: Hi, Enter you first average formula in L3 and then select the cell and double click the fill handle (The little black box on the bottom right) and your formula will automatically fill down as far as there are data in column K with the row number auto incrementing. Mike "drums787" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple minimums, quick ? | Excel Discussion (Misc queries) | |||
Can Quick Access Toolbar be expanded to 2 rows? | Excel Discussion (Misc queries) | |||
Averaging multiple ranges with #n/a values | Excel Discussion (Misc queries) | |||
Is there a quick way to delete all duplicate rows in a column? | Excel Discussion (Misc queries) | |||
averaging specific rows in multiple arrays | Excel Worksheet Functions |