Create a summary table from different text criteria

Hi,

I am having trouble converting text data to numerical data. I have attached two sample tables. I want a summary of the top table's activity placed in the appropriate cell in the bottom table. The lower table should automatically update as changes are made to the top table. In reality, we have more salesmen and more customers but I just provided a small sample to get the right formula/functions.

Thanks for your help,

Rudy

Thank you CorineEyes, it worked like a champ. I would have never figured it out myself.

MRice, thank you for submitting your suggestion. Unfortunately, I am using Excel 2003 and I couldn't open your file.

Take care and keep up your outstanding support of this site. You both are miracle workers.

Rudy