How do I sum up numbers from different excel sheets using uipath?

[ppr (Peter Preuss)]

@Daniel_Lim
Welcome to the forum.

Your case looks close to current ongoing discussion from there:

How to use for each row when the variable is at the column instead of row

My excel sheet looks like this since I can’t upload it. Item Number Chicken 2 Ham 5 Fish 3 Sheet1 Sheet2 Sheet3 … I already did the excel application scope and read range all 3 sheets and put in DataTable1/2/3 respectively. How do I sum for example ham across all 3sheets? I tried using For each row and it doesn’t work. After summing out the number of fish, I will then put the total sum of fish into a google form which I know how to do. And also what variable…

otherwise just provide more details to us. Thanks