Oct 09 2020 06:31 AM
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)
Oct 09 2020 07:25 AM
@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)
Oct 10 2020 06:32 AM