Using cells to refer to worksheets

[Rup1776]

Hello,

I am trying to SUM the total number of a specific colunm for a number of
different worksheets, in the same worksheet.

I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
have been able to generate the correct formula for each worksheet
A B
Contacts
Ward 3 =SUM('Ward 3'!H3:H36)

Is there a way to use the text in column A to generate the formula in column
B. rather than copying and changing the formula?

Im not sure how clear the question is so please ask!!!

Thanks

Rup

 

[Niek Otten]

Hi Rup,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I am trying to SUM the total number of a specific colunm for a number of
| different worksheets, in the same worksheet.
|
| I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
| sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
| have been able to generate the correct formula for each worksheet
| A B
| Contacts
| Ward 3 =SUM('Ward 3'!H3:H36)
|
| Is there a way to use the text in column A to generate the formula in column
| B. rather than copying and changing the formula?
|
| Im not sure how clear the question is so please ask!!!
|
| Thanks
|
| Rup