總和 依二數字之間數 (12079)

F1{=SUM(IFERROR(LEFT(RIGHT(SUBSTITUTE("~"&E4:E19,"~",REPT(" ",9)),{18,9}),9)*{-1,1},))

另解{=SUM(ABS(INT(SUBSTITUTE(0&E4:E19,"~","."))-(0&MID(E4:E19,FIND("~",E4:E19&"~")+1,9))))