实例讲解Excel2013隔行求和以及公式推导

[[{"txt": "\u516c\u5f0f\u7684\u4f5c\u7528\u5728\u4e8e\u8ba1\u7b97\u3002\u53ef\u4ee5\u8bf4\uff0c\u6ca1\u6709\u516c\u5f0f\u7684Excel\u5c31\u6ca1\u6709\u4f7f\u7528\u4ef7\u503c\u3002\u7528\u516c\u5f0f\u53ef\u4ee5\u8fdb\u884c\u7b80\u5355\u7684\u8ba1\u7b97\uff0c\u5982\u52a0\u3001\u51cf\u3001\u4e58\u3001\u9664\u7b49\uff1b\u4e5f\u53ef\u4ee5\u5b8c\u6210\u5f88\u590d\u6742\u7684\u8ba1\u7b97\uff01\u4e0b\u9762\u5c31\u8be6\u7ec6\u7684\u544a\u8bc9\u5c0f\u4f19\u4f34\u4eec\uff0c\u5b9e\u4f8b\u8bb2\u89e3Excel2013\u9694\u884c\u6c42\u548c\u4ee5\u53ca\u516c\u5f0f\u63a8\u5bfc"}, {"img": ["https://exp-picture.cdn.bcebos.com/d3c39889a146b7b10ebffe08c77c34b33d41359c.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Microsoft Excel 2013"}, {"txt": "\u7535\u8111"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u9996\u5148\u628a\u9f20\u6807\u5b9a\u4f4d\u5728\u60f3\u8981\u9694\u4e00\u884c\u6c42\u548c\u7684\u5355\u5143\u683c\u4e0a\u9762\uff0c\u7136\u540e\u5728\u4e0a\u65b9\u7684\u7f16\u8f91\u680f\u4e2d\u8f93\u5165\u4e0b\u65b9\u7684\u516c\u5f0f\uff0c\u7136\u540e\u6309\u56de\u8f66\u952e\u5c31\u53ef\u4ee5\u5f97\u5230\u60f3\u8981\u7684\u6c42\u548c\u503c\u4e86\u3002=SUMPRODUCT((MOD(ROW(B1:B12),2)=1)*B1:B12)"}, {"img": ["https://exp-picture.cdn.bcebos.com/35f2224133bad341e43b6082427622bc7cc52c9c.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u540c\u6837\u7684\uff0c\u6211\u4eec\u628a\u6c34\u7684\u5b9a\u4f4d\u5728\u60f3\u8981\u9694\u4e24\u884c\u6c42\u548c\u7684\u5355\u5143\u683c\u4e0a\u9762\uff0c\u7136\u540e\u8f93\u5165\u4e0b\u65b9\u7684\u516c\u5f0f\uff0c\u6309\u56de\u8f66\u952e\u5373\u53ef\u3002=SUMPRODUCT((MOD(ROW(B1:B12),2)=0)*B1:B12)"}, {"img": ["https://exp-picture.cdn.bcebos.com/7c84d1672b5fd546ead039a17fd0b503c9d2249c.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5982\u679c\u6211\u4eec\u60f3\u8981\u9694\u4e09\u884c\u6c42\u548c\u7684\u8bdd\uff0c\u6211\u4eec\u53ef\u4ee5\u8f93\u5165\u4e0b\u65b9\u7684\u516c\u5f0f\uff0c\u7136\u540e\u6309\u56de\u8f66\u952e\u3002=SUMPRODUCT((MOD(ROW(B1:B12),3)=0)*B1:B12)"}, {"img": ["https://exp-picture.cdn.bcebos.com/47bf594ec28333bfc3a9b4fadbb8b43ea9db1d9c.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u901a\u8fc7\u4ee5\u4e0a\u4e09\u4e2a\u516c\u5f0f\uff0c\u6211\u4eec\u53d1\u73b0\u516c\u5f0f\u6709\u4e00\u5b9a\u7684\u89c4\u5f8b\uff0c\u6211\u4eec\u53ef\u4ee5\u66f4\u6539\u7d22\u683c\u7684\u884c\u6570\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u7b97\u51fa\u6765\u6211\u4eec\u60f3\u8981\u7684\u7ed3\u679c\u4e86\uff0c\u6bd4\u5982\u6211\u4eec\u628a\u5404\u4e09\u884c\u6c42\u503c\u7684\u516c\u5f0f\u6539\u4e2d\u7684\u4e09\u6539\u4e3a\u56db\uff0c\u5c31\u53ef\u4ee5\u9694\u56db\u884c\u6c42\u548c\u4e86\u3002\u80fd\u628a\u901a\u7528\u516c\u5f0f\u5217\u5728\u4e0b\u65b9\u3002=SUMPRODUCT((MOD(ROW(\u6570\u636e\u533a\u57df),N)=0)*1,\u6570\u636e\u533a\u57df)\uff1b\u5176\u4e2d\uff0cN\u4e3a\u4e00\u4e2a\u884c\u503c\uff0cN\u4e3a\u591a\u5c11\u5373\u4e3a\u9694\u591a\u5c11\u884c\u6c42\u4e00\u6b21\u548c"}, {"img": ["https://exp-picture.cdn.bcebos.com/fb738d9c2cf7dfb2de5e4f99d01b1edef5dc139c.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u6309\u7167\u4e0a\u9762\u7684\u6b65\u9aa4\u505a\u7684\u65f6\u5019\u8981\u8ba4\u771f\uff0c\u54ea\u4e2a\u6b65\u9aa4\u51fa\u9519\u7684\u65f6\u5019\uff0c\u53ef\u4ee5\u91cd\u65b0\u518d\u6765\u4e00\u6b21\uff01"}]]