Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
Best Answer

Ok. In that case, it is the quotes around each of the output numbers. Quotes will have them output as text values. Try removing the quotes from around each output number (or wrap the whole IF in a VALUE function), and that should take care of the problem for you.
Answers

How exactly are each of the numbers being populated? Looks like you have column formulas? What are those? They may be outputting text strings that look like numbers instead of actual numbers depending on the functions/syntax being used. I am guessing you used something like a LEFT function to just pull the starting number out of the string to the right of it? If that is the case, the LEFT function outputs text values, and all you should need to do is wrap each of the existing formulas in a VALUE function.

Here is the formula I used for each of those fields

Ok. In that case, it is the quotes around each of the output numbers. Quotes will have them output as text values. Try removing the quotes from around each output number (or wrap the whole IF in a VALUE function), and that should take care of the problem for you.

That did the job !! Thank you. I am now seeing the sum of all those fields.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!