[libreoffice-users] Sum across sheets

[Steve Edmonds <steve.edmonds@ptglobal.com>]

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: 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