Forum Discussion
Trying to add the same value on 25 different sheets
I have a workbook with 25 sheets, each with a different name. I need a formula to add the values of the same cell on each sheet and place them on a different sheet.
3 Replies
Nope, doesn't work
Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.
Assuming that the 25 sheets are adjacent, you can use a formula like this:
=SUM('First Sheet:Last Sheet'!B2)
to sum the value of cell B2 in all sheets from First Sheet to Last Sheet.
You'll have to use the actual names of your sheets of course.
