After further research I got rid of the datapilot table and used the
following:
{=SUM((A2:A512=A520)*B2:B512)}
It checks the value of each date in the aray A2:A512 against the date in
A520. If they are equal it multiplies 1 by the values that I am summing in
B2:B512. If the dates are not equal it multiplies by 0. It works great and
is automatic.
"Dennis Marks" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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]
