Getting the sum of row for thousands of employees

Good Day.

I have this datatable where I have to get the sum of all the months (column F to column Q) for each employee. Is using get row activity an efficient way to process thousands of employees?

Kindly see below the desired output and the working file being used. Thank you.

SampleExcel.xlsx (218.0 KB)

Best regards,
Robert Monsalud

@Robert_Russell_Monsalud

The Simplest way is to write the formula in the excel at the end all the rows using the write cell and write as =SUM(Range) of a Total Hour Row
Then you can use Auto Fill Range activity and use E to Q column

Hope this may help you

Thanks

1 Like

Can you elaborate it more? Thank you

Hi [Robert Russell Monsalud,

You can use this workflow
I think it will work

demo.xaml (8.1 KB)
SampleExcel.xlsx (209.5 KB)
Thanks

1 Like

@Robert_Russell_Monsalud

Check below workflow for your reference

SumusingExcelForumla.zip (202.3 KB)

If this helpful for you, please close this thread by clicking on Mark as solution this post so that others can be beneficial

Hope this may help you

Thanks

1 Like

Thank you so much.

Best regards,
Robert Monsalud

1 Like

Thank you so much.

Best regards,
Robert Monsalud

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