201803100945二列找數據 正反向相乘 (4153)

C11:G22SUMPRODUCT(N(OFFSET($J$2,MATCH($B11,$J$3:$J$14,),MATCH($B$3:$B$6,$K$2:$N$2,)))*C$3:C$6)

方式二SUMPRODUCT(MMULT($K$3:$N$14*($J$3:$J$14=$B11),N(OFFSET(C$7,-ROW($1:$4),))))

{=SUM(IF($B$3:$B$6=$K$2:$N$2,C$3:C$6)*MMULT(COLUMN(A:L)^0,N(IF($J$3:$J$14=$B11,$K$3:$N$14))))

{=SUM(MMULT(COLUMN(A:D)^0,N(IF($B$3:$B$6=$K$2:$N$2,C$3:C$6)))*IF($J$3:$J$14=$B11,$K$3:$N$14))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite