Forum Discussion
Crusty2020NC
Oct 09, 2020Copper Contributor
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 a...
Riny_van_Eekelen
Oct 09, 2020Platinum Contributor
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)