Excel 2010 In Pictures

6 Scroll down the Function list, then click COUNTIF.

7 Click the OK button.