Using cells to refer to worksheets

G

Guest

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
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF across a number of worksheets 1
Difficulty with Sum+IF Function 10
time calculations 1
Formula Too Long error 5
SUM formula results returns 0 value 7
Another data across multiple worksheets question (ugh..) 1
Adding up total hours worked on employee schedule using various criteria 0
Value of minutes not calculated 8

Top