Vlookup containing a date condition

[TomTomExcel]

Hi,

I am looking for some help.

At work i have a report containing product, quantity and dates. I would like to set up a formula to combine all qty's by weekly in a report listing all products. (See example of delivery report "attachment capture 1")

I usually use Vlookup to extract total quantity from the report. But i cannot find a way to extract the quantity within certain dates, in this case per week. (see how I want my report to look like in "attachment capture")


Cheers,
Tom

 

[johnny51981]

Hi Tom:
A SUMIFS might do you some good.

Try this. Mind you, since I we can't see the Column and Row addressing in your screenshots, I've used descriptions rather than cell addressing. Also, you will need to include one more cell that has the week prior to your WK1 Ending date, so you can collect the correct counts there.

=SUMIFS([Your Quantity Column], [Your Product Column] = [The Product Column in your Summary], [Delivery Date Column] > [The Previous Week Ending Date in your Summary], [Delivery Date Column] <= [The Current Week Ending Date in your Summary]