+ Reply to Thread
Results 1 to 8 of 8

Average Data In A Column

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    Texas
    Posts
    1

    Average Data In A Column

    I do not use excel very often but know there is a simple formula to take the average of numbers inputted into a column. For example, I would like to sum all the values entered into column “D” and then divide that by the number of entries

    4
    5
    3
    1
    4
    11
    6
    2
    0
    ----
    36/9 = 4

    If I were to add another entry it would automatically change the divisor to 10

    Any suggestions would be helpful

    Thanks a lot
    John
    Last edited by JohnSchroeder; 11-25-2008 at 03:22 PM.

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Suppose ur data is in Range A1:A9

    Then you can use this formula

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267
    All you would need to do is say:

    =average(A1:A10)
    or whatever the range is.

  4. #4
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465
    Hello JohnSchroeder,

    you can use " /COUNT(A2:A21)" formula.

    for more details please check attached file.
    Last edited by arthurbr; 11-25-2008 at 02:27 PM.
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.


    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Welcome to the forum.

    Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

    Thanks.

  6. #6
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465
    Hello, JohnSchroeder

    You can use "=+A29/COUNT(A1:A28)" formula

    for more details please check attached file.
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Thx for changing your title
    If you want to adapt automatically to the range's varying length, use dynamic ranges which are described here
    Then use the average formula =average(your_range_name)
    Do you want to include null or negative values in the range you average?

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372
    @Rahul, @Shijesh,

    why do you need to reinvent the wheel? Excel provides the AVERAGE() function, as wmorrison49 said. Why the need for sums and counts and all that?

    I think it's more complicated to come up with a workaround for something that already has an out of the box solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1