Leave cell blank

Can someone help me update both of these formulas to leave the cell blank if the total is 0?

Thanks

=SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal"))

=SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25 Total]@row , [FY26 Total]@row , [FY27 Total]@row )

Find more posts tagged with

Accepted answers

Delilah

Thank you. I had the IF COUNT in the formula when I updated it because that what's I kept seeing when I searched, but just taking that out worked.

All comments

VBAGuru

You could use a nested IF solution:

=IF(SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal"))=0,"",SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal")))

and

=IF(SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25 Total]@row , [FY26 Total]@row , [FY27 Total]@row)=0,"",SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25 Total]@row , [FY26 Total]@row , [FY27 Total]@row))

Delilah

Thank you. I had the IF COUNT in the formula when I updated it because that what's I kept seeing when I searched, but just taking that out worked.

VBAGuru

Glad it works for you!

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.