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…
- Introduction
- COUNTIF: simple example: Count how many times a certain word appears in a range
- COUNTIF: using criteria stored in a cell rather than embedded in the formula
- COUNTIF: numbers – count how many items are greater than or less than a certain value
- COUNTIF: multiple criteria – using OR Logic
- COUNTIF: An explanation
- COUNTIFS: multiple criteria from separate columns (AND logic)
- COUNTIF: using wildcard characters to count partial matches
- COUNTIFS: using wildcard characters to count partial matches
- COUNTIF and COUNTIFS: working with dates (after a specific date, between 2 dates)
- COUNTIFS: combining dates and wildcards