Sum function across multiple spreadsheets

[jmcclain]

I am trying to create a summart spreadsheet that will total $ figures from
various excel files.

Most of the "target cells" that contain the $ figure to be added is in
itself a total of cells within that spreadsheet.

I am not able to create this as I normally would.

Any suggestions would be appreciated.

 

[Don Guillett]

Have your total in the same cell on each worksheet. Then
=sum(sheet1:sheet5!a1)

 

[jmcclain]

Thank - However,I need to show a line item for each total pulled from the
respective spreadsheet and then calculate a grand total.

 

[Jonathan Rynd]

Thank - However,I need to show a line item for each total pulled from
the respective spreadsheet and then calculate a grand total.

Then you'll need to use the INDIRECT function.

Something on the order of:
=INDIRECT("sheet"&(row()-5)&"!A1")
to get each line item, then calculate the grand total as usual.