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, b...
Hi Richard,
That could be something like this
=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))
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.
