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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!