The sumif function is a little simpler: =sumif(A2:A512;A520;B2:B512)
where A520 contains the criterion to determine what to sum. Range names
would make it more readable. But if you're happy, I'm happy.
On Sat, 2006-01-14 at 16:54, Dennis Marks wrote:
> 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]
--
Fred
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
