非空 計算二行相乘 (14393)

非空數 重複提取 H3{=INDEX(A:A,SMALL(IF((A$3:A$8<>"")*(MMULT(N($C$3:$F$8>0),{1;1;1;1})>={1,2,3,4}),ROW($3:$8),9),ROW(A1)))&""

I3{=IF(H3="","",RIGHT(SMALL(IF((A$3:A$7=H3)*(C$3:F$7>0),C$3:F$7*C$4:F$8+{1,2,3,4}/1%%),COUNTIF(H$3:H3,H3)),4)*1)