I am using the below sumifs formula that references another file that has a large number of Tabs.
This Large Data File uses First/Last Tabs - all Data Tabs are in the same format. Excel 2010
To do this, I believe I need utilise the @Indirect Function, but I am struggling to incorporate into the below formula.
=SUMIFS('[LargeDataFile.xlsx]2014'!$H$7:$H$665,'[LargeDataFile.xlsx]2014'!$D$7:$D$665,$C5,'[LargeDataFile.xlsx]2014'!$B$7:$B$665,D$2)
Thank you - Any help appreciated
Bookmarks