Thread: Inserting a string seach within a complex function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DJ_Swammi
 
Posts: n/a
Default Inserting a string seach within a complex function
Hi everyone, quick question:

How can I use IF(ISNUMBER(SEARCH... within a SUMPRODUCT statement?

Here's the code I came up with, but it doesn't really seem to work:

=SUMPRODUCT((Strategies!$B$3:$B$62=1)*(Strategies! $E$3:$E$62=(IF(ISNUMBER(SEARCH(1,Strategies!$E$3:$ E$62)),1,0))))/(COUNTIF(Strategies!$B$2:$B$62,1))

Any suggestions?
Reply With QuoteReply With Quote