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

i got it to work... kind of.. with:

=COUNTIF(INDIRECT("'[cfshows.xls]"&A38&"'!U:U"),"=Brown, Bob")

but it always returns 1, even if bob is on there 20 times