Excel Formulas: Cells Contains One of Many Things with SUMPRODUCT!!

We have already learned how to check the cell that contains one of many things in Excel. Here we are going to solve the same problem by using the SUMPRODUCT function only. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want the test the cells that contain one of many things in Excel, you can use the below formula.

=SUMPRODUCT(–(A1=things))>0

Syntax Explanations:

*SUMPRODUCT * – This function helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the SUMPRODUCT Function.
*A1 * – It represents the input text strings.
Minus Operator (-) – This symbol will help to subtract any two values.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example.

Here we will enter the input text strings in Column B.
Now, we need to check if the cell contains one of many things.

Select any cell and apply the above-given formula.

Finally, press ENTER to get the result out.

Verdict:

Here, we have described the formulas to check if the cell contains one of many things in Excel using the SUMPRODUCT function. If you have any doubts regarding this topic or any other Excel VBA-related topic, ask in the comments section below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **