#1
|
|||
|
|||
Average of many rows
If I had 4 columns of a lot of data (900 rows) and wanted to take the average of each individual row across the 4 columns, is there anyway I could do this more efficiently than just calculating each average individually?
|
#2
|
|||
|
|||
Assuming the first row of data is in A1:D1,
put this in E1 =AVERAGE(A1:D1) press enter and then select the cell again. Notice that little square in the lower right corner? That's called the Fill handle. Hover over the Fill handle and your mouse will turn into a black plus sign. Double click and the formula will fill down as far as the data in the column to the left goes. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Odd behaviour of table - keep rows together | Stephan Lindner | Word Tables | 1 | 09-10-2011 05:31 AM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Help Autoformating a Table w 2 header rows | Julie713 | Word Tables | 0 | 03-01-2010 08:15 AM |
How do I turn the top 2 rows into a header | GR8Fandini | Excel | 1 | 02-06-2010 12:58 PM |
Table rows moving to new page when you don't want them to | graham | Word Tables | 1 | 11-16-2009 08:51 AM |