# COUNT Cells Not Equal To Many Things in Microsoft Excel

Written by | 0 Comments | 308 Views

In this article, you will learn how to use the Microsoft Excel COUNT formula and its purpose in Microsoft Excel. You will also get to know how to count cells not equal to many things and see the generic formula.

Count Cells Not Equal To Many Things in Microsoft Excel

The main purpose of this formula is to count cells not equal to any of many things. Here we will learn how to count cells not equal many things in Microsoft Excel.  That implies, with the help of a formula based on the MATCH, ISNA, and SUMPRODUCT functions you can count the cell not equal to many things. In case you have a couple of things you don't want to count, you can use COUNTIFS functions. So, with the help of this formula, you can able to count cells not equal to any of many things.

General Formula to COUNT Cells Not Equal To Many Things

=SUMPRODUCT(--(ISNA(MATCH(data,exclude,0))))

The Explanation for the COUNT Cells Not Equal To Many Things

So we know that Microsoft Excel COUNTIF function you can able to count cells not equal to any of many things. Here we will learn how to count cells not equal many things in Microsoft Excel. As we know that, if you want to have just a couple of things you don't want to count, you can also use the COUNTIFS function. But it does not work well if you have so many things on the list. The reason is you need to add an additional range/criteria pair to for each thing you don't want to count. It is always easy to build a list and pass in a reference to this list as part of the criteria.

It should be noted that if you use the SUMPRODUCT function instead of SUM it will avoid the need to use control + shift + enter. So, with the help of the COUNT formula, you can able to count cells not equal to any of many things.