Sum if not blank

Heather K
Heather K ✭✭
edited 12/09/19 in Formulas and Functions

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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!