Re: sumproduct between two dates

Thank you very much!! Both formulas worked.

"Bob Phillips" wrote:

> =SUMPRODUCT(--(A2:A20>=--"2005-07-20"),--(A2:A20<=--"2005-7-20"+30),--(B2:B2
> 0>50%),C2:C20)
>
> --
> HTH
>
> Bob Phillips
>
> "chased" <chased@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:854C00EF-CE82-4104-B6C0-AA2B7A802D66@xxxxxxxxxxxxxxxx
> > I have a Date column, a percentage column, and a balance column. I want
> to
> > add all balances between a specific date to 30 days after that date and
> all
> > balances between those dates above a certain percentage.
> >
> > Date Pctg. Balance
> > 7/15/05 50% 10000
> > 7/29/05 75% 15000
> > 7/31/05 75% 15544
> > 8/08/05 50% 12344
> >
> > I want the formula to review from 7/15/05 to 8/15/05 and everything above
> > 50% and add the balances that qualify.
>
>
>
.

Relevant Pages

  • Re: sumproduct between two dates
    ... HTH ... Bob Phillips ... > balances between those dates above a certain percentage. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional formating, values.
    ... The trick is to ensure that that is the first condition, ... > HTH ... > Bob Phillips ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Totaling Months
    ... HTH ... Bob Phillips ... > I have 3 columns in my worksheet, column F Date Due, column G is Date ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: excel sorting task
    ... HTH ... Bob Phillips ... > I have the following data in a worksheet ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: How do I make a column of checkboxes quickly?
    ... HTH ... Bob Phillips ... > I have a list of people my company has already mailed letters to (about ... Prev by Date: ...
    (microsoft.public.excel.misc)
Loading