I'm trying to get a max value on a summary sheet for 27 years worth of data.
I seem to be running into the problem that the cell(s) I want the max value
from is a calculated cell. These are the formulas that I'm using.

Summary sheet =max('2008'!c21:'2007'!c21) I get the value error on this one.

year sheets c21 =SUM(D21:AH21)

I tried adding a new cell ai21 that I typed in the value of cell c21, The
formula =max('2008'!ai21:'2007'!ai21) still gives me the value error.

The "show calculation steps" gives the following:
reference evaluation
Statistics$c$12 =max('2008'!ai21:'2007'!ai21)
the next evaluation will result in an error
Statistics$c$12 =max(#value!)
to show the result of the underlined expression, click evaluate. The most
recent result appear italicized.
also tried =max('2008'!$ai$21:'2007'!$ai$21) with the same results.

thanks in advance for your suggestions.

Try it like this:

=MAX('2008:2007'!C21)

--
Biff
Microsoft Excel MVP


"RickP25" wrote in message
...
I'm trying to get a max value on a summary sheet for 27 years worth of
data.
I seem to be running into the problem that the cell(s) I want the max
value
from is a calculated cell. These are the formulas that I'm using.

Summary sheet =max('2008'!c21:'2007'!c21) I get the value error on this
one.

year sheets c21 =SUM(D21:AH21)

I tried adding a new cell ai21 that I typed in the value of cell c21, The
formula =max('2008'!ai21:'2007'!ai21) still gives me the value error.

The "show calculation steps" gives the following:
reference evaluation
Statistics$c$12 =max('2008'!ai21:'2007'!ai21)
the next evaluation will result in an error
Statistics$c$12 =max(#value!)
to show the result of the underlined expression, click evaluate. The most
recent result appear italicized.
also tried =max('2008'!$ai$21:'2007'!$ai$21) with the same results.

thanks in advance for your suggestions.