+ Reply to Thread
Results 1 to 5 of 5

AR Aging Report - Subtotal formula for visible rows only

  1. #1
    Registered User
    Join Date
    08-22-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2018
    Posts
    2

    AR Aging Report - Subtotal formula for visible rows only

    Hi I need help in creating a formula that will help me show the total value per each criteria for each filtered data. Because in my aging report I want to show the total amount of all companies and show subtotals of different "Status" of each invoice. I have been trying to figure out the subproduct formula but unsuccessful.

    Apologies if this was already answered before, if so please send link or point me to the right direction. New to this forum and thank you again.

    Example:

    Capture_Unfiltered.JPG

    Capture_Filtered.JPG

    Your help is greatly appreciated.
    Last edited by KapitanDan; 08-22-2019 at 08:53 PM. Reason: Explaining my post

  2. #2
    Registered User
    Join Date
    08-09-2019
    Location
    Ha nam, Vietnam
    MS-Off Ver
    2010
    Posts
    13

    Re: AR Aging Report - Subtotal formula for visible rows only

    hi,
    you can see the method of Subtotal formula.
    total value (only show item after filter) by subtotal(9, range total)
    Ex: SUBTOTAL(9,AC6:AC10)

  3. #3
    Registered User
    Join Date
    08-22-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2018
    Posts
    2
    Quote Originally Posted by tranhieu04 View Post
    hi,
    you can see the method of Subtotal formula.
    total value (only show item after filter) by subtotal(9, range total)
    Ex: SUBTOTAL(9,AC6:AC10)
    I know that. What I need is once I filter per company itíll also show the amounts per status at the top. Also subtotal accordingly. Itís like subtotalling 2 criterias.

  4. #4
    Registered User
    Join Date
    08-09-2019
    Location
    Ha nam, Vietnam
    MS-Off Ver
    2010
    Posts
    13
    Befor i did'nt understood. I think you can use 2 method to soler it.
    1. By company filter of status you use a cells to filter company (drop and select) then vlookup that to show status.
    2. Use vba

    That i think to solve. Maybe have most simple...

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,684

    Re: AR Aging Report - Subtotal formula for visible rows only

    Hello Kapitan Dan and Welcome to Excel Forum.
    You could possibly use the strategy that is described in post #17 of the linked thread.
    https://www.excelforum.com/excel-gen...a-table-2.html
    To have someone attempt to apply that method to your data, please upload the spreadsheet from which the screen shots in post #1 are taken by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1