ds的自查,修改之后能用了,可惜限制挺大的
=SUM(
IFERROR(
VALUE(
MID(
TEXTSPLIT(TEXTJOIN("+", TRUE, H3:H4), "+"),
SEARCH("现金", TEXTSPLIT(TEXTJOIN("+", TRUE, H3:H4), "+")) + LEN("现金"),
LEN(TEXTSPLIT(TEXTJOIN("+", TRUE, H3:H4), "+")) - SEARCH("现金", TEXTSPLIT(TEXTJOIN("+", TRUE, H3:H4), "+")) - LEN("现金") + 1
)
),
0
)
)
