Hi,
On the attached worksheet, I have subtotaled the Mkt Reps in order to count the number of referrals they have provided in a month.
I also sorted by the Mkt Rep to alphabetise the referral source.
What I am also trying to do, is get count of each referral source associated with each Mkt Rep.
So for instance, (using attached wkst)
Mktg Rep = Burns
Total Referrals =39
# Referrals from Aberjona for Burns =?
# Referrals from Berenson = ?
I guess I am trying to subtotal a subtotal...
Any ideas on how to achieve what I am looking for?
Much appreciated.
Bookmarks