Sumproduct with counting array

[merry_fay]

Hi,

I'm trying to set up a sumproduct using a count as the 2nd array

eg Sumproduct(A2:A10,1 to 9)
so the output is: A2*1, A3*2, A4*3 etc

I'm having problems working out how to do the numbers side (1 to 9 bit) & can't find any examples. I know I could create a range & enter the numbers in the cells but this would be a last resort!

Can anyone help please?

Thanks
merry_fay

 

[njimack]

Maybe this:
=SUMPRODUCT(A1:A10,ROW(A1:A10))

 

[MrKowz]

Try:

=SUMPRODUCT(A2:A10,{2,3,4,5,6,7,8,9,10})

 

[merry_fay]

Thanks guys!!! Both methods work but I've adapted njimack's slightly as it's more dynamic:

=SUMPRODUCT(A1:A10,ROW(A1:A10)-ROW(A1)+1)

(my actual final formula is a bit too lengthy to post as all the references are replaced with offsets & matches, but this gives the gist & works!!)

This means I can use a range anywhere & am not fixed to row 1!

Thankyou