Sum products prices that are between two dates

M

Maddoktor

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
 
R

Roger Govier

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.
 
Top