How to Add rows one by one and print sum value at the end of the column

[AndyMenon]

Hi again,

Please refer to this recent post. It shows how to navigate the columns horizontally:

How to loop multiple rows

Each row is an array. You can fine tune this fundamental concept into shape. So here it is: 'Width of each row is the count of columns of the table Assign ColumnCount=DT.Columns.Count() For Each row in DT 'Initialize Column counter Assign x = 0 Do Assign cellValue=row(x).ToString() ' Do something with cellValue ' Example x=0 then put cell value in SAP Box1, ' if x=2 then put cell value in SAP Box2, etc. 'Read next column in current row Assign x=x+1 While(x<=row.ColumnCount-…