Hide

The COUNTIF Function - A Tutorial Video With Examples

You can download here the worksheet from this video to practice it by yourself!

Excel Countif Function

This function is a little more advanced among the various counting functions, but on the other hand it might grant you with higher value analysis of your data.

It lets you select a group of cells and determine how many entries of a specific word or number are found within that selection.

Unlike some of the more common features, COUNTIF does not have a formula quickbutton automatically found in your menu - you’ll have to enter the command and variables manually.

But, it's really not difficult! Simply type an equal sign and the word "countif" in the target cell of your choosing, followed by a lead parentheses.
Now, select the cells you wish to poll, type a comma, and now the criteria to look for. Close the parentheses, hit Enter, and Excel will calculate your number!

Use the "download here" link under the video above to download the spreadsheet used in the video and practice it by yourself!