COUNTIFS criteria for "anything" in cross-sheet formula.

I've created a complicated cross-sheet formula that is supposed to the number of times the criteria "Mentioned" is found in Range 6 with an "any" criteria for Range 5 so that no matter what is in Range 5, if "Mentioned" is in Range 5, it will count it.

This is what I tried:

=COUNTIFS({Media Tracking Range 5}, {Media Tracking Range 6}, "Mentioned")

But it came back unparseable. So I tried this:

=COUNTIFS({Media Tracking Range 5}, [$Column$1], {Media Tracking Range 6}, "Mentioned")

Also unparseable. Is there a different "anything" variable?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

So Range 5 is not blank and range 6 is "Mentioned"? If so, try this...

=COUNTIFS({Media Tracking Range 5}, @cell <> "", {Media Tracking Range 6}, "Mentioned")

Sarah Zimmerman

Hi Paul, thank you. Yes, that is correct! That worked beautifully, thank you so much!

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.