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

jcotten
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!!!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!