Statistical Function - COUNTIFS

Unlike COUNTIF, which only counts one criteria, COUNTIFS will enable you to count up the number of times multiple criteria appear within your data sets. So handy!

The video shows the COUNTIFS function in use. The final written calculation is below: ​ =COUNTIFS($C$3:$C$17,$H4,$D:$D,I$3)) ​ In this formula, $C:$C is the first range of data that may contain the first item we want to count (i.e. type of fruit) $D:$D is the second range of data that may contain the second specific criteria (i.e. customer name).

As these are both ranges, we use Absolute Cell Addressing ($) to fix all letters within them. $H4 is the cell that contains the first criteria we want to count. In this example, we are looking for how many times the word apple appears in column C. ​ I$3 is the cell that contains the second criteria we want to count. In this example, we are looking for how many times the word Andy appears in column D. ​ 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 times each customer purchased each type of fruit.