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
<colgroup><col span="14"></colgroup><tbody>
</tbody>
<colgroup><col span="14"></colgroup><tbody>
</tbody>
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>