Sum of values from a column


I have an excel sheet whose one column has values 100,200,300,400,500. I also have a variable whose value is 800, I need to do hit and trial method to sum up the values of columns of excel sheet to make it 800.

Ex: 100+300+400 = 800.
How can i do it using uipath?

1 Like

@AditiGandhi Can you tell us what you really want to do, In this case, there’s another possibilty of having 800

500 + 300 =800 :sweat_smile:

1 Like

Try this
Convert.ToInt(dt.Compute(“SUM(ColumnName)”, string.Empty));


read that data table and use Sum method on that data table of that column.

1 Like