Try:

=SUMPRODUCT(TRANSPOSE(INDIRECT("row"&ROW())*(rngDa taNums)))



"JzP" wrote:

Hi all,
For various complicated reasons I am using a macro to build a series
of "helper" named ranges which are named "Row" and then the row
number. (ie Row1, Row2 etc)
I can then use the following function in my worksheet;
=SUMPRODUCT(TRANSPOSE(Row1)*(rngDataNums)) and, if I enter it with
Ctrl-Shift-Enter, I get the correct value.

What I want to do is to replace the "Row1" in the formula above with
the equivalent of "Row" & Row() so each row will use the correct named
range previously built for that row.

However, can't work out the correct syntax.

Any help would be greatly appreciated.
TIA

John