Sorting Alphabetically

I often have to create spreadsheets that list our clients and the revenue
associated with them. I then have to give subtotals by the first letter of
the client's last name. You see each employee is responsible for a letter.

How do I sort by the first letter of a last name and then do subtotals for
each letter of the alphabet?

No need
=SUMPRODUCT((LEFT(B4:B14)="a")*C4:C14)
or where a2 contains a
=SUMPRODUCT((LEFT(B4:B14)=a2)*C4:C14)
--
Don Guillett
SalesAid Software
[email protected]
"Jack" <[email protected]> wrote in message
news:OG0l7sz%[email protected]...
> I often have to create spreadsheets that list our clients and the revenue
> associated with them. I then have to give subtotals by the first letter of
> the client's last name. You see each employee is responsible for a letter.
>
> How do I sort by the first letter of a last name and then do subtotals for
> each letter of the alphabet?
>
>
>