Results 1 to 3 of 3

Thread: Help!! How to sub total at change in letter

  1. #1
    Neophyte bindyv's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Help!! How to sub total at change in letter



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!
    Attached Files Attached Files

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    194
    Articles
    0
    Excel Version
    2019
    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.
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,616
    Articles
    0
    Excel Version
    365
    …or to get Sum and Count, add a helper column to the data and then pivot it. See attached.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •