SUMIF value exists, leave blank if cells are blank (nothing to sum)

jcotten ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range.  Is that possible?  

Here's the background:  I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column.  If they entered values into the column (even if the values are 0 all the way down the column), then they have completed the task.  If they didn't do the work, then the column would remain blank.  I need to sum the column anyways, so if there are values, then the answer would be the sum of whatever has been entered (whether that's 4 rows or 20 rows).  I don't want the sum to be 0 if they haven't entered any values...I want the cell to remain blank (incomplete).  Then I have another sheet that looks at that cell.  If there is a value (even if it is 0), then task complete.  If it is blank, then task not complete.  

I hope this makes sense.  Thank you all so much for your help!!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!