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
Bookmarks