sum all sheets cell in master sheet

[nikko50]

I want to sum all of the b8 cells of the hundrend or so sheets I have into cell a1 of the "Master" sheet. How can I do this?

 

[rs2k]

Select your first sheet and press 'Shift' and select your last sheet, to select all your sheets;

=SUM(First:Last!B8)

HTH
Colin

 

[number kruncher]

You need a 3D formulae, eg.

=SUM(Sheet2:Sheet3!B8)

All the sheets to be added need to be contiguous, i.e. adjacent to each other.

 

[poolhall]

try this:

Sub test()
Dim ws As Worksheet

For Each ws In Worksheets
    Sheet1.Range("A1").Value = Sheet1.Range("A1").Value + Sheets(ws.Name).Range("B8").Value
Next ws

End Sub

 

[nikko50]

We will be adding sheets daily. How can this be done so I don;t always have to do that?

 

[number kruncher]

Add New Sheet(s) between the First Sheet and the Last one, then these will be automaticaly be included in the 3D SUM.