Mar 15 2022 08:49 AM
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?
Mar 15 2022 09:05 AM
Could the values you're summing be text values that look like numbers?
What happens if you change =SUM(range) to =SUM(--range) ?
Mar 15 2022 09:06 AM
@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.
Mar 15 2022 09:19 AM
Mar 15 2022 09:21 AM
Mar 15 2022 09:23 AM
@hones720 Can you share the file? Or a screen shot to begin with?
Mar 25 2022 07:57 AM
Solution
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!
Mar 25 2022 07:57 AM
Solution
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!