Sum of values from a column

Help
1

Hello,

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?

2

@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:

3

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

4

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