| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a decimal from the right of a string | Excel Discussion (Misc queries) | |||
| Function to convert Time String to Time | Excel Worksheet Functions | |||
| Complex if and mid function. | Excel Worksheet Functions | |||
| Inserting an AutoDate Function | New Users to Excel | |||
| Copy an IF function when Inserting new row | Excel Discussion (Misc queries) | |||
Threaded Mode
