Formula to add diagonally (A1, B2, C3, etc)

[maryren]

I need a formula to add diagonally. I know I could add the sum of each cell (A1, B2, C3, etc.), but is there a way to write a formula that would achieve this and can be copied over to the next column? I've tried to think of a way to do it, but have been unsuccessful.

ADD DIAGONAL.jpg

[shg]

=sumproduct(--(row(a1:g7) - row(a1) = column(a1:g7) - column(a1)), a1:g7)

[Norie]

Perhaps this which needs to be entered with CTRL+SHIFT+ENTER.

Please Login or Register  to view this content.

[shg]

=SUM(IF(ROW(A1:G7)=COLUMN(A1:G7),A1:G7,0))

That's not going to copy right, Norie.

[maryren]

Thanks for this, it works great, really appreciate it.

[shg]

You're welcome.