Dear all,
I have a question about one of the most powerful function (This is my opinion for SUMPRODUCT)

I have quantities and amonuts. The quantities are in array C19:H19, but the amounts are in each first colum J19:AA19
For help I create one row J48:AA48={1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0}
and then =SUMPRODUCT(J19:AA19;J48:AA48)

BUT
How I can take quantities?
I must be reached =IFERROR(+((C19*J19)+(D19*M19)+(E19*P19)+(F19*S19)+(G19*V19)+(H19*Y19))/I19;0)
I19 is equal to sum of quantities

Thank you for help in advance!