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) -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- 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
