Hi
I have a spreadsheet where I am doing the following (amongst other things):
- listing a number of products
- which are delivered on a particular week
eg
Column A lists product names
Column B lists number of units (of a particular product) shipped
Column C lists the ship date
In a seperate sheet I want to identify how many of each item werr shipped in a particular week (in a table)
eg
Column A product name
Column B onwards is Week Ending Date
Under each Date it should have a total of units ship for that particular product/row in that week i.e. between the dates in each column
I looked at SUMPRODUCT to do this, but can't figure out how to do the lookup ie if product name, then SUM units between DATE1 and DATE2.
Any thoughts?
Thanks
Carlos
Bookmarks