ExcelBanter - how do i add up the same cell from multiple named tab sheets

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

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

- - how do i add up the same cell from multiple named tab sheets (https://www.excelbanter.com/excel-discussion-misc-queries/212831-how-do-i-add-up-same-cell-multiple-named-tab-sheets.html)

Paul

how do i add up the same cell from multiple named tab sheets

I need to add the same cell from multiple different named tabs into a report.

and many times

any ideas short of "sheet1,a1+sheet2,a1+.........

--
Thanks

Paul

Jarek Kujawa[_2_]

how do i add up the same cell from multiple named tab sheets

=SUM('sheet1:sheet20'!a1)

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