On Wednesday, May 15, 2013 10:38:17 AM UTC-7, JoshBrunz wrote:
i have 1 workbook with about 20 sheets, i need to search this workbook

for a name in one column on each sheet. i made a list of the sheets in

the 2nd workbook in column a. i tried this formula in column b, but i

can't get it to recognize the cell in my formula:



=SUM(SUMIF(INDIRECT("'[cfshows.xls]&A2'!U:U"),"Brown, Bob"))









--

JoshBrunz

Hi Josh,

What do you want the formula to return once it finds the name in one of the sheets?

Regards,
Howard