Forum Discussion

Crusty2020NC's avatar
Crusty2020NC
Copper Contributor
Oct 09, 2020

Adding over multiple workbooks

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)

excel

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 09, 2020

    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)