27
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

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
Let’s consider the below example.



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 *!! **
27