Looks like DataPilot will do what I want. Please ignore unless you have a better solution.
"Dennis Marks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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. > > -- > Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
