Question: I am using the COUNTIF function and I would like to make the criteria equal to a cell.
For example:
=COUNTIF(C4:C19,”>=2/26/04”)
I want to replace 2/26/04 with cell A1. How do I do this?
Answer: To use a cell reference in the criteria, you could do the following:
=COUNTIF(C4:C19,”>=”&A1)
