Microsoft Office Forums - View Single Post - [Solved] SUMIFS across multiple closed workbooks

Thread: [Solved] SUMIFS across multiple closed workbooks

View Single Post

Old

01-14-2016, 06:25 AM

funkyfido

funkyfido is offline

funkyfido uses Windows XP

Windows XP funkyfido uses Office 2007

funkyfido uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jun 2013

Posts: 24

funkyfido is on a distinguished road

Default

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.

Reply With Quote