{"id":5870,"date":"2024-12-21T08:23:15","date_gmt":"2024-12-21T08:23:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat\/"},"modified":"2024-12-21T08:23:15","modified_gmt":"2024-12-21T08:23:15","slug":"huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS \u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1t nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>H\u00f4m nay <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t h\u00e0m c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng r\u1ea5t cao trong Excel. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean trong nh\u1eefng b\u00e1o c\u00e1o m\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c l\u1eb7p l\u1ea1i nhi\u1ec1u l\u1ea7n theo m\u1ed9t nguy\u00ean t\u1eafc th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n trong <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF <\/strong><\/a>\u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1t nh\u1ea5t, t\u1ee9c l\u00e0 c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c sang v\u1ecb tr\u00ed kh\u00e1c m\u00e0 v\u1eabn x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u00fang\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh.<\/em><\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y ch\u00fang ta s\u1ebd \u0111i gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n sau:<\/p>\n<p><strong>\u0110\u1ec1 b\u00e0i:<\/strong> Cho b\u1ea3ng d\u1eef li\u1ec7u t\u1ea1i v\u00f9ng F2:H10, t\u00ednh c\u00e1c k\u1ebft qu\u1ea3 t\u1ea1i v\u00f9ng B4:D7 theo c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1ea1i c\u1ed9t A (M\u00e3) v\u00e0 d\u00f2ng 3 (Ng\u00e0y)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11671 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tc3b9y-bie1babfn-dk-01.png\" width=\"662\" height=\"338\" title=\"tc3b9y-bie1babfn-dk-01\"><\/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-67667af26b7e8\" 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\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat.html#Cach_viet_dieu_kien_ham_SUMIFS\" title=\"C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS\">C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat.html#Buoc_1_Phan_tich_de_bai\" title=\"B\u01b0\u1edbc 1: Ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i\">B\u01b0\u1edbc 1: Ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat.html#Buoc_2_Xay_dung_cong_thuc_SUMIFS\" title=\"B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUMIFS\">B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUMIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat.html#Buoc_3_Tuy_bien_dieu_kien_trong_ham_SUMIFS\" title=\"B\u01b0\u1edbc 3: T\u00f9y bi\u1ebfn \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIFS\">B\u01b0\u1edbc 3: T\u00f9y bi\u1ebfn \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIFS<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_ham_SUMIFS\"><\/span>C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Phan_tich_de_bai\"><\/span><strong>B\u01b0\u1edbc 1: Ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng theo 2\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 Ng\u00e0y v\u00e0 M\u00e3, do\u00a0\u0111\u00f3 ta kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF m\u00e0 ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m SUMIFS (\u1edf\u00a0\u0111\u00e2y ch\u00fang ta b\u1ecf qua c\u00e1c h\u00e0m kh\u00e1c m\u00e0 ch\u1ec9 x\u00e9t t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m SUMIF\/SUMIFS)<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh kh\u00f4ng ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh m\u00e0 t\u00f9y bi\u1ebfn, vi\u1ebft 1 h\u00e0m SUMIFS t\u1ea1i B4 r\u1ed3i copy h\u00e0m\u00a0\u0111\u00f3 sang c\u00e1c\u00a0\u00f4 kh\u00e1c\u00a0\u0111\u1ec3 t\u00ednh<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n M\u00e3 v\u00e0 Ng\u00e0y c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i trong c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Xay_dung_cong_thuc_SUMIFS\"><\/span><strong>B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUMIFS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac h\u00e0m <strong>SUMIFS(sum_range, Criteria_range1, Criteria1, \u2026)<\/strong><\/p>\n<ul>\n<li><strong>Sum_range<\/strong>: l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria_range1<\/strong>: l\u00e0 c\u1ed9t M\u00e3 trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria1<\/strong>: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 M\u00e3 (\u0111\u1ec3 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi Criteria_range1), v\u1edbi\u00a0\u00f4 B4 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i\u00a0\u00f4 A4<\/li>\n<li><strong>Criteria_range2<\/strong>: l\u00e0 c\u1ed9t Ng\u00e0y trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria2<\/strong>: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 Ng\u00e0y (t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi Criteria_range2), v\u1edbi\u00a0\u00f4 B4 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i\u00a0\u00f4 B3<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 B4 c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">B4=SUMIFS(H3:H10,F3:F10,A4,G3:G10,B3)<\/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\/2024\/12\/ex101_92019-nho-519.gif\" title=\"ex101_92019-nho-519\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/22-%E2%97%8F-cach-co-dinh-dong-co-dinh-cot-trong-excel.html\">C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Tuy_bien_dieu_kien_trong_ham_SUMIFS\"><\/span><strong>B\u01b0\u1edbc 3: T\u00f9y bi\u1ebfn \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIFS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi vi\u1ec7c copy sang b\u00ean ph\u1ea3i (FillRight t\u1eeb B4 t\u1edbi D4): v\u1edbi thao t\u00e1c n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i c\u1ed9t A, n\u00ean\u00a0\u00f4 A4 s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t l\u00e0 $A4<\/p>\n<p>V\u1edbi vi\u1ec7c copy xu\u1ed1ng d\u01b0\u1edbi (FillDown\u00a0t\u1eeb B4 t\u1edbi B7): v\u1edbi thao t\u00e1c n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i d\u00f2ng 3, n\u00ean\u00a0\u00f4\u00a0B3 s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t l\u00e0 B$3<\/p>\n<p>V\u00f9ng d\u1eef li\u1ec7u F3:H10 c\u0169ng c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 khi copy c\u00f4ng th\u1ee9c th\u00ec v\u00f9ng n\u00e0y kh\u00f4ng thay\u00a0\u0111\u1ed5i<\/p>\n<p>Do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i B4 s\u1ebd\u00a0\u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng l\u1ea1i th\u00e0nh:<\/p>\n<blockquote>\n<p>B4=SUMIFS($H$3:$H$10,$F$3:$F$10,$A4,$G$3:$G$10,B$3)<\/p>\n<\/blockquote>\n<p>Khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c\u00a0\u00f4 c\u00f2n l\u1ea1i ta s\u1ebd\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3\u00a0\u0111\u00fang nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11673 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tc3b9y-bie1babfn-dk-02-1.png\" width=\"660\" height=\"410\" title=\"tc3b9y-bie1babfn-dk-02-1\"><\/p>\n<p><strong>*\u00a0\u00c1p d\u1ee5ng:<\/strong><\/p>\n<p style=\"padding-left: 30px\">C\u00e1ch n\u00e0y th\u01b0\u1eddng d\u00f9ng trong c\u00e1c y\u00eau c\u1ea7u v\u1ec1 l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft, b\u00e1o c\u00e1o theo nhi\u1ec1u\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f9ng l\u00fac.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo t\u1eebng th\u00e1ng v\u1edbi h\u00e0m SUMIFS<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-sumifs-tinh-tong-hop-nhap-xuat-ton-bao-cao-kho.html\">C\u00f4ng th\u1ee9c SUMIFS t\u00ednh t\u1ed5ng h\u1ee3p Nh\u1eadp \u2013 Xu\u1ea5t \u2013 T\u1ed3n b\u00e1o c\u00e1o kho<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2KhnDTY\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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\/2024\/12\/ex101_92019-nho-519.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5871,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5870","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=5870"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5870\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5871"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}