Hi
Add an extra column to your source table assume column X
=LEFT(A1,2)&"|"&MID(A1,3,2)&"|"&RIGHT(A1,4)

Assuming Call Status is column D
Then a Sumproduct
=SUMPRODUCT(--($X$1:$X$1000="EM|UK|PROS"),--($D$1:$D$1000="LEAD A"))

You could set up a report matrix in say columns AA:AC
In AB1 enter Lead A, in AC1 enter Lead B
IN AA2 enter the first of your Analysis groups e.g EM|UK|PROS
and so on down the column.
In AB2 enter
=SUMPRODUCT(--($X$1:$X$1000=$AA2),--($D$1:$D$1000=AB$1))
Copy across to AC2, then copy both cells down as far as required.

--
Regards
Roger Govier

"drumbumuk" wrote in message
...
Problem
I collate results of lead qualification telemarketing in an Excel
database.
In the database, amongst other fields in sheet1, I have Campaign Title,
Lead
Source Code, Country and Call Status

The lead source code looks like this: UKEMMMYYXXXXXXXXXXTYPE

Whe
UK is always present,
EM could be replaced by WB,
MMYY are MonthYear, X is the campaign name (text of various length)
TYPE is either PROS, CUST or ONLINE

The other key field a

COUNTRY - is one of three possibilities, UK, RoI, SA
CALL STATUS - could be a number of possibilites but I am interested in
Lead
A or Lead B

I need to be able to report on how many Leads (A, B) I have by
EM+COUNTRY+TYPE and WB+COUNTRY+TYPE

I have tried every possibility I can think of, except the right one,
including Pivot Tabels which I know little about.

Any help gratefully recieved.