Help!! How to sub total at change in letter

bindyv

New member
Joined
Jul 10, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Hi all,
I need to sub total to count at each change in letter of the customer name and also include the sum of total balance.
Eg.
A count = 2 Total Balance 2960797.5
D count = 2 Total Balance 1368669.32
I have attached an example spreadsheet. Thanks in advance!
 

Attachments

  • Example.xlsx
    9 KB · Views: 9
Split the Cust Name column using Text to Columns to show only first letter. Then use the Sub-Totals function found on the data tab to sum after each change in the first letter. See the attached.
 

Attachments

  • Example (1).xlsx
    9.7 KB · Views: 7
…or to get Sum and Count, add a helper column to the data and then pivot it. See attached.
 

Attachments

  • ExcelGuru10103Example.xlsx
    13.9 KB · Views: 6
Back
Top