Workbook Referencing for SUMIFs

[Scoggs]

I'm having some difficulty referencing my SUMIF formulas that have multiple criteria to an external workbook that contains multiple sheets. Currently I am able to link to an individual sheet with this:

=SUM(IF(('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan'!$D$7:$D$2000="Criteria A")*....etc

I would like to make a cumulative formula with a reference that spans each month tab of an external workbook. I've have luck with this on other formulas, but no luck with complex SUMIFs with multiple criteria. This is what I'm working with and not having much luck.=SUM(IF(('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan:Dec'!$D$7:$D$2000="Criteria A")*('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan:Dec'!$F$7:$F$2000="Criteria B"),'X:\MAM
\Tracking\Yearly Reports\[2014 Report.xlsm]Jan:Dec'!$O$7:$O$2000))

Any advice or suggestions would be extremely helpful. Thanks!

- Chris

 

[RoryA]

I wouldn't even attempt that. Even were you to get a working version, the performance would most likely be appalling. Do the yearly summaries in the source workbook and then go back to the original formula. Better still, have one table of data in the source workbook that you can use as the source for a pivot table or query.