Adding over multiple workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-1764075%22%20slang%3D%22en-US%22%3EAdding%20over%20multiple%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764075%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20cells%20from%2013%20different%20workbooks%20into%20one%20workbook%20which%20shows%20annual%20totals.%26nbsp%3B%20So%20far%20I%20can%20populate%20the%20first%20workbook%20but%20when%20attempting%20to%20add%20another%20to%20the%20same%20cell%20I%20get%20an%20error%20which%20I%20can%20not%20resolve%2C%3C%2FP%3E%3CP%3EFirst%20formula%3A%3C%2FP%3E%3CP%3E%3DSUM('%5BFLASH%20REPORT-01-2Jan-29Jan-2017.xlsx%5DWK1N'!%24B%2419)%3C%2FP%3E%3CP%3Ewhen%20I%20add%20the%20next%20workbook%2Fcell%20to%20add%20I%20get%20an%20error%3C%2FP%3E%3CP%3ESecond%20formula%3A%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%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1764075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1764396%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20over%20multiple%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826322%22%20target%3D%22_blank%22%3E%40Crusty2020NC%3C%2FA%3E%26nbsp%3BRemove%20the%20%22)%22%20after%20the%20first%20%24B%2419.%20See%20if%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM('%5BFLASH%20REPORT-01-2Jan-29Jan-2017.xlsx%5DWK1N'!%24B%2419%2C'%5BFLASH%20REPORT-02-30Jan-26Feb-2017.xlsx%5DWK1N'!%24B%2419)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767313%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20over%20multiple%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826322%22%20target%3D%22_blank%22%3E%40Crusty2020NC%3C%2FA%3E%26nbsp%3B%20Thank%20you%2C%26nbsp%3B%20I%20feel%20silly.%26nbsp%3B%20Sometimes%20the%20obvious%20is%20not%20so%20clear%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECrusty%2C%2C%2Cout%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to add cells from 13 different workbooks into one workbook which shows annual totals.  So far I can populate the first workbook but when attempting to add another to the same cell I get an error which I can not resolve,

First formula:

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

when I add the next workbook/cell to add I get an error

Second formula:

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

2 Replies
Highlighted

@Crusty2020NC Remove the ")" after the first $B$19. See if that helps.

 

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

 

Highlighted

@Crusty2020NC  Thank you,  I feel silly.  Sometimes the obvious is not so clear to see.

 

Crusty,,,out