Hey guys,

I'm creating a sheet to basically track downtime within a certain production
Cell, at the moment i have used mainly countif statements as well as
Sumproduct to tally up the minutes when 2 conditions are true. for example
the cell is BA and the operation is a setup, repair etc.

Now i need to narrow it down to downtime in a specific week, how would i
enter a sumproduct and counif to run between certain dates ?

Example of the sheet data would be ..

Date Cell Operation mins
01/10/2007 BA Setup 50
03/10/2007 Filters Repair 30

Any help would be greatly appreciated ...