Hello, Is there a way to identify the data you want? If so, you could use a set of =SUMIF() or =SUMIFS() to add up the data that matches one or a group of criteria. Otherwise, you may need to provide an example (obviously scrubbed since it seems to be some financial data) because I cannot quite picture what you are attempting to do.
I hope this helps. Rémy Gauthier. Le mercredi 15 février 2017 à 18:19 -0500, Robert Peirce a écrit : > 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+unsubscr...@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