if formula .

I have three columns, I want to get the count if the week is 8, the year is 2023 and the country is US. if that condition is not met I want it to return nothing and have the cell empty.

Can anyone help

=COUNTIFS({Submit FY}, "2023", {week}, [Primary Column]@row, {Country}, "US"))

The formula initially looked like that but it returned zero when condition wasnt met. Now I want it to return nothing

@Paul Newcome

Find more posts tagged with

Accepted answers

Paul Newcome

There are a number of posts already detailing how to do this, but the basic idea is that you use an IF statement to say that IF the COUNTIFS is greater than zero, output the COUNTIFS.

All comments

Paul Newcome

There are a number of posts already detailing how to do this, but the basic idea is that you use an IF statement to say that IF the COUNTIFS is greater than zero, output the COUNTIFS.

Tadiwa

Thank you! That helped

Paul Newcome

Happy to 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.