using wildcards on text
 

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))}

using wildcards on text
 

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)

--
Regards

Roger Govier


"Scott" wrote in message
...
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))}