Re: [libreoffice-users] Calc: SUM with multiple references (SOLVED)

Thank You!
It's a bit ugly. but it works.  :-)

On Mon, 2013-01-14 at 22:00 +0100, Regina Henschel wrote:
> Hi,
>
> in the coming LO4.0 you can use SUMIFS as in Excel. The release 
> candidate 1 is coming soon. If you are not in a productive environment 
> or you can spend a PC for it, please try it.
>
> Otherwise you can use the workaround described in the help. Look at the 
> example in the description of the function SUM.
>
> Kind regards
> Regina
>
>
>
> Chaz Sliger schrieb:
> > Need to create a formula similar to MS Excel.
> > Basic logic is:
> > Sum all values in C where A = x and B = y
> >
> > This is done to produce a sheet of consolidated sums from a sheet with
> > an ongoing set of log entries.
> >
> > LOG:
> > DATE       TIME ACTIVITY
> > 2013-01-06  :25 finance
> > 2013-01-06  :42 systems
> > 2013-01-06 1:13 finance
> > 2013-01-06  :23 systems
> >   ...
> >
> > SUMS:
> > DATE       finance systems
> > 2013-01-06 1:38    1:05
> >   ...
> >
> > So the formula becomes something like:
> > sumif(LOG.$A:A=$A2 AND LOG.$C:C=$B$1; LOG.$B$2:B)
> >
> > Any suggestions?



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