Add Subtotals For 2 Columns

[EdAROC]

I'm not searching correctly, because I'm sure this is answered somewhere...

Simple spreadsheet, the columns are: Customer, Category, Job#, Tons
Sorted on: Customer, Category

Want Tons subtotals for Category and Customer (and a grand total).

I can create a subtotal for one column or the other, but, I can't get subtotals for both columns.

[FONT=Courier New]
Customer  Category  Job#  Tons
ABC       Cat1         1   1.1
ABC       Cat1         2   0.8
   Subtotal Cat1           1.9

ABC        Cat2        3   2.0
ABC        Cat2        4   1.6
   Subtotal Cat2           3.6
Subtotal ABC               5.5

XYZ        Cat1        5
  {and so on}
[/FONT]

 

[GlennUK]

Do the SUBTOTAL command on change of Customer, then afterwards do another SUBTOTAL command for change of of Category ( making sure that "Replace Current Subtotals" is unticked ).

Excel Workbook
	A	B	C	D
1	Customer	Category	Job#	Tons
2	ABC	Cat1	1	1.1
3	ABC	Cat1	2	0.8
4	*	Cat1 Total	*	1.9
5	ABC	Cat2	3	2
6	ABC	Cat2	4	1.6
7	*	Cat2 Total	*	3.6
8	ABC Total	*	*	5.5
9	XYZ	Cat1	5	1.3
10	XYZ	Cat1	6	1.1
11	XYZ	Cat1	7	2.3
12	*	Cat1 Total	*	4.7
13	XYZ	Cat2	8	1.2
14	XYZ	Cat2	9	0.5
15	*	Cat2 Total	*	1.7
16	XYZ Total	*	*	6.4
17	DEF	Cat1	10	1.1
18	DEF	Cat1	11	2.2
19	DEF	Cat1	12	2.5
20	*	Cat1 Total	*	5.8
21	DEF	Cat2	13	1
22	DEF	Cat2	14	2
23	DEF	Cat2	15	3
24	*	Cat2 Total	*	6
25	DEF Total	*	*	11.8
26	Grand Total	*	*	23.7
Sheet7

 

[EdAROC]

That's embarrassing - the answer was right in front of me all the time.

Thanks for your help Glenn.

 

[GlennUK]

Ha ha, glad to help