Results 1 to 3 of 3

Thread: Question Grouping rows in Table

  1. #1
    Acolyte Dan Bliss's Avatar
    Join Date
    Dec 2016
    Posts
    45
    Articles
    0
    Excel Version
    Office 365

    Question Grouping rows in Table



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

    Outlining or grouping contiguous rows works as shown using Data>>Group after highlighting rows. Question: Does grouping work on a Table? If so, how so that I can get a result similar to what shows in image on right below.
    I find in a table, the =SUM[Pop in M] sets to 0 when rows are grouped.
    Click image for larger version. 

Name:	ExcelGroup_pic1.JPG 
Views:	52 
Size:	38.2 KB 
ID:	6505Click image for larger version. 

Name:	ExcelGroup_pic2.JPG 
Views:	46 
Size:	45.8 KB 
ID:	6506

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    I was able to...

    Click image for larger version. 

Name:	t2.gif 
Views:	20 
Size:	2.6 KB 
ID:	6507

    using Excel 2013


  3. #3
    Acolyte Dan Bliss's Avatar
    Join Date
    Dec 2016
    Posts
    45
    Articles
    0
    Excel Version
    Office 365
    Thanks, NBVC for your input. Ah! If only I had been a bit more observant... I used AutoSum on the Home ribbon when creating a sum of a column of a table. It defaults using SUBTOTAL function. SUBTOTAL function's first parameter is function_num, which when > 100, as in images 1 and 2 below (function_num is 109) ignore hidden row values. If I edit the value of function_num to 9 so that expression is: =SUBTOTAL(9,[Pop in M]), then hidden values are not ignored and the result in B5 is 70, left undisturbed when the group is collapsed/hidden.
    SUBTOTAL nicely documented at: https://support.office.com/en-us/art...0-E478765B9939


    Click image for larger version. 

Name:	ExcelGroup_pic3.JPG 
Views:	29 
Size:	48.3 KB 
ID:	6511Click image for larger version. 

Name:	ExcelGroup_pic4.JPG 
Views:	29 
Size:	45.2 KB 
ID:	6512Click image for larger version. 

Name:	ExcelGroup_pic7.JPG 
Views:	29 
Size:	45.7 KB 
ID:	6515
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ExcelGroup_pic5.JPG 
Views:	9 
Size:	37.6 KB 
ID:	6513   Click image for larger version. 

Name:	ExcelGroup_pic6.JPG 
Views:	10 
Size:	36.4 KB 
ID:	6514  

Tags for this Thread

Posting Permissions

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