What function do i use?

[msb]

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

 

[Rowan Drummond]

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]

Thanks, I'll give this a try

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]

Worked like a charm. Thanks!!!
msb

 

[Rowan Drummond]

You're welcome.