excel绝对值之和
1.=SUM(SUMIF(A2:A14,{">0","<0"})*{1,-1})
参考:https://zh-cn.extendoffice.com/documents/excel/1287-excel-sum-absolute-value.html
2.=SUMPRODUCT(ABS(A1:A20))
参考:https://zhidao.baidu.com/question/2142137492776091908.html
1.=SUM(SUMIF(A2:A14,{">0","<0"})*{1,-1})
参考:https://zh-cn.extendoffice.com/documents/excel/1287-excel-sum-absolute-value.html
2.=SUMPRODUCT(ABS(A1:A20))
参考:https://zhidao.baidu.com/question/2142137492776091908.html