Dennis,
You stated that you can't sort the data in the columns. I'd be
interested to know why that is, only because my first thought was that
would be the easy way.
One possible solution would be to create a third column containing an IF
function that matches the value from COL1 with another value you enter.
If they match, it fills in the value from COL2, otherwise it enters a 0.
I setup a test spreadsheet and I have a cell C2 where I enter my "test"
value (e.g. AAAAA). My formula in cell C5 is:
=IF(A5=$C$2;B5;0)
Depending on your data source, you may need to set this up in a separate
file and it could be cleaned up to make it easier to use (especially if
you'll be doing this a lot). But I think this should give you the basic
concept.
HTH,
Jeff Causey
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.
