Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

For example:

=SUMPRODUCT(INDEX(foo;ROW(A1);COLUMN($A$1:$C$1)))

Note:

  • Here A1 and $A$1:$C$1 are not the cell addresses. ROW and COLUMN functions generate numbers (e.g. 3 for COLUMN($A$1:$C$1)
  • So adapt COLUMN to the actual number of columns in your range.

HTH - Regards

Hi

For example:

=SUMPRODUCT(INDEX(foo;ROW(A1);COLUMN($A$1:$C$1)))

Note:

  • Here A1 and $A$1:$C$1 are not the cell addresses. ROW and COLUMN functions generate numbers (e.g. 1 to 3 for COLUMN($A$1:$C$1)
  • So adapt COLUMN to the actual number of columns in your range.

SumRowRange.ods

HTH - Regards