Thanks, Alan!

To Carl:
And the missing righthand parenthesis in Alan's
formulae is a typo <g

LeoH


"Alan Beban" skrev i en meddelelse
...
Leo Heuser wrote:
Carl
2.
First column:
=SUM(OFFSET(E1:F6,0;0,,1)) :::or =SUM(INDEX(E1:F6,0,1)
Second column:
=SUM(OFFSET(E1:F6,0;1,,1)) :::or =SUM(INDEX(E1:F6,0,2)
etc.

First row:
=SUM(OFFSET(E1:F6,0;0,1,)) :::or =SUM(INDEX(E1:F6,1,0)
Second row:
=SUM(OFFSET(E1:F6,1;0,1,)) :::or =SUM(INDEX(E1:F6,2,0)
etc.

And the semicolon in Leo Heuser's formulas is a typo.

Alan Beban