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.
I reckon indirect.ext probably returns an array when the workbook is closed and sumif will not work with an array as the first argument only with a range
Josie
if at first you don't succeed try doing it the way your wife told you to
SUMIF doesn't work with closed workbooks, try using SUMPRODUCT, e.g.
=SUMPRODUCT((Range1="Jan")+0,Range2)
Audere est facere
Makes sense. Thanks for the quick reponse.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks