Have you ever needed to quickly count the number of times a word or number or date appears in a range of cells?

If I need to know how many people have ordered chicken for the team meal then it’s not too difficult (unless you have a team of 200 and people keep changing their mind!)

But what if you needed to count the number of staff (in a company of 000’s) who had an iPhone Pro that was due for renewal in 2022?

This is where knowing how to use the COUNTIF and COUNTIFS functions comes in useful.

In addition to explaining and demonstrating the difference between COUNTIF and COUNTIFS, the full 17-minute video below covers the special syntax for dates, how to count within a range of numeric values and date values (i.e. between) and how to use wildcard characters (partial matches).

Links to the video and individual sections below…