I have an Excel with 2 sheets. How do you calculate sum of all values in a column say “Sales” without ‘Save for later’ activity in StudioX ? I need it for both sheets. The column has values from E2 to E12 in sheet 1 and from E2 to E34 in sheet2. I want to write sum in E13 and E35 respectively.
I do ‘First/Last data row’ to find first (2) and last row number(12) in sheet1 for sum and put sum in a cell (E13) but I want to avoid ‘Save for later’ activity.
Is there a way out to work dynamically ?