Forum Discussion
Excel continues to have SUM 0.00 even though all formula are correct
If any of your numbers are left aligned, they are probably text - you can't just click on them and change them to numbers so...
I did a search on Excel "convert text to numbers" - pro users probably already know this but as I mentioned, I'm using a new version - if you highlight the column of numbers that aren't adding up and then go to "Data", click on "Text to columns" - click Next, click Next, click Finish - it will convert any text to numbers. Much easier than my last post!
R0bperry904 this questions over 2 years old, but I was having a similar problem on an excel sheet that had been fine previously and found that there was a hidden sum in the columns I was implementing a formula on if that makes sense. Found it in the formula bar. From the sheet itself it was showing 0, I had to click on it and then I could see that the cell had a formula already imbedded. Removed it and then my formula was working again.