How to reference cells with the COUNTIF function in Excel ... a specific condition. To make it work, you supply the range and a condition, which can be a literal value or an expression. SEE ...