{"id":9092,"date":"2025-01-01T14:34:15","date_gmt":"2025-01-01T14:34:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct\/"},"modified":"2025-01-01T14:34:15","modified_gmt":"2025-01-01T14:34:15","slug":"huong-dan-nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn nh\u1eadn bi\u1ebft t\u1ea5t c\u1ea3 \u00f4 \u0111\u1ec1u tr\u1ed1ng b\u1eb1ng h\u00e0m SUMPRODUCT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xem li\u1ec7u m\u1ed9t v\u00f9ng trong Excel c\u00f3 ch\u1ee9a to\u00e0n \u00f4 tr\u1ed1ng hay kh\u00f4ng? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ec3\u00a0nh\u1eadn bi\u1ebft t\u1ea5t c\u1ea3 \u00f4 \u0111\u1ec1u tr\u1ed1ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25674\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-biet-vung-trong-hay-khong-1.png\" width=\"739\" height=\"279\" title=\"nhan-biet-vung-trong-hay-khong-1\"><\/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-677552671e9de\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct.html#Cong_thuc_nhan_biet_tat_ca_o_deu_trong\" title=\"C\u00f4ng th\u1ee9c nh\u1eadn bi\u1ebft t\u1ea5t c\u1ea3 \u00f4 \u0111\u1ec1u tr\u1ed1ng\">C\u00f4ng th\u1ee9c nh\u1eadn bi\u1ebft t\u1ea5t c\u1ea3 \u00f4 \u0111\u1ec1u tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_nhan_biet_tat_ca_o_deu_trong\"><\/span>C\u00f4ng th\u1ee9c nh\u1eadn bi\u1ebft t\u1ea5t c\u1ea3 \u00f4 \u0111\u1ec1u tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p class=\"excel geshifilter-excel\"><strong><span class=\"sy1\">=IF(<\/span><span class=\"kw4\">SUMPRODUCT<\/span><span class=\"sy0\">(<\/span><span class=\"sy1\">\u2014<\/span><span class=\"sy0\">(v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"sy1\">&lt;&gt;<\/span><span class=\"st0\">\u201c\u201d<\/span><span class=\"sy0\">))<\/span><span class=\"sy1\">=<\/span><span class=\"nu0\">0,\u201dTr\u1ed1ng\u201d,\u201dKh\u00f4ng tr\u1ed1ng\u201d)<\/span><\/strong><\/p>\n<\/blockquote>\n<p class=\"excel geshifilter-excel\">Gi\u1ea3i th\u00edch:<br \/>\n<strong>H\u00e0m SUMPRODUCT<\/strong> s\u1ebd t\u00ednh b\u1ed9i s\u1ed1 trong m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/p>\n<p class=\"excel geshifilter-excel\">D\u1ea5u\u00a0<strong>\u2014<\/strong> s\u1ebd chuy\u1ec3n \u0111i\u1ec1u ki\u1ec7n th\u00e0nh\u00a0<strong>0\u00a0<\/strong>v\u00e0\u00a0<strong>1<\/strong>.<\/p>\n<p class=\"excel geshifilter-excel\"><strong>H\u00e0m IF\u00a0<\/strong>tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\u00a0<strong>Tr\u1ed1ng<\/strong> n\u1ebfu \u0111i\u1ec1u ki\u1ec7n th\u1ecfa m\u00e3n v\u00e0 ng\u01b0\u1ee3c l\u1ea1i l\u00e0\u00a0<strong>Kh\u00f4ng tr\u1ed1ng,<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta s\u1ebd l\u1ea5y v\u00ed d\u1ee5 tr\u00ean. Khi \u0111\u00f3, t\u1ea1i \u00f4 D2, c\u00f4ng th\u1ee9c ta nh\u1eadp v\u00e0o l\u00e0:<\/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-5.gif\" title=\"ex101_92019-nho-5\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p><strong>=IF(SUMPRODUCT(\u2013(A2:C2&lt;&gt;\u201d\u201d))=0,\u201dTr\u1ed1ng\u201d,\u201dKh\u00f4ng tr\u1ed1ng\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>B\u00f4i \u0111en t\u1eebng ph\u1ea7n v\u00e0 \u1ea5n F9, c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=IF(SUMPRODUCT(\u2013({TRUE,TRUE,TRUE}))=0,\u201dTr\u1ed1ng\u201d,\u201dKh\u00f4ng tr\u1ed1ng\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>Ti\u1ebfp theo l\u00e0 b\u00ean ngo\u00e0i:<\/p>\n<blockquote>\n<p><strong>=IF(SUMPRODUCT({1,1,1})=0,\u201dTr\u1ed1ng\u201d,\u201dKh\u00f4ng tr\u1ed1ng\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong>SUMPRODUCT:<\/strong><\/p>\n<blockquote>\n<p><strong>=IF(3=0,\u201dTr\u1ed1ng\u201d,\u201dKh\u00f4ng tr\u1ed1ng\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25676\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-biet-vung-trong-hay-khong-2.png\" width=\"739\" height=\"330\" title=\"nhan-biet-vung-trong-hay-khong-2\"><\/p>\n<p>B\u1eb1ng c\u00e1ch n\u00e0y, ta c\u00f3 th\u1ec3 ki\u1ec3m tra li\u1ec7u v\u00f9ng c\u00f3 th\u1ef1c s\u1ef1 tr\u1ed1ng kh\u00f4ng. Nh\u01b0 v\u00f9ng A5:C5 t\u01b0\u1edfng tr\u1ed1ng nh\u01b0ng th\u1ef1c ra kh\u00f4ng ph\u1ea3i (k\u00ed t\u1ef1 m\u1eaft th\u01b0\u1eddng kh\u00f4ng nh\u00ecn \u0111\u01b0\u1ee3c).<\/p>\n<p>\u00a0<\/p>\n<p>Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o? Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-if-co-ban-qua-cac-vi-du-don-gian.html\"><strong>H\u01b0\u1edbng d\u1eabn h\u00e0m IF c\u01a1 b\u1ea3n trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-sumproduct-nang-cao-trong-excel.html\">H\u00e0m SUMPRODUCT n\u00e2ng cao trong Excel<\/a><\/strong><\/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-5.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9093,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9092","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\/9092","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=9092"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9092\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9093"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}