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")

Find more posts tagged with

Accepted answers

Mark Cronk

=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")

Mike Arbaugh

Thank you. It works well.

All comments

Mark Cronk

Mike Arbaugh

Thank you. It works well.

Mark Cronk

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.