[libreoffice-users] Is there an easy way to sum across a gap?

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: users+unsubscribe@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