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