總和 三數值分開欄 (12171)

L2=SUM(SUMIF(A$2:B$16,K2,OFFSET(D$2:D$16,,{0,3,4})))

數值欄可改變=SUMPRODUCT((A$2:A$16=K2)*ISNUMBER(FIND("數值",D$1:H$1))*D$2:H$16)