sumproduct help
 

Hello,

I would like to ask for help with a sumproduct formula. On sheet one I will
dump a report that has more than five months of data. The data looks like
this:
A B C
D
2/25/2006 15:27 Order Status Store One Not Started
2/25/2006 15:35 Order Status Store Two In Progress

I need help with writing the formula to pull numbers only between a seven
day period if the status (column D) shows Not started or In progress and if
it matches the store (column C).

The sheet that will show the result will have the store names listed in the
A column and the Dates of the report (start and end) listed in B1 and C1.

Thanks for the help.