Forum Discussion

Copper Contributor

Jul 23, 2020

Solved

Excel continues to have SUM 0.00 even though all formula are correct

My =SUM continues to display 0.00 when adding multiple cells with function totals of their own. My column values each have cell D4 with formula =SUM(C4*M4) to get a total of two entered values for ...

excel

Barb1010
Aug 10, 2020
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!
Barb1010

MBL123

Copper Contributor

Jul 01, 2023

R0bperry904 First time I have posted in this forum.
In my case, my column had a circular formula in all cells in the column. I went to the Data page and checked Allow Circular Reference and added number of iterations, and then the column began to sum correctly.

I have to say that as I was typing this reply, I tried to find that "allow circular formula" and now I can't find it on the Data menu. I checked on the Formula menu, and I can't find it there either. However I know it is in Options and I thought I had it there as well, but I guess I didn't. I hope that helps in some way.

klasko92

Copper Contributor

Jan 15, 2024

MBL123 yes, this was the solution for me thanks to this thread! It is now phrased as "enable iterative calculation" in the file->options->formulas. I've highlighted it for clarity in the below image.