Learn How to Count Cells Equal to Either x or y

Count Cells Equal to Either x or y Using Microsoft Excel Count Formula

The main purpose of the Microsoft Excel COUNT formula is to count the number of cells equal to either one value OR another. Here we will learn how to count cells equal to either x or y.  That implies, with the help of the COUNT formula you can able to count the number of cells equal to either one value OR another, you use a formula that uses the COUNTIF function twice. So, with the help of the COUNT formula, you can able to count the number of cells equal to either one value OR another.

General Syntax of the COUNT Count Cells Equal to Either x or y

=COUNTIF(rng,value1) + COUNTIF(rng,value2)

The Explanation for the Count Cells Equal to Either x or y

So we know that Microsoft Excel COUNT formula you can able to count the number of cells equal to either one value OR another. Here we will learn how to count cells equal to either x or y. COUNTIF counts the number of cells in a range that matches supplied criteria. In the example given above, the criteria for the first COUNTIF is "apples" and the criteria for the second COUNTIF is "pears".

It should be noted that COUNTIF is not case-sensitive. So, with the help of the COUNT formula, you can able to count the number of cells equal to either one value OR another.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel