Hi Guys

I have a requirement to count the number of cells only if they include an exact match in column C and also contain specific text within a string of text in the corresponding row of Column D.

I am trying to use the countifs function with the search function as below without success.


=COUNTIFS('Incite Raw'!$C$2:$D$12241,"="&$B3,'Incite Raw'!$C$2:$D$12241,ISNUMBER(SEARCH(E$1,'Incite Raw'!$C$2:$D$12241)))

Is this formula incorrect and if so what is the best way to achieve the result?

Thanks

Scott