Sum products prices that are between two dates

  • Thread starter Thread starter Maddoktor
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify occurences that occur after a date but not before 1
Find last date of sold stock and sold price. 2
Charts based on Different Dates 2
compare date range with date in columns and input data from another cell 2
Count between dates 2
Sum workdays by month from List of Start/End dates 4
Sum value between two dates and copy to new cell 6
Using countif with a range of dates 5

Back
Top