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
Greetings,
Cor
--
- - - - - - - - - -
- Cor Nouws -
- www.nouenoff.nl -
- - - - OOo - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
