two variables to get result

  • Thread starter Thread starter Cinny
  • Start date Start date
C

Cinny

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
 
Try this:

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

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