The COUNTIFS function has been around for many versions.
COUNTIFS offers the ability to perform single or multiple criteria counting. Including using wildcards like * and ? in the criteria to represent unknown characters.
It offers different techniques to determine important results like
- Counting positives or negatives
- Determining if a list contains duplicates
- Identifying the first or last occurrence of an entry in a list
- Comparing two lists
- Validating an in-cell drop-down list selection
- Summarising many validations
- Creating flexible conditional formats
- Applying filters based on multiple columns
As always, I will share a few general tips along the way.
Level: Intermediate
Duration: 1 hour
Price: AU$25