+ Reply to Thread
Results 1 to 7 of 7

Excel 2010 - SUM formula returns incorrect result

  1. #1
    Registered User
    Join Date
    10-31-2007
    Posts
    34

    Excel 2010 - SUM formula returns incorrect result

    Hi All,

    Just found an anomaly in my Excel 2010 by accident. We have the following numbers in a column:

    633
    355
    -2459
    117
    2,372
    402
    -123.6
    -45

    The SUM formula returns -1,754. Manual adding the value in each cell returns 1,251.4. This is really odd! Has anyone come across such an issue before?

    Regards
    HS TS VN

  2. #2
    Registered User
    Join Date
    12-07-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    80

    Re: Excel 2010 - SUM formula returns incorrect result

    Hi,

    Please find attached excel for your reference.When i sum the formula and return the value 1251.4

    Imran.
    Attached Files Attached Files

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    5,718

    Re: Excel 2010 - SUM formula returns incorrect result

    Try to check if any cell contains value stored as text? at least, -123.6?

  4. #4
    Registered User
    Join Date
    10-31-2007
    Posts
    34

    Re: Excel 2010 - SUM formula returns incorrect result

    Thanks. Your excel file shows correct result. Is your excel 2010? Attached is the file created in excel 2010. Just wonder why.
    Attached Files Attached Files
    Last edited by digita; 02-15-2016 at 12:42 AM.

  5. #5
    Registered User
    Join Date
    12-07-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    80

    Re: Excel 2010 - SUM formula returns incorrect result

    Hi,

    633 and 2372 stored as text number in your excel file, please convert to number then put sum function your answer will be correct.I am attaching file for your reference.

    Imran.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-31-2007
    Posts
    34

    Re: Excel 2010 - SUM formula returns incorrect result

    Thank you for pointing that out. The numbers are actually exported from any program. Some come out as numbers others as text. With that said, manual add each cell returns more reliable result than the sum function.

  7. #7
    Registered User
    Join Date
    12-07-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    80

    Re: Excel 2010 - SUM formula returns incorrect result

    Hi,

    No problem if the numbers are exported from any program, Please convert text to number following these steps.

    Select column>>Go to DATA>>Text to Column>>Select Delimited>>Next>>Next>>Select General>>finish.

    Imran.

+ 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. isblank & vlookup formula returns #n/a result and incorrect result
    By helpmeplease333 in forum Excel General
    Replies: 5
    Last Post: 05-06-2012, 11:41 PM
  2. vlookup based on random result returns incorrect result
    By rickat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2005, 09:20 AM
  3. Median result used in formula gives incorrect result
    By vlatham in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-21-2005, 12:05 PM
  4. sumif formula returns incorrect value
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] sumif formula returns incorrect value
    By modular_brian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. sumif formula returns incorrect value
    By modular_brian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. sumif formula returns incorrect value
    By modular_brian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2005, 06:05 PM
  8. [SOLVED] Using Min function with cells in a Row returns incorrect result.
    By Gaurav in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-07-2005, 09:06 AM

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