How to use Microsoft Excel 2013 COUNTIF. This video does apply to lower versions of Excel. This video will educate you on the basics of how to use the statistical function COUNTIF. The syntax of COUNTIF is =COUNTIF(Range, Criteria). Watch the quick video for an example of how to use.