SUMIFS across multiple closed workbooks

Debaser · #1 01-14-2016, 06:31 AM

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))

funkyfido · #2 01-14-2016, 06:43 AM

Thanks that works a treat. Why is the last part of the formulae a * and not a select? Want to understand how it works.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pull the data from different closed workbooks paste into master vba	manilara	Excel Programming	2	11-19-2015 08:41 PM
Vlookup multiple workbooks	c123456	Excel	3	03-13-2015 12:59 PM
Office 2008 workbooks into Office 2011 workbooks	nfotx	Excel	0	12-07-2014 04:22 PM
Help with SUMIFS	LeFoah	Excel	2	10-20-2013 09:22 AM
Link multiple excel workbooks to publisher	bandcsaravia	Publisher	0	10-24-2011 09:14 AM