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

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

CodePudding user response：

=SUMPRODUKT(HVIS.FEJL(N:N*O:Q;0))  

' or in English

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

Thank you @VBasic2008 and @mayukh-bhattacharya

CodePudding user response：

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':