Forum Discussion
Solved
Sum and Product on an Array
I am trying to multiply row 2 by row 1 and then sum the results. BUT, I want to start the multiplication of row 2 at the start of row 1.
I have tried sumproduct on its own and using CSE, but I think I am not using the correct formula. Any ideas?
Hi Richard,
That could be something like this
=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))
2 Replies
Hi Richard,
That could be something like this
=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))
Many thanks. Very useful.
