Re: [libreoffice-users] Sum across sheets

On 2012-04-19 10:09, T. R. Valentine wrote:
> On 18 April 2012 16:57, Steve Edmonds<steve.edmonds@ptglobal.com>  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: users+help@global.libreoffice.org
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