I have data in a table by month. At the end of each year there is a
summary row separated by a blank line above and below. Frequently I
need to sum from, say, 03/16-02/17 so I have 10 rows with data I want,
three rows with data I don't want and two more rows with data I want.
My approach has been something like this:
sum(A3:A12)+sum(A16:A17)
A13:A15 contain the data I don't want but I want to be able to see.
This works but it is less than automatic. When I copy the formulae I
need to edit them so they apply to the right rows.
Another thing is the rows summed aren't always the same. Sometimes I
may need only two rows and other times maybe as many as 12.
--
To unsubscribe 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
