=SUMPRODUCT(--(Sheet1!$A$1:$A$1000$A2-7),--(Sheet1!$A$1:$A$1000<=$A2),--(Sh
eet1!$B$1:$B$1000=B$1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Adnan" (donotspam) wrote in message
...
I have a "Date" Colum, its first row begins with 01 Oct 06 and ends with
01
Oct 08.
I have another column "Type of Work" that has three types of work, SR, SO
and WR
I would like to draw a total number of Work Orders per week and type of
work
Order (results on the other sheet)
e.e:

Weekending SR SO WO
07-Oct-06 = 10 45 15
14-Oct-06 = 30 56 102
etc...

I tried with Pivot Table but I can cot brake them down by weeks.

Is there other way of working this out please? Perhaps formula, PivotTable
or maybe code?

Thank you,
Adnan

--
Please post all your inquiries on this community so we can all benefit -
Thank you!