I have excel 2003.
I have a sheet which has a running total that changes each month.
I want just the most updated total to show up in another cell that's on
another worksheet (in the same workbook)- how do I get it to change when the
running total moves into the next cell?
Thanks, Meenie

More information would be better... Use the find a way of correlating the
date (most recent date, for instance) with the max function.
=INDEX(B$1:B$11,MATCH(MAX(A1:A11),A1:A11,0))
Dates in Column A
Date to match in Column B

Regards,
Ryan---

--
RyGuy


"Meenie" wrote:

I have excel 2003.
I have a sheet which has a running total that changes each month.
I want just the most updated total to show up in another cell that's on
another worksheet (in the same workbook)- how do I get it to change when the
running total moves into the next cell?
Thanks, Meenie

I have a workbook with several worksheets. Each sheet has a total for that
month (these are compliance scores to a series of questions so they are
percentages)
ie: work sheet for Unit 1 has an Average of 100%
work sheet for Unit 2 has an Average of 90%
work sheet for Unit 3 has an Average of 100%

Next I have another workbook that shows the year to date Compliance for
each unit. So fur Unit 1, I have a column for each month and the worksheet
is linked to the answers from original worksheets from each month.

Problem: This is April, so the months from May through December are 0 or
#ref! (depending on whether the workbook they are linked to is actually
created yet).

I want the total only to average the numbers in the column and disregard the
zeros and the #ref!'s.
Thanks, Meenie

I know this is a little different from my original question, I had tried to
circumvent the problem by doing it a different way, but it only created
another problem :)

"Meenie" wrote:

I have a workbook with several worksheets. Each sheet has a total for that
month (these are compliance scores to a series of questions so they are
percentages)
ie: work sheet for Unit 1 has an Average of 100%
work sheet for Unit 2 has an Average of 90%
work sheet for Unit 3 has an Average of 100%

Next I have another workbook that shows the year to date Compliance for
each unit. So fur Unit 1, I have a column for each month and the worksheet
is linked to the answers from original worksheets from each month.

Problem: This is April, so the months from May through December are 0 or
#ref! (depending on whether the workbook they are linked to is actually
created yet).

I want the total only to average the numbers in the column and disregard the
zeros and the #ref!'s.
Thanks, Meenie