software

Hi
gt; I m facing problem with my worksheets which i have to calculate total
sales
gt; in particular month.
gt;
gt; sheet 1 have
gt;
gt; Date Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
gt; DD/MM/YY
gt; 1.10.2005 10000
gt; 2.10.2005 250000
gt; 3.10.2005
gt; 150000
gt; 4.10.2005 1000
gt; 1.11.2005
gt; 2.11.2005
gt; 3.12.2005
gt; 4.12.2005
gt; 1.1.2005 etc
gt;
gt; Sheet 2 have
gt; Quarterly Return
gt;
gt; Month
gt; Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
Dear Bob philip
thanks for response but it is not working. I think theres is date you assume
in text but it is in date format mm.dd.yy.
January
gt; February
gt; March
gt;
gt; In Sheet 2 i want to calculate Sale amount for particular month which is
in
gt; sheet 1
gt; How it can be
gt;
gt; Thanks and regard

Sorry I missed this one earlier.

try

=SUMPRODUCT(--(MONTH(Sheet1!$A$4:$A$200)=MONTH($A2)),Sheet1!B$4: B$200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Hi
gt; gt; I m facing problem with my worksheets which i have to calculate total
gt; sales
gt; gt; in particular month.
gt; gt;
gt; gt; sheet 1 have
gt; gt;
gt; gt; Date Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST
gt; gt; DD/MM/YY
gt; gt; 1.10.2005 10000
gt; gt; 2.10.2005 250000
gt; gt; 3.10.2005
gt; gt; 150000
gt; gt; 4.10.2005 1000
gt; gt; 1.11.2005
gt; gt; 2.11.2005
gt; gt; 3.12.2005
gt; gt; 4.12.2005
gt; gt; 1.1.2005 etc
gt; gt;
gt; gt; Sheet 2 have
gt; gt; Quarterly Return
gt; gt;
gt; gt; Month
gt; gt; Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4%
RST
gt; Dear Bob philip
gt; thanks for response but it is not working. I think theres is date you
assume
gt; in text but it is in date format mm.dd.yy.
gt; January
gt; gt; February
gt; gt; March
gt; gt;
gt; gt; In Sheet 2 i want to calculate Sale amount for particular month which is
gt; in
gt; gt; sheet 1
gt; gt; How it can be
gt; gt;
gt; gt; Thanks and regard