ISNUMBER(SEARCH

[Renattae_Schmidt]

Hello all,

I was wondering if it possible to have multiple ISNUMBER(SEARCH functions in a formula. I am currently using this formula but only the first ISNUMBER(SEARCH seems to be working.

=COUNTA(UNIQUE(FILTER('Iri Comp Data'!K:K,('Iri Comp Data'!C:C<=200)*ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!O:O)*ISNUMBER(SEARCH("ON",'Iri Comp Data'!$S:$S))))))

Thank you!

[#2 · Accepted solution]

@Renattae_Schmidt 

Perenties were using wrongly, it shall be like

=COUNTA(
   UNIQUE(
   FILTER( 'Iri Comp Data'!K:K,
           ('Iri Comp Data'!C:C<=200) *
           ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!O:O) ) *
           ISNUMBER( SEARCH( "ON",'Iri Comp Data'!$S:$S )) )))