My subtotal and sum

[anmol786]

i have data sheet

then i want to add sum of total data in the next cell of the cell where written "Subtotal"

is there any way to that using excel formula

data sheet is attached here

No. 1			No. 2			No.3
	rs.			rs.			rs.
	5			5			5
	6			6			6
	7			7			7
	8		Subtotal	18			6
Subtotal	26						9
						Subtotal	33
		I want to put formula so that in the adjacent cell of the cell where "Subtotal" the total sum should be put
		Like : if in CellA8 there is "Subtotal" put sum total in B8
		Or any cell in the range A4 to A8 has "Subtotal" put sum total in the cell next to the cell where "Subtotal" is written
		Plz give me formula

<colgroup><col span="14"></colgroup><tbody>
</tbody>

No. 1			No. 2			No.3
	rs.			rs.			rs.
	5			5			5
	6			6			6
	7			7			7
	8		Subtotal	18			6
Subtotal	26						9
						Subtotal	33
		I want to put formula so that in the adjacent cell of the cell where "Subtotal" the total sum should be put
		Like : if in CellA8 there is "Subtotal" put sum total in B8
		Or any cell in the range A4 to A8 has "Subtotal" put sum total in the cell next to the cell where "Subtotal" is written
		Plz give me formula

<colgroup><col span="14"></colgroup><tbody>
</tbody>

 

[arthurbr]

Heavy cross poster
My subtotal and sum
My subtotal and sum

 

[arthurbr]

Other cross post My subtotal and sum