加總 文本數字 (10366)

B14:F14{=SUM((0&LEFT(B4:B12,FIND("户",B4:B12&"户")-1))*1)&"户"&SUM((0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(B4:B12,"户","万"),"万",REPT(" ",9)),9,9)))*1)&"万元"

另解{=SUBSTITUTE(SUBSTITUTE(IMSUM(0&SUBSTITUTE(SUBSTITUTE(B4:B12,"户","+"),"万元","i")),"+","户"),"i","万元")

另解{=SUM(IFERROR(--LEFT(B4:B12,FIND("户",B4:B12)-1),))&"户"&SUM(IFERROR(--MID(B4:B12,FIND("户",B4:B12)+1,FIND("万",B4:B12)-FIND("户",B4:B12)-1),))&"万元"