第1个回答 2013-08-16
你可以直接copy这几个公式
C1: =SUMIF(D3:D11,">0")
D1: =SUMIF(D3:D11,"<0")
C2: =SUBSTITUTE(SUBSTITUTE(IF(LEFT(A1,1)="-",0&A1,A1)&IF(LEFT(B1,1)="-",B1,"+"&B1),"+",","),"-",",-")&","
C4: =FIND(",",C$2,C3+1)
D3: =VALUE(MID($C$2,C3+1,C4-C3-1))
甚至可以适用于类似 3+12-45+32+2 和 8-9-111+6等复杂情况。
如果你非得用一个函数实现(不用任何辅助单元格),需要用VB。本回答被网友采纳