Summing up figs in same cell in 20 diff sheets

[joanong]

Hi,

I have 20 worksheets (identical in format) and I would like to have a summary sheet summing the figs up.

I supposed I can click on every 'B10' cell of the 20 sheets to get the sum in 'B10' in summary sheet, but I'm curious whether I can run a macro or use a formula to do this.

Tried to sum up the figs by using =SUM, select all the sheets, and click on cell 'B10', but I got a #REF error.

Will be v grateful if someone can help, or direct me to any online so that I can read up myself.

Thanks alot!

 

[Juan Pablo González]

Use

=SUM(Sheet1:Sheet20!B10)

to sum B10 in all the sheets from Sheet1 to Sheet20 (Including these two)

 

[joanong]

Wow, that's fast!

Thanks! :wink: