wps表格中有带有文字数字怎么求和并且12进1

每件是12瓶,所以每月相加,瓶数还要12瓶进1件
2025-03-09 09:38:50
推荐回答(1个)
回答1:

C13=INT(SUMPRODUCT(MID(SUBSTITUTE(SUBSTITUTE(C1:C12,"件",REPT(" ",9)),"瓶",),{1,9},9)/{1,12}))&"件 "&MOD(SUMPRODUCT(--SUBSTITUTE(MID(C1:C12,FIND("件",C1:C12)+1,9),"瓶",)),12)&"瓶"