

B3=IFERROR(FIND("4、",A3)^0+1,1)
C3=IF(B3=2,3,1)
D3=C3
E3=LET(x,TEXTSPLIT(A3,"。"),QY,SUM(IFERROR(FIND("清淤",x)^0,0)),PS,8*SUM(IFERROR(FIND("抛石抛筑",x)^0,0)),AP,6*SUM(IFERROR(FIND("岸坡土方开挖",x)^0,0)),TEXTJOIN("+",,QY,PS,AP)&"="&SUM(QY,PS,AP))
F3=LET(x,TEXTSPLIT(A3,"。"),QY,2*SUM(IFERROR(FIND("清淤",x)^0,0)),PS,SUM(IFERROR(FIND("抛石抛筑",x)^0,0)),TEXTJOIN("+",,QY,PS)&"="&SUM(QY,PS))
G3=TEXTJOIN("+",,IFERROR(FIND("岸坡土方开挖",TEXTSPLIT(A3,"。"))^0*2,""))&"="&SUM(IFERROR(FIND("岸坡土方开挖",TEXTSPLIT(A3,"。"))^0*2,""))