Forum Discussion

Admin57's avatar
Admin57
Copper Contributor
May 05, 2026

Excel Spreadsheet -Auto Sum

I downloaded a file and tried to sum the numbers but it show the correct formula but gives me the wrong total. 

excel
Formulas and Functions

3 Replies

  • Olufemi7's avatar
    Olufemi7
    Steel Contributor
    May 05, 2026

    Hello Admin57​,

    Excel shows the formula but gives a wrong total because the numbers are not being treated as real numbers.

    Most common cause is numbers stored as text.

    Fix:

    • Select the column
    • Go to Data
    • Click Text to Columns
    • Click Finish

    Or use a helper column:

    • Enter =VALUE(TRIM(A1))
    • Fill down
    • Copy and paste values back

    Also check:

    • AutoSum range includes all cells
    • Formulas > Calculation Options is set to Automatic

    Quick check:

    • Use =ISNUMBER(A1)
    •  If FALSE, the value is text not a number
  • m_tarler's avatar
    m_tarler
    Silver Contributor
    May 05, 2026

    well with only that to go on we could make a number of guesses but having the file, the numbers, the formula would help.

    A couple guesses could be:

    a) some of the cells have text values that might look like numbers but really be treated as text by excel

    b) you're talking about round off error, which given the right numbers could be more than expected

    c) you have number format that makes it appear different than expected

    d) any of a number of other possibilities

    I would first check (a) above that all those cells are really number values and not text.  Try something as simple as changing =SUM(A1:A10) to =SUM(--A1:A10) and see if you get a different answer (or an error).  That -- will try to convert text into a number if it can.