+ Reply to Thread
Results 1 to 5 of 5

Newbie: Sum and Average of decimal numbers

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    14

    Newbie: Sum and Average of decimal numbers

    Hallo experts,
    As a first post in this forum I would like to know some knowledge about basic Excel-2010 functions.
    I have given a table with some decimal values like e.g 0.3658 0.358 0.485 0.7863 0.558 0.858 0.985, I want to find the sum and average of these number.

    1) I have tried the autosum or auto Function =AVERAGE(A2:A7) but it yields #DIV/0! error
    2) when I use =AVERAGEA(A2:A7), it yield ans=0
    3) puttin =ROUND(AVERAGEA(H2:H23);3) also yields 0;

    any other suggestion are welcome..

    Best Regards
    Ali

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Newbie: Sum and Average of decimal numbers

    You probably have there no numbers but texts. In Germany you probably have comma not dot as decimal separator .

    Try changing your values (Ctrl+H and replace . with ,)

    After such change your formulas shall work as expected.
    Best Regards,

    Kaper

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Newbie: Sum and Average of decimal numbers

    It seems that the numbers in the range A2:A7 are text

    Try this
    - In a separate cell input 1
    - Copy this cell
    - Select range A2:A7
    - Paste Special -- Multiply -- Values
    - Ok

    Now use
    =Average(A2:A7)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    04-10-2014
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Newbie: Sum and Average of decimal numbers

    Thanks alot guys.
    I rechked my excel, The windows and every thing is German, but a English language package has been installed. the changing of . to , worked

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Newbie: Sum and Average of decimal numbers

    Glad to hear that. Would be nice if you mark therad as solved, Chect foru rules http://www.excelforum.com/forum-rule...rum-rules.html to learn how to do it (and a lot of other important information).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-28-2013, 08:45 AM
  2. Replies: 4
    Last Post: 12-26-2012, 05:37 AM
  3. Replies: 4
    Last Post: 08-15-2006, 09:20 PM
  4. [SOLVED] Decimal number to percentage formula (newbie question)
    By Ken Benson in forum Excel General
    Replies: 4
    Last Post: 07-11-2006, 01:35 PM
  5. Newbie question Different decimal place values for columns
    By dan yemiola in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2006, 03:25 PM

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