Replace Subtotal with Sum

[cagauravgarg]

Is there any shortcut way to replace the Subtotal formula in groupings with Sum formula? I have multiple level of groupings in the excel. Attached an image for example

 

[James006]

Once you have tested the macro, feel free to share your comments

 

[Dave Patton]

I am not sure what you are trying to do.
A concise example of your challenge would help.

My post considers your post #6.
If you want to check the total you could just use sum with the total. See the sum highlighted with green.

T202303a.xlsm
	A	B	C	D	E	F
1
2				Location IS -
3
4		Acct #	Unique ID	$'000	43861	43890
5				Regular
6		501.1	501.1 - Retail tires	Retail tires	1	2
7		501.1	501.1 - Labor	Labor	1	2
8		501.7	501.7 - Commercial tire	Commercial tire	1	2
9		501.4	501.4 - Chains	Chains	1	2
10		501	501 - Sales	Sales	342	32
11				Regular	346	40
12				Miscellaneous
13		501.9	501.9 - Finance charge	Finance charge	1	2
14		501.9.5	501.9.5 - Oregon state surcharge	Oregon state surcharge	1	2
15		501.9.4	501.9.4 - Merchant services fraud	Merchant services fraud	1	2
16		501.9.3	501.9.3 - Nat. account charge back	Nat. account charge back	1	2
17		501.9.2	501.9.2 - Pinmarx	Pinmarx	1	2
18		501.9	501.9 - Misc sales	Misc sales	12	31
19				Miscellaneous	17	41
20				Net sales	363	81
21
3c

Cell Formulas
Range	Formula
D11	D11	=D5
E11:F11	E11	=SUM(E6:E10)
D19	D19	=D12
E19:F19	E19	=SUM(E12:E18)
E20:F20	E20	=SUM(E5:E19)/2