{"id":2738,"date":"2024-12-02T08:33:35","date_gmt":"2024-12-02T08:33:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/9-bi-kip-su-dung-countif-hieu-qua-trong-excel\/"},"modified":"2024-12-02T08:33:35","modified_gmt":"2024-12-02T08:33:35","slug":"9-bi-kip-su-dung-countif-hieu-qua-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/9-bi-kip-su-dung-countif-hieu-qua-trong-excel\/","title":{"rendered":"9 b\u00ed k\u00edp s\u1eed d\u1ee5ng COUNTIF hi\u1ec7u qu\u1ea3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd b\u00e0n v\u1ec1 vi\u1ec7c <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\"><strong>s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel<\/strong><\/a>. Excel \u0111\u00e3 cung c\u1ea5p cho ch\u00fang ta h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm d\u1ef1a tr\u00ean 1 ho\u1eb7c 1 v\u00e0i \u0111i\u1ec1u ki\u1ec7n. COUNTIF ho\u1ea1t \u0111\u1ed9ng t\u1ed1t tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel ph\u1ed5 bi\u1ebfn nh\u01b0 Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, v\u1eady n\u00ean b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i b\u00e0i n\u00e0y v\u00e0 th\u1ef1c h\u00e0nh trong b\u1ea5t c\u1ee9 phi\u00ean b\u1ea3n Excel n\u00e0o. Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd l\u1ea7n l\u01b0\u1ee3t \u0111i t\u00ecm hi\u1ec3u c\u00e1c n\u1ed9i dung sau \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-674d70dea5ede\" 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<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Cu_phap_va_cach_su_dung_ham_COUNTIF\" title=\"C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF:\">C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_COUNTIF_voi_chuoi_so_va_tham_chieu_trong_Excel\" title=\"S\u1eed d\u1ee5ng COUNTIF v\u1edbi chu\u1ed7i, s\u1ed1 v\u00e0 tham chi\u1ebfu trong Excel\">S\u1eed d\u1ee5ng COUNTIF v\u1edbi chu\u1ed7i, s\u1ed1 v\u00e0 tham chi\u1ebfu trong Excel<\/a><\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_COUNTIF_voi_dau_sao_trong_dieu_kien\" title=\"S\u1eed d\u1ee5ng COUNTIF v\u1edbi d\u1ea5u sao trong \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng COUNTIF v\u1edbi d\u1ea5u sao trong \u0111i\u1ec1u ki\u1ec7n<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Dem_so_cell_rong_hoac_khong_rong_voi_COUNITF\" title=\"\u0110\u1ebfm s\u1ed1 cell r\u1ed7ng ho\u1eb7c kh\u00f4ng r\u1ed7ng v\u1edbi COUNITF\">\u0110\u1ebfm s\u1ed1 cell r\u1ed7ng ho\u1eb7c kh\u00f4ng r\u1ed7ng v\u1edbi COUNITF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_COUNTIF_voi_cac_phep_toan_so_sanh\" title=\"S\u1eed d\u1ee5ng COUNTIF v\u1edbi c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh\">S\u1eed d\u1ee5ng COUNTIF v\u1edbi c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_ham_COUNITF_trong_Excel_voi_ngay_thang\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNITF trong Excel v\u1edbi ng\u00e0y th\u00e1ng\">S\u1eed d\u1ee5ng h\u00e0m COUNITF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_ham_COUNTIF_trong_Excel_voi_nhieu_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Su_dung_COUNTIF_de_phat_hien_du_lieu_trung_lap\" title=\"S\u1eed d\u1ee5ng COUNTIF \u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p\">S\u1eed d\u1ee5ng COUNTIF \u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/su-dung-countif-nang-cao-excel.html#Kiem_tra_du_lieu_co_trong_ca_2_cot\" title=\"Ki\u1ec3m tra d\u1eef li\u1ec7u c\u00f3 trong c\u1ea3 2 c\u1ed9t\">Ki\u1ec3m tra d\u1eef li\u1ec7u c\u00f3 trong c\u1ea3 2 c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_va_cach_su_dung_ham_COUNTIF\"><\/span><a id=\"doan-1\" href=\"\"><\/a>C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><strong>=COUNTIF( &lt; v\u00f9ng \u0111\u1ebfm &gt;, &lt; \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm &gt; )<\/strong><\/p>\n<\/blockquote>\n<p>Ch\u00fang ta ch\u00fa \u00fd \u0111\u1ebfn 2 tham s\u1ed1 khi <a href=\"http:\/\/blog.ezworkapp.com\/tag\/huong-dan-su-dung-ham-countif\">s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/a>:<\/p>\n<ul>\n<li>&lt; v\u00f9ng \u0111\u1ebfm &gt;: v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a nh\u1eefng \u00f4 c\u1ea7n \u0111\u1ebfm. V\u00ed d\u1ee5: A1:C20<\/li>\n<li>&lt; \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm&gt;: \u0111i\u1ec1u ki\u1ec7n d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u r\u1ed3i \u0111\u1ebfm. C\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o, m\u1eddi c\u00e1c b\u1ea1n \u0111\u1ecdc ti\u1ebfp<\/li>\n<\/ul>\n<p>V\u00e0 sau \u0111\u00e2y l\u00e0 1 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n cho h\u00e0m COUNTIF c\u1ee7a ch\u00fang ta. Trong c\u1ed9t B, \u0111\u1ebfm xem t\u00ean Roger Federer xu\u1ea5t hi\u1ec7n bao nhi\u00eau l\u1ea7n<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countif-function.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2169\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countif-function.png\" alt=\"h\u00e0m countif trong excel\" width=\"313\" height=\"366\" title=\"excel-countif-function\"><\/a><\/p>\n<p>C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y l\u00e0<\/p>\n<blockquote>\n<p><strong>=COUNTIF(C2:C15,\u201dRoger Federer\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 5 \u0111\u01a1n v\u1ecb. C\u00f3 1 ch\u00fa \u00fd cho c\u00e1c b\u1ea1n \u1edf \u0111\u00e2y l\u00e0, h\u00e0m COUNTIF c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng trong tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n, v\u1eady n\u00ean khi ta \u0111\u1ebfm <strong>\u201cRoger Federer\u201d\u00a0<\/strong>s\u1ebd cho k\u1ebft qu\u1ea3 kh\u00e1c <strong>\u201croger federer\u201d<\/strong><\/p>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-countif-countifs-trong-excel.html\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE<\/a>! khi s\u1eed d\u1ee5ng h\u00e0m COUNTIF \/ COUNTIFS trong Excel<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_voi_chuoi_so_va_tham_chieu_trong_Excel\"><\/span><a id=\"doan-2\" href=\"\"><\/a>S\u1eed d\u1ee5ng COUNTIF v\u1edbi chu\u1ed7i, s\u1ed1 v\u00e0 tham chi\u1ebfu trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thay v\u00ec g\u00f5 tr\u1ef1c ti\u1ebfp \u0111i\u1ec1u ki\u1ec7n v\u00e0o tham s\u1ed1 th\u1ee9 2 c\u1ee7a h\u00e0m COUNTIF, ch\u00fang ta c\u00f3 th\u1ec3 thay \u0111i\u1ec1u ki\u1ec7n n\u00e0y b\u1eb1ng 1 con s\u1ed1 ho\u1eb7c b\u1eb1ng tham chi\u1ebfu \u0111\u1ebfn 1 cell trong Excel. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<figure id=\"attachment_2170\" aria-describedby=\"caption-attachment-2170\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.09.13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2170\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-09-13-300x166-1.png\" alt=\"s\u1eed d\u1ee5ng countif v\u1edbi s\u1ed1\" width=\"300\" height=\"166\" title=\"screen-shot-2016-12-20-at-20-09-13-300x166-1\"><\/a><figcaption id=\"caption-attachment-2170\" class=\"wp-caption-text\">s\u1eed d\u1ee5ng countif v\u1edbi s\u1ed1<\/figcaption><\/figure>\n<figure id=\"attachment_2171\" aria-describedby=\"caption-attachment-2171\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.09.45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2171 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-09-45-300x168-1.png\" alt=\"S\u1eed d\u1ee5ng countif v\u1edbi \u0111\u1ecba ch\u1ec9 tham chi\u1ebfu\" width=\"300\" height=\"168\" title=\"screen-shot-2016-12-20-at-20-09-45-300x168-1\"><\/a><figcaption id=\"caption-attachment-2171\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng countif v\u1edbi \u0111\u1ecba ch\u1ec9 tham chi\u1ebfu<\/figcaption><\/figure>\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\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 trong Excel<\/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\/2024\/12\/ex101_92019-nho-211.gif\" title=\"ex101_92019-nho-211\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_voi_dau_sao_trong_dieu_kien\"><\/span><a id=\"doan-3\" href=\"\"><\/a>S\u1eed d\u1ee5ng COUNTIF v\u1edbi d\u1ea5u sao trong \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u0110\u00f4i khi, ch\u00fang ta s\u1ebd mu\u1ed1n \u0111\u1ebfm xem trong c\u1ed9t B, c\u00f3 bao nhi\u00eau \u00f4 ch\u1ee9a 1 chu\u1ed7i n\u00e0o \u0111\u00f3. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p>\u0110\u1ebfm xem trong c\u1ed9t B c\u00f3 bao nhi\u00eau \u00f4 ch\u1ee9a ch\u1eef \u201cBrown\u201d. \u0110i\u1ec1u n\u00e0y, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi c\u00fa ph\u00e1p:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(D2:D10, \u201c*Brown*\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<figure id=\"attachment_2172\" aria-describedby=\"caption-attachment-2172\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/countif-wildard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2172\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countif-wildard-300x250-1.png\" alt=\"s\u1eed d\u1ee5ng countif v\u1edbi d\u1ea5u sao\" width=\"300\" height=\"250\" title=\"countif-wildard-300x250-1\"><\/a><figcaption id=\"caption-attachment-2172\" class=\"wp-caption-text\">s\u1eed d\u1ee5ng countif v\u1edbi d\u1ea5u sao<\/figcaption><\/figure>\n<p>\u00dd ngh\u0129a c\u1ee7a k\u00ed t\u1ef1 d\u1ea5u * trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau: Trong ph\u1ea7n \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m COUNTIF, ch\u00fang ta vi\u1ebft d\u1ea5u * \u1edf c\u1ea3 2 \u0111\u1ea7u c\u1ee7a ch\u1eef \u201cBrown\u201d, d\u1ea5u * s\u1ebd \u0111\u1ea1i di\u1ec7n cho 0 hay nhi\u1ec1u k\u00ed t\u1ef1 kh\u00e1c. N\u1ebfu ch\u00fang ta coi \u201c*Brown*\u201d nh\u01b0 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n th\u00ec nh\u1eefng tr\u01b0\u1eddng h\u1ee3p sau \u0111\u1ec1u tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u1ebfm b\u1edfi COUNTIF:<\/p>\n<ul>\n<li>ABC Brown<\/li>\n<li>Brown ABC<\/li>\n<li>ABC Brown XYZ<\/li>\n<\/ul>\n<p>Qua \u0111\u00e2y, ch\u00fang ta suy ra \u0111\u01b0\u1ee3c, \u0111\u1ec3 vi\u1ebft \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>\u0110\u1ebfm s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef Brown, \u0111i\u1ec1u ki\u1ec7n n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau: <strong>\u201cBrown*\u201d<\/strong><\/li>\n<li>\u0110\u1ebfm s\u1ed1 \u00f4 k\u1ebft th\u00fac b\u1eb1ng ch\u1eef Brown, \u0111i\u1ec1u ki\u1ec7n n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau: <strong>\u201c*Brown\u201d<\/strong><\/li>\n<\/ul>\n<p>Ngo\u00e0i d\u1ea5u * l\u00e0 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho b\u1ea5t k\u00ec s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 n\u00e0o, ch\u00fang ta c\u00f3 d\u1ea5u ? s\u1ebd \u0111\u1ea1i di\u1ec7n cho 1 k\u00ed t\u1ef1 duy nh\u1ea5t. V\u00ed d\u1ee5 nh\u01b0 sau: \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 ch\u00ednh x\u00e1c 3 k\u00ed t\u1ef1 li\u1ec1n tr\u01b0\u1edbc \u201cABC\u201d<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.22.00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2174\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-22-00-300x170-1.png\" width=\"300\" height=\"170\" title=\"screen-shot-2016-12-20-at-20-22-00-300x170-1\"><\/a><\/p>\n<p>V\u1eady \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 d\u1ea5u <strong>? <\/strong>ho\u1eb7c<strong> *\u00a0<\/strong>\u1edf trong th\u00ec ta s\u1ebd l\u00e0m th\u1ebf n\u00e0o? C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A4:A7,\u201d*~?*\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>v\u00e0<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A4:A7,\u201d*~**\u201d)<\/strong><\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.24.42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2176\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-24-42-300x182-1.png\" width=\"300\" height=\"182\" title=\"screen-shot-2016-12-20-at-20-24-42-300x182-1\"><\/a><\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.26.28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2177\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-26-28-300x185-1.png\" width=\"300\" height=\"185\" title=\"screen-shot-2016-12-20-at-20-26-28-300x185-1\"><\/a><\/p>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Dem_so_cell_rong_hoac_khong_rong_voi_COUNITF\"><\/span><a id=\"doan-4\" href=\"\"><\/a>\u0110\u1ebfm s\u1ed1 cell r\u1ed7ng ho\u1eb7c kh\u00f4ng r\u1ed7ng v\u1edbi COUNITF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 cell kh\u00f4ng r\u1ed7ng ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/p>\n<blockquote>\n<p><strong>=COUNTIF(range,\u201d&lt;&gt;\u201d&amp;\u201d\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 cell r\u1ed7ng, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(range,\u201d\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>ho\u1eb7c<\/p>\n<blockquote>\n<p><strong>=COUNTBLANK(range)<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 minh ho\u1ea1<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.37.32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2178\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-37-32-300x104-1.png\" width=\"300\" height=\"104\" title=\"screen-shot-2016-12-20-at-20-37-32-300x104-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_voi_cac_phep_toan_so_sanh\"><\/span><strong><a id=\"doan-5\" href=\"\"><\/a>S\u1eed d\u1ee5ng COUNTIF v\u1edbi c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng COUNTIF v\u1edbi c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh: b\u1eb1ng, l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng. Ch\u00fang ta s\u1ebd vi\u1ebft c\u00e1c ph\u00e9p to\u00e1n n\u00e0y v\u00e0o tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-20-at-20.44.46.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2179 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-20-at-20-44-46-1024x433-1.png\" width=\"1024\" height=\"433\" title=\"screen-shot-2016-12-20-at-20-44-46-1024x433-1\"><\/a><\/p>\n<p>C\u1ed9t D v\u00e0 c\u1ed9t E \u0111\u1ec1u mang l\u1ea1i k\u1ebft qu\u1ea3 gi\u1ed1ng nhau, nh\u01b0ng ch\u00fang ta n\u00ean s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft \u1edf c\u1ed9t E, b\u1edfi v\u00ec \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng b\u1ecb g\u00e1n ch\u1eb7t v\u00e0o trong c\u00f4ng th\u1ee9c, khi s\u1eeda s\u1ebd r\u1ea5t d\u1ec5 d\u00e0ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNITF_trong_Excel_voi_ngay_thang\"><\/span><a id=\"doan-6\" href=\"\"><\/a>S\u1eed d\u1ee5ng h\u00e0m COUNITF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1eddng h\u1ee3p c\u00e1c b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 \u0111\u01a1n h\u00e0ng sau 1 ng\u00e0y c\u1ee5 th\u1ec3 ho\u1eb7c tr\u01b0\u1edbc 1 ng\u00e0y c\u1ee5 th\u1ec3 ho\u1eb7c t\u1eeb 1 ng\u00e0y c\u1ee5 th\u1ec3 +\/- x ng\u00e0y, th\u00ec b\u1ea3ng sau v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 v\u00e0 gi\u1ea3i th\u00edch s\u1ebd gi\u00fap c\u00e1c b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-21-at-09.21.56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-2181 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-09-21-56-1024x318-1.png\" alt=\"countif v\u1edbi ng\u00e0y th\u00e1ng\" width=\"1024\" height=\"318\" title=\"screen-shot-2016-12-21-at-09-21-56-1024x318-1\"><\/a><\/p>\n<p>Ngo\u00e0i c\u00e1ch vi\u1ebft tr\u1ef1c ti\u1ebfp gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng c\u1ea7n so s\u00e1nh v\u00e0o tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m COUNTIF, ta c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TODAY() \u0111\u1ec3 \u0111\u1ebfm:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A2:A10, TODAY())<\/strong><\/p>\n<\/blockquote>\n<p>N\u1ebfu mu\u1ed1n \u0111\u1ebfm s\u1ed1 ng\u00e0y trong 1 v\u00f9ng A1:A100 trong kho\u1ea3ng t\u1eeb 18 th\u00e1ng 1 n\u0103m 2016 \u0111\u1ebfn 23 th\u00e1ng 4 n\u0103m 2016, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A1:A100,\u201d&gt;1\/18\/2016\u2033) \u2013\u00a0COUNTIF(A1:A100,\u201d&gt;=4\/23\/2016\u2033)<\/strong><\/p>\n<\/blockquote>\n<p>minh ho\u1ea1 cho c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-21-at-09.54.03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2182\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-09-54-03-1024x275-1.png\" width=\"1024\" height=\"275\" title=\"screen-shot-2016-12-21-at-09-54-03-1024x275-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_trong_Excel_voi_nhieu_dieu_kien\"><\/span><a id=\"doan-7\" href=\"\"><\/a>S\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 1: \u0111\u1ebfm s\u1ed1 s\u1ea3n ph\u1ea9m c\u00f3 s\u1ea3n l\u01b0\u1ee3ng t\u1eeb 5 t\u1ea5n \u0111\u1ebfn 10 t\u1ea5n trong v\u00ed d\u1ee5 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-09-55-19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2183 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-09-55-19.png\" alt=\"s\u1eed d\u1ee5ng countif excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"974\" height=\"676\" title=\"screen-shot-2016-12-21-at-09-55-19\"><\/a><\/p>\n<p><em>V\u00ed d\u1ee5 2: \u0110\u1ebfm s\u1ed1 lo\u1ea1i n\u01b0\u1edbc hoa qu\u1ea3 v\u00e0 salat trong menu sau \u0111\u00e2y:<\/em><\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-21-at-09.58.52.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-2184 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-09-58-52-1024x647-1.png\" alt=\"s\u1eed d\u1ee5ng countif trong excel\" width=\"1024\" height=\"647\" title=\"screen-shot-2016-12-21-at-09-58-52-1024x647-1\"><\/a><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Ti\u0300m hi\u00ea\u0309u th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_de_phat_hien_du_lieu_trung_lap\"><\/span><a id=\"doan-8\" href=\"\"><\/a>S\u1eed d\u1ee5ng COUNTIF \u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VD: t\u00ecm trong menu sau \u0111\u00e2y nh\u1eefng m\u00f3n b\u1ecb l\u1eb7p, n\u1ebfu l\u1eb7p th\u00ec ghi ch\u1eef \u201cl\u1eb7p\u201d sang \u00f4 b\u00ean c\u1ea1nh<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-21-at-10.05.49.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2186\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-10-05-49-1024x716-1.png\" alt=\"ki\u1ec3m tra l\u1eb7p b\u1eb1ng countif\" width=\"1024\" height=\"716\" title=\"screen-shot-2016-12-21-at-10-05-49-1024x716-1\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Kiem_tra_du_lieu_co_trong_ca_2_cot\"><\/span><a id=\"doan-9\" href=\"\"><\/a>Ki\u1ec3m tra d\u1eef li\u1ec7u c\u00f3 trong c\u1ea3 2 c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5: ki\u1ec3m tra c\u00e1c m\u00f3n \u0103n c\u00f3 trong c\u1ea3 2 c\u1ed9t menu 1 v\u00e0 2<\/p>\n<blockquote>\n<p><strong>=SUMPRODUCT((COUNTIF(A2:A12,B2:B12)&gt;0)*(B2:B12&lt;&gt;\u201d\u201d))<\/strong><\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/12\/Screen-Shot-2016-12-21-at-10.11.13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2187\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-12-21-at-10-11-13-1024x419-1.png\" width=\"1024\" height=\"419\" title=\"screen-shot-2016-12-21-at-10-11-13-1024x419-1\"><\/a><\/p>\n<p>V\u1edbi v\u00ed d\u1ee5 tr\u00ean, \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 m\u00f3n c\u00f3 \u1edf c\u1ed9t B m\u00e0 <strong>KH\u00d4NG<\/strong> c\u00f3 \u1edf trong c\u1ed9t A, ta \u0111\u1ed5i c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUMPRODUCT((COUNTIF(A2:A12,B2:B12)=0)*(B2:B12&lt;&gt;\u201d\u201d))<\/strong><\/p>\n<\/blockquote>\n<p>V\u1eady l\u00e0 qua b\u00e0i n\u00e0y, c\u00e1c b\u1ea1n \u0111\u00e3 t\u00ecm hi\u1ec3u \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m COUNTIF trong Excel, hi v\u1ecdng b\u00e0i vi\u1ebft c\u00f3 \u00edch cho c\u00e1c b\u1ea1n.\u00a0N\u00ea\u0301u co\u0301 b\u00e2\u0301t ky\u0300 th\u0103\u0301c m\u0103\u0301c gi\u0300 ha\u0303y comment ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 chu\u0301ng t\u00f4i co\u0301 th\u00ea\u0309 gia\u0309i quy\u00ea\u0301t mo\u0323i th\u0103\u0301c m\u0103\u0301c cu\u0309a ca\u0301c ba\u0323n trong th\u01a1\u0300i gian s\u01a1\u0301m nh\u00e2\u0301t.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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-211.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2739,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2738","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\/2738","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=2738"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2739"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}