{"id":1148,"date":"2020-03-20T17:17:41","date_gmt":"2020-03-20T09:17:41","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1148"},"modified":"2020-04-07T14:16:43","modified_gmt":"2020-04-07T06:16:43","slug":"average_every_5_rows","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/average_every_5_rows\/","title":{"rendered":"\u6bcf5\u884c\u8a08\u7b97\u5e73\u5747\u503c"},"content":{"rendered":"<blockquote><p>\u5982\u679c\u6211\u5011\u8981\u8a08\u7b97\u67d0\u4e00\u7bc4\u570d\u7684\u5e73\u5747\u503c\uff0c\u6211\u5011\u6703\u7528AVERAGE\u3002\u4e0d\u904e\u5982\u679c\u8981\u6bcf5\u884c\u8a08\u7b97\u5e73\u5747\u503c\uff0c\u90a3AVERAGE\u516c\u5f0f\u5167\u7684\u7bc4\u570d\u4e0d\u5c31\u662f\u8981\u4eba\u624b\u9010\u4e00\u53bb\u8f38\u5165\uff1f\u56e0\u70ba=AVERAGE(A1:A5)\u5411\u4e0b\u62c9\u4e00\u683c\u53ea\u6703\u662f=AVERAGE(A2:A6)\uff0c\u4e0d\u6703\u662f=AVERAGE(A6:A10)\u3002\u90a3\u5982\u4f55\u624d\u53ef\u4ee5\u5728\u516c\u5f0f\u89e3\u6c7a\u9019\u500b\u82b1\u6642\u9593\u4eba\u624b\u64cd\u4f5c\u7684\u554f\u984c\u5462\uff1f<\/p><\/blockquote>\n\t\t\t\t\t\t\t<h3 style=\"margin-bottom:20px;display:block;width:100%;margin-top:10px\">\u6bcf5\u884c\u8a08\u7b97\u5e73\u5747\u503c <\/h3>\r\n\t\t\t\t\t\t<style>\r\n\t\t\t\t<style>\r\n#wpsm_accordion_1147 .wpsm_panel-heading{\r\n\tpadding:0px !important;\r\n}\r\n#wpsm_accordion_1147 .wpsm_panel-title {\r\n\tmargin:0px !important; \r\n\ttext-transform:none !important;\r\n\tline-height: 1 !important;\r\n}\r\n#wpsm_accordion_1147 .wpsm_panel-title a{\r\n\ttext-decoration:none;\r\n\toverflow:hidden;\r\n\tdisplay:block;\r\n\tpadding:0px;\r\n\tfont-size: 18px !important;\r\n\tfont-family: Open Sans !important;\r\n\tcolor:#000000 !important;\r\n\tborder-bottom:0px !important;\r\n}\r\n\r\n#wpsm_accordion_1147 .wpsm_panel-title a:focus {\r\noutline: 0px !important;\r\n}\r\n\r\n#wpsm_accordion_1147 .wpsm_panel-title a:hover, #wpsm_accordion_1147 .wpsm_panel-title a:focus {\r\n\tcolor:#000000 !important;\r\n}\r\n#wpsm_accordion_1147 .acc-a{\r\n\tcolor: #000000 !important;\r\n\tbackground-color:#e8e8e8 !important;\r\n\tborder-color: #ddd;\r\n}\r\n#wpsm_accordion_1147 .wpsm_panel-default > .wpsm_panel-heading{\r\n\tcolor: #000000 !important;\r\n\tbackground-color: #e8e8e8 !important;\r\n\tborder-color: #e8e8e8 !important;\r\n\tborder-top-left-radius: 0px;\r\n\tborder-top-right-radius: 0px;\r\n}\r\n#wpsm_accordion_1147 .wpsm_panel-default {\r\n\t\tborder:1px solid transparent !important;\r\n\t}\r\n#wpsm_accordion_1147 {\r\n\tmargin-bottom: 20px;\r\n\toverflow: hidden;\r\n\tfloat: none;\r\n\twidth: 100%;\r\n\tdisplay: block;\r\n}\r\n#wpsm_accordion_1147 .ac_title_class{\r\n\tdisplay: block;\r\n\tpadding-top: 12px;\r\n\tpadding-bottom: 12px;\r\n\tpadding-left: 15px;\r\n\tpadding-right: 15px;\r\n}\r\n#wpsm_accordion_1147  .wpsm_panel {\r\n\toverflow:hidden;\r\n\t-webkit-box-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\tbox-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\t\tborder-radius: 4px;\r\n\t}\r\n#wpsm_accordion_1147  .wpsm_panel + .wpsm_panel {\r\n\t\tmargin-top: 5px;\r\n\t}\r\n#wpsm_accordion_1147  .wpsm_panel-body{\r\n\tbackground-color:#ffffff !important;\r\n\tcolor:#000000 !important;\r\n\tborder-top-color: #e8e8e8 !important;\r\n\tfont-size:16px !important;\r\n\tfont-family: Open Sans !important;\r\n\toverflow: hidden;\r\n\t\tborder: 2px solid #e8e8e8 !important;\r\n\t}\r\n\r\n#wpsm_accordion_1147 .ac_open_cl_icon{\r\n\tbackground-color:#e8e8e8 !important;\r\n\tcolor: #000000 !important;\r\n\tfloat:right !important;\r\n\tpadding-top: 12px !important;\r\n\tpadding-bottom: 12px !important;\r\n\tline-height: 1.0 !important;\r\n\tpadding-left: 15px !important;\r\n\tpadding-right: 15px !important;\r\n\tdisplay: inline-block !important;\r\n}\r\n\r\n\t\t\t\r\n\t\t\t<\/style>\t\r\n\t\t\t<\/style>\r\n\t\t\t<div class=\"wpsm_panel-group\" id=\"wpsm_accordion_1147\" >\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1147 \" href=\"javascript:void(0)\" data-target=\"#ac_1147_collapse1\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u516c\u5f0f\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1147_collapse1\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<pre>F2\u7684\u516c\u5f0f\u662f\uff1a\r\n=AVERAGE(OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,))<\/pre>\r\n\u7136\u5f8c\u5411\u4e0b\u62c9\u4fbf\u53ef\u3002\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1147 \" href=\"javascript:void(0)\" data-target=\"#ac_1147_collapse2\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-plus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u516c\u5f0f\u89e3\u91cb\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1147_collapse2\" class=\"wpsm_panel-collapse collapse \"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<pre>=AVERAGE(OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,))<\/pre>\r\n\r\n<hr \/>\r\n\r\n<ul>\r\n \t<li>AVERAGE\u662f\u8a08\u7b97\u5e73\u5747\u503c<\/li>\r\n \t<li>\u7576\u4e2d\u7684\u5167\u5bb9\u662f\u4e00\u500b\u7bc4\u570d\u6216\u4e00\u7d44\u6578\u5b57<\/li>\r\n \t<li>\u6240\u4ee5\u53ea\u8981\u6211\u5011\u6210\u529f\u5730\u5728AVERAGE\u5167\u5305\u542b\u4e86\u7b2c1\u62795\u683c\u5167\u5bb9\uff0c\u5373C2\u81f3C6\uff0c\u5411\u4e0b\u62c9\u6642\uff0c\u53c8\u6210\u529f\u5730\u5728AVERAGE\u5167\u5305\u542b\u4e86\u7b2c2\u62795\u683c\u5167\u5bb9\uff0c\u5373C7\u81f3C11\uff0c\u5982\u6b64\u985e\u63a8\u5c31\u6703\u8a08\u5230\u7b54\u6848\u4e86<\/li>\r\n<\/ul>\r\n\r\n<hr \/>\r\n\r\n<ul>\r\n \t<li>OFFSET\u662f\u627e\u51fa\u67d0\u4e00\u683c\u6216\u67d0\u4e00\u7bc4\u570d\u7684\u5167\u5bb9<\/li>\r\n \t<li>OFFSET\u7684\u8a9e\u6cd5\u662f\uff1a\r\n<ul>\r\n \t<li>OFFSET(reference, rows, cols, [height], [width])<\/li>\r\n \t<li><b class=\"ocpRunInHead\">Reference<\/b>\u00a0\u5fc5\u8981\u3002 \u9019\u662f\u7528\u4ee5\u8a08\u7b97\u4f4d\u79fb\u7684\u8d77\u59cb\u53c3\u7167\u3002 Reference \u5fc5\u9808\u53c3\u7167\u4e00\u500b\u5132\u5b58\u683c\u6216\u76f8\u9130\u7684\u5132\u5b58\u683c\u7bc4\u570d\uff0c\u5426\u5247 OFFSET \u6703\u50b3\u56de #VALUE! \u932f\u8aa4\u503c\u3002<\/li>\r\n \t<li><b class=\"ocpRunInHead\">Rows <\/b>\u5fc5\u8981\u3002 \u9019\u662f\u8981\u5de6\u4e0a\u89d2\u5132\u5b58\u683c\u5f80\u4e0a\u6216\u5f80\u4e0b\u53c3\u7167\u7684\u5217\u6578\u3002 \u4f7f\u7528 5 \u505a\u70ba rows \u5f15\u6578\uff0c\u6307\u51fa\u53c3\u7167\u7684\u5de6\u4e0a\u89d2\u5132\u5b58\u683c\u662f reference \u4e0b\u65b9\u7684\u7b2c\u4e94\u5217\u3002 Rows \u53ef\u4ee5\u662f\u6b63\u6578 (\u8868\u793a\u5728\u8d77\u59cb\u53c3\u7167\u4e0b\u65b9) \u6216\u8ca0\u6578 (\u8868\u793a\u5728\u8d77\u59cb\u53c3\u7167\u4e0a\u65b9)\u3002<\/li>\r\n \t<li><b class=\"ocpRunInHead\">Cols <\/b>\u5fc5\u8981\u3002 \u9019\u662f\u8981\u7d50\u679c\u7684\u5de6\u4e0a\u89d2\u5132\u5b58\u683c\u5411\u5de6\u6216\u5411\u53f3\u53c3\u7167\u7684\u6b04\u6578\u3002 \u4f7f\u7528 5 \u4f5c\u70ba cols \u5f15\u6578\uff0c\u6307\u51fa\u53c3\u7167\u4f4d\u5740\u7684\u5de6\u4e0a\u89d2\u5132\u5b58\u683c\u662f reference \u53f3\u65b9\u7684\u7b2c\u4e94\u6b04\u3002 Cols \u53ef\u4ee5\u662f\u6b63\u6578 (\u8868\u793a\u5728\u8d77\u59cb\u53c3\u7167\u53f3\u65b9) \u6216\u8ca0\u6578 (\u8868\u793a\u5728\u8d77\u59cb\u53c3\u7167\u5de6\u65b9)\u3002<\/li>\r\n \t<li><b class=\"ocpRunInHead\">[\u9ad8\u5ea6]<\/b> \u9078\u64c7\u6027\u3002 \u9019\u662f\u8981\u50b3\u56de\u53c3\u7167\u7684\u5217\u6578\u9ad8\u5ea6\u3002 Height \u5fc5\u9808\u662f\u6b63\u6578\u3002<\/li>\r\n \t<li>\r\n<p class=\"\"><b class=\"ocpRunInHead\">[\u5bec\u5ea6]<\/b> \u9078\u64c7\u6027\u3002 \u9019\u662f\u8981\u50b3\u56de\u53c3\u7167\u7684\u6b04\u6578\u5bec\u5ea6\u3002 Width \u5fc5\u9808\u662f\u6b63\u6578\u3002<\/p>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>\u53ef\u7406\u89e3\u6210\uff1a\r\n<ul>\r\n \t<li><b class=\"ocpRunInHead\">Reference<\/b> \u8d77\u9ede<\/li>\r\n \t<li><b class=\"ocpRunInHead\">Rows <\/b>\u5411\u4e0b\u8d70y\u683c<\/li>\r\n \t<li><b class=\"ocpRunInHead\">Cols <\/b>\u5fc5\u8981\u3002 \u5411\u4e0b\u8d70y\u683c<\/li>\r\n \t<li><b class=\"ocpRunInHead\">[\u9ad8\u5ea6]<\/b> \u5f9e\u8d77\u9ede\u5411\u4e0b\u53ca\u5411\u53f3\u8d70y,x\u683c\u5f8c\u7684\u8d77\u9ede\u8d77\u5411\u4e0b\u8d70n\u683c\u7684\u7bc4\u570d<\/li>\r\n \t<li>\r\n<p class=\"\"><b class=\"ocpRunInHead\">[\u5bec\u5ea6]<\/b> \u5f9e\u8d77\u9ede\u5411\u4e0b\u53ca\u5411\u53f3\u8d70y,x\u683c\u5f8c\u7684\u8d77\u9ede\u8d77\u5411\u53f3\u8d70m\u683c\u7684\u7bc4\u570d<\/p>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,)\u5c31\u662f\uff1a\r\n<ul>\r\n \t<li>\u4ee5C2\u4f5c\u70ba\u8d77\u9ede<\/li>\r\n \t<li>\u5411\u4e0b\u8d70(ROW()-ROW($F$2))*5\u7684\u683c\u6578\r\n<ul>\r\n \t<li>ROW()\u662f\u6307\u516c\u5f0f\u8eab\u8655\u7684\u5217\u6578\uff0c\u7531\u65bc\u8eab\u8655\u5728F2\uff0c\u5373\u7b2c2\u5217<\/li>\r\n \t<li>ROW($F$2)\u662f\u6307F2\u8eab\u8655\u7684\u5217\u6578\uff0c\u5373\u7b2c2\u5217<\/li>\r\n \t<li>\u6240\u4ee5\u662f(2-2)*5\uff0c\u5373\u662f0<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>\u7b2c3\u500b\u53c3\u6578\u6f0f\u7a7a\uff0c\u5373\u662f0\uff0c\u7dad\u6301\u5728\u540c\u4e00\u6b04\u4e0a<\/li>\r\n \t<li>\u73fe\u5728\u65b0\u7684\u8d77\u9ede\u662fC2\u5411\u4e0b\u884c0\u683c\uff0c\u5411\u53f3\u884c0\u683c\u7684\u4f4d\u7f6e\uff0c\u4ea6\u5373\u662f\u539f\u4f86\u7684F2<\/li>\r\n \t<li>\u7b2c4\u53ca\u7b2c5\u53c3\u6578\u662f5\u53ca\u6f0f\u7a7a(0)\uff0c\u5373\u662f\u4ee5F2\u8d77\uff0c\u5f97\u51fa\u4e0b\u97624\u683c\uff08F2\u672c\u8eab\u70ba\u7b2c1\u683c\uff09\u53ca\u53f3\u97620\u683c\u7684\u7bc4\u570d\uff0c\u5373\u662fA2:A6\uff0c\u518d\u4ee5AVERAGE\u8a08\u7b97\u5e73\u5747\u6578<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>\u6211\u5011\u518d\u770bF3\u7684\u516c\u5f0f\uff1a=AVERAGE(OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,))<\/li>\r\n<\/ul>\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1152\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=1417%2C610\" alt=\"\" width=\"1417\" height=\"610\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?w=1417&amp;ssl=1 1417w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=300%2C129&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=1024%2C441&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=150%2C65&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=768%2C331&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=830%2C357&amp;ssl=1 830w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=230%2C99&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=350%2C151&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC3.png?resize=480%2C207&amp;ssl=1 480w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/>\r\n<ul>\r\n \t<li style=\"list-style-type: none;\">\r\n<ul>\r\n \t<li>OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,)<\/li>\r\n \t<li>\u4ee5C2\u70ba\u8d77\u9ede<\/li>\r\n \t<li>\u5411\u4e0b\u884c(ROW()-ROW($F$2))*5\u7684\u683c\u6578\uff0c\u5373(3-2)*5<\/li>\r\n \t<li>\u5411\u53f3\u884c0\u683c<\/li>\r\n \t<li>C7\u662f\u65b0\u8d77\u9ede<\/li>\r\n \t<li>\u5411\u4e0b\u53d64\u683c\uff08\u52a0\u4e0a\u672c\u8eabC7\u4e5f\u5305\u62ec\u5728\u5167\uff09<\/li>\r\n \t<li>C7\u81f3C11\u4fbf\u662f\u8981\u8a08\u7b97\u5e73\u5747\u6578\u7684\u7bc4\u570d\u4e86<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1147 \" href=\"javascript:void(0)\" data-target=\"#ac_1147_collapse3\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-plus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u516c\u5f0f\u91cd\u9ede\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1147_collapse3\" class=\"wpsm_panel-collapse collapse \"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<pre>=AVERAGE(OFFSET($C$2,(ROW()-ROW($F$2))*5,,5,))<\/pre>\r\n<ul>\r\n \t<li>C2\u662f\u8cc7\u6599\u958b\u9996\u7684\u7b2c\u4e00\u683c<\/li>\r\n \t<li>F2\u662f\u516c\u5f0f\u8eab\u8655\u7684\u4f4d\u7f6e<\/li>\r\n \t<li>5\u662f\u6bcf\u9694n\u884c\u7684n<\/li>\r\n<\/ul>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\r\n<script type=\"text\/javascript\">\r\n\t\r\n\t\tfunction do_resize(){\r\n\r\n\t\t\tvar width=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).width();\r\n\t\t\tvar height=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).height();\r\n\r\n\t\t\tvar toggleSize = true;\r\n\t\t\tjQuery('iframe').animate({\r\n\t\t\t    width: toggleSize ? width : 640,\r\n\t\t\t    height: toggleSize ? height : 360\r\n\t\t\t  }, 250);\r\n\r\n\t\t\t  toggleSize = !toggleSize;\r\n\t\t}\r\n\t\t\r\n<\/script>\t\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c\u6211\u5011\u8981\u8a08\u7b97\u67d0\u4e00\u7bc4\u570d\u7684\u5e73\u5747\u503c\uff0c\u6211\u5011\u6703\u7528AVERAGE\u3002\u4e0d\u904e\u5982\u679c\u8981\u6bcf5\u884c\u8a08\u7b97\u5e73\u5747\u503c\uff0c\u90a3AVERAGE\u516c\u5f0f\u5167\u7684\u7bc4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1151,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,7,1,12,20],"tags":[148,149,28],"class_list":["post-1148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-formulas","category-lookup","category-mathematical","category-onlinesupport","tag-average","tag-offset","tag-row"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E6%AF%8F5%E8%A1%8C%E8%A8%88%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BC-1.png?fit=1084%2C680&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=1148"}],"version-history":[{"count":1,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1148\/revisions"}],"predecessor-version":[{"id":1149,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1148\/revisions\/1149"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/1151"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=1148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=1148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=1148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}