SUMIFS across multiple closed workbooks

		Microsoft Office Forums > Microsoft Excel > Excel
SUMIFS across multiple closed workbooks

FAQ

Thread Tools

Display Modes

01-14-2016, 06:25 AM

funkyfido

Windows XP SUMIFS across multiple closed workbooks

Office 2007

Novice

Join Date: Jun 2013

Posts: 24

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 AM.