Sum Work sheets in a work book

Lewy2 · May 12th, 2002, 06:53 PM

I sure Ive done this before.
I have a work book with 55 worksheets in it and want to sum a the same cell in each sheet. I have tried =sum(sheet(1)!a1:'sheet(55)'!a1) when I point to the cells this is what it comes up with as well but it won't work

Aladin Akyurek · May 12th, 2002, 06:54 PM

Quote:

On 2002-05-12 17:53, Lewy2 wrote:
I sure Ive done this before.
I have a work book with 55 worksheets in it and want to sum a the same cell in each sheet. I have tried =sum(sheet(1)!a1:'sheet(55)'!a1) when I point to the cells this is what it comes up with as well but it won't work

=SUM(Sheet1:Sheet55!A1)

JChrisHardy · May 13th, 2002, 01:22 AM

Type =SUM( in the cell where the answer is to appear.
Click on the tab of the first sheet to be summed and select the cell to be summed.
Hold down the SHIFT key and click on the tab of the last sheet to be included.
Type ) to close the SUM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 12th, 2002, 06:53 PM	#1
Lewy2 New Member Join Date: Mar 2002 Location: Surfers Paradise Posts: 19	I sure Ive done this before. I have a work book with 55 worksheets in it and want to sum a the same cell in each sheet. I have tried =sum(sheet(1)!a1:'sheet(55)'!a1) when I point to the cells this is what it comes up with as well but it won't work

May 13th, 2002, 01:22 AM	#3
JChrisHardy New Member Join Date: May 2002 Location: Essex Posts: 7	Type =SUM( in the cell where the answer is to appear. Click on the tab of the first sheet to be summed and select the cell to be summed. Hold down the SHIFT key and click on the tab of the last sheet to be included. Type ) to close the SUM.