=INDIRECT("S1:S"&$A$7)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Pecan1862" wrote in message
...
I'm setting up an sales audit spreadsheet, and can't determine how to make
the 2nd set of numbers in a reference range variable based on a value in
an
absolute cell, e.g., S1:(S1+$A$7). This formula doesn't work, but what I
need to accomplish is summing S1:S15 when 15 is the value of $A$7 or
whatever
value is entered in $A$7.

If anyone has any ideas on how to resolve this, any help would be greatly
appreciated, as I've spent days trying to figure this one out!!!

Thanks,

Pam