Thread: [Solved] Average of many rows
View Single Post
 
Old 10-30-2010, 07:54 PM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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.
Reply With Quote