[Island Girl]

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.

[Kate G.]

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" wrote in message
...
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.

[Island Girl]

That's exactly what I meant, Kate. Thank you so very much!

"Kate G." wrote:

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" wrote in message
...
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.