Sumproduct summing and multiplying 2 matrixes - 4 columns (not criteria)

user_5336592 0
Viewed 74

I have some columns and i need pr line to add say from O:S and then multiply with corresponding values from column N

So first sum from O:S then multiply with N:N

I could do =SUMPRODUKT(N:N;O:O) + SUMPRODUKT(N:N;P:P) + SUMPRODUKT(N:N;Q:Q) + SUMPRODUKT(N:N;R:R) + SUMPRODUKT(N:N;S:S)

so I multiply N with each of the columns O to S but im sure there is a better way !
Specialy since it could be from S through QQ and that would be one boring formula to write

the problem

sumproduct excel-formula excel
2 Answers
=SUMPRODUKT(HVIS.FEJL(N:N*O:Q;0))  

' or in English

=SUMPRODUCT(IFERROR(N:N*O:Q,0))

Thank you @VBasic2008 and @mayukh-bhattacharya

user_53365920

SUMPRODUCT: The Multiplier of Arrays

  • As expected, it's as easy as:

    =SUMPRODUCT(N:N*O:S)

  • Here's a small visual study I 'conducted':

enter image description here

user_98140690
Related