{"id":4697,"date":"2024-12-08T06:21:36","date_gmt":"2024-12-08T06:21:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ham-countif-giai-dap-2-thac-mac-thuong-gap-khi-bat-dau-tim-hieu\/"},"modified":"2024-12-08T06:21:36","modified_gmt":"2024-12-08T06:21:36","slug":"ham-countif-giai-dap-2-thac-mac-thuong-gap-khi-bat-dau-tim-hieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ham-countif-giai-dap-2-thac-mac-thuong-gap-khi-bat-dau-tim-hieu\/","title":{"rendered":"H\u00e0m countif: Gi\u1ea3i \u0111\u00e1p 2 th\u1eafc m\u1eafc th\u01b0\u1eddng g\u1eb7p khi b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft v\u1ec1\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">h\u00e0m COUNTIF c\u01a1 b\u1ea3n<\/a>,<\/strong> H\u1ecdc Excel Online \u0111\u00e3 th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng th\u1eafc m\u1eafc t\u01b0\u1edfng ch\u1eebng \u0111\u01a1n gi\u1ea3n nh\u01b0ng l\u1ea1i th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 hai v\u1ea5n \u0111\u1ec1 m\u00e0 h\u1ea7u h\u1ebft nh\u1eefng ng\u01b0\u1eddi s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u00e3 t\u1eebng tr\u1ea3i qua.<\/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-67553aef39edd\" 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\/2-thac-mac-thuong-gap-ve-ham-countif.html#Su_dung_Wildcard_cho_dinh_dang_so\" title=\"S\u1eed d\u1ee5ng Wildcard cho \u0111\u1ecbnh d\u1ea1ng s\u1ed1\">S\u1eed d\u1ee5ng Wildcard cho \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/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\/2-thac-mac-thuong-gap-ve-ham-countif.html#Su_dung_COUNTIF_ket_hop_AND_hoac_OR\" title=\"S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p AND ho\u1eb7c OR\">S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p AND ho\u1eb7c OR<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Wildcard_cho_dinh_dang_so\"><\/span>S\u1eed d\u1ee5ng Wildcard cho \u0111\u1ecbnh d\u1ea1ng s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Wildcard (k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n)<\/strong> \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m ti\u00eau ch\u00ed khi t\u00ecm ki\u1ebfm v\u0103n b\u1ea3n, \u0111\u1ea1i di\u1ec7n cho m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00ed t\u1ef1 kh\u00e1c. N\u00f3 bao g\u1ed3m 3 k\u00fd t\u1ef1 l\u00e0<strong> d\u1ea5u sao (*), d\u1ea5u h\u1ecfi (?)\u00a0<\/strong>v\u00e0\u00a0<strong>d\u1ea5u ng\u00e3 (~)<\/strong>. C\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam trong vi\u1ebft v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html\">Wildcard<\/a><\/strong> c\u1ee7a ch\u00fang t\u00f4i<\/p>\n<p>Quay tr\u1edf l\u1ea1i b\u00e0i, v\u1ea5n \u0111\u1ec1 li\u00ean quan t\u1edbi\u00a0<strong>wildcard<\/strong> \u1edf \u0111\u00e2y l\u00e0 khi \u0111\u1ebfm theo \u0111\u1ea7u s\u1ed1.<\/p>\n<p>V\u00ed d\u1ee5: C\u00e1c tr\u01b0\u1eddng h\u1ecdc \u0111\u1ebfm m\u00e3 s\u1ed1 sinh vi\u00ean th\u00e1ng 3 n\u0103m 2016. S\u1ed1 c\u1ea7n \u0111\u1ebfm c\u00f3 d\u1ea1ng 163x\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23048\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/wildcard-countif-1.png\" width=\"380\" height=\"460\" title=\"wildcard-countif-1\"><\/p>\n<p>K\u1ebft qu\u1ea3 khi s\u1eed d\u1ee5ng wildcard:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23050\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/wildcard-countif-2.png\" width=\"577\" height=\"537\" title=\"wildcard-countif-2\"><\/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-381.gif\" title=\"ex101_92019-nho-381\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>L\u00ed do: Wildcard c\u00f3 th\u1ec3 thay th\u1ebf\u00a0m\u1ecdi gi\u00e1 tr\u1ecb\u00a0<strong>trong chu\u1ed7i k\u00ed t\u1ef1<\/strong>, nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 thay th\u1ebf \u0111\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng<strong> s\u1ed1 (Number)<\/strong>.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c theo nh\u1eefng c\u00e1ch sau:<\/p>\n<p><strong>C\u00e1ch 1: Chuy\u1ec3n d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng TEXT<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23052\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/wildcard-countif-3.png\" width=\"703\" height=\"538\" title=\"wildcard-countif-3\"><\/p>\n<p>T\u1ea1i \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u00e3 chuy\u1ec3n to\u00e0n b\u1ed9 ID c\u1ee7a sinh vi\u00ean v\u1ec1 d\u1ea1ng\u00a0<strong>TEXT<\/strong> b\u1eb1ng h\u00e0m TEXT, sau \u0111\u00f3 ki\u1ec3m tra l\u1ea1i b\u1eb1ng h\u00e0m ISTEXT v\u00e0 cu\u1ed1i c\u00f9ng COUNTIF k\u1ebft h\u1ee3p wildcard nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/p>\n<p><strong>C\u00e1ch 2:<\/strong>\u00a0<strong>S\u1eed d\u1ee5ng ph\u00e9p so s\u00e1nh<\/strong><\/p>\n<p>Thay v\u00ec coi d\u00e3y s\u1ed1 nh\u01b0 m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1, t\u1ea1i sao ta kh\u00f4ng \u0111\u1eb7t n\u00f3 v\u00e0o kho\u1ea3ng so s\u00e1nh nh\u1ec9?<\/p>\n<p>V\u1edbi v\u00ed d\u1ee5 tr\u00ean, nh\u1eefng ID th\u1ecfa m\u00e3n s\u1ebd n\u1eb1m trong kho\u1ea3ng 16300000 \u0111\u1ebfn 16399999. H\u00e3y c\u00f9ng xem h\u00e0m COUNTIF s\u1ebd x\u1eed l\u00ed nh\u01b0 n\u00e0o nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23056\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-countif-1.png\" width=\"641\" height=\"538\" title=\"and-countif-1\"><\/p>\n<p>\u1ede \u0111\u00e2y, \u0111\u1ec3 c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong kho\u1ea3ng gi\u1eefa, H\u1ecdc Excel Online \u0111\u00e3 k\u1ebft h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n\u00a0<strong>AND<\/strong>. V\u00e0\u2026 sai m\u1ea5t r\u1ed3i!<\/p>\n<p>V\u00ec sao, ch\u00fang ta h\u00e3y \u0111\u1ebfn v\u1edbi th\u1eafc m\u1eafc th\u1ee9 hai m\u00e0 ng\u01b0\u1eddi m\u1edbi s\u1eed d\u1ee5ng COUNTIF th\u01b0\u1eddng g\u1eb7p d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_ket_hop_AND_hoac_OR\"><\/span>S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p AND ho\u1eb7c OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ede v\u00ed d\u1ee5 tr\u00ean, ta \u0111\u00e3 th\u1ea5y \u0111\u01b0\u1ee3c vi\u1ec7c s\u1eed d\u1ee5ng AND ho\u1eb7c OR trong h\u00e0m COUNTIF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai. M\u1eb7c d\u00f9 nghe logic r\u1ea5t \u1ed5n:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(range, criteria)<\/strong><\/p>\n<\/blockquote>\n<p>R\u00f5 r\u00e0ng l\u00e0 criteria \u1edf \u0111\u00e2y l\u00e0 h\u00e0m\u00a0<strong>AND<\/strong>, v\u00e0 \u0111i\u1ec1u ki\u1ec7n ta \u0111\u00e3 li\u1ec7t k\u00ea ra \u0111\u1ea7y \u0111\u1ee7 r\u1ed3i, ph\u1ea3i kh\u00f4ng?<\/p>\n<p>Ta h\u00e3y xem qua h\u00e0m\u00a0<strong>AND\u00a0<\/strong>m\u1ed9t ch\u00fat:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23057\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-countif-2.png\" width=\"601\" height=\"344\" title=\"and-countif-2\"><\/p>\n<p>V\u1ea5n \u0111\u1ec1 \u1edf \u0111\u00e2y l\u00e0:<\/p>\n<ol>\n<li>H\u00e0m\u00a0<strong>AND<\/strong> (v\u00e0 c\u1ea3\u00a0<strong>OR)<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0\u00a0<strong>TRUE\u00a0<\/strong>ho\u1eb7c\u00a0<strong>FALSE<\/strong>.<\/li>\n<li>Logic so s\u00e1nh trong h\u00e0m\u00a0<strong>AND<\/strong>. C\u00e1i g\u00ec s\u1ebd l\u1edbn h\u01a1n, ho\u1eb7c nh\u1ecf h\u01a1n?<\/li>\n<\/ol>\n<p>Khi \u0111\u01b0a\u00a0<strong>AND\u00a0<\/strong>ho\u1eb7c\u00a0<strong>OR\u00a0<\/strong>v\u00e0o\u00a0<strong>COUNTIF<\/strong>,\u00a0\u0111\u1ed1i s\u1ed1\u00a0<strong>range<\/strong> c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c so v\u1edbi\u00a0<strong>criteria<\/strong> l\u00e0\u00a0<strong>TRUE<\/strong> ho\u1eb7c\u00a0<strong>FALSE<\/strong> (ho\u1eb7c\u00a0<strong>#VALUE!<\/strong>). R\u00f5 r\u00e0ng k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 0 r\u1ed3i.<\/p>\n<p>V\u1eady ta kh\u1eafc ph\u1ee5c th\u1ebf n\u00e0o?<\/p>\n<p><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng h\u00e0m COUNTIFS thay th\u1ebf<\/strong><\/p>\n<p>H\u00e0m COUNTIFS cho ph\u00e9p \u0111\u1ebfm v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. T\u1ea1i sao ph\u1ea3i c\u1ed1 nh\u1ed3i nh\u00e9t v\u00e0o COUNTIF trong khi c\u00f3 th\u1ec3 d\u00f9ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\">h\u00e0m COUNTIFS<\/a>.<\/strong><\/p>\n<p><strong>C\u00e1ch 2: L\u1eadp c\u1ed9t ph\u1ee5<\/strong><\/p>\n<p>H\u01b0\u1edbng l\u00e0m m\u00e0 H\u1ecdc Excel Online g\u1ee3i \u00fd nh\u01b0 sau: L\u1eadp m\u1ed9t c\u1ed9t ph\u1ee5 d\u00f9ng h\u00e0m And \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0<strong>True\u00a0<\/strong>ho\u1eb7c\u00a0<strong>False<\/strong>, sau \u0111\u00f3 s\u1eed d\u1ee5ng\u00a0<strong>COUNTIF\u00a0<\/strong>v\u1edbi c\u1ed9t ph\u1ee5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23062\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-countif-4.png\" width=\"615\" height=\"537\" title=\"and-countif-4\"><\/p>\n<p><strong>C\u00e1ch 3: S\u1eed d\u1ee5ng logic to\u00e1n h\u1ecdc<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23059\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-countif-3.png\" width=\"1021\" height=\"536\" title=\"and-countif-3\">Logic \u1edf \u0111\u00e2y l\u00e0: \u0110\u1ec3 t\u00ecm s\u1ed1 nh\u1eefng s\u1ed1 th\u1ecfa m\u00e3n trong kho\u1ea3ng A v\u00e0 B, l\u1ea5y s\u1ed1 nh\u1eefng s\u1ed1 th\u1ecfa m\u00e3n kho\u1ea3ng A tr\u1eeb \u0111i s\u1ed1 nh\u1eefng s\u1ed1 th\u1ecfa m\u00e3n kho\u1ea3ng B (kho\u1ea3ng B n\u1eb1m trong kho\u1ea3ng A).<\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\">H\u00e0m count<\/a> v\u00e0 counta \u0111\u1ebfm s\u1ed1 \u00f4 trong Excel<\/strong><\/p>\n<p>Qua b\u00e0i h\u1ecdc n\u00e0y, c\u00e1c b\u1ea1n ph\u1ea7n n\u00e0o \u0111\u00e3 gi\u1ea3i \u0111\u00e1p \u0111\u01b0\u1ee3c nh\u1eefng th\u1eafc m\u1eafc c\u1ee7a m\u00ecnh v\u1ec1 COUNTIF ph\u1ea3i kh\u00f4ng n\u00e0o? \u0110\u1eebng qu\u00ean t\u00ecm t\u00f2i, luy\u1ec7n t\u1eadp \u0111\u1ec3 ng\u00e0y c\u00e0ng thu\u1ea7n th\u1ee5c h\u01a1n nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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-381.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4698,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4697","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\/4697","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=4697"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4697\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4698"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}