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

[msb]

Thanks, I'll give this a try

"Rowan Drummond" <[email protected]> wrote in message
news:[email protected]...
> 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
>>

[msb]

Worked like a charm. Thanks!!!
msb


"msb" <[email protected]> wrote in message
news:[email protected]...
>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]

You're welcome.

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