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.
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.