Hey,

I am trying to solve the following problem:

I am using the formula below, to calculate the diagonal sum:

{=SUM(N(INDIRECT(ADDRESS(ROW(32:34);ROW(2:4)))))}

However, I want to replace the second cell reference of the ROW definition, i.e. here 34 and 4 with a variable, or value of a cell.

How can I do this?

Thanks a lot in advance!