I'd like to have the ability to use the SUM() and other functions by
selecting a set # of rows which is determined by the number placed in the
FIRST row of a worksheet. For example, if I wanted to SUM for 3 rows I would
normally do SUM(A4:A6), SUM(A5:A7), SUM(A6:A8).... or generally
SUM(A((Row())-(A1-1):A(Row())) where A(Row()) is the current ROW # and (A1-1)
is one less than the value in A1 (# or rows desired to add or apply the
function to).
How can I do this for say A1=3, B1=5, C1=7 or even just varying what's in
A1...G1 to see how things work? I'd like to NOT have a specific summation
function. That is, NOT using SUM(A2:A10).
TIA