subtotals

[blondiechick]

Sort by car only, and use the subtotals to show total fees paid to employees for each car.

I am confused. Am I just supposed to show the cars only and teh subtotals for each car? And leave out the color and the year?

 

[Yogi Anand]

Hi blondiechick:

It will be better to clarify what you are trying to accomplish with a few rows of your data and your expected result.

 

[blondiechick]

The fields are as followed:

A3=Employee
B3=Car
C3=Color
D3=Year
E3=Subtotal

 

[blondiechick]

I think I got this one. So its all cool. I just hope its right!