INDIRECT() FUNCTION

  • Thread starter Thread starter Jay
  • Start date Start date
J

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
 
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
 
Back
Top