ExcelBanter - Microsoft Excel

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

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

- - Microsoft Excel (https://www.excelbanter.com/excel-worksheet-functions/88886-microsoft-excel.html)

Laurie

Microsoft Excel

Can I create a summary worksheet in a workbook that contains totals from each
worksheet in that workbook.

CLR

Microsoft Excel

Yes,
This formula in any cell in Sheet1 will return the value in Cell D1 of Sheet2
=Sheet2!D1

Likewise, this one will return the value in cell G7 of Sheet3, etc etc
=Sheet3!G7

hth
Vaya con Dios,
Chuck, CABGx3

"Laurie" wrote:

Can I create a summary worksheet in a workbook that contains totals from each
worksheet in that workbook.

All times are GMT +1. The time now is 05:43 PM.