Sorting Alphabetically

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

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)
 
Back
Top