I have such data in 35 excel sheets ( Sheet 1 to sheet 35) at the same position
I want to add all the second columns and get total Range combining all files. So if there are two such files and in the second file 0..32% is 5, then after combining I should get 0..32% 5+2=7. And so On.
How do I do this ?