Table Subtotals

jstevens
GoldLounger
Posts: 2618
Joined: 26 Jan 2010, 16:31
Location: Southern California

Table Subtotals

Post by jstevens »

Is it possible to include subtotals in a table based on certain groupings? This is not the same as Excel's "Data>Group" feature.

I recall seeing something online but don't remember where.

I have attached a sample workbook.
EL_table_subtotal.xlsm
You do not have the required permissions to view the files attached to this post.
Regards,
John

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Table Subtotals

Post by HansV »

It is not possible to insert subtotals in a table (see Why can't I add subtotals in an Excel table?

After converting the table to a range and deleting the blank rows, you can add subtotals - see the attached version.

EL_table_subtotal.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

jstevens
GoldLounger
Posts: 2618
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Table Subtotals

Post by jstevens »

Thank you Hans!
Regards,
John