How to sum values in different excel sheets

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!

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.

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 (11.7 KB)

mark it as solved and close the thread

Chethan P

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