總和 二代碼間 (11415)

 G2:H5{=SUM(OFFSET(C$1,MATCH(LEFT($F2,FIND("~",$F2)-1),$A:$A,)-1,,SUM(LARGE(ISNUMBER(FIND($A$2:$A$16,$F2))*ROW($2:$16),{1,2})*{1,-1})+1))