Forum Discussion

R0bperry904's avatar
R0bperry904
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's avatar
    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 

Shasler395's avatar
Shasler395
Copper Contributor
Feb 15, 2024

R0bperry904 Was having the same issue. All the numbers were set to CURRENCY already. Changing the formatting to NUMBER didn't help...Auto Sum formula still produced 0. However, when I changed the column of numbers to GENERAL and then back to CURRENCY, it fixed it for me.

Resources