formula for mulitple worksheets

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.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Thanks Mr.E, I found my message on the second to the last page. I'm just going to throw this message in to try to bump it back to the top of the lot.
 
Upvote 0
Phylis - Your first option should work, is your options set to Manual Calculation. If your status bar is on at the bottom left of the sheet the word CALCULATE will appear. If this is the case go to Tools, Options, Calculation and change to Automatic.
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top