Hi
Hope these steps would help you resolve this
—Use a excel application scope and uminsee the scope use read range activity and get the output with a variable output of type datatable named dt
—now use a FOR EACH ROW activity and pass dt as input
—Inside the loop use a WHILE LOOP activity like this int_sum = int_sum + Cint(row(count).ToString)
Where int_sum is sum of all columns except pay
So count is a vary of type int32 with default value as 1 defined in the variable panel
Next to this use a assign activity like this count = count + 1
—now next to this While loop use a assign activity like like this row(0) = int_sum - cint(row(0).ToString