Sum products prices that are between two dates

Hi all,

I was wondering if someone could tell me what the formula would be if I
wanted to add the prices of products that were purchased between two dates.

If column A was formatted with the dates between 01/01/06 and 31/01/06
and column B with the prices.

Thanks in advance

Maddoktor

Hi Maddoktor

In cell D1, enter the Start date required in cell E1 enter the end date
required.
In F1 =SUMPRODUCT(--($A$1:$A$100>=D1),--($A$1:$A$100<=E1),$B$1:$B$100)

Change the ranges to suit.

--
Regards

Roger Govier


"Maddoktor" <maddoktor@clinic.com> wrote in message
news:e1v4slKKGHA.532@TK2MSFTNGP15.phx.gbl...
> Hi all,
>
> I was wondering if someone could tell me what the formula would be if
> I wanted to add the prices of products that were purchased between two
> dates.
>
> If column A was formatted with the dates between 01/01/06 and 31/01/06
> and column B with the prices.
>
> Thanks in advance
>
> Maddoktor