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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!