If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Totals Across Multiple Worksheets
I am trying to sum the totals (in accounting number format) across multiple
worksheets onto a single worksheet. I have tried manually creating the necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th formula from a previous worksheet. No matter how I do this, the formula stays visible and does not calculate or become anything more than text. Is there any other way to sum across multiple pages? |
#2
|
|||
|
|||
Linking Totals Across Multiple Worksheets
If you are seeing the formula as text rather than the results, I guess that
the cell is formatted as text. Format the cell as General, then F2 and enter. Having solved that, you may find that it is easier to replace ='ex1'!c19+'ex2'!c19+'ex3'!c19 by =SUM('ex1:ex3'!c19) -- David Biddulph "snowboardbaltimore" wrote in message ... I am trying to sum the totals (in accounting number format) across multiple worksheets onto a single worksheet. I have tried manually creating the necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th formula from a previous worksheet. No matter how I do this, the formula stays visible and does not calculate or become anything more than text. Is there any other way to sum across multiple pages? |
#3
|
|||
|
|||
Linking Totals Across Multiple Worksheets
Make sure the cell with the formula is formatted as GENERAL at first. Enter
your formula *then* change the format if you'd like. Try this formula: =SUM('EX1:EX3'!C19) -- Biff Microsoft Excel MVP "snowboardbaltimore" wrote in message ... I am trying to sum the totals (in accounting number format) across multiple worksheets onto a single worksheet. I have tried manually creating the necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th formula from a previous worksheet. No matter how I do this, the formula stays visible and does not calculate or become anything more than text. Is there any other way to sum across multiple pages? |
#4
|
|||
|
|||
Linking Totals Across Multiple Worksheets
Thank you very much, that solved the problem for most of the formulas. I am
not sure how they got adjusted to textw hen the rest of the document (and the ones they were originally written in and copied from) are in "Accounting" and "General". now, I just have to figure out the rest of them. But, thank you for the great help and making me aware. "David Biddulph" wrote: If you are seeing the formula as text rather than the results, I guess that the cell is formatted as text. Format the cell as General, then F2 and enter. Having solved that, you may find that it is easier to replace ='ex1'!c19+'ex2'!c19+'ex3'!c19 by =SUM('ex1:ex3'!c19) -- David Biddulph "snowboardbaltimore" wrote in message ... I am trying to sum the totals (in accounting number format) across multiple worksheets onto a single worksheet. I have tried manually creating the necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th formula from a previous worksheet. No matter how I do this, the formula stays visible and does not calculate or become anything more than text. Is there any other way to sum across multiple pages? . |
Thread Tools | |
Display Modes | |
|
|