Follow these steps:
- Use Find First/Last Data Row activity to find last row of Column A. This will give you last row in int32.
- Use Write Cell Activity to write this formula at cell address
"G"+lastRowFromStep1
"=SUM(G2:G"+(lastRowFromStep1-1)+")"
Follow these steps:
"G"+lastRowFromStep1"=SUM(G2:G"+(lastRowFromStep1-1)+")"