Summing upward diagonals

Hi there,

I am wondering if anyone can help me with a problem I am having:

I am trying to sum up the upward diagonals of a square table:

3 1 1 1
6 5 4 1
7 8 9 1
2 2 2 1

So basically I would like a formula to sum the following:

Row 1: 3
Row 2: 6+1 = 7
Row 3: 7+5+1= 13
Row 4: 2+8+4+1= 15

I have been experimenting with various offset arrays but can't seem to get it to work!

Would really appreciate any help!

Thanks,
Gilca

Did you try this one?

Comfirmed with ctrl+shift+enter (no tjust enter)

Formula:

Please Login or Register  to view this content.