Variable row number in a formula

Posted by John S. on March 06, 2001 8:44 AM

cell A1 has a number that changes. This number represents the bottom row # in a changing range somewhere off in the spreadsheet. I want the formula
SUM(B1:Bx)where x = the number in A1

Posted by Mark W. on March 06, 2001 8:48 AM

=SUM(B1:INDIRECT("B"&A1))

Posted by Dave Hawley on March 06, 2001 8:48 AM

Hi John

You can use the indirect function for this:
=SUM(INDIRECT("B1:B"&A1))

Dave

OzGrid Business Applications