Excel 2007 In Pictures

  1. When the Insert Function window appears, click Statistical in the Category list:

  2. Scroll down the Function list, then click COUNTIF.