字符起迄月份 總和 (14890)

H2:N6=SUMPRODUCT(ISNUMBER(MATCH($C$1:$G$1,ROW(INDIRECT(SUBSTITUTE(LEFT(J$1,LEN(J$1)-1),"-",":")))&"月",))*($B$2:$B$6=$I2)*$C$2:$G$6)