one way:

=MAX(OFFSET($A$5,0,0,$B$1,1))

B1 contains number of rows to be included: for your example it would be 6
(A5 to A10 inclusive)

"Ken" wrote:

How do I refer to a range of values when one component is a variable? For
instance, lets say I want the MAX value of the cells from cell A5 to A(6+x)
where x is a variable ... if x=4 then I would be finding the MAX value in the
cells from A5 to A10. How do I structure this formula in Excel?
--
Ken