Phylis Sophical
New Member
- Joined
- Jan 13, 2002
- Messages
- 42
So happy I have found this board. Here's the problem.
I have 20+ sheets in a workbook. The first one is a summary sheet. I am trying to
put a formula in the summary sheet to add up the totals of a particular cell in all
the other sheets. (cell C47 of each sheet)
I have tried =, then go to each sheet, click the cell and a plus sign, then Enter.
I have tried =, then selecting all the sheets together, clicking in C47 and clicking
Enter.
I have tried linking one cell on the summary sheet to C47 of sheet1, then going to
the next cell and repeating for sheet2 and so on. Then simply adding those cells
up =SUM(F44:AJ44). I did this in a row, not a column, does that make a
difference?
When I first enter the formulas, the result carries into the summary sheet. But if I
go to a new sheet and put in a total amount, or change the amount on any of the
other sheets, it won't show in the summary sheet.
I have the sheets protected except for the cells I enter the total amounts in. Is this
making a difference? Some of the sheet names are two words, but they do have
colons on either side in the formula.
Thanks in advance for any help.
I have 20+ sheets in a workbook. The first one is a summary sheet. I am trying to
put a formula in the summary sheet to add up the totals of a particular cell in all
the other sheets. (cell C47 of each sheet)
I have tried =, then go to each sheet, click the cell and a plus sign, then Enter.
I have tried =, then selecting all the sheets together, clicking in C47 and clicking
Enter.
I have tried linking one cell on the summary sheet to C47 of sheet1, then going to
the next cell and repeating for sheet2 and so on. Then simply adding those cells
up =SUM(F44:AJ44). I did this in a row, not a column, does that make a
difference?
When I first enter the formulas, the result carries into the summary sheet. But if I
go to a new sheet and put in a total amount, or change the amount on any of the
other sheets, it won't show in the summary sheet.
I have the sheets protected except for the cells I enter the total amounts in. Is this
making a difference? Some of the sheet names are two words, but they do have
colons on either side in the formula.
Thanks in advance for any help.