Bob,

I appreciate your quick response. I tried it, it gives me a number but I
dont really seam to know where its coming form nor what its calculating?

Where do I paste this formula?

Note: Sheet1 has the data, and sheet2 should have results, I have the format
on sheet2 that looks this way:

Weekend SRs SOs WRs
07-Oct-06 [formula here for each for each work type (SR, SO, WR)]
14-Oct-06 €¦
21-Oct-06 €¦

Thank you again,
Adnan

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


"Bob Phillips" wrote:

=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!