Counting the same cell across all sheets

[lukerees83]

I had a workbook that was divided into 12 sheets, one for each of the 12 months, and someone on here told me that if I wanted to sum the same cell across all sheets (in this case cell s5) the following formula would work:

=SUM(Jan:Dec!S5)

However, I now have a slight complication. Instead of 12 sheets I have had to divide the month of May into 2 halves and make a sheet for each one, so I now have 13 sheets with the fifth one named 'May' and the 6th one named 'May part 2'. Is there a formula that can sum all 13 s5 cells across these new sheets?

 

[JackDanIce]

Does this work?

=SUM(Jan:Dec!S5)+'May part 2'!S5

 

[stefankemp]

The same formula should still work, provided that Jan is the first (left most) sheet and Dec is the last (right most) sheet, with all the other monthly sheets (including the extra one for May) in between, and nothing else in between.

 

[Aladin Akyurek]

Create two new sheets, named Start and End. Put all of the relevant sheets between Start and End. Now you can invoke:

=SUM(Start:End!S5)

 

[T. Valko]

I had a workbook that was divided into 12 sheets, one for each of the 12 months, and someone on here told me that if I wanted to sum the same cell across all sheets (in this case cell s5) the following formula would work:

=SUM(Jan:Dec!S5)

However, I now have a slight complication. Instead of 12 sheets I have had to divide the month of May into 2 halves and make a sheet for each one, so I now have 13 sheets with the fifth one named 'May' and the 6th one named 'May part 2'. Is there a formula that can sum all 13 s5 cells across these new sheets?

Make a sheet "sandwich"...

Insert a blank sheet to the immediate left of the first sheet you want to include in the calculation. Name this sheet something like Start.

Insert a blank sheet to the immediate right of the last sheet you want to include in the calculation. Name this sheet something like End.

Then, your formula becomes:

=SUM(Start:End!S5)

If you add more new sheets just place them between Start and End.

 

[lukerees83]

Ah! Genius. Thanks for that.

 

[T. Valko]

Ah! Genius. Thanks for that.

You're welcome. Thanks for the feedback!