Sum if not blank
Options
Heather K
✭✭
I am trying to sum across multiple columns but have it show blank if the columns do not have values. Each of the columns has a formula in them to calculate a number. However, I want the sum column to show blank instead of 0 if all of the other columns are blank.
My formula right now is =SUMIF([Question 1 Score]@row:[Question 5 Score]@row, <>"", [Question 1 Score]@row:[Question 5 Score]@row) which is still giving me a 0 when all columns are blank.
How do I get it to show blank when the other columns are blank?
Tags:
Comments

That works to show the blank but then if all the scores are 0, it is still showing blank instead of 0.

Perfect. Thank you very much!

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!