Blank a cell if value is zero

I apologize as I know this has been asked numerous time but i cannot get it to work for me. I have a IfSum formula that I would like to turn the cell blank if the value is zero.

=SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February")

Thanks in advance for all the help

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

@Troy Bjelland

You just need to embed your SUMIFS inside an IF as a logical statement:

=IF(SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February") = 0, "", SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February"))

In English: If this formula equals zero, leave the cell blank (begin quotes and end quotes with nothing in between - "" ), otherwise, put the formula result in the cell.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.