ExcelBanter - sum over more then one sheet

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sum over more then one sheet (https://www.excelbanter.com/excel-programming/322422-sum-over-more-then-one-sheet.html)

hans[_3_]

sum over more then one sheet

I have a function maxsheetname
it returns the highest sheetname

Now i want to sum cel c1 on sheet 1 to maxsheetname()
=SUM('1:maxsheetname()'!C1) does not work.

What am i doing wrong

Greetings Hans

All times are GMT +1. The time now is 02:17 AM.