Nice find Rod. Does much the same thing and eliminates the need for a
third column. Still have to feed the criteria into it though, but
should be pretty easy.
Dennis noted he had figured out how to do what he needed with the
DataPilot and I've been poking around with that as well. Produces a
very nice little table.
Jeff
Randomthots wrote:
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)
