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

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