subtotal

[gledister]

Imagine we have this situation...

Excel Workbook
	A	B
1	Reference	Quantity
2	F118080M2204A00 L	1
3	F118080M2204A00 M	2
4	F118080M2204A00 S	1
5	F118080M2204A00 XL	2
6	F118080M2204A00 XS	1
7	F118080M2204A00 S	2
Sheet1

and then we do subtotals...

Excel Workbook
	A	B
1	Reference	Quantity
3	F118080M2204A00 L Total	1
5	F118080M2204A00 M Total	2
7	F118080M2204A00 S Total	1
9	F118080M2204A00 XL Total	2
11	F118080M2204A00 XS Total	1
13	F118080M2204A00 S Total	2
14	Grand Total	9
Sheet1

What I want is that the "S" size needs to be summed even if its not consecutive to the other "S" size...anyone got any idea?!

Thanks in advance.

Regards.

 

[gledister]

I did solve it with pivot table...but am curious to know even subtotal can solve that....

 

[gledister]

*bump*