多數字相乘 空白與0不計算 (14880)

H2=10^MMULT(LOG(TEXT(B2:F2,"0;;1")),{1;1;1;1;1})-(COUNTIF(B2:F2,">0")=0)

另解{=PRODUCT(IF(B2:F2>0,B2:F2,1))-(COUNTIF(B2:F2,">0")=0)