+ Reply to Thread
Results 1 to 3 of 3

Group+Subtotal HOW?

  1. #1
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Group+Subtotal HOW?

    As you can see in example, is it possible with Subtotal (Data tab--->Outline--->Subtotal) to insert different formulas in one row e.g. after FIN I need to put few formula?
    I've highlighted what kind of values and formulas I needed.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Group+Subtotal HOW?

    Hi
    See the file Group_ungroup (1).xlsx
    or this for compatibility Group_ungroup (1).xls
    I hope it helps
    Regards

  3. #3
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Group+Subtotal HOW?

    Quote Originally Posted by José Augusto View Post
    Hi
    See the file Attachment 426753
    or this for compatibility Attachment 426754
    I hope it helps
    Regards
    Yes, great job. Can you describe me how did you do this? :D

+ 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] Subtotal including first Row of next group
    By yossel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2014, 05:18 PM
  2. Replies: 1
    Last Post: 10-19-2012, 07:55 AM
  3. How to Insert Group in Subtotal
    By koolguys4u in forum Excel General
    Replies: 1
    Last Post: 03-25-2012, 12:10 PM
  4. Macro to group rows with certain subtotal
    By erosche in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-27-2011, 12:43 PM
  5. Group / Outline / subtotal
    By tikchye_oldLearner57 in forum Excel General
    Replies: 0
    Last Post: 06-22-2006, 06:50 AM
  6. [SOLVED] Excel subtotal group sort
    By rick@bcbsne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2005, 02:05 AM

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