Statistical Function - COUNTIF

COUNTIF is essential! It will look at a range of data, and count how many times a specific criteria appears within it. Check out the example below...

The video shows the COUNTIF function in use.

The final written calculation is below:

=COUNTIF($C$3:$C$17,$G5)

In this formula, $C$3:$C$17 is the range of cells that may contain the item we want to count. As this is a range, we use Absolute Cell Addressing ($) to fix all letters and all numbers.

$G5 is the cell that contains the criteria we need to count. In this example, we are looking for how many times the word apple appears in cells C3 to C17.

Since I have used Absolute Cell Addressing within this calculation, I can use the Fill Handle to populate the rest of the table and count up how many customers purchased bananas and cherries too!