Why not use a pivot table?

http://peltiertech.com/Excel/Pivots/pivotstart.htm


otherwise use

=SUMPRODUCT(--(MONTH(A2:A200)=7),--(B2:B200="Bike"),--(C2:C200="Mike"),D2:D200)

assuming you want to count the numbers in D where A is a particular month
(in this example July), B is bike and C is Mike

--
Regards,

Peo Sjoblom

(No private emails please)


"jshafer817" wrote
in message ...

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