PieterLambrechts
New Member
- Joined
- Feb 22, 2021
- Messages
- 5
- Office Version
- 2010
- Platform
- Windows
Dear fellow Excel enthusiasts
I am trying to sum one cell across multiple worksheets. The worksheets that I want to include in the sum are all, except the first worksheet (Dashboard is used to display information).
I use the following formula: =SUM(Firstsheet:Lastsheet! H26). I always get the error: #name? I googled for about an hour, tried a bunch of different things (adding ' or " before and after the sheet names for example) but this doesn't work. Does anybody know what I might be doing wrong?
Many thanks in advance!
I am trying to sum one cell across multiple worksheets. The worksheets that I want to include in the sum are all, except the first worksheet (Dashboard is used to display information).
I use the following formula: =SUM(Firstsheet:Lastsheet! H26). I always get the error: #name? I googled for about an hour, tried a bunch of different things (adding ' or " before and after the sheet names for example) but this doesn't work. Does anybody know what I might be doing wrong?
Many thanks in advance!