Thread: [Solved] SUMIFS across multiple closed workbooks
View Single Post
 
Old 01-14-2016, 06:31 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You really don't want to use entire columns in a SUMPRODUCT formula so you'll need to limit the rows:

=SUMPRODUCT('C:\path to file\[WORKBOOK.XLSX]Dec15 Pt2'!$S$1:$S$1000,('C:\path to file\[WORKBOOK.XLSX]Dec15 Pt2'!$N$1:$N$1000=$A3)*('C:\path to file\[WORKBOOK.XLSX]Dec15 Pt2'!$R$1:$R$1000=$B3))
Reply With Quote