Excel...Adding Data Cells from multiple workbooks into separate workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1763920%22%20slang%3D%22en-US%22%3EExcel...Adding%20Data%20Cells%20from%20multiple%20workbooks%20into%20separate%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763920%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%2013%20workbooks%20that%20I%20am%20attempting%20to%20consolidate%20into%20a%20annual%20summary.%26nbsp%3B%20I%20am%20able%20to%20import%20only%20the%20first%20portion%20of%20the%20equation%3C%2FP%3E%3CP%3E%3DSUM('%5BFLASH%20REPORT-01-2Jan-29Jan-2017.xlsx%5DWK1N'!%24B%2419)%3C%2FP%3E%3CP%3Eafter%20which%20I%20get%20errors.%3C%2FP%3E%3CP%3E%3DSUM('%5BFLASH%20REPORT-01-2Jan-29Jan-2017.xlsx%5DWK1N'!%24B%2419)%2C'%5BFLASH%20REPORT-02-30Jan-26Feb-2017.xlsx%5DWK1N'!%24B%2419)%3C%2FP%3E%3CP%3ECan%20you%20advise%20on%20how%20to%20modify%20this%20formula%3F%26nbsp%3B%20Once%20I%20can%20add%20two%20cells%20I%20should%20be%20able%20to%20figure%20out%20how%20to%20add%20the%20other%2011.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1763920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have 13 workbooks that I am attempting to consolidate into a annual summary.  I am able to import only the first portion of the equation

=SUM('[FLASH REPORT-01-2Jan-29Jan-2017.xlsx]WK1N'!$B$19)

after which I get errors.

=SUM('[FLASH REPORT-01-2Jan-29Jan-2017.xlsx]WK1N'!$B$19),'[FLASH REPORT-02-30Jan-26Feb-2017.xlsx]WK1N'!$B$19)

Can you advise on how to modify this formula?  Once I can add two cells I should be able to figure out how to add the other 11.

1 Reply

@Crusty2020NC Sum is used for ranges, you just want to add 2 cells, so use '+' directly:

'[FLASH REPORT-01-2Jan-29Jan-2017.xlsx]WK1N'!$B$19) + '[FLASH REPORT-02-30Jan-26Feb-2017.xlsx]WK1N'!$B$19