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

Hello,
If I understand correctly, I think this might do it:
=IF(COUNT([Column3]:[Column3]) > 0, SUM([Column3]:[Column3]), " ")
If the count of nonblank cells in the referenced column is >0 it'll return the sum of the column. If the count is 0, it'll be blank.
Hope that helps.
Dave

That worked beautifully! Thank you very much!!!
Help Article Resources
Categories
Check out the Formula Handbook template!