Please Help!

[TRYIN]

I have Dealer#, DealerName, DateFunded(January 03, 2007), Amt. Funded and
RepName, I want to be able to write a formula to show me how many deals were
funded for each rep by each month for each dealer.

Thanks very much for your help in advance.

 

[Luke M]

You can do that with the SUMPRODUCT function. I found this site very helpful.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new

 

[Bernard Liengme]

Start by looking in Help for Pivot Table
Then read one or more of these

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/

Come back when you need more help
best wishes