I run a small call center and want to track the status of leads for each
individual telemarketer. I can count the total number of leads for each TM
using the "Countif " function and the TM's name.

I need to count the lead status for each TM as well. For each TM name there
would be 5 lead status catagories. I have set up the worksheet columns as
follows: lead date, lead Name, Phone, Telemarketer, Lead status.

Any Thoughts?