{"id":1192,"date":"2020-04-17T17:16:00","date_gmt":"2020-04-17T09:16:00","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1192"},"modified":"2026-08-27T16:15:11","modified_gmt":"2026-08-27T08:15:11","slug":"sum_without_error_and_hiddenrow","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/sum_without_error_and_hiddenrow\/","title":{"rendered":"How to sum while avoiding error messages and hidden rows"},"content":{"rendered":"<blockquote><p>Everyone knows to use SUM to add a range. But if the range contains error values, SUM won\u2019t work \u2014 what do you use then? If you want to exclude values in hidden rows, SUM also can\u2019t do that \u2014 what then? And if the range contains both error values and hidden rows, SUM still fails \u2014 what can you use?<\/p><\/blockquote>\n\t\t\t\t\t\t<style>\r\n\t\t\t\t<style>\r\n#wpsm_accordion_1191 .wpsm_panel-heading{\r\n\tpadding:0px !important;\r\n}\r\n#wpsm_accordion_1191 .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_1191 .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_1191 .wpsm_panel-title a:focus {\r\noutline: 0px !important;\r\n}\r\n\r\n#wpsm_accordion_1191 .wpsm_panel-title a:hover, #wpsm_accordion_1191 .wpsm_panel-title a:focus {\r\n\tcolor:#000000 !important;\r\n}\r\n#wpsm_accordion_1191 .acc-a{\r\n\tcolor: #000000 !important;\r\n\tbackground-color:#e8e8e8 !important;\r\n\tborder-color: #ddd;\r\n}\r\n#wpsm_accordion_1191 .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_1191 .wpsm_panel-default {\r\n\t\tborder:1px solid transparent !important;\r\n\t}\r\n#wpsm_accordion_1191 {\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_1191 .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_1191  .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_1191  .wpsm_panel + .wpsm_panel {\r\n\t\tmargin-top: 5px;\r\n\t}\r\n#wpsm_accordion_1191  .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_1191 .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_1191\" >\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_1191 \" href=\"javascript:void(0)\" data-target=\"#ac_1191_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-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\tMethod for summing while excluding error values\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_1191_collapse1\" 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\tTo sum while excluding error values, there are two methods:\r\n<ol>\r\n \t<li>\r\n<pre>=SUMIF(B2:B6,\"<9.9E+99\")<\/pre>\r\n<ul>\r\n \t<li>9.9E+99 is an astronomically large number<\/li>\r\n \t<li>In Excel, error values are treated as larger than any number<\/li>\r\n \t<li>So in B2:B6 any value smaller than that astronomical number (i.e., all numeric values) will be summed<\/li>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1198\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=821%2C459\" alt=\"\" width=\"821\" height=\"459\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?w=821&amp;ssl=1 821w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=300%2C168&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=150%2C84&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=768%2C429&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=230%2C129&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=350%2C196&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%953.png?resize=480%2C268&amp;ssl=1 480w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>\r\n<pre>=SUMPRODUCT(IFERROR(B2:B6,0))<\/pre>\r\n<ul>\r\n \t<li>Convert any error values in B2:B6 to 0<\/li>\r\n \t<li>Then sum the original numbers and the zeros converted from error values \u2014 this effectively avoids the errors<\/li>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1199\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=1005%2C571\" alt=\"\" width=\"1005\" height=\"571\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?w=1005&amp;ssl=1 1005w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=150%2C85&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=768%2C436&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=830%2C472&amp;ssl=1 830w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=230%2C131&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=350%2C199&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%954.png?resize=480%2C273&amp;ssl=1 480w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ol>\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_1191 \" href=\"javascript:void(0)\" data-target=\"#ac_1191_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\tMethod for summing while excluding hidden rows\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_1191_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\tTo sum while excluding hidden rows, use the following method:\r\n<ul>\r\n \t<li>\r\n<pre>=SUBTOTAL(109,B2:B6)<\/pre>\r\n<ul>\r\n \t<li>In SUBTOTAL, function numbers 9 and 109 perform SUM<\/li>\r\n \t<li>109 additionally excludes manually hidden rows when summing<\/li>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1200\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=628%2C355\" alt=\"\" width=\"628\" height=\"355\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?w=628&amp;ssl=1 628w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=150%2C85&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=230%2C130&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=350%2C198&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%955.png?resize=480%2C271&amp;ssl=1 480w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/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_1191 \" href=\"javascript:void(0)\" data-target=\"#ac_1191_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\tMethod for summing while excluding both error values and hidden rows\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_1191_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\tIf the sum range contains both error values and hidden rows, use the following method:\r\n<ul>\r\n \t<li>\r\n<pre>=AGGREGATE(9,7,B2:B6)<\/pre>\r\n<ul>\r\n \t<li>In AGGREGATE, function number 9 is SUM<\/li>\r\n \t<li>The second argument 7 tells AGGREGATE to ignore hidden rows and error values when performing the function specified by the first argument<\/li>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1201\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=645%2C345\" alt=\"\" width=\"645\" height=\"345\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?w=645&amp;ssl=1 645w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=150%2C80&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=230%2C123&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=350%2C187&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/04\/%E9%81%BF%E9%96%8B%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E5%8F%8A%E9%9A%B1%E8%97%8F%E5%88%97%E7%9A%84%E5%8A%A0%E7%B8%BD%E6%96%B9%E6%B3%956.png?resize=480%2C257&amp;ssl=1 480w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/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_1191 \" href=\"javascript:void(0)\" data-target=\"#ac_1191_collapse4\" 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\tMore on summing functions\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_1191_collapse4\" 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<a href=\"http:\/\/www.fyndpro.com\/index.php\/workshops\/\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1129 aligncenter\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=1125%2C1665\" alt=\"\" width=\"1125\" height=\"1665\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?w=1125&amp;ssl=1 1125w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=203%2C300&amp;ssl=1 203w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=692%2C1024&amp;ssl=1 692w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=101%2C150&amp;ssl=1 101w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=768%2C1137&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=1038%2C1536&amp;ssl=1 1038w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=830%2C1228&amp;ssl=1 830w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=230%2C340&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=350%2C518&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/%E5%B7%A5%E4%BD%9C%E5%8D%80%E5%9F%9F-1-1.png?resize=480%2C710&amp;ssl=1 480w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a>\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>","protected":false},"excerpt":{"rendered":"<p>\u8981\u52a0\u7e3d\u4e00\u500b\u7bc4\u570d\u7684\u6578\u5b57\uff0c\u4fc2\u4eba\u90fd\u8b58\u7528SUM\u3002\u4e0d\u904e\u5982\u679c\u8981\u52a0\u7e3d\u4e00\u500b\u5167\u6709Error\u7bc4\u570d\u7684\u6578\u5b57\uff0cSUM\u5c31\u505a\u5514\u5230\u4e86\uff0c\u5481\u7528\u54a9\u5462 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3790,"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,20],"tags":[153,107,13,14,126,292],"class_list":["post-1192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-aggregate","tag-subtotal","tag-sum","tag-sumif","tag-sumproduct","tag-error-values"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_02_421_excel.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/comments?post=1192"}],"version-history":[{"count":4,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1192\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1192\/revisions\/1202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/3790"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=1192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=1192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=1192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}