Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/06/COUNTIF-Exclude.xlsx

In this video I demonstrate how to exclude values when performing a COUNTIF. Normally when you perform a COUNTIF you want to specify which values to count. What if you want to count everything but...

I show you how to exclude a single value or multiple values in your COUNTIF calculation.

The functions used in this video are COUNTIF, COUNTIFS, MATCH, ISNA, SUM and SUMPRODUCT.
------------------------