=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.