Forum Discussion
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 properly configured. Any ideas?
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!
6 Replies
hones720 The "numbers" are probably texts. Check by entering the formula =ISNUMBER(......) somewhere. Reference a cell from your list between the brackets. If the answer is FALSE, you know that it's a text.
- Tried it. Answer is TRUE
hones720 Can you share the file? Or a screen shot to begin with?
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.
