SOLVED

Sum and Product on an Array

Copper Contributor

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.image.png

 

 

I have tried sumproduct on its own and using CSE, but I think I am not using the correct formula. Any ideas?

2 Replies
best response confirmed by Richard Conway (Copper Contributor)
Solution

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.

1 best response

Accepted Solutions
best response confirmed by Richard Conway (Copper Contributor)
Solution

Hi Richard,

 

That could be something like this

=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))

 

View solution in original post