I need to sum the below selected way.

i summed D11==SUM(D2:D10)

same need to perform D11 to P11

what is the best way in UiPath.

The Above operation can be performed by mentioning the range in write cell activity

1 Like

Hi @Jeevabalan,

Find Sum of PF in employee contribution

then go to column where you need to go & calculate total

1 Like

Hi @Jeevabalan

you can solve this in two ways:

- by using formulas in excel

2.by reading the excel and storing the data in datatable and using below mentioned syntax:

sum=datatable.compute(“SUM(columnname)”,"")

DataTable1.Columns[“Total”].Expression = “C1+C2+C3”;

Regards,

Shiva Karthik

1 Like

The best way in UiPath is to type the formula in excel

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.