calculation sales of particular month among months of sale
 

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

calculation sales of particular month among months of sale
 

Try this version then

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

"Rao Ratan Singh" wrote in message
...
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
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
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

calculation sales of particular month among months of sale
 

As far as I understand it your problem is this:

You have sheet1 with the following

Date sales1 sales2 sales3 for cells say a5:d20

You have sheet 2 with the following: for cells say a5:d??

month <sum of sales1 per month <sum of sales2 per month etc

In A5:A7 enter the months 1, 2, and 3

In B5 enter:
=SUMPRODUCT(--((MONTH(Sheet1!$A$5:$A$20)=$A5)*Sheet1!B$5:B$20))

Copy B5 to C5 and D5
Copy B5:D5 to B6 to D7

In A9 enter Q1
In B9 enter =sum(B5:B7) and copy to C5 and D5

Repeat this for the rest of the months

Hans