Troubleshooting the comparison operator Other Excel tutorials and resources Can the COUNTIF function reference a cell? The simple answer is yes, COUNTIF () can be used to reference a cell.