Forum Discussion
Solved
sum function not adding properly. Returning 0.00 instead of total
I am using a simple sum function to add a column of numbers. For some reason, I am getting a total of 0.00 instead of the sum of the numbers. I have been using the function for years and it is proper...
I found the problem. There was an error in a cell from a different page that caused the sum function not to work. I fixed that error and all is fine. Thanks so much for your help!
Could the values you're summing be text values that look like numbers?
What happens if you change =SUM(range) to =SUM(--range) ?
Thanks but it didn't work.