总和 每列依指定 乘 數量 (10880)

B12:M12=SUM(MMULT(($A2:$A11={"W30-1","W20-1","W20-2","W20-3"})*B2:B11,{1;2;3;4}/1%))

另解=SUMPRODUCT(SUMIF($A2:$A11,{"W30-1","W20-1","W20-2","W20-3"},B2:B11)*{1,2,3,4}/1%)