Sum of C3 in all sheets and put in result in master sheet

[thebutlerdidit]

I have a workbook with a master spreadsheet and ~100 feeder sheets.

In cell B3 of the master, I want a formula that sums all C3 inputs from the feeder sheets.
I want to drag this formula to the right so cell C3 of the master contains sums of all D3 inputs from the feeder sheets, and
I want to drag the formula down so cell B4 of the master contains the the sums of all C4 inputs from the feeder sheets,
etc

Hard to explain. Hope someone can help.

thebutlerdidit

[Tony Valko]

Create a "sheet sandwich".

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

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

Then, the formula would be:

=SUM(Start:End!C3)

When you add new sheets that need to be included in the
calculation just put them between the Start sheet and the
End sheet.

Copy across and down as needed.

[XOR LX]

Hi,

=SUM(Sheet1:Sheet100!C3)

provided that Sheet1 and Sheet100 are the left- and rightmost of your sheets respectively (as seen by the viewer) in the workbook.

Regards

[Richard Buttrey]

Hi,

Try

=SUM('FirstSheet:LastSheet'!D3)

where FirstSheet and LastSheet are the first and last tabs you're trying to sum. There must be no other sheets in between otherwise they too will be summed. To avoid potential problems when adding sheet tabs that you want included it's generally considered good practice to create two hidden dummy sheets called say 'First' and 'Last' at either end of your tab names and use these names in the formula.

[thebutlerdidit]

Tony, the sheet sandwich is ridiculously cool! Thanks for providing me with a great solution!

thebutlerdidit

[Tony Valko]

You're welcome. Thanks for the feedback!