I run a countifs against a column of data, and can easily test for specific concrete criteria in other columns, but I want to run a function on the value in a column as a criteria.

For example,
countifs(data Name, "=Technical", data count, ">4")
is great.

But I want to check for some function on another column, e.g. "data number, square(x)<100", I cannot reference the indexed data value in the (data number) column as the "x" in the formula.

What I really want to do (!) is to test if a field is (not) in a list of matches, e.g.
..., data tag, NOT(ISERROR(MATCH(???,GoodValues))),

Where I can see if the tag for an entry is in a list ("GoodValues") defined elsewhere.