{"id":775,"date":"2023-08-25T12:17:29","date_gmt":"2023-08-25T05:17:29","guid":{"rendered":"https:\/\/trannghiait.com\/?p=775"},"modified":"2023-08-25T12:17:29","modified_gmt":"2023-08-25T05:17:29","slug":"vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/","title":{"rendered":"V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00f9ng h\u00e0m Countif cho excel"},"content":{"rendered":"\n<p>\u0110\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng l\u1ec7nh countif trong Excel:<\/p>\n\n\n\n<p>L\u1ec7nh countif \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u00e3 cho th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. \u0110i\u1ec1u ki\u1ec7n n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb, m\u1ed9t bi\u1ec3u th\u1ee9c ho\u1eb7c m\u1ed9t h\u00e0m logic.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a l\u1ec7nh countif nh\u01b0 sau: <code><strong>=COUNTIF(range, criteria)<\/strong><\/code><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>range l\u00e0 ph\u1ea1m vi ch\u1ee9a c\u00e1c \u00f4 c\u1ea7n \u0111\u1ebfm.<\/li>\n\n\n\n<li>criteria l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb, m\u1ed9t bi\u1ec3u th\u1ee9c ho\u1eb7c m\u1ed9t h\u00e0m logic.<\/li>\n<\/ul>\n\n\n\n<p>\u0110\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng l\u1ec7nh countif trong Excel v\u1edbi nhi\u1ec1u v\u00ed d\u1ee5 kh\u00e1c nhau:<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/#Vi_du_1_Dem_so_luong_sinh_vien_co_diem_toan_lon_hon_8_trong_bang_diem\" title=\"V\u00ed d\u1ee5 1: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m to\u00e1n l\u1edbn h\u01a1n 8 trong b\u1ea3ng \u0111i\u1ec3m.\">V\u00ed d\u1ee5 1: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m to\u00e1n l\u1edbn h\u01a1n 8 trong b\u1ea3ng \u0111i\u1ec3m.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/#Vi_du_2_Dem_so_luong_san_pham_co_gia_tri_ban_ra_cao_hon_1000_do_la\" title=\"V\u00ed d\u1ee5 2: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb b\u00e1n ra cao h\u01a1n 1000 \u0111\u00f4 la.\">V\u00ed d\u1ee5 2: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb b\u00e1n ra cao h\u01a1n 1000 \u0111\u00f4 la.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/#Vi_du_3_Dem_so_luong_nhan_vien_co_ten_bat_dau_bang_chu_%E2%80%9CA%E2%80%9D\" title=\"V\u00ed d\u1ee5 3: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef &#8220;A&#8221;.\">V\u00ed d\u1ee5 3: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef &#8220;A&#8221;.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/#Vi_du_4_Dem_so_luong_san_pham_co_mau_sac_la_%E2%80%9CDo%E2%80%9D_hoac_%E2%80%9CXanh%E2%80%9D\" title=\"V\u00ed d\u1ee5 4: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 m\u00e0u s\u1eafc l\u00e0 &#8220;\u0110\u1ecf&#8221; ho\u1eb7c &#8220;Xanh&#8221;.\">V\u00ed d\u1ee5 4: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 m\u00e0u s\u1eafc l\u00e0 &#8220;\u0110\u1ecf&#8221; ho\u1eb7c &#8220;Xanh&#8221;.<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Dem_so_luong_sinh_vien_co_diem_toan_lon_hon_8_trong_bang_diem\"><\/span>V\u00ed d\u1ee5 1: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m to\u00e1n l\u1edbn h\u01a1n 8 trong b\u1ea3ng \u0111i\u1ec3m.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c <code>=COUNTIF(B2:B11, \"&gt;8\")<\/code> v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>B2:B11<\/code> l\u00e0 ph\u1ea1m vi ch\u1ee9a \u0111i\u1ec3m to\u00e1n c\u1ee7a c\u00e1c sinh vi\u00ean.<\/li>\n\n\n\n<li><code>\"&gt;8\"<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 8.<\/li>\n<\/ul>\n\n\n\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m to\u00e1n l\u1edbn h\u01a1n 8 trong b\u1ea3ng \u0111i\u1ec3m.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Dem_so_luong_san_pham_co_gia_tri_ban_ra_cao_hon_1000_do_la\"><\/span>V\u00ed d\u1ee5 2: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb b\u00e1n ra cao h\u01a1n 1000 \u0111\u00f4 la.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c <code>=COUNTIF(C2:C11, \"&gt;1000\")<\/code> v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>C2:C11<\/code> l\u00e0 ph\u1ea1m vi ch\u1ee9a gi\u00e1 tr\u1ecb b\u00e1n ra c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m.<\/li>\n\n\n\n<li><code>\"&gt;1000\"<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u00e1n ra cao h\u01a1n 1000 \u0111\u00f4 la.<\/li>\n<\/ul>\n\n\n\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb b\u00e1n ra cao h\u01a1n 1000 \u0111\u00f4 la.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Dem_so_luong_nhan_vien_co_ten_bat_dau_bang_chu_%E2%80%9CA%E2%80%9D\"><\/span>V\u00ed d\u1ee5 3: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef &#8220;A&#8221;.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c <code>=COUNTIF(A2:A11, \"A*\")<\/code> v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>A2:A11<\/code> l\u00e0 ph\u1ea1m vi ch\u1ee9a t\u00ean c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean.<\/li>\n\n\n\n<li><code>\"A*\"<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef &#8220;A&#8221;.<\/li>\n<\/ul>\n\n\n\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef &#8220;A&#8221;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_4_Dem_so_luong_san_pham_co_mau_sac_la_%E2%80%9CDo%E2%80%9D_hoac_%E2%80%9CXanh%E2%80%9D\"><\/span>V\u00ed d\u1ee5 4: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 m\u00e0u s\u1eafc l\u00e0 &#8220;\u0110\u1ecf&#8221; ho\u1eb7c &#8220;Xanh&#8221;.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c <code>=COUNTIF(D2:D11, \"\u0110\u1ecf\")+COUNTIF(D2:D11, \"Xanh\")<\/code> v\u00e0o \u00f4 \u0111\u00f3.<\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>D2:D11<\/code> l\u00e0 ph\u1ea1m vi ch\u1ee9a m\u00e0u s\u1eafc c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m.<\/li>\n\n\n\n<li><code>\"\u0110\u1ecf\"<\/code> v\u00e0 <code>\"Xanh\"<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 m\u00e0u s\u1eafc t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n\n\n\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ebfm.<\/p>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m c\u00f3 m\u00e0u s\u1eafc l\u00e0 &#8220;\u0110\u1ecf&#8221; ho\u1eb7c &#8220;Xanh&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u0110\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng l\u1ec7nh countif trong Excel: L\u1ec7nh countif \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u00e3 <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/25\/vi-du-don-gian-de-hieu-dung-ham-countif-cho-excel\/\" title=\"V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u d\u00f9ng h\u00e0m Countif cho excel\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-775","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=775"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"predecessor-version":[{"id":777,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/775\/revisions\/777"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}