SUMIF value exists, leave blank if cells are blank (nothing to sum)
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
Check out the Formula Handbook template!