COUNTIFS Blank & Not Blank

Hello,

Formula shouldn't be too difficult, but I'm having some issues. What is the syntax for a function that counts is a cell is blank within certain criteria. Here was my attempt, but it was not working. Will also need the notblank version.

=COUNTIFS({Domain}, [Primary Column]@row, {Metric}, ISBLANK({Metric}))

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try this:

=COUNTIFS({Domain}, @cell = [Primary Column]@row, {Metrics}, @cell = "")

=COUNTIFS({Domain}, @cell = [Primary Column]@row, {Metrics}, @cell <> "")

RingJake

Hey Paul,

Thank you for the reply here is what my fx & spreadsheet looks like. This is giving me an "#Invalid REF". Generally I'd think this wouldn't be too difficult, but I'm less familiar with the @cells.

Screen Shot 2022-06-02 at 10.23.51 AM.png

Paul Newcome

Double check that your cross sheet references are created correctly and they they are the same size/shape (for example both need to be entire columns or entire rows).

RingJake

This worked, thank 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.