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

Sarah Zimmerman

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?

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. 👍️