G3:H6=IF($F3="","",SUMPRODUCT((TEXT($A$3:$A$16,"M")-LEFTB(G$2,2)=0)*($B$3:$B$16=$F3)*$C$3:$C$16*$D$3:$D$16)/SUMPRODUCT((TEXT($A$3:$A$16,"M")-LEFTB(G$2,2)=0)*($B$3:$B$16=$F3)*$C$3:$C$16))
另解G3:H6{=IF($F3="","",10^SUM(LOG(MMULT(COLUMN(A:N)^0,IFERROR((TEXT($A$3:$A$16,"M")-LEFTB(G$2,2)=0)*($B$3:$B$16=$F3)*$C$3:$C$16*$D$3:$D$16^{1,0},)))*{1,-1}))
留言
張貼留言