Creating a table with multiples subtotals

**Helpme77** · 10-20-2015, 12:45 PM

I've attached a spreadsheet that explains what I need in a text box. Thanks for any help given.

**Helpme77** · 10-20-2015, 05:28 PM

Anybody? I thought an Excel guru could knock this out in 5 or 10 minutes. I'm stuck.

**Helpme77** · 10-21-2015, 03:49 PM

Bump. . . I really need help on this one.

**popipipo** · 10-21-2015, 04:07 PM

Did you try a pivot table?

**MarvinP** · 10-21-2015, 04:28 PM

Hi Helpme,

I agree with popipipo but have sorted and repeated a few fields in the Pivot. See my small changes from his answer attached.

If you don't want to use formulas or VBA then Pivot Tables is certainly the way to go. NOW - you need to study Pivots and all the power they bring.

**Helpme77** · 10-21-2015, 04:38 PM

I will try this out. I use pivot tables everyday, but for the same exact function, so I'm unfamiliar with the full power of pivot tables in Excel.

Creating a table with multiples subtotals

LinkBack

Thread Tools

Rate This Thread

Display

Creating a table with multiples subtotals

Re: Creating a table with multiples subtotals

Re: Creating a table with multiples subtotals

Re: Creating a table with multiples subtotals

Re: Creating a table with multiples subtotals

Re: Creating a table with multiples subtotals

Thread Information

Users Browsing this Thread

Similar Threads

Creating subtotals on normalised table

Multiples table on sheet, help with print and filter

[SOLVED] Split worksheet into multiples and add subtotals to each WS

creating formula for multiples of 2 or 3

creating subtotals outside a pivot table

create a spreadsheet containing a table of dimensions that are multiples of up to six

[SOLVED] Count multiples and add to pivot table

Creating a chart with subtotals

Bookmarks

Bookmarks

Posting Permissions