using wildcards on text

S

Scott

How can I find a part of a text string in a cell from an external file?
This is what I currently have but it wont let me use wildcards (e.g.
"*ages*").

{=COUNT(IF('C:\[fileA.xls]sheetA'!$M$4:$M$1000="ages",'C:\[fileA.xls]sheetA'!$L$4:$L$1000))}
 
R

Roger Govier

Hi Scott

Maybe
=COUNTIF('C:\[fileA.xls]sheetA'!$M$4:$M$1000,"=ages*")
or
=SUMIF('C:\[fileA.xls]sheetA'!$M$4:$M$1000,"=ages*"
,'C:\[fileA.xls]sheetA'!$L$4:$L$1000)
 
Top