Thread: how do I use variable column and rows using other cell reference .
View Single Post
  #1   Report Post  
Bomber
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote