On 2012-04-19 10:09, T. R. Valentine wrote:
On 18 April 2012 16:57, Steve Edmonds<[email protected]> wrote:
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)
Example: =SUM(Sheet1.A1:Sheet2.C6) -- will total everything in Sheet1
and Sheet2 in cells A1 through C6. It will not include a value in,
e.g., Sheet1.D1.
My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
SUM(Bill.E4:Harry.E4) doesn't work.
SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work.
Once you rename a sheet, you have to use the sheet's name. If you
create the formula before renaming a sheet, the formula will be
changed.
If the first sheet is Bill and the last sheet is Harry and you want to
add values in cell E4 of each sheet: =SUM(Bill.E4:Harry.E4)
Thanks TR and to Regina.
I could not get this to work this morning at home (#Ref errors), but it
does here at work (I just fetched the sheet off my home PC). The sheet
is a few years old so probably originated in OOO but the OS and LO
versions at work and home should be the same. I will check, it is
working now so that is what is important.
Cheers, Steve
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
