How to Use COUNTIF in Excel — A Step-by-Step Walkthrough · Click an empty cell where you want the count to appear. For this example, click cell G2 . · Type = ...