I want to add up a set of numbers for certain items from 3 different excel sheets but I am unsure how to do so and I could not find anything of help on the web.
ppr
May 10, 2021, 11:10am
2
@Daniel_Lim
Your case looks close to current ongoing discussion from there:
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