How to add columns in continues increasing in rows

[Gaurav0001]

Hello,
I need help, if we receive rows daily and its get increased by + 1 or + Infinity.
How I am suppose to add the columns in one cell.

Scenario 1 :

For Example :

Below table contains amount and it gets added in a particular cell leaving one blank row above

(10+20+10 = 30)

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
		30

Amount added in a particular cell (10+20+10+20+30+10 = 100 )

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
BCD	20	30	10
		100

Amount added in a particular cell : (10+20+10+20+30+10+20+5+10 = 135)

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
BCD	20	30	10
CDE	20	5	10
		135

As you see above, the rows getting append and according to that the total sum is also changing its cell positions.
I need help to make a workflow that will add the selected column and give the output in a specific cell leaving on row blank at above.



Scenario 2 :

Need to add only the last/latest rows and give the output in a specific cell position (Leaving one row blank above).

For Example :

(10+20+10 = 30)

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
		30

Amount added in a particular cell (20+30+10 = 60 )

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
BCD	20	30	10
		60

Amount added in a particular cell : (20+5+10 = 35)

Name	P-Amount	O-Amount	T-Amount
ABC	10	20	10
BCD	20	30	10
CDE	20	5	10
		35

[cjaneczko]

This will do it and scale as the data increases. For Scenario 2 you can use the same workflow but remove the Transpose and update the Summary tool to only total the O-Amount field.