How to add columns from different sheets in excel?

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 ?

1 Answer

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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