ExcelBanter - Summing up worksheets

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

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

- - Summing up worksheets (https://www.excelbanter.com/excel-worksheet-functions/106670-summing-up-worksheets.html)

Orninn

Summing up worksheets

How do I sum up totals from different worksheets?

Bob Phillips

Summing up worksheets

=SUM(Sheet1!A1:A10)+SUM(Sheet2!B5:B25)

or maybe

=SUM(Sheet1:Sheet3!A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Orninn" wrote in message
...
How do I sum up totals from different worksheets?

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