+ Reply to Thread
Results 1 to 7 of 7

Retrieve Total from a particular group

  1. #1
    Registered User
    Join Date
    10-07-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    51

    Retrieve Total from a particular group

    Hello, I need some help. I have a spreadsheet that has various groups on it with totals that I need to collect and put them on a different spreadsheet. The amount of items in this group can either decrease or increase thru out the month. I have attached a small sample of what I'm try to do. On this example I need to find the group titled Current and get the total dollar amount of that group, which is 60. But next time month it may have 15 items instead of 3 with a different total amount that I will need to get.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Retrieve Total from a particular group

    I suggest that you put the total calc on the same row as the group heading. IE Current total will be in C9 instead of C13. That way you can just find the heading and pull the data from 2 cells over
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Retrieve Total from a particular group

    Pl see file.
    In Sheet2 B2 ARRAY formula then copy down.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Registered User
    Join Date
    10-07-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    51

    Re: Retrieve Total from a particular group

    Thank you. The only this is if I add more items to that group it doesn't move over the correct total.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,330

    Re: Retrieve Total from a particular group

    The layout of your data would be better like this:
    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    4
    Misc
    134521
    20/05/2019
    100
    5
    Misc
    765832
    20/06/2019
    200
    6
    Misc
    32145
    08/08/2019
    50
    7
    Misc Total
    350
    8
    9
    10
    Current
    78769
    10/05/2019
    10
    11
    Current
    98765
    10/06/2019
    20
    12
    Current
    356909
    10/08/2019
    30
    13
    Current Total
    60
    14
    15
    16
    Past
    777878
    10/01/2019
    500
    17
    Past
    875493
    05/03/2019
    100
    18
    Past
    222987
    06/04/2019
    50
    19
    Past Total
    650
    Sheet: Sheet1

    Then you can use a simple formula:

    Excel 2016 (Windows) 32 bit
    G
    4
    =SUMIFS($D$4:$D$19,$A$4:$A$19,F4,$B$4:$B$19,"Total")
    Sheet: Sheet1
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Retrieve Total from a particular group

    Upload the file showing the problem.

  7. #7
    Registered User
    Join Date
    10-07-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    51

    Re: Retrieve Total from a particular group

    Sorry for the late response was out of town for work. I'll see if the other area will change the layout. Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] To count total numbers recorded by group total
    By michael35 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2018, 08:12 AM
  2. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  3. sort by group and total by each group
    By mheinemann in forum Excel General
    Replies: 3
    Last Post: 04-30-2015, 11:48 AM
  4. Using drop down lists to retrieve group of cells
    By randyg1999 in forum Excel General
    Replies: 6
    Last Post: 10-01-2014, 05:23 PM
  5. Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  6. Replies: 8
    Last Post: 01-09-2014, 08:01 PM
  7. Sort a group of names based on the group total
    By ron2k_1 in forum Excel General
    Replies: 3
    Last Post: 08-13-2010, 01:16 PM

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