How to Use Microsoft Excel COUNTIF

When you have a long list of data, you may have a need to find out how many times a particular word appears within a column or row of data. Microsoft Excel includes the Countif feature for that very purpose. The feature lets you assign the parameters of what cells to count.

Adult counting coins
Counting can be a breeze on the computer.
credit: Creatas/Creatas/Getty Images

Step

Open or create a Microsoft Excel worksheet with columns or rows of text in which you want to tally the number of cells containing a single word and nothing else. For example, you could have a column labeled "Trip Date" and another column labeled "City." Let's say you want to find out how many times you went to Detroit in a month.

Step

Click the cell at the bottom of the City column. Although you can place the Countif formula in any location, for this example, we will be placing it beneath the City column to count the occurrences of the word Detroit.

Step

Type "=COUNTIF(range,criteria)," where the range equals the cell range in which you want to count and the criteria equals the word. For example, you could type the following to count the number of times Detroit appears between cells B2 and B12:

Step

\=COUNTIF(B2:B12,"Detroit")

Step

Press "Enter" to get your result.