#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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. |
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 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 | co-lay | Excel | 3 | 02-13-2012 03:46 PM |
Help! for using an appropriate function/Macro in Excel | pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |