ExcelBanter - How can I get a total across multiple spreadsheets?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I get a total across multiple spreadsheets? (https://www.excelbanter.com/excel-worksheet-functions/6505-how-can-i-get-total-across-multiple-spreadsheets.html)

Margaret McCullough

How can I get a total across multiple spreadsheets?

I have a workbook that contains 4 spreadsheets (ss). The first ss is a grand
total of the remaining ss. I'm trying to pull the numbers from the 3
spreadsheets onto the first spreadsheet so I have a total of certain numbers.
Any help would be greatly appreciated!!

Frank Kabel

Hi
=SUM('sheet1:sheet4'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Margaret McCullough" <Margaret
schrieb im Newsbeitrag
...
I have a workbook that contains 4 spreadsheets (ss). The first ss is
a grand
total of the remaining ss. I'm trying to pull the numbers from the 3
spreadsheets onto the first spreadsheet so I have a total of certain
numbers.
Any help would be greatly appreciated!!

All times are GMT +1. The time now is 07:24 PM.