What function do i use?
 

I have a workbook that tracks sales and other information at our car
dealership. I have 2 columns that I want to total data from on a separate
worksheet in the workbook. One column shows the vehicle model sold and the
other column shows the salesperson. The worksheet will total all models
sold but I want to have it break it down by model (Lexus dealer with 8
different models) sold per salesperson.

Example: ES LS etc, etc,
Joe Smith: 4 5
Sam Jones: 2 1

Any input would be appreciated.

Thanks,
MSB

What function do i use?
 

Lets say your data is in sheet2 in columns A (salesperson) and B
(Model). In the sheet where you want the totals enter the salespersons
names in column A and the models in Row1. Then in cell B2 enter the formula:
=SUMPRODUCT(--(Sheet2!$A$2:$A$20=$A2),--(Sheet2!$B$2:$B$20=B$1))
and copy down and across as needed.
Note you will need to change the range references to pick up all your
data. You can't use an entire column.

Hope this helps
Rowan

msb wrote:
I have a workbook that tracks sales and other information at our car
dealership. I have 2 columns that I want to total data from on a separate
worksheet in the workbook. One column shows the vehicle model sold and the
other column shows the salesperson. The worksheet will total all models
sold but I want to have it break it down by model (Lexus dealer with 8
different models) sold per salesperson.

Example: ES LS etc, etc,
Joe Smith: 4 5
Sam Jones: 2 1

Any input would be appreciated.

Thanks,
MSB

What function do i use?
 

Thanks, I'll give this a try

"Rowan Drummond" wrote in message
...
Lets say your data is in sheet2 in columns A (salesperson) and B (Model).
In the sheet where you want the totals enter the salespersons names in
column A and the models in Row1. Then in cell B2 enter the formula:
=SUMPRODUCT(--(Sheet2!$A$2:$A$20=$A2),--(Sheet2!$B$2:$B$20=B$1))
and copy down and across as needed.
Note you will need to change the range references to pick up all your
data. You can't use an entire column.

Hope this helps
Rowan

msb wrote:
I have a workbook that tracks sales and other information at our car
dealership. I have 2 columns that I want to total data from on a
separate worksheet in the workbook. One column shows the vehicle model
sold and the other column shows the salesperson. The worksheet will
total all models sold but I want to have it break it down by model (Lexus
dealer with 8 different models) sold per salesperson.

Example: ES LS etc, etc,
Joe Smith: 4 5
Sam Jones: 2 1

Any input would be appreciated.

Thanks,
MSB

What function do i use?
 

Worked like a charm. Thanks!!!
msb


"msb" wrote in message
...
I have a workbook that tracks sales and other information at our car
dealership. I have 2 columns that I want to total data from on a separate
worksheet in the workbook. One column shows the vehicle model sold and the
other column shows the salesperson. The worksheet will total all models
sold but I want to have it break it down by model (Lexus dealer with 8
different models) sold per salesperson.

Example: ES LS etc, etc,
Joe Smith: 4 5
Sam Jones: 2 1

Any input would be appreciated.

Thanks,
MSB

What function do i use?
 

You're welcome.

msb wrote:
Worked like a charm. Thanks!!!
msb