EXCEL中带不同单位的单元格,如何求和?答:=SUBSTITUTE(A1,"m²","")*SUBSTITUTE(B1,"元/m²","")具体位置根据表格中那个可以修改,可以进行下拉填充公式 想出现货币符号可以把单元格格式设置为货币 也可以加一层函数把他设置为货币格式 =TEXT(SUBSTITUTE(A1,"m²","")*SUBSTITUTE(B1,"元/m²","")," ¥*...
excel怎样有单位数值按不同单位分别求和答:""),"支","")))&"个"&SUMPRODUCT((ISNUMBER(FIND("支",A2:A100)))*(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(0&A2:A100,"箱",""),"瓶",""),"个",""),"支","")))&"支"如图:(如果求和结果不想存放在一个单元格内,请自行从连接符&处将4个公式断开并单独运算即可。)...