How to sum values in different excel sheets

Help Activities
, , ,
1

hi!
i have a problem with summing up numbers in more than 2 different excel sheets only using uipath. for example, i have to add the number of apple laptops sold across all 3 sheets. to add on, i have to use uipath to type in the sum and fill it up into a form. how can i do this?
thank you!

2

If you have 3 different sheets, then you can use 3 read range activities to read data from those sheets and save those values in 3 data tables. Then you can use those data tables to get required values and sum them.

3

I think this an interview question everyone asking the same question :smiley:
Ok here is the solution you have to use lookup data table activity I sare some folder below go and check definitely you will get the solution

FormQuestion1.zip (11.7 KB)

mark it as solved and close the thread

Regards
Chethan P

4

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