Nesting Totals And Sub-totals

seppburgh2

New Member
Joined
Apr 17, 2002
Messages
1
Boss (wife) gave me her year end client product useage report to subtotal product line and than for the whole client. The data looks like this Colume one has the client name, colume tow has the product type (FS,MS,RX), colume three the product description and colume four the total dollars spend.

What I can work out is how to subtotal the product types within a client then an overall client subtotal. And display both. For example:
(raw data source)
Client Product Type Product Desc. $ Total

SAM FS DOG FOOD $20
SAM MS DOG DISH $40
SAM MS PLACE MAT $10
sAM RX BUG-b-GONE SHOT $30

What I need to get to, by the subtotal funtion only gives me total by client or total by product type, but not together. Thus my example would look like this:

(what to build data table)











Client Product Type Product Desc. $ Total

SAM FS DOG FOOD $20
SAM FS Total $20
SAM MS DOG DISH $40
SAM MS PLACE MAT $10
Sam MS Total $50
sAM RX BUG-b-GONE SHOT $30
Sam RX Total $30
Sam Total $100

This was a short example of the situation, my wife has 460 clients that come to 6800 rows of data. Can someone please help out with some simple suggestions for nesting functions of maybe the subtotal commands.

Thank you.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top