how do I use variable column and rows using other cell reference .

[Guest]

without using VB - how do I say sum a range where the row /column values
depend upon the value in another cell (i.e. =SUM(A[2+value in cell say
k4]:A[3+value of cell say k5]). In other words, the column row in the above
case is dependent upon another cell value.

 

[Bob Phillips]

=SUM(INDIRECT("A"&K4&":A"&K5))

 

[Guest]

I want to do something similar to this but want to vary the columns

ie = (current column +/- number of columns specified by value in say cell
A1, constant row value)

Gidders

=SUM(INDIRECT("A"&K4&":A"&K5))

--
HTH

Bob Phillips

without using VB - how do I say sum a range where the row /column values
depend upon the value in another cell (i.e. =SUM(A[2+value in cell say
k4]:A[3+value of cell say k5]). In other words, the column row in the above
case is dependent upon another cell value.