Formula Help!

[Donnb]

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?

 

[Pete_UK]

Set up a simple table on another sheet with names going down column A
starting with A2 and your five status codes in B1:F1. Then in B2 you
can use this formula:

=SUMPRODUCT((Sheet1!D$1$1000=$A2)*(Sheet1!E$1:E$1000=B$1))

Copy this across into C2:F2, then copy B2:F2 down for as many names as
you have.

This will give you a count for each name under the codes in columns B
to F.

Hope this helps.

Pete

 

[Gord Dibben]

I'd help you but you may be one of those annoying telemarketers that think
my phone is a latrine for their personal use..


Gord Dibben MS Excel MVP

 

[Pete_UK]

LOL !!

Judging by the way "center" is spelt, I assumed that the op was in
North America, and so was unlikely to give me a call !! <bg>

Pete