ExcelBanter - two variables to get result

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - two variables to get result (https://www.excelbanter.com/excel-worksheet-functions/196835-two-variables-get-result.html)

two variables to get result

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

two variables to get result

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