Here is an array formula that works.

Data

100 300
100 300
100 300
100
100
100
100
100 300
100 300

500 Result

{=SUM((I12:I20 <"")*(J12:J20<"")*I12:I20)}

Enter as Array with Ctrl-Shift-Enter

Siegfried