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

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

Solution 1:^[1]

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

' or in English

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

Thank you @VBasic2008 and @mayukh-bhattacharya

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	VBasic2008

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

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]