Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2014, 08:21 AM
Nobody Nobody is offline Excel function issue Windows 8 Excel function issue Office 2013
Novice
Excel function issue
 
Join Date: Jun 2014
Posts: 1
Nobody is on a distinguished road
Default Excel function issue

Hello, I'm new to this forum, because I'm seeking for help.
My problem is with the excel function called "AVERAGE".
I have a list, as example:
A B C D
1 2 3 -
5 4 3 -



(Something like this)
How I am able to make(not manually,in real problem I'm talking about 2.000+ lines) or use the "AVERAGE" function for every single line. And make it to show the results on the column "D"?
Like: =AVERAGE(A2,B2,C2) and it will show 2
But I want this for done automatically.
How I'm supposed to do that?
Reply With Quote
  #2  
Old 06-30-2014, 12:26 PM
gebobs gebobs is offline Excel function issue Windows 7 64bit Excel function issue Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

In D2, =AVERAGE(A2:C2). Copy D2 and paste to the bottom of the table.

If you format your data as a table (Home:Format As Table:...), Excel will copy the results down for you.
Reply With Quote
Reply

Tags
functions

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date or edate function help JohanB26 Excel 2 07-17-2013 09:23 AM
Excel function issue Excel 2003 User Defined Function Allan_H Excel 1 03-08-2013 09:36 AM
How do I auto-update the TODAY excel function within PowerPoint show presentation? Powerpoint100 PowerPoint 0 02-12-2013 01:45 PM
Excel function issue Excel Function co-lay Excel 3 02-13-2012 03:46 PM
Excel function issue Help! for using an appropriate function/Macro in Excel pawan2paw Excel 1 06-04-2009 12:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:31 AM.


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