{"id":9927,"date":"2025-01-05T05:37:12","date_gmt":"2025-01-05T05:37:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/05\/huong-dan-su-dung-ham-countifs-co-ban-qua-3-vi-du-don-gian\/"},"modified":"2025-01-05T05:37:12","modified_gmt":"2025-01-05T05:37:12","slug":"huong-dan-su-dung-ham-countifs-co-ban-qua-3-vi-du-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/05\/huong-dan-su-dung-ham-countifs-co-ban-qua-3-vi-du-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIFS c\u01a1 b\u1ea3n qua 3 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel, c\u00f3 r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m COUNTIFS \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u qua 3 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y:<\/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-677a1a879c1fd\" 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\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html#Cau_truc_ham_COUNTIFS\" title=\"C\u1ea5u tr\u00fac h\u00e0m COUNTIFS\">C\u1ea5u tr\u00fac h\u00e0m COUNTIFS<\/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\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html#Vi_du_ve_su_dung_ham_COUNTIFS\" title=\"V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m COUNTIFS\">V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m COUNTIFS<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html#Su_dung_ham_COUNTIFS_cho_dieu_kien_so_sanh_trung_khop_trong_vung_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIFS cho \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh tr\u00f9ng kh\u1edbp trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m COUNTIFS cho \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh tr\u00f9ng kh\u1edbp trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html#Su_dung_ham_COUNTIFS_so_sanh_voi_mot_gia_tri_ngoai_vung_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIFS so s\u00e1nh v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb ngo\u00e0i v\u00f9ng \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m COUNTIFS so s\u00e1nh v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb ngo\u00e0i v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html#_Ung_dung_su_dung_ham_COUNTIFS_lap_bang_theo_doi_di_muon\" title=\"\u00a0\u1ee8ng d\u1ee5ng s\u1eed d\u1ee5ng h\u00e0m COUNTIFS l\u1eadp b\u1ea3ng theo d\u00f5i \u0111i mu\u1ed9n\">\u00a0\u1ee8ng d\u1ee5ng s\u1eed d\u1ee5ng h\u00e0m COUNTIFS l\u1eadp b\u1ea3ng theo d\u00f5i \u0111i mu\u1ed9n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cau_truc_ham_COUNTIFS\"><\/span>C\u1ea5u tr\u00fac h\u00e0m COUNTIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m COUNTIFS \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm \u0111\u1ed1i t\u01b0\u1ee3ng th\u1ecfa m\u00e3n t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc trong c\u00e1c d\u1ea3i \u00f4. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m COUNTIFS nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],\u2026)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><b class=\"ocpRunInHead\">criteria_range1: <\/b>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n\u00a0th\u1ee9 nh\u1ea5t, ch\u1ee9a nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u1ec3 \u0111\u01b0a ra \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p><b class=\"ocpRunInHead\">criteria1:<\/b> \u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm th\u1ee9 nh\u1ea5t. Gi\u00e1 tr\u1ecb c\u1ee7a\u00a0<strong>criteria1<\/strong> ph\u1ea3i thu\u1ed9c\u00a0<strong>criteria_range1.<\/strong><\/p>\n<p><b class=\"ocpRunInHead\">criteria_range2:\u00a0<\/b>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai, t\u01b0\u01a1ng t\u1ef1\u00a0<strong>criteria_range1.<\/strong><\/p>\n<p><strong>criteria2:\u00a0<\/strong>T\u01b0\u01a1ng t\u1ef1\u00a0<strong>criteria1.<\/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-108.gif\" title=\"ex101_92019-nho-108\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2026 (t\u01b0\u01a1ng t\u1ef1 c\u00f3\u00a0<strong>criteria_range3, criteria3\u2026).<\/strong> \u0110\u1ed1i s\u1ed1 t\u1eeb\u00a0<strong>criteria_range2<\/strong> kh\u00f4ng b\u1eaft bu\u1ed9c nh\u1eadp v\u00e0o.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_su_dung_ham_COUNTIFS\"><\/span>V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m COUNTIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIFS_cho_dieu_kien_so_sanh_trung_khop_trong_vung_dieu_kien\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIFS cho \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh tr\u00f9ng kh\u1edbp trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>[iframe width=\u201d700\u2033 height=\u201d687\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21111&amp;authkey=%21AOUZ0fercw0ewfg&amp;em=2&amp;wdAllowInteractivity=False&amp;Item=\u2019VD1\u2032!A1%3AM32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p>\u1ede \u0111\u00e2y, v\u1edbi y\u00eau c\u1ea7u \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi c\u00f3 gi\u1edbi t\u00ednh\u00a0<strong>Nam<\/strong> \u1edf\u00a0<strong>H\u00e0 N\u1ed9i<\/strong>, h\u00e0m COUNTIFS s\u1ebd ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>\u0110\u1ebeM(V\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb th\u1ee9 nh\u1ea5t, \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t, v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb th\u1ee9 hai, \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai,\u2026, v\u00f9ng ch\u1ee9a gi\u00e1 tr\u1ecb th\u1ee9 n, \u0111i\u1ec1u ki\u1ec7n th\u1ee9 <\/strong><strong>n<\/strong><strong>) = s\u1ed1 gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi\u00a0<\/strong><strong>n<\/strong><strong> \u0111i\u1ec1u ki\u1ec7n.<\/strong><\/p>\n<\/blockquote>\n<p><em>L\u01b0u \u00fd: C\u00e1c v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i c\u00f3 c\u00f9ng m\u1ed9t k\u00edch c\u1ee1.<\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIFS_so_sanh_voi_mot_gia_tri_ngoai_vung_dieu_kien\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIFS so s\u00e1nh v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb ngo\u00e0i v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>[iframe width=\u201d700\u2033 height=\u201d687\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21111&amp;authkey=%21AOUZ0fercw0ewfg&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019VD2\u2032!A1%3AN32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ta s\u1ebd so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c \u1edf ngo\u00e0i, \u0111\u00f3 l\u00e0 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 3:\u00a0<strong>Ng\u00e0y sinh th\u1ecfa m\u00e3n trong kho\u1ea3ng t\u1eeb 1\/1\/1996 \u0111\u1ebfn 31\/12\/1996.\u00a0<\/strong>C\u00e1ch l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u00ed d\u1ee5 1.<\/p>\n<p>Ngo\u00e0i vi\u1ec7c g\u00f5 tr\u1ef1c ti\u1ebfp \u0111o\u1ea1n\u00a0<strong>{<\/strong><strong>$F$2:$F$31,\u201d&gt;=1\/1\/1996\u2033,$F$2:$F$31,\u201d&lt;=12\/31\/1996\u2033},\u00a0<\/strong>c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o th\u00eam 2 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u1ea7u cu\u1ed1i \u0111\u1ec3 ti\u1ec7n cho vi\u1ec7c thay \u0111\u1ed5i trong c\u00e1c d\u1eef li\u1ec7u sau n\u00e0y, sau \u0111\u00f3 tham chi\u1ebfu t\u1edbi \u00f4 v\u00e0 ti\u1ebfn h\u00e0nh \u0111\u1ebfm nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"_Ung_dung_su_dung_ham_COUNTIFS_lap_bang_theo_doi_di_muon\"><\/span>\u00a0\u1ee8ng d\u1ee5ng s\u1eed d\u1ee5ng h\u00e0m COUNTIFS l\u1eadp b\u1ea3ng theo d\u00f5i \u0111i mu\u1ed9n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>[iframe width=\u201d700\u2033 height=\u201d900\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21111&amp;authkey=%21AOUZ0fercw0ewfg&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019VD3\u2032!A1%3AAL36&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p>\u1ede v\u00ed d\u1ee5 n\u00e0y, ta s\u1ebd k\u1ebft h\u1ee3p hai h\u00e0m:<\/p>\n<p>H\u00e0m\u00a0<strong>COUNTIFS:\u00a0<\/strong>K\u1ebft h\u1ee3p v\u00ed d\u1ee5 1 v\u00e0 v\u00ed d\u1ee5 2, ta s\u1ebd \u0111\u1ebfm nh\u1eefng ng\u00e0y nh\u00e2n vi\u00ean \u0111i mu\u1ed9n qua 2 \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec1u ki\u1ec7n 1 l\u00e0 ng\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ebfm ph\u1ea3i tr\u00f9ng kh\u1edbp ng\u00e0y trong b\u1ea3ng t\u00ednh. \u0110i\u1ec1u ki\u1ec7n 2 l\u00e0 gi\u1edd \u0111\u01b0\u1ee3c \u0111\u1ebfm ph\u1ea3i l\u1edbn h\u01a1n gi\u1edd quy \u0111\u1ecbnh. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi 2 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>H\u00e0m\u00a0<strong>IF:\u00a0<\/strong>Khi x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 n\u1eb1m trong kho\u1ea3ng s\u1ed1 t\u1ef1 nhi\u00ean [0;1], ta ti\u1ebfn h\u00e0nh \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n. N\u1ebfu k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a\u00a0<strong>COUNTIFS<\/strong> l\u00e0 1 \u2013 nh\u00e2n vi\u00ean \u0111\u00f3 \u0111i mu\u1ed9n, ta \u0111\u00e1nh d\u1ea5u \u201cx\u201d. N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 0, k\u1ebft qu\u1ea3 tr\u1ed1ng.<\/p>\n<p>Cu\u1ed1i c\u00f9ng, d\u00f9ng h\u00e0m\u00a0<strong>COUNTIF<\/strong> t\u1ea1i c\u1ed9t t\u1ed5ng \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng ng\u00e0y nh\u00e2n vi\u00ean \u0111\u00f3 \u0111i mu\u1ed9n.<\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e2ng cao h\u01a1n li\u00ean quan t\u1edbi h\u00e0m\u00a0<strong>COUNTIFS<\/strong> t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/?s=countifs\">\u0111\u00e2y<\/a>.\u00a0<\/strong>V\u00e0 \u0111\u1eebng qu\u00ean, lu\u00f4n lu\u00f4n\u00a0 luy\u1ec7n t\u1eadp th\u1eadt thu\u1ea7n th\u1ee5c nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-108.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9927","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\/9927","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=9927"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9928"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}