Good morning,

This one has been giving me nightmares!
I'm using Excel 2003 and am trying to do the following -

I have a spread sheet which lists all customers, their representatives names
and what products they buy. EG:
A B C D E
1. REP CUST PCT 1 PCT 2 PCT 3
2. John Cust 1 2 1 ""
3. John Cust 2 "" 2 5
4. Jack Cust 3 3 "" 1
5. John Cust4 "" 1 ""

(""= blank cells)

And on another sheet I have a table which is populated by using 3 drop down
boxes. For example - a user can select a representatives name and two
products and see some summary details populate in the cells below.
I've been trying to find a way to add to this, a formula which will look up
all the entries for one representative, and then count how many customers
they have for the two products selected. Ie - If I searched for John and
wanted to see results for products 1 & 2, the correct result would be 3. (3
customers)

So far I've only been able to find a way to count each time a product is
recorded - so when searching for John and Products 1 and 2 - I currently get
a 4.

I would appreciate any and all help on this. Thank you for your time.

Kind Regards
Leanne