Sum formula not working
Trying to sum cells in a row that have value based on a formula. I've read that this can be an issue and to use VALUE in the equation. However, I'm still getting a RED Zero as a result.
Any ideas?
=VALUE(SUM([Printing and Shipping]7, [Interim Reviews]7))
Thanks
Best Answer
-
Hi Jeana,
Try wrapping the VALUE function around the actual cells referenced, versus around the formula as a whole:
=SUM(VALUE([Printing and Shipping]@row), VALUE([Interim Reviews]@row))
Here's more information on the VALUE function: https://help.smartsheet.com/function/value
I've swapped out your row reference of 7 to be @row so this should work for any row. If this is still returning 0, it would help to see screen captures of your sheet (but please block out any sensitive data), and a copy/paste of the formula returning each number. Thank you!
Cheers,
Genevieve
Answers
-
Hi Jeana,
Try wrapping the VALUE function around the actual cells referenced, versus around the formula as a whole:
=SUM(VALUE([Printing and Shipping]@row), VALUE([Interim Reviews]@row))
Here's more information on the VALUE function: https://help.smartsheet.com/function/value
I've swapped out your row reference of 7 to be @row so this should work for any row. If this is still returning 0, it would help to see screen captures of your sheet (but please block out any sensitive data), and a copy/paste of the formula returning each number. Thank you!
Cheers,
Genevieve
-
Perfect, that's what I was missing! Thank you so much!
-
Great!! Glad it worked for you 🙂