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

jcotten

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

David Hersher

Hello,

If I understand correctly, I think this might do it:

=IF(COUNT([Column3]:[Column3]) > 0, SUM([Column3]:[Column3]), " ")

If the count of non-blank 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

jcotten

That worked beautifully!  Thank you very much!!!