201508211727EXCEL函數-每三格相乘後加總(1703) ?EXCEL. D2=SUMPRODUCT(B2:B14*B3:B15*B4:B16*(MOD(ROW(B2:B14),3)=2)). C2:C16=IF(MOD(ROW(),3)=2,PRODUCT(OFFSET(B2, ...
確定! 回上一頁