a pivot table sounds like it would be your best way to go. Make sure no
blank rows are in your information table. select a cell within the info (or
highlight all the data). Go to the Data menu -- choose Pivot Table And Pivot
Chart Reports. The Wizard should pop up and instruct you through it. This
will make it easier to select information by month, salesman, item, or
combinations of them. This will also create your chart for you.

"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