Jeff Causey wrote:
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.
There's a sumif() function, but I can't tell you more about it since the
help system in 2.01 calc is all horked up.
(I think I'm going to revert back to 2.0 and hope for 2.02)
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
