Unfortunately, if I'm not mistaken, your other files would need to be
opened when using the INDIRECT function. Since you likely would like
to avoid having to open relevant files before using the formula, I'd
suggest you search the Board/Newsgroups for the 'PULL' function by
Harlan Grove. I've never used it, but I believe it will give you what
you want without first having to open files.

bruce42 Wrote:
Thank you. That's perfect.

Is there a way to pull data from other files in the same folder as that
workbook? All of the other workbooks are formatted the same way.

I'm using the following formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&M2:M43&"'!S10:S54") ,G4,INDIRECT("'"&M2:M43&"'!AC10:AC54")))


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=381963