I'm trying to use indirect.ext to sum up data from a closed workbook.

When the workbook referenced by formula is open, it works perfectly which leads me to think that there is no issue with the formula.

When the workbook is closed, the formula returns a #VALUE error.

The formula parses to:

SUMIF({"Title";"JAN";"JAN"},"JAN",{"Quantity";1;1})

before returning a #VALUE error when I would expect 2 (1+1)

Running Excel 2010 on Windows XP 32-bit; all files are 2010 format. Any help is appreciated.