Forum Discussion
Excel sum problem
I can't get a column to sum, although there is no text, and the numbers in the column are contiguous. I have tried various formulas, but the sum is always zero, which is absurd. I don't know what e...
It's possible the column of numbers are being treated as texts. You could try to re-evaluate the column with Text to Columns.
https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885
https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885
Thank you. I tried to do that but it didn't work.
- Thanks for your advice. I went through the entries one by one and there was some text that I changed and now it is working. Still don't know why there was text, but the problem was solved, thank you.
