{"id":12271,"date":"2025-01-15T07:50:23","date_gmt":"2025-01-15T07:50:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-countif-trong-excel-huong-dan-cu-the-va-co-vi-du-minh-hoa\/"},"modified":"2025-01-15T07:50:23","modified_gmt":"2025-01-15T07:50:23","slug":"ham-countif-trong-excel-huong-dan-cu-the-va-co-vi-du-minh-hoa","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-countif-trong-excel-huong-dan-cu-the-va-co-vi-du-minh-hoa\/","title":{"rendered":"H\u00e0m CountIf trong excel, h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3 v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong x\u00e3 h\u1ed9i hi\u1ec7n nay, vi\u1ec7c s\u1eed d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c kh\u00f4ng c\u00f2n l\u1ea1 l\u1eabm v\u1edbi m\u1ecdi ng\u01b0\u1eddi nh\u01b0ng kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel. H\u00f4m nay m\u00ecnh xin gi\u1edbi thi\u1ec7u m\u1ed9t trong c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t \u0111\u00f3 l\u00e0 h\u00e0m Countif<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m Countif<\/strong> d\u00f9ng \u0111\u1ec3 th\u1ed1ng k\u00ea theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p: Countif (Range, Criteria)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li style=\"text-align: justify\"><strong>Range<\/strong>: L\u00e0 \u0111\u1ecba ch\u1ec9 d\u00e3y \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li style=\"text-align: justify\"><strong>Criteria<\/strong>: L\u00e0 gi\u00e1 tr\u1ecb \u0111i\u1ec1u ki\u1ec7n (gi\u00e1 tr\u1ecb \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 \u1edf d\u1ea1ng bi\u1ec3u th\u1ee9c s\u1ed1, bi\u1ec3u th\u1ee9c k\u00ed t\u1ef1, bi\u1ec3u th\u1ee9c logic) \u0111\u01b0\u1ee3c \u0111\u1eb7t gi\u1eefa hai d\u1ea5u nh\u00e1y k\u00e9p, ph\u1ea3i c\u00f9ng ki\u1ec3u v\u1edbi d\u1eef li\u1ec7u c\u1ee7a Range<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><b>V\u00ed D\u1ee5:\u00a0<\/b><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ed1ng k\u00ea s\u1ed1 h\u1ecdc sinh c\u00f3 t\u1ed5ng \u0111i\u1ec3m l\u00e0 32 <img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3563 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2-5.png\" width=\"600\" height=\"239\" title=\"2-5\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Countif nh\u01b0 sau:\u00a0<strong>=COUNTIF(H6:H10;\u201d32\u2033)<\/strong>, ngh\u0129a l\u00e0 trong t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong d\u00e3y\u00a0H6 \u0111\u1ebfn\u00a0H10 c\u00f3 bao nhi\u00eau \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 32<\/p>\n<ul>\n<li style=\"text-align: justify\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3567\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/3-4.png\" width=\"600\" height=\"177\" title=\"3-4\"><\/li>\n<\/ul>\n<ul>\n<li style=\"text-align: justify\">L\u01b0u \u00fd: c\u00e1c b\u1ea1n nh\u1edb \u0111\u1ec3 gi\u00e1 tr\u1ecb \u0111i\u1ec1u ki\u1ec7n v\u00e0o trong ngo\u1eb7c k\u00e9p nh\u00e9, n\u1ebfu kh\u00f4ng s\u1ebd kh\u00f4ng cho ra k\u1ebft qu\u1ea3 \u0111\u00e2u nh\u00e9<\/li>\n<li style=\"text-align: justify\">R\u1ea5t \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng \u1ea1? M\u00ecnh mong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap \u0111\u1ee1 c\u00e1c b\u1ea1n ph\u1ea7n n\u00e0o trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi excel \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng h\u01a1n. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/li>\n<\/ul>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/pGQnJN1sXBs\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\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-376.gif\" title=\"ex101_92019-nho-376\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-376.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12272,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12271","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\/12271","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=12271"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12271\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12272"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}