calculations across sheet and other workbooks
 

Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP

Hi

=SUM(Sheet2!A1:A3+Sheet1!A1:A5) works for me.

Should work across spreadsheets

HTH

"rexmann" wrote:

Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP

Nice one - thanks Fred

cheers Rexmann


"Fred" wrote:

Hi

=SUM(Sheet2!A1:A3+Sheet1!A1:A5) works for me.

Should work across spreadsheets

HTH

"rexmann" wrote:

Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP

calculations across sheet and other workbooks
 

Dear all
I know this is an old thread, but I have a related question.
I am trying to make the contents of a cell equal to the contents of another
cell in another workbook. I've used autosum to create a formula but it won't
'hide' behind the data. The cell will only display the formula. I've tried
CTRL` to show/hide formulas but the formula stays visible.

Can anyone help?

Many thanks
JH

"rexmann" wrote:

Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP

calculations across sheet and other workbooks
 

That cell might be formatted as text, so the formula is taken as a
text string. Click on Format | Cells | Number tab, and select General
then OK. Then press F2 as if to edit the cell and then <Enter, which
will bring about the change in format.

Hope this helps.

Pete

On Jan 8, 12:11*pm, Silverwrinkly
wrote:
Dear all
I know this is an old thread, but I have a related question.
I am trying to make the contents of a cell equal to the contents of another
cell in another workbook. *I've used autosum to create a formula but it won't
'hide' behind the data. *The cell will only display the formula. *I've tried
CTRL` to show/hide formulas but the formula stays visible.

Can anyone help?

Many thanks
JH



"rexmann" wrote:
Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP- Hide quoted text -

- Show quoted text -

calculations across sheet and other workbooks
 

Hi Pete
It partially helped. The formula is now hidden, but the cell will only show
a result of zero.

Thanks
JH

"Pete_UK" wrote:

That cell might be formatted as text, so the formula is taken as a
text string. Click on Format | Cells | Number tab, and select General
then OK. Then press F2 as if to edit the cell and then <Enter, which
will bring about the change in format.

Hope this helps.

Pete

On Jan 8, 12:11 pm, Silverwrinkly
wrote:
Dear all
I know this is an old thread, but I have a related question.
I am trying to make the contents of a cell equal to the contents of another
cell in another workbook. I've used autosum to create a formula but it won't
'hide' behind the data. The cell will only display the formula. I've tried
CTRL` to show/hide formulas but the formula stays visible.

Can anyone help?

Many thanks
JH



"rexmann" wrote:
Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP- Hide quoted text -

- Show quoted text -

calculations across sheet and other workbooks
 

Press F9 to see if the cell recalculates - if it does then you have
the sheet set to manual recalculation, and you can re-set this to
Automatic by clicking on Tools | Options | Calculation tab.

If this still doesn't work for you, then please post your formula
here, together with an explanation of what you want it to do (i.e.
describe the data that you have as well).

Hope ths helps.

Pete

On Jan 8, 1:24*pm, Silverwrinkly
wrote:
Hi Pete
It partially helped. *The formula is now hidden, but the cell will only show
a result of zero.

Thanks
JH



"Pete_UK" wrote:
That cell might be formatted as text, so the formula is taken as a
text string. Click on Format | Cells | Number tab, and select General
then OK. Then press F2 as if to edit the cell and then <Enter, which
will bring about the change in format.

Hope this helps.

Pete

On Jan 8, 12:11 pm, Silverwrinkly
wrote:
Dear all
I know this is an old thread, but I have a related question.
I am trying to make the contents of a cell equal to the contents of another
cell in another workbook. *I've used autosum to create a formula but it won't
'hide' behind the data. *The cell will only display the formula. *I've tried
CTRL` to show/hide formulas but the formula stays visible.

Can anyone help?

Many thanks
JH

"rexmann" wrote:
Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

calculations across sheet and other workbooks
 

Hi Pete
This is the formula that is in the cell that I want the data copied to. For
security reasons I have had to change the name of the spreadsheet that the
data is coming from, but the data is in cell B14 of that spreadsheet.

=SUM('[NAME OF SPREADSHEET WITH DATA.xls]'!$B$14)

Thanks again for your help
JH

"Pete_UK" wrote:

Press F9 to see if the cell recalculates - if it does then you have
the sheet set to manual recalculation, and you can re-set this to
Automatic by clicking on Tools | Options | Calculation tab.

If this still doesn't work for you, then please post your formula
here, together with an explanation of what you want it to do (i.e.
describe the data that you have as well).

Hope ths helps.

Pete

On Jan 8, 1:24 pm, Silverwrinkly
wrote:
Hi Pete
It partially helped. The formula is now hidden, but the cell will only show
a result of zero.

Thanks
JH



"Pete_UK" wrote:
That cell might be formatted as text, so the formula is taken as a
text string. Click on Format | Cells | Number tab, and select General
then OK. Then press F2 as if to edit the cell and then <Enter, which
will bring about the change in format.

Hope this helps.

Pete

On Jan 8, 12:11 pm, Silverwrinkly
wrote:
Dear all
I know this is an old thread, but I have a related question.
I am trying to make the contents of a cell equal to the contents of another
cell in another workbook. I've used autosum to create a formula but it won't
'hide' behind the data. The cell will only display the formula. I've tried
CTRL` to show/hide formulas but the formula stays visible.

Can anyone help?

Many thanks
JH

"rexmann" wrote:
Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -