SUMIFS across multiple closed workbooks

Debaser · #1 01-14-2016, 05:56 AM

Use SUMPRODUCT instead. What would your SUMIFS formula look like if it worked?

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

I would have had this on each of my spreadsheets.

=SUMIFS('Dec15 Pt2'!$S:$S,'Dec15 Pt2'!$N:$N,$A3,'Dec15 Pt2'!$R:$R,$B3)

For each month I have several parts all in different excel files.

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