Excel如何快速统计非0个数单元格技巧？

[[{"txt": "\u00a0 \u00a0 \u00a0 \u00a0\u672c\u6559\u7a0b\u5c06\u4ecb\u7ecd\u5982\u4f55\u5feb\u901f\u7edf\u8ba1Excel\u8868\u683c\u4e2d\u975e0\u5355\u5143\u683c\u4e2a\u6570\uff0c\u8be5\u6280\u5de7\u9700\u8981\u7528\u5230\u51fd\u6570\u516c\u5f0f\uff0c\u5982\u679c\u60a8\u611f\u5174\u8da3\u7684\u8bdd\uff0c\u4e0d\u59a8\u770b\u770b\u4e0b\u6587\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ba97ffd06de89a6102d5242045e8b004551bad47.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Excel"}, {"txt": "\u6559\u7a0b\u4ee5Excel2013\u4e3a\u4f8b"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u4e3a\u4e86\u65b9\u4fbf\u5b66\u4e60\u548c\u7406\u89e3\uff0c\u6559\u7a0b\u4ee5\u4e0b\u5217\u8868\u683c\u6570\u636e\u4e3a\u4f8b\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/430174fec314f1c5011e24723c27ac5307889d47.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u62e9d1\u5355\u5143\u683c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/dda98e4800fc77f707fe3a93c8715fdb37209047.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728d1\u5355\u5143\u683c\u8f93\u5165\u5185\u5bb9\uff0c\u975e0\u4e2a\u6570\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/3761a73acd8920c581ffed86568a59de44078847.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u62e9d2\u5355\u5143\u683c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/d400248ca608a50f260c353f10cec7f88b77ff47.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728d2\u5355\u5143\u683c\u4e2d\u8f93\u5165\u4ee5\u4e0b\u5185\u5bb9\uff1a=COUNTIF(B2:B6,\"0\")"}, {"img": ["https://exp-picture.cdn.bcebos.com/890dfb4a2f27e7ef94f60eb219dd3340b7f3f547.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6309\u4e0bEnter\u952e\u5373\u53ef\u5f97\u5230b\u5217\u6570\u636e\u4e2d\u975e0\u5355\u5143\u683c\u4e2a\u6570\uff0c\u5982\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/b7b28f87031c99c06b0c8435af2fa872951fed47.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u5982\u679c\u5bf9\u60a8\u6709\u70b9\u5e2e\u52a9\uff0c\u8bf7\u5e2e\u5fd9\u70b9\u4e2a\u8d5e\u518d\u8d70\uff0c\u8c22\u8c22\uff01"}]]