INDIRECT() FUNCTION

[Jay]

I have the followin 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 be changing "50" in all the above cells. How do I make there
functions get the value "50" from another sell.

Something like:

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


thanks,
Jay

 

[Peo Sjoblom]

One way

=IF(A1="","",MIN(B1:INDIRECT("B"&A1)))

 

[Lance]

You could change your formulas to

Min(B:B), Max(B:B) and Sum(B:B) if there are no other
values in column B

Lance