How to SUM the same cell over multiple pages in a workbook? I have a simple workbook with Cell A20 showing a number amount on every page (each page is a persons name). I want to total up the A20 cells from the first page to a page called “End”. I get an error #NAME? using the formula I used in Excel so I assume it must be different in LibreOffice.
Any advice would be much appreciated.
- You’re kidding?
How should a contributor to this site know what formula you used in Excel?
How should we know if you replaced the “!” as sheetname separator with “.” as needed? - Ranges spanning multiple adjacent sheets are named cuboids in Calc. In the single sheet the range may consist of a single cell.
There are only a few functions accepting cuboids in an argument position. (SUM()does.) - Stabbing in the dark I can only give a related example like
=SUM($StartSheet.$A$1:$EndSheet.$A$1)
1 Like
Thank you Lupp. I’m sorry I did not have the correct words to explain my issue, but you worked it out, clever person.