Formulas to Count Cells Equal to One Of Many Values in Excel!!

In this short tutorial, we will discuss the Formulas to count the cells equal to one of many values in Excel 365 with a brief explanation. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• The below formula will help you to count the cells which are equal to one of many values in Excel.

=SUMPRODUCT(COUNTIF(range,things))

Syntax Explanations:

• SUMPRODUCT – In Excel, this function can multiply the selected arrays or ranges and returns the sum of the products. Read more on SUMPRODUCT Function.
• COUNTIF – The COUNTIF Function will help to count the cells that match a single condition or criteria.
• *Range * – It represents the input values of the cell.
• Things – This represents the values to be count.
• Comma (,) – It is a separator which helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

• In the below image, we enter the inputs in Column A.
• Then, enter the given formula in the formula bar.
• After applying the formula it will display the results in Cell D2 as shown below.

Example

• Follow the above steps to count the cells which contain one or more values in Excel.

Wind-Up:

In this tutorial, you can learn the simple and easy formulas to count the cells equal to many values in Excel Office 365 with a suitable Example. If you have any suggestions, don’t forget to drop it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!

Read Also:

• Formulas to Count Cells Contains Equal Values or Numbers in Excel!!
• Formulas for Counting the Cells between Two Numbers in Excel!!