Formula to SUM = 0 Why?

Linda F

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.

Paul Newcome

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.

Paul Newcome

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.

Linda F

Here is the formula I used for each of those fields

Paul Newcome

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.

Linda F

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

Paul Newcome

Happy to help. 👍️