As an example, let's say your data is in cells A1:D4.

You could create a table with month number along the left side and names
across the top (in my test I created this table in cells A10:C14)

John Matt
1 X
2
3
4
5
6


Then enter a formula like this, copy across and down (I entered it in cell
B11, where the "X" is above):

=SUMPRODUCT((MONTH($A$1:$A$4)=$A13)*($C$1:$C$4=B$1 0)*($B$1:$B$4="Bike"))

To get the value of the bikes sold, you could add

*($D$1:$D$4)

at the end of the formula (inside the last parenthesis).



"jshafer817" wrote:


I need some major help. I have 4 columns.
A B C
D
3/1/2005 Bike John
Amount

a is date
b is product
c is salesman
d is amount

I need to write a formula and come up with a chart that will show how
many bikes that john sold, each month.

I thought it would be a lot simpler, and I am trying to educate
myself.
I have played with SumIF and SumProduct, but I dont think sumif
supports multiple criteria ranges.

I am a major noob when it comes to writing formulas. I could build you
a samba server, and build a website, but I cant seem to do this at
all.

I bet this is easy for some of you guys out there. Can you lend me a
hand????


--
jshafer817
------------------------------------------------------------------------
jshafer817's Profile: http://www.excelforum.com/member.php...o&userid=25758
View this thread: http://www.excelforum.com/showthread...hreadid=391707