Hi,

What does "not work" mean? What kind of result are you getting? Are the
workbooks opened?

Jean-Guy

" wrote:

On Mar 8, 3:00 pm, "Bob Phillips" wrote:
=SUMPRODUCT((INDIRECT("'["&A1&"]"&B1&"'!$L$64:$L$500")<0)*(L64:L500<"TOTAL")*(I6 4:K500))

--
---
HTH

Bob

Nope, I tried that. Doesn't work. Thanks anyway.