How to Exclude Values in COUNTIF | COUNTIFS NOT EQUAL to Multiple Text | Exclude Values from List
Download the featured file here: https://www.bluepecantraining.com/wp-...
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.
------------------------
