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.

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

http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new
--
Best Regards,

Luke M


"TRYIN" wrote:

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.

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/2...le-parameters/

Come back when you need more help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TRYIN" wrote in message
...
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.