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.
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/article/SUBTOTAL-function-7B027003-F060-4ADE-9040-E478765B9939
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.