|
| View previous topic :: View next topic |
| Author |
Message |
Island Girl
Guest
|
 Posted: Sun Dec 23, 2007 10:05 pm Post subject: cell reference |
 |
|
I have very little experience in Excel, as you can detect from the following
question:
I have separately totaled Segment I, Segment II, Segment III and Segment IV
on the same sheet.
At the end of the document the total of each segment is referred to.
How do I enter (refer to) this total so that if something in each segment
changes, the cell reference will update?
Thank you so much for being there. |
|
| Back to top |
|
 |
Google
Sponsor
|
| Posted: Sun Dec 23, 2007 10:05 pm Post subject: Advertisement |
|
|
|
|
| Back to top |
|
|
Kate G.
Guest
|
| Posted: Sun Dec 23, 2007 10:37 pm Post subject: Re: cell reference |
|
|
Assuming your Segments are in independent columns... and you say you have
totaled each segment.
Then at the end of the document, do a simple reference back to the
individual totals. So for example, in column A you have Segment I and in
A45 you have the total for the entries in Column A.
Then at the "end" of bottom of the document, in for example Row A50... just
type in =A45.
Then when you change A22 or A37... it will automatically recalculate your
total in A45... and in A50 as well.
If this isn't what you meant == please post back.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Kathryn Groves
"Island Girl" <IslandGirl@discussions.microsoft.com> wrote in message
news:24D00474-3B45-4C9E-8546-D98E4F707EE2@microsoft.com...
| Quote: | I have very little experience in Excel, as you can detect from the
following
question:
I have separately totaled Segment I, Segment II, Segment III and Segment
IV
on the same sheet.
At the end of the document the total of each segment is referred to.
How do I enter (refer to) this total so that if something in each segment
changes, the cell reference will update?
Thank you so much for being there.
|
|
|
| Back to top |
|
|
Island Girl
Guest
|
| Posted: Sun Dec 23, 2007 10:44 pm Post subject: Re: cell reference |
|
|
That's exactly what I meant, Kate. Thank you so very much!
"Kate G." wrote:
| Quote: | Assuming your Segments are in independent columns... and you say you have
totaled each segment.
Then at the end of the document, do a simple reference back to the
individual totals. So for example, in column A you have Segment I and in
A45 you have the total for the entries in Column A.
Then at the "end" of bottom of the document, in for example Row A50... just
type in =A45.
Then when you change A22 or A37... it will automatically recalculate your
total in A45... and in A50 as well.
If this isn't what you meant == please post back.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Kathryn Groves
"Island Girl" <IslandGirl@discussions.microsoft.com> wrote in message
news:24D00474-3B45-4C9E-8546-D98E4F707EE2@microsoft.com...
I have very little experience in Excel, as you can detect from the
following
question:
I have separately totaled Segment I, Segment II, Segment III and Segment
IV
on the same sheet.
At the end of the document the total of each segment is referred to.
How do I enter (refer to) this total so that if something in each segment
changes, the cell reference will update?
Thank you so much for being there.
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
