Try this:

E1 = Sales Rep1
F1 = Count of Customers (or whatever)

=SUMPRODUCT(--(A1:A4=E1),--(B1:B4=F1),C1:C4)

--
Biff
Microsoft Excel MVP


"Cinny" wrote in message
...
Hi

I have the below data, which I want to bring in a different format.
Basically the data in Column 3 I want to bring back for each sales rep,
however the two variables I would be using would be Sales Rep then Count
Cusotmers, or Sales Rep and Sum of Fop$ 09, to get the figure in Column 3.
How would I go about this?

Sales Rep Data Total
Sales Rep1 Count of Customers 21
Sales Rep1 Sum of FOP$ 09 42,349,912
Sales Rep1 Sum of ACT$ 08 46,217,303
Sales Rep1 Sum of ACT$ 07 48,191,043