Excel表格求和公式为“=sum( )”,求和等于0,通常情况是因为求和的数据范围不是数字格式的缘故,恢复方法如下:
工具:联想笔记本电脑e460、Windows10系统、Excel2016。
1、如果数字左上角有很明显的绿标的,选择数据后,点击感叹号图标,点击“转换为数字”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/962bd40735fae6cd2807e0f81db30f2443a70ff3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、之后就能得出正常结果了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42a98226cffc1e17fb0cc7a85890f603728de9fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、如果数据左上角没有显示绿标的(有时候导出的一些数据会出现这种情况),这时候选中数据后,点击“数据-分列”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/00e93901213fb80e95622a4e24d12f2eb83894fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择分隔符号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d009b3de9c82d158d4301228920a19d8bd3e42fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、依据系统提示,都按默认选择。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/962bd40735fae6cd2806e0f81db30f2443a70ffc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后数据求和也就恢复正常了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/622762d0f703918f3e637653433d269758eec4fd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)