# Excel Function of the Month – COUNTIF

## COUNTIF

Description

The COUNTIF function is used to count the number of cells in a specified range that meet a certain condition.

Usage

The COUNTIF function requires two criterion. First we tell the function what range to look in, then we tell the function what we’re looking for in that range. Every cell that contains the data we’re looking for is then counted.

Here is an example of people and what phone models they have:

Now let’s say we want to count how many people have Samsung models.

It’s easy to see the two criterion provided.

B1:B10 is our range. “Samsung” is the string we’re looking for. The function looks in the range and counts how many times the string “Samsung” appears in that range.

Check out my Excel posters for your classroom

I have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP