Summing same cell from multiple worksheets

[Marl]

I have multiple, identical, worksheets in a workbook that I would like to sum to a summary page. Is there an easy way to do this?

 

[Aladin Akyurek]

Insert two new sheets, name them First and Last, and place all the relevant sheets between these two then invoke:

=SUM(First:Last!$A$2:$A$10)

 

[Marl]

Aladin:

Thanks. Is there any problem in removing the $ and making the statemetn relational so it can be copied to other cells to achieve the same drill through summing?

 

[Aladin Akyurek]

Aladin:

Thanks. Is there any problem in removing the $ and making the statemetn relational so it can be copied to other cells to achieve the same drill through summing?

No, not all. You can make them relative as needed.