Count cells from another sheet <> to a value or is blank

I am trying to count cells from another sheet that do not equal certain values OR are blank. When I create a filter on that sheet, I find 40 cells that fit the criteria.

However, my formula from my Metrics sheet counts 0 cells.

COUNTIFS({Subtype}, <>"Electronic Messaging", {Subtype}, <>"Core Sales Aid / Visual Aid", {Subtype}, <>"AUTOMATIC", {Subtype}, OR(ISBLANK(@cell)))

Any ideas what I'm doing wrong?

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hi @Geoff Hill

Try this

=COUNTIFS({Subtype}, OR(ISBLANK(@cell), @cell <>"Electronic Messaging", @cell<>"Core Sales Aid / Visual Aid", {Subtype}, @cell<>"AUTOMATIC"))

cheers

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.