Using SUMIF to have a blank cell if data comes back zero
I am pulling data from another sheet. I am using a SUMIF to sum things off a certain date and if it meets a certain name. When it has no data to bring back, it shows a zero and I would like for the cell to be blank so that my charts do not show a lot of zeros. How can I do this? Thanks
=SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, $Month@row, {WOF-WOP Range 1}, Day@row, {Defect Shift}, "VTIS 1")
Best Answers
-
=IF(SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, $Month@row, {WOF-WOP Range 1}, Day@row, {Defect Shift}, "VTIS 1") =0, "", SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, $Month@row, {WOF-WOP Range 1}, Day@row, {Defect Shift}, "VTIS 1")
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you. It works well.
Answers
-
=IF(SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, $Month@row, {WOF-WOP Range 1}, Day@row, {Defect Shift}, "VTIS 1") =0, "", SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, $Month@row, {WOF-WOP Range 1}, Day@row, {Defect Shift}, "VTIS 1")
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you. It works well.
-
Hi @Mike Arbaugh ,
Excellent. Glad you found a solution. Please accept my answer to close out the discussion. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!