On Fri, 2006-01-13 at 23:52 +0100, Cor Nouws wrote: > Hi Dennis, > > Dennis Marks wrote: > > > Is this possible with a function or a feature of Calc. I have a spreadsheet > > as follows: > > > > COL1 COL2 > > AAAAA value > > BBBBB value > > CCCCC value > > AAAAA value > > BBBBB value > > CCCCC value > > etc > > > > I would like a sum of value in col2 ONLY when item in column 1 is a > > specific > > value. For example what is the sum of the values where col1 is equal to > > BBBBBB? I can't sort it and there can be a variable number of records. > > > > To be more specific I have payroll records for each employee. I would like > > to sum records only for a specific date. > > I would suggest: > - target value in lets say D1 > - in Col3: IF(A1=$D$1;B2;"") > - and under Col3 the sum
I would think that the SUMIF() function would be ideal for this problem. Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
