INDIRECT() FUNCTION

[Jay]

Sorry: my previous post had a few spelling errors.

I have the following formulas in cells:

CELL A2 = MIN(B1:B50)
CELL A3 = MAX(B1:B50)
CELL A4 = SUM(B1:B50)

Hence, my data is in cell range (B1:B50). But as I add more data I do not
want to change "50" in all the above cells. How do I make these
functions get the value "50" from another cell.

Something like:

CELL A2 = MIN(B1:B & CELL(A1)) where cell A1 will have the value 50.


thanks,
Jay