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

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