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.
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.