I am not sure what you mean by pivot table.

I have two sheets....

'Sheet One' with client data...this is the sheet that has the referral
source (C10:C1000) and the status fields (D10:D10000).

'Sheet Two'...I want to list statistics....so on this sheet I may
list:

Cell A1 = the # of clients that have a referral source of "Yellow
Pages" and a status of "Interested"
Cell A2 = the # of clients that have a referral source of "Yellow
Pages" and a status of "Not Interested"
cells A3:A15 will contain other variations of statistical data.

If this Pivot table will accomplish this can you explain it more to me?


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=516297