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.
Table Subtotals
-
- GoldLounger
- Posts: 2618
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Table Subtotals
You do not have the required permissions to view the files attached to this post.
Regards,
John
John
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Table Subtotals
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.
After converting the table to a range and deleting the blank rows, you can add subtotals - see the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2618
- Joined: 26 Jan 2010, 16:31
- Location: Southern California