# Revision history [back]

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