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

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.

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

--
HTH

Bob Phillips

"Bomber" wrote in message
...
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.

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"Bomber" wrote in message
...
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.