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