Forum Discussion
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.
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
The first fix worked.
Thank you!!