Excel - sum operation for multiple column

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.

@Jeevabalan You can use same formula like below in write cell activity

=SUM(D11:P11)

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

Untitled

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:

  1. 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

Hi @albert.yango,

For one scenario we have soo many solutions

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