Sumproduct given a condition

Hi there, sheet attached.

I am trying to arrive at the results in the yellow cells without needing the blue cells inbetween.

A sumproduct would be best but the 2nd row of blue cells has an if statement in it.

MQ

=sumproduct(c3:l3,c5:l5)

=sumproduct((c2:l2*c3:l3)*(c5:l5<>0))

Hi pickslides,

See the attached for some yellow formulas.

Charley Kyd did a great job explaining SumProduct for me at http://exceluser.com/formulas/sumproduct_12.htm .

For the 1st 1...
=SUMPRODUCT((C3:L3)*(C5:L5))
for the 2nd...
=SUMPRODUCT((C2:L2)*(C3:L3)*(C5:L5>0))