工具/材料:Microsoft Office Excel2016版,Excel表格。
1、首先选中Excel表格,双击打开。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b6050e95a23e4f81a4c500fa286?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/96dda144ad345982306b0dc503f431adcaef8480?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、再者在该界面中,公示栏中输入无数据输入时显示空白,而不是0,在输入数据时即使公式结果为0也会显示0的公式“=IF(COUNTBLANK(A1:A5)>0,"",SUM(A1:A5))”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8718367adab44aed0ddc56b3bc1c8701a08bfbd3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后在该界面中,成功显示公式结果为0时单元格里为0。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd900ccdc8e3601213fb90e9180?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/72f082025aafa40f4e4b268aa464034f79f019d3?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/d000baa1cd11728b9da06475c7fcc3cec2fd2cdc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)