|
|
#4
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)) 
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode