On Wed, 30 Jul 2008 04:03:01 -0700, Suleman Peerzade
wrote:

The result would be
REP CUST PCT 1 PCT 2 PCT 3
Jack Cust 3 3 1
Jack Count 1
John Cust 1 2 1
John Cust 4 1
John Cust 2 2 5
John Count 3
Grand Count 4


This shows that the REP John has three customers in total.
But the question was to count the customers for a selected rep
"for the two products selected".
If product PCT 1 and PCT 3 are selected (on the other worksheet) the
expected result would be 2, as John has only two customers, Cust 1 and
Cust 2 for the selected products.
Your subtotal solution does not show how to take care of "the two
product selected". Or am I missing something here?

Lars-Åke