Calculation based with Range of Date

Hi
I m facing problem with my worksheets which i have to calculate total sales
in particular month.

sheet 1 have

Date Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
DD/MM/YY
1.10.2005 10000
2.10.2005 250000
3.10.2005
150000
4.10.2005 1000
1.11.2005
2.11.2005
3.12.2005
4.12.2005
1.1.2005 etc

Sheet 2 have
Quarterly Return

Month
Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
January
February
March

In Sheet 2 i want to calculate Sale amount for particular month which is in
sheet 1
How it can be

Thanks and regard

B2: =SUMPRODUCT(--(TEXT(Sheet1!$A$2:$A$200,"mmmm")=$A2),Sheet!B$2:B$200)

copy down and across

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rao Ratan Singh" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I m facing problem with my worksheets which i have to calculate total
sales
> in particular month.
>
> sheet 1 have
>
> Date Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
> DD/MM/YY
> 1.10.2005 10000
> 2.10.2005 250000
> 3.10.2005
> 150000
> 4.10.2005 1000
> 1.11.2005
> 2.11.2005
> 3.12.2005
> 4.12.2005
> 1.1.2005 etc
>
> Sheet 2 have
> Quarterly Return
>
> Month
> Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
> January
> February
> March
>
> In Sheet 2 i want to calculate Sale amount for particular month which is
in
> sheet 1
> How it can be
>
> Thanks and regard
>