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 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
-
That worked beautifully! Thank you very much!!!
Help Article Resources
Categories
Check out the Formula Handbook template!
