How do I reference a cell from within a "...IF"-type function condition string? When using a ...IF type of function (like COUNTIF, AVERAGEIF, etc.), I use condition strings:


e.g. "&gt;100", "=Mr. Smith"


Instead of using a literal from within the string, how do I (or can I) reference a different cell from within the table?


e.g. "&gt;ColA Row2"


Stuff I've Tried (that doesn't work)

...,"=A2",...
...,=A2,...
When directly referencing a cell from within an IF type function, don't use a condition string. Also, no need to use a comparison operator.


Condition string usage, to compare against a literal value:

COUNTIF(A1:A20, "=Mr. Smith")
Direct cell reference, to compare against cell B1:

COUNTIF(A1:A20, B1)