# How to Count Cells that are Not Equal to Either X or Y in Excel

When working with data in Excel, it is essential to know how to count cells that meet specific criteria. Often, you may want to count cells that are not equal to specific values such as X or Y. Counting such cells can be challenging if you don’t know the right Excel formulas to use. In this article, we will discuss different methods to count cells that are not equal to either X or Y in Excel.

## Problem

Imagine you have a dataset with multiple columns and rows in Excel. You want to count the number of cells that are not equal to either X or Y. However, the dataset is enormous, and it is not practical to count them manually. You need a quick and efficient way to count such cells.

## Using COUNTIF Function

The COUNTIF function in Excel allows you to count the number of cells that meet specific criteria. To count cells that are not equal to either X or Y, you can use the following formula:

``=COUNTIF(range,"<>X")+COUNTIF(range,"<>Y")``

In this formula, “range” represents the range of cells in which you want to count cells that are not equal to either X or Y. The “<>” operator means “not equal to.” Therefore, the first COUNTIF function counts all cells that are not equal to X, and the second COUNTIF function counts all cells that are not equal to Y. By adding the results of both functions, you get the total number of cells that are not equal to either X or Y.

## Using SUMPRODUCT Function

Another way to count cells that are not equal to either X or Y is by using the SUMPRODUCT function. The SUMPRODUCT function multiplies corresponding values in two or more arrays and returns the sum of those products. To count cells that are not equal to either X or Y, you can use the following formula:

``=SUMPRODUCT((range<>"X")*(range<>"Y"))``

In this formula, “range” represents the range of cells in which you want to count cells that are not equal to either X or Y. The “<>” operator means “not equal to.” Therefore, the formula multiplies all values in the range that are not equal to X and Y and returns the sum of those products.

## Using COUNTIFS Function

If you want to count cells that are not equal to multiple values, you can use the COUNTIFS function in Excel. The COUNTIFS function counts the number of cells that meet multiple criteria. To count cells that are not equal to either X or Y using the COUNTIFS function, you can use the following formula:

``=COUNTIFS(range,"<>X",range,"<>Y")``

In this formula, “range” represents the range of cells in which you want to count cells that are not equal to either X or Y. The “<>” operator means “not equal to.” Therefore, the COUNTIFS function counts all cells in the range that are not equal to X and Y.

## Conclusion

In this article, we have discussed three different methods to count such cells: using the COUNTIF function, the SUMPRODUCT function, and the COUNTIFS function. You can choose any of these methods based on your preference and the size of your dataset. Remember, knowing these formulas will save you a lot of time and effort when working with data in Excel.

## Bibek Sapkota

I'm Bibek | Tech Enthusiast & Lifelong Learner. | Playing on the Web for the Past Few Years as an SEO Specialist and Full-Time Blogger. I'm constantly seeking out new opportunities to learn and grow, and I love sharing my knowledge with others. This is where I started this blog! Here, you will find me sharing comprehensive reviews, helpful guides, tips-tricks and ways to get the full benefits of ever-changing technology. On this blog, you can also explore Powerful Knowledge, Tips & Resources On Blogging, SEO and Passive income Opportunities.