Hi. 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)
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. Thanks, 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
