Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-30-2010, 07:54 PM
Kimberly Kimberly is offline Average of many rows Windows 7 Average of many rows 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average of many rows 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
Average of many rows How do I turn the top 2 rows into a header GR8Fandini Excel 1 02-06-2010 12:58 PM
Average of many rows Table rows moving to new page when you don't want them to graham Word Tables 1 11-16-2009 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft