Subtotal and running/cumulative total!

[rahul25]

Loacation Name Sales Comm
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
300 EEE 100 12.5
300 FFF 100 12.5
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5

Is there any way to get the subtotal and running/cumulative total in each change of location number as under:

Loacation Name Sales Comm
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
252 total
Cum total
300 EEE 100 12.5
300 FFF 100 12.5
252 total
Cum total
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5
252 total
Cum total
Grand Total

 

[XLGibbs]

G2 copied down
=SUMPRODUCT(--($A$2:$A$9=F2),$D$2:$D$9)

H2 copied down
=SUM($G$2:G2)


Ihope this gets you started

Book1
	A	B	C	D	E	F	G	H
1							SUB	RUNNING
2	252	ABC	100	12.5		252	37.5	37.5
3	252	CCC	100	12.5		300	25	62.5
4	252	DDD	100	12.5		500	37.5	100
5	300	EEE	100	12.5
6	300	FFF	100	12.5
7	500	GGG	100	12.5
8	500	HHH	100	12.5
9	500	KKK	100	12.5
Sheet1

 

[rahul25]

Sorry I forgot to mention that I need VBA code which will give me subtotal and running total just in the rows within data area not somewhere else.

 

[XLGibbs]

Yes, that certainly would have been useful information...has to be code?

There are many alternative means via formula, pivot table, or even using the subtotal function....

 

[Aladin Akyurek]

G2 copied down
=SUMPRODUCT(--($A$2:$A$9=F2),$D$2:$D$9)

H2 copied down
=SUM($G$2:G2)


...

Whenever there is a single condition, the faster SumIf will suffice:

=SUMIF($A$2:$A$9,F2,$D$2:$D$9)

 

[XLGibbs]

thanks Aladiin