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