Include an OR inside the sumproduct function

Hello, I have 2 formulas SUMPRODUCT(--ISNUMBER(SEARCH .... and wanted to ask how can I make both in one formula with OR

=IF(CE$2="NO",0,IF(SUMPRODUCT(--ISNUMBER(SEARCH(","&$BB$43:$BG$43 & ",",","&AX9 & ",")))>=$CE$3,0,1))
=IF(CE$2="NO",0,IF(SUMPRODUCT(--ISNUMBER(SEARCH(","&$BB$44:$BG$44 & ",",","&AX9 & ",")))>=$CE$3,0,1))

I know * is or but couldn't figure it out when using isnumber and search with it.

I really appreciate your helps

is this part a typo? $BB$43:$BGB$43
because your other formula looks at BB44:BG44
not being able to see the formulas in action, I wonder if you would be able to change the $BB$43:$BG$44 as it appears you are searching for the same things in both parts unless the BGB part isn't a typo.

a sample workbook would be helpful unless you tried this...
=IF(CE$2="NO",0,IF(SUMPRODUCT(--ISNUMBER(SEARCH(","&$BB$43:$BG$44 & ",",","&AX9 & ",")))>=$CE$3,0,1))
and it worked?
it appears to me that you are looking for the same info in each row, I'm not completely sure where to insert the OR. That is why a simplified sample workbook would be helpful WITH expected results (see yellow banner at the top of the post for instructions about uploading one).

Please try

Formula:

Please Login or Register  to view this content.

Thanks for the feedback and rep . Glad to have helped.