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

Sarah Zimmerman
edited 08/27/20 in Formulas and Functions

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!