How can I get the cell to remain blank instead of returning a 0?

PKane

Hello Community,

I'm hoping someone can please advise - how I would adjust my formula to leave the cell blank if the result is 0?

=COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1)

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @PKane

I hope you're well and safe!

You'd add an IF before the countifs that checks if it's zero, and if it is, it should be blank.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PKane

Hello @Andrée Starå - thank you for your reply!

I tried this - but it apparently is not correct :(

=IF(COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2023", {DC UPS Scope?}, 1)= 0, "-")

Any suggestions?

Genevieve P.

Hi @PKane

You'll need to repeat the formula: once for the IF statement if it's 0, and once again if the result is not 0. Try this:

=IF(COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1) = 0, "", COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1))

Cheers,

Genevieve

PKane

@Genevieve P. - not only did it work perfectly, but since I am pretty new to formulas, your explanation helped me learn/understand the rationale also - so I cannot thank you enough!

Genevieve P.

I'm glad I could help! 🙂

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.