How do I set up a variable reference range in Excel?

[Guest]

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., S1S1+$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

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)