Help with formula - COUNTIF and ISBLANK

Hello! I'm looking for help with a formula that is on a dashboard metrics sheet that is summarizing some numbers. I took a screenshot of the formula — essentially I'm looking to count all the # of sites in a specific Cohort but I also want to make sure it doesn't count any sites that are marked inactive in the main sheet.

I took a screenshot of the dropdown "inactive status" column in the main sheet. I'm stuck on how to write the formula...I use the "ISBLANK" one right?

So:

=COUNTIF({Master Data Sheet Group Assignment}, HAS(@cell, [Primary Column]@row), {Master Data Sheet Inactive Status, ISBLANK

and do I put @cell? what do I reference here?

please and thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

You need a COUNTIFS (with the "S" on the end) to allow for multiple range/criteria sets.

As for the ISBLANK and @cell question, the @cell goes inside the ISBLANK function.

{Range}, ISBLANK(@cell)

All comments

Paul Newcome

You need a COUNTIFS (with the "S" on the end) to allow for multiple range/criteria sets.

As for the ISBLANK and @cell question, the @cell goes inside the ISBLANK function.

{Range}, ISBLANK(@cell)

laura.sandoval

This worked thank you!! I get caught up in the little things, I appreciate the help :)

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.