Skip to Content
0
Former Member
Nov 20, 2012 at 04:40 PM

Calculate diagonal cells in a table

27 Views

Hi,

I'm having trouble creating a formula for a table. I need to calculate the product (*) of cells that are diagonally.

Example;


VARIABLE = (column 1, row 1) + (column 2, row 2) + (column 3, row 3) +.......


column column column column

 row x

 row x

 row x

 row x







Is there a funtion to calculate what I need ?





If anyone can help me, thanks!