calculation sales of particular month among months of sale

calculation sales of particular month among months of sale

Post by UmFvIFJhdG » Thu, 02 Feb 2006 21:00:28


Hi
sales
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
in
 
 
 

calculation sales of particular month among months of sale

Post by Bob Philli » Thu, 02 Feb 2006 21:33:42

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)



RST
assume

 
 
 

calculation sales of particular month among months of sale

Post by flumm » Sat, 04 Feb 2006 21:47:55

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