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]
