I have such data in 35 excel sheets ( Sheet 1 to sheet 35) at the same position

enter image description here

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 ?


You can use the formula =SUM(FirstSheetName:LastSheetName!CellNumber) Create a new sheet and copy your first column (Range) as it is. Select the cell in your next column (No. of Students) where you start your entries and type the formula in your formula bar and hit enter. Then use the drag to fill option to drag and fill the remaining cells.

Image 1 Image 2 Image 3 Image 4

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.