What is the formula for adding a group of worksheets together?

[Guest]

I am setting up monthly spread sheets for tax purposes. I have each month
set up separately and a total page. I want to know if you can put a formula
in on the total page (which is a separate worksheet in my workbook) that will
add up a single row from each worksheet an d give me a total for my total
page.

 

[Guest]

Hi

Something like =SUM(Sheet2:Sheet3!B22). Start the formula =SUM( ,then
select the sheets you want and then the range.

regards
Peter

 

[Guest]

Does this work on all versions of MS Excel? And what if you change to the
name of the sheet do you put the new name of the sheet or do you still use
Sheet 1: etc.

 

[Gord Dibben]

A method that allows for changing sheet names.........

Insert a dummy sheet at beginning and a dummy sheet at end of sheets.

Name these Start and End.

Your formula would then be =SUM(Start:End!B22) and encompass all sheets
between no matter what the name or how many new sheets are inserted.

Yes.....it works in all versions I can remember as far back as Version 5


Gord Dibben MS Excel MVP