excel 公式支持 ~ -

=SUM(IFERROR(VALUE(RIGHT(D7:D100,LEN(D7:D100)-FIND("~",D7:D100))),D7:D100))

=SUM(IFERROR(VALUE(RIGHT(D7:D100,LEN(D7:D100)-FIND("~",D7:D100))),IFERROR(IF(ISNUMBER(VALUE(D7:D100)),VALUE(D7:D100),VALUE(RIGHT(D7:D100,LEN(D7:D100)-FIND("-",D7:D100)))),0)))