Adding over multiple workbooks

Copper 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

@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)

 

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

 

Crusty,,,out