WPS表格中如何对有文字和数字的单元格进行求和!!求大神解答

2025-03-21 02:46:52
推荐回答(1个)
回答1:

=IF(E3="","",SUMPRODUCT(--TEXT(MID(TEXT(MID(SUBSTITUTE(E3,"组",REPT(" ",9)),ROW($1:$1000),10),),2,9),"0.00;-0.00;;!0")))