Return a range based on a variable
Hi,
Try this
=SUM(INDIRECT("A1:A" & A7))
Mike
"Art" wrote:
Column A contains these five numbers: 9,2,3,5,8
Cell A7 contains the number 4
I need a formula that does the following:
Sum the numbers in column A up to the number of rows in A7.
Formula evaluates to 19 (9+2+3+5)
Thanks,
--
Art
|