ExcelBanter - Combine cell totals from 5 sheets into summary in Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combine cell totals from 5 sheets into summary in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/31375-combine-cell-totals-5-sheets-into-summary-excel.html)

milor

Combine cell totals from 5 sheets into summary in Excel

Norman Jones

Hi Milor,

=SUM(Sheet1:Sheet5!A1)

---
Regards,
Norman

"milor" wrote in message
...

All times are GMT +1. The time now is 01:55 PM.