{"id":10893,"date":"2025-01-15T00:30:47","date_gmt":"2025-01-15T00:30:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel\/"},"modified":"2025-01-15T00:30:47","modified_gmt":"2025-01-15T00:30:47","slug":"cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">H\u00e0m SUMPRODUCT<\/a><\/strong> l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t \u0111a n\u0103ng v\u00e0 c\u00f3 nhi\u1ec1u \u1ee9ng d\u1ee5ng trong Excel, tuy nhi\u00ean khi m\u1edbi h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, nhi\u1ec1u kh\u1ea3 n\u0103ng b\u1ea1n s\u1ebd g\u1eb7p l\u1ed7i; trong \u0111\u00f3 c\u00f3 l\u1ed7i <strong>#VALUE!<\/strong><\/p>\n<p>M\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT nh\u01b0 sau:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-678701b63885a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel.html#Vung_tham_chieu_bi_lech_kich_thuoc\" title=\"V\u00f9ng tham chi\u1ebfu b\u1ecb l\u1ec7ch k\u00edch th\u01b0\u1edbc\">V\u00f9ng tham chi\u1ebfu b\u1ecb l\u1ec7ch k\u00edch th\u01b0\u1edbc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel.html#Trong_vung_tham_chieu_co_1_hay_nhieu_o_chua_loi_VALUE\" title=\"Trong v\u00f9ng tham chi\u1ebfu c\u00f3 1 hay nhi\u1ec1u \u00f4 ch\u1ee9a l\u1ed7i #VALUE!\">Trong v\u00f9ng tham chi\u1ebfu c\u00f3 1 hay nhi\u1ec1u \u00f4 ch\u1ee9a l\u1ed7i #VALUE!<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vung_tham_chieu_bi_lech_kich_thuoc\"><\/span>V\u00f9ng tham chi\u1ebfu b\u1ecb l\u1ec7ch k\u00edch th\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-value-cua-ham-sumproduct-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11573\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-value-cua-ham-sumproduct-01.png\" alt=\"loi-value-cua-ham-sumproduct-01\" width=\"406\" height=\"431\" title=\"loi-value-cua-ham-sumproduct-01\"><\/a><\/p>\n<p>Nh\u01b0 c\u00e1c b\u1ea1n nh\u00ecn th\u1ea5y \u1edf tr\u00ean h\u00ecnh minh ho\u1ea1, v\u00f9ng tham chi\u1ebfu trong \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m SUMPRODUCT c\u00f3 k\u00edch th\u01b0\u1edbc kh\u00f4ng gi\u1ed1ng nhau, \u0111i\u1ec1u n\u00e0y s\u1ebd t\u1ea1o ra l\u1ed7i <strong>#VALUE!\u00a0<\/strong><\/p>\n<p>C\u00e1ch x\u1eed l\u00fd nh\u01b0 sau: s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ec3 v\u00f9ng tham chi\u1ebfu th\u1ed1ng nh\u1ea5t v\u1ec1 k\u00edch th\u01b0\u1edbc:<\/p>\n<p><i class=\"ocpItalic\">=SUMPRODUCT(D2:<b class=\"ocpLegacyBold\">D13<\/b>,E2:<b class=\"ocpLegacyBold\">E13<\/b>)<\/i><\/p>\n<p>Xem th\u00eam: <strong>C\u00e1ch kh\u1eafc ph\u1ee5c t\u1ea5t c\u1ea3 c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/loi-value-ref-num-na-div0-name-null-trong-excel-va-cach-sua.html\">l\u1ed7i trong Excel<\/a><\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-236.gif\" title=\"ex101_92019-nho-236\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Trong_vung_tham_chieu_co_1_hay_nhieu_o_chua_loi_VALUE\"><\/span>Trong v\u00f9ng tham chi\u1ebfu c\u00f3 1 hay nhi\u1ec1u \u00f4 ch\u1ee9a l\u1ed7i #VALUE!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong v\u00f9ng tham chi\u1ebfu c\u00f3 1 hay nhi\u1ec1u \u00f4 ch\u1ee9a l\u1ed7i #VALUE! c\u0169ng l\u00e0 l\u00fd do g\u00e2y ra l\u1ed7i #VALUE! cho h\u00e0m SUMPRODUCT khi tham chi\u1ebfu t\u1edbi nh\u1eefng v\u00f9ng n\u00e0y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/loi-value-cua-ham-sumproduct-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11576\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-value-cua-ham-sumproduct-03.png\" alt=\"loi-value-cua-ham-sumproduct-03\" width=\"342\" height=\"419\" title=\"loi-value-cua-ham-sumproduct-03\"><\/a><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:\u00a0<\/strong>ch\u1ec9nh s\u1eeda l\u1ea1i d\u1eef li\u1ec7u d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m SUMPRODUCT<\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t trong r\u1ea5t nhi\u1ec1u b\u00e0i vi\u1ebft trong chu\u1ed7i b\u00e0i vi\u1ebft v\u1ec1 x\u1eed l\u00fd l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c trong Excel. \u0110\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft t\u1ed5ng h\u1ee3p, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o link sau \u0111\u00e2y:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-236.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10894,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10893","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10893"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10893\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10894"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}