Forum Discussion
hones720
Mar 15, 2022Copper Contributor
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...
- Mar 25, 2022
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!
Riny_van_Eekelen
Mar 15, 2022Platinum Contributor
hones720 Can you share the file? Or a screen shot to begin with?
hones720
Mar 25, 2022Copper Contributor
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!