I'm having trouble creating a formula for a table. I need to calculate the product (*) of cells that are diagonally.
VARIABLE = (column 1, row 1) + (column 2, row 2) + (column 3, row 3) +.......
column column column column
Is there a funtion to calculate what I need ?
If anyone can help me, thanks!