{"id":5983,"date":"2024-12-21T12:08:16","date_gmt":"2024-12-21T12:08:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-countif-co-ban-dem-cac-gia-tri-voi-dieu-kien-trong-excel\/"},"modified":"2024-12-21T12:08:16","modified_gmt":"2024-12-21T12:08:16","slug":"huong-dan-su-dung-ham-countif-co-ban-dem-cac-gia-tri-voi-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-countif-co-ban-dem-cac-gia-tri-voi-dieu-kien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF c\u01a1 b\u1ea3n \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-countif\" cite=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html?ham-countif\">\n<p style=\"text-align: justify\"><em>Excel cung c\u1ea5p m\u1ed9t s\u1ed1 h\u00e0m ph\u1ee5c v\u1ee5 vi\u1ec7c \u0111\u1ebfm c\u00e1c lo\u1ea1i \u00f4 kh\u00e1c nhau nh\u01b0 \u0111\u1ebfm \u00f4 tr\u1ed1ng, \u00f4 kh\u00f4ng tr\u1ed1ng, \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c nh\u1eefng \u00f4 ch\u1ee9a k\u00ed t\u1ef1 c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> c\u00f9ng c\u00e1c b\u1ea1n s\u1ebd t\u1eadp trung v\u00e0o\u00a0 <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\"><strong>h\u00e0m\u00a0COUNTIF<\/strong><\/a>\u00a0c\u01a1 b\u1ea3n, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm \u00f4 v\u1edbi \u0111i\u1ec1u ki\u1ec7n t\u1ef1 thi\u1ebft l\u1eadp th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/em><\/p>\n<\/blockquote>\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-6766afafc0542\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html#Cau_truc_ham_COUNTIF_co_ban\" title=\"C\u1ea5u tr\u00fac h\u00e0m COUNTIF c\u01a1 b\u1ea3n\">C\u1ea5u tr\u00fac h\u00e0m COUNTIF c\u01a1 b\u1ea3n<\/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\/dem-co-dieu-kien-ham-countif-co-ban.html#Ung_dung_ham_Countif_trong_cac_chuoi_o\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m Countif trong c\u00e1c chu\u1ed7i \u00f4\">\u1ee8ng d\u1ee5ng h\u00e0m Countif trong c\u00e1c chu\u1ed7i \u00f4<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html#Ham_COUNTIF_cho_van_ban_va_so_chinh_xac_tuyet_doi\" title=\"H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)\">H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html#Ham_COUNTIF_voi_ky_tu_dai_dien_khop_mot_phan\" title=\"H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)\">H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html#Dem_cac_o_bat_dau_hoac_ket_thuc_bang_cac_ky_tu_nhat_dinh\" title=\"\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh\">\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/a><\/li>\n<\/ul>\n<\/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\/dem-co-dieu-kien-ham-countif-co-ban.html#Ung_dung_ham_COUNTIF_co_ban_voi_chu_cai_va_so_trung_khop\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF c\u01a1 b\u1ea3n v\u1edbi ch\u1eef c\u00e1i v\u00e0 s\u1ed1 tr\u00f9ng kh\u1edbp\">\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF c\u01a1 b\u1ea3n v\u1edbi ch\u1eef c\u00e1i v\u00e0 s\u1ed1 tr\u00f9ng kh\u1edbp<\/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\/dem-co-dieu-kien-ham-countif-co-ban.html#Su_dung_COUNTIF_ket_hop_nhung_ki_tu_dai_dien_wildcard\" title=\"S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n (wildcard)\">S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n (wildcard)<\/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\/dem-co-dieu-kien-ham-countif-co-ban.html#Su_dung_ham_COUNTIF_dem_voi_cac_phep_so_sanh_lon_nho_bang\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ebfm v\u1edbi c\u00e1c ph\u00e9p so s\u00e1nh l\u1edbn nh\u1ecf b\u1eb1ng\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ebfm v\u1edbi c\u00e1c ph\u00e9p so s\u00e1nh l\u1edbn nh\u1ecf b\u1eb1ng<\/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\/dem-co-dieu-kien-ham-countif-co-ban.html#Ung_dung_ham_COUNTIF_loc_gia_tri_trung_lap\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p\">\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.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<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/dem-co-dieu-kien-ham-countif-co-ban.html#Loi_ket\" title=\"L\u1eddi k\u1ebft\">L\u1eddi k\u1ebft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cau_truc_ham_COUNTIF_co_ban\"><\/span>C\u1ea5u tr\u00fac h\u00e0m COUNTIF c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m\u00a0<strong>COUNTIF<\/strong> c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<blockquote>\n<p style=\"text-align: justify\"><strong>=COUNTIF(range, criteria)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong>range<\/strong>: V\u00f9ng ch\u1ee9a c\u00e1c \u00f4 mu\u1ed1n \u0111\u1ebfm<\/p>\n<p style=\"text-align: justify\"><strong>criteria:\u00a0<\/strong>\u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n thi\u1ebft l\u1eadp d\u01b0\u1edbi d\u1ea1ng m\u1ed9t s\u1ed1, k\u00ed t\u1ef1 ho\u1eb7c m\u1ed9t logic s\u1ebd ch\u1ec9 \u0111\u1ecbnh nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_ham_Countif_trong_cac_chuoi_o\"><\/span><strong>\u1ee8ng d\u1ee5ng h\u00e0m Countif trong c\u00e1c chu\u1ed7i \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00e1c b\u1ea1n hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng Countif m\u00ecnh s\u1ebd \u0111i v\u00e0o c\u00e1c v\u00ed d\u1ee5 t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p h\u01a1n sau \u0111\u00e2y<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_cho_van_ban_va_so_chinh_xac_tuyet_doi\"><\/span><strong>H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tr\u00ean th\u1ef1c t\u1ebf, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn v\u1ec1 h\u00e0m COUNTIF \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb ch\u1eef kh\u1edbp v\u1edbi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i v\u1eeba r\u1ed3i. H\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc l\u1ea1i c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 c\u00f3 ch\u1ee9a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n: <strong>= COUNTIF (C2: C15, \u201cRoger Federer\u201d)<\/strong>. V\u00ec v\u1eady, b\u1ea1n nh\u1eadp:<\/p>\n<ul style=\"text-align: justify\">\n<li>V\u00f9ng ch\u1ecdn \u0111\u1ebfm l\u00e0 tham s\u1ed1 \u0111\u1ea7u ti\u00ean;<\/li>\n<li>D\u1ea5u ph\u1ea9y nh\u01b0 d\u1ea5u ph\u00e2n c\u00e1ch;<\/li>\n<li>M\u1ed9t t\u1eeb ho\u1eb7c m\u1ed9t s\u1ed1 t\u1eeb trong d\u1ea5u ngo\u1eb7c k\u00e9p l\u00e0m \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Thay v\u00ec nh\u1eadp l\u1ea1i t\u1eeb, b\u1ea1n c\u00f3 th\u1ec3 <strong>s\u1eed d\u1ee5ng tham chi\u1ebfu \u0111\u1ebfn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o<\/strong> ch\u1ee9a t\u1eeb ho\u1eb7c c\u00e1c t\u1eeb \u0111\u00f3 v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1, v\u00ed d\u1ee5: <strong>= COUNTIF (C1: C9, C7)<\/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-536.gif\" title=\"ex101_92019-nho-536\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">H\u00e0m COUNTIF d\u00f9ng t\u01b0\u01a1ng t\u1ef1 cho s\u1ed1. Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c <strong>= COUNTIF (D2: D9,5)<\/strong> \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb 5 \u1edf C\u1ed9t D.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5263 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-1.png\" width=\"276\" height=\"246\" title=\"excel-find-replace-highlight-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_voi_ky_tu_dai_dien_khop_mot_phan\"><\/span><strong>H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u Excel c\u1ee7a b\u1ea1n bao g\u1ed3m m\u1ed9t v\u00e0i bi\u1ebfn th\u1ec3 c\u1ee7a (c\u00e1c) t\u1eeb kho\u00e1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a m\u1ed9t t\u1eeb, c\u1ee5m t\u1eeb ho\u1eb7c ch\u1eef c\u00e1i nh\u1ea5t \u0111\u1ecbnh nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a n\u1ed9i dung \u00f4.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao cho nh\u1eefng ng\u01b0\u1eddi kh\u00e1c nhau v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao cho Danny Brown. B\u1edfi v\u00ec t\u00ean c\u1ee7a Danny \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng nhi\u1ec1u c\u00e1ch kh\u00e1c nhau, ta nh\u1eadp \u201c* Brown *\u201d l\u00e0 \u0111i\u1ec1u ki\u1ec7n <strong>= COUNTIF (D2: D10, \u201c*Brown *\u201d)<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5264 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-2-300x250-1.png\" width=\"300\" height=\"250\" title=\"excel-find-replace-highlight-2-300x250-1\"><\/p>\n<p style=\"text-align: justify\">D\u1ea5u hoa th\u1ecb <strong>(*)<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0 cu\u1ed1i, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong v\u00ed d\u1ee5 tr\u00ean. N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i kh\u1edbp t\u1eebng k\u00fd t\u1ef1 \u0111\u01a1n, h\u00e3y nh\u1eadp m\u1ed9t d\u1ea5u h\u1ecfi <strong>(?)<\/strong>, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_cac_o_bat_dau_hoac_ket_thuc_bang_cac_ky_tu_nhat_dinh\"><\/span><strong>\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, d\u1ea5u sao (*) ho\u1eb7c d\u1ea5u ch\u1ea5m h\u1ecfi (?), v\u1edbi t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng v\u0103n b\u1ea3n nh\u1ea5t \u0111\u1ecbnh b\u1ea5t k\u1ec3 c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 kh\u00e1c trong \u00f4, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (C2: C10, \u201c<\/strong><strong>Mr*\u201d)<\/strong> \u2013 t\u00ednh c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cMr\u201d.<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (C2: C10, \u201c* ed\u201d)<\/strong> \u2013 t\u00ednh c\u00e1c \u00f4 k\u1ebft th\u00fac b\u1eb1ng ch\u1eef \u201ced\u201d.<\/p>\n<p style=\"text-align: justify\">H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda cho c\u00f4ng th\u1ee9c th\u1ee9 hai:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5265 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-3.png\" width=\"335\" height=\"243\" title=\"excel-find-replace-highlight-3\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh v\u00e0 ch\u1ee9a m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi d\u1ea5u h\u1ecfi (?) t\u1ea1i \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (D2: D9, \u201c??own\u201d)<\/strong> \u2013 \u0111\u1ebfm s\u1ed1 \u00f4 k\u1ebft th\u00fac b\u1eb1ng ch\u1eef \u201cown\u201d v\u00e0 c\u00f3 ch\u00ednh x\u00e1c 5 k\u00fd t\u1ef1 trong c\u00e1c \u00f4 t\u1eeb D2 \u0111\u1ebfn D9, bao g\u1ed3m c\u1ea3 kho\u1ea3ng c\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (D2: D9, \u201cMr ??????\u201d)<\/strong> \u2013 \u0111\u1ebfm s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef \u201cMr\u201d v\u00e0 c\u00f3 ch\u00ednh x\u00e1c 8 k\u00fd t\u1ef1 trong c\u00e1c \u00f4 t\u1eeb D2 \u0111\u1ebfn D9, bao g\u1ed3m kho\u1ea3ng c\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. \u0110\u1ec3 t\u00ecm s\u1ed1 \u00f4 ch\u1ee9a d\u1ea5u h\u1ecfi \u201c?\u201d ho\u1eb7c d\u1ea5u hoa th\u1ecb \u201c*\u201d, h\u00e3y g\u00f5 d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc d\u1ea5u ? ho\u1eb7c * trong c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5, <strong>= COUNTIF (D2: D9, \u201c* ~? *\u201d)<\/strong> \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1ea5u ch\u1ea5m h\u1ecfi trong d\u1ea3i D2: D9.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ung_dung_ham_COUNTIF_co_ban_voi_chu_cai_va_so_trung_khop\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF c\u01a1 b\u1ea3n v\u1edbi ch\u1eef c\u00e1i v\u00e0 s\u1ed1 tr\u00f9ng kh\u1edbp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e3y tham kh\u1ea3o v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">[iframe width=\u201d700\u2033 height=\u201d689\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21115&amp;authkey=%21AGBxOyCOXzaOtds&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019%C4%90%E1%BA%BFm%20ch%C3%ADnh%20x%C3%A1c\u2019!A1%3AN32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p style=\"text-align: justify\">T\u1ea1i \u0111\u00e2y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n tr\u00f9ng kh\u1edbp v\u1edbi \u0111i\u1ec1u ki\u1ec7n. C\u00fa ph\u00e1p t\u01b0\u01a1ng \u1ee9ng trong v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF($C$2:$C$31,$I$8)<\/strong>\u00a0ho\u1eb7c<strong>\u00a0=COUNTIF($C$2:$C$31,\u201dNam\u201d) \u2013\u00a0<\/strong>\u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u201cNam\u201d trong v\u00f9ng C2 \u0111\u1ebfn C31<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF($D$2:$D$31,I11) <\/strong>ho\u1eb7c<strong>\u00a0=COUNTIF($D$2:$D$31,18) \u2013\u00a0<\/strong>\u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u201c18\u201d trong v\u00f9ng C2 \u0111\u1ebfn C31.<\/p>\n<p style=\"text-align: justify\"><em>L\u01b0u \u00fd: Criteria kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng. B\u1edfi v\u1eady, Nam hay NAM, nam th\u00ec c\u0169ng nh\u01b0 nhau th\u00f4i. Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, n\u00f3 r\u1ea5t ti\u1ec7n v\u00ec b\u1ea1n kh\u00f4ng ph\u1ea3i x\u1eed l\u00ed ch\u00ednh x\u00e1c d\u1eef li\u1ec7u, nh\u01b0ng trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, n\u00f3 l\u1ea1i \u1ea3nh h\u01b0\u1edfng r\u1ea5t nhi\u1ec1u t\u1edbi vi\u1ec7c t\u00ecm ki\u1ebfm. V\u1eady x\u1eed l\u00ed th\u1ebf n\u00e0o? C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch. \u1ede \u0111\u00e2y, m\u00ecnh s\u1ebd g\u1ee3i \u00fd m\u1ed9t h\u01b0\u1edbng \u0111i, \u0111\u00f3 l\u00e0 thay v\u00ec \u0111\u1ebfm\u00a0\u201cNam\u201d, \u201cNAM\u201d, \u201cnam\u201d, h\u00e3y \u0111\u1ebfm <strong>TRUE<\/strong> v\u00e0 <strong>FALSE<\/strong> k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m\u00a0<strong>EXACT<\/strong>. C\u1ee5 th\u1ec3 ra sao, c\u00e1c b\u1ea1n h\u00e3y th\u1eed suy ngh\u0129 v\u00e0 t\u1ef1 th\u1ef1c h\u00e0nh l\u1eddi gi\u1ea3i nh\u00e9.<\/em><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng h\u1ec1 kh\u00f3 nh\u1edb ph\u1ea3i kh\u00f4ng? Gi\u1edd ta\u00a0s\u1ebd\u00a0\u0111\u1ebfn v\u1edbi nh\u1eefng \u201cbi\u1ebfn th\u1ec3\u201d \u1edf nh\u1eefng v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_COUNTIF_ket_hop_nhung_ki_tu_dai_dien_wildcard\"><\/span>S\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n (wildcard)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>K\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n (Wildcard)\u00a0<\/strong>\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf c\u00e1c k\u00ed t\u1ef1 kh\u00e1c trong \u00f4. C\u00f3 3 k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n l\u00e0 d\u1ea5u sao (<strong>*<\/strong>), d\u1ea5u h\u1ecfi (?), d\u1ea5u ng\u00e3 (~).<\/p>\n<p>*<strong>Ch\u00fa \u00fd<\/strong>: Wildcard c\u00f3 th\u1ec3 thay th\u1ebf m\u1ecdi gi\u00e1 tr\u1ecb <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>. N\u1ebfu g\u1eb7p tr\u01b0\u1eddng h\u1ee3p nh\u01b0 v\u1eady, b\u1ea1n h\u00e3y chuy\u1ec3n to\u00e0n b\u1ed9 v\u1ec1 d\u1ea1ng <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 style=\"text-align: justify\">H\u00e3y c\u00f9ng xem v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\">[iframe width=\u201d700\u2033 height=\u201d689\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21115&amp;authkey=%21AGBxOyCOXzaOtds&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019%C4%90%E1%BA%BFm%20v%E1%BB%9Bi%20k%C3%AD%20t%E1%BB%B1%20%C4%91%E1%BA%A1i%20di%E1%BB%87n\u2019!A1%3AN32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p style=\"text-align: justify\">\u00a0Trong v\u00ed d\u1ee5 n\u00e0y, ta s\u1ebd \u0111\u1ebfm cho 2 tr\u01b0\u1eddng h\u1ee3p: nh\u1eefng ng\u01b0\u1eddi c\u00f3 h\u1ecd\u00a0<strong>L\u00ea;\u00a0<\/strong>nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean\u00a0<strong>Anh.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, ta s\u1eed d\u1ee5ng d\u1ea5u (*) thay th\u1ebf cho c\u1ee5m k\u00ed t\u1ef1. \u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi h\u1ecd\u00a0<strong>L\u00ea<\/strong>, ta s\u1eed d\u1ee5ng c\u00fa ph\u00e1p <strong>\u201cL\u00ea*\u201d<\/strong> t\u1ea1i v\u00f9ng \u0111i\u1ec1u ki\u1ec7n; ho\u1eb7c\u00a0<strong>$I$8 &amp; \u201c*\u201d<\/strong> n\u1ebfu tham chi\u1ebfu t\u1edbi \u00f4 <strong>I8<\/strong>. N\u1ebfu c\u00e1c b\u1ea1n c\u00f2n kh\u00fac m\u1eafc v\u1ec1 c\u00e1c k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n, xem th\u00eam b\u00e0i vi\u1ebft v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html\"><strong>K\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n Wildcard<\/strong><\/a> ngay<\/p>\n<p style=\"text-align: justify\">K\u1ebft h\u1ee3p <strong>h\u00e0m\u00a0COUNTIF <\/strong>c\u01a1 b\u1ea3n, ta c\u00f3 th\u1ec3\u00a0 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y \u0111\u1ebfn v\u1edbi v\u00ed d\u1ee5 th\u1ee9 3<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_dem_voi_cac_phep_so_sanh_lon_nho_bang\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ebfm v\u1edbi c\u00e1c ph\u00e9p so s\u00e1nh l\u1edbn nh\u1ecf b\u1eb1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">[iframe width=\u201d700\u2033 height=\u201d689\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21115&amp;authkey=%21AGBxOyCOXzaOtds&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019%C4%90%E1%BA%BFm%20v%E1%BB%9Bi%20to%C3%A1n%20t%E1%BB%AD%20l%E1%BB%9Bn%20nh%E1%BB%8F%20b%E1%BA%B1ng\u2019!A1%3AN32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi vi\u1ec7c \u0111\u1ebfm s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n l\u00e0 c\u00e1c ph\u00e9p so s\u00e1nh l\u1edbn h\u01a1n (&gt;), nh\u1ecf h\u01a1n (&lt;) ho\u1eb7c b\u1eb1ng (=), c\u00f3 hai ki\u1ec3u \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng lu\u00e2n phi\u00ean nhau \u0111\u00f3 l\u00e0\u00a0<strong>\u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp<\/strong> v\u00e0\u00a0<strong>\u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu<\/strong>.<\/p>\n<p style=\"text-align: justify\">V\u1edbi\u00a0<strong>\u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp<\/strong> ta \u0111\u1eb7t to\u00e0n b\u1ed9 trong d\u1ea5u\u00a0<strong>nh\u00e1y k\u00e9p<\/strong> nh\u01b0 sau:\u00a0<strong>\u201c&gt;=a\u201d\u00a0<\/strong>v\u1edbi\u00a0<strong>&gt;=<\/strong> l\u00e0 ph\u00e9p so s\u00e1nh,\u00a0<strong>a<\/strong> l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u01b0\u1ee3c so s\u00e1nh.<\/p>\n<p style=\"text-align: justify\">V\u1edbi\u00a0<strong>\u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu<\/strong>\u00a0ta \u0111\u1eb7t ph\u00e9p so s\u00e1nh trong d\u1ea5u nh\u00e1y k\u00e9p, k\u1ebft h\u1ee3p c\u00f9ng k\u00ed t\u1ef1 <strong>&amp;:\u00a0<\/strong><strong>\u201c&gt;=\u201d&amp; I8\u00a0<\/strong>v\u1edbi &gt;= l\u00e0 ph\u00e9p so s\u00e1nh, I8 l\u00e0 \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1edbi.<\/p>\n<p style=\"text-align: justify\">Qua 3 v\u00ed d\u1ee5 tr\u00ean, ch\u1eafc h\u1eb3n c\u00e1c b\u1ea1n \u0111\u00e3 b\u1eaft \u0111\u1ea7u hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m COUNTIF r\u1ed3i ph\u1ea3i kh\u00f4ng? Gi\u1edd h\u00e3y t\u00ecm hi\u1ec3u \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y m\u1ed9t ch\u00fat v\u1edbi v\u00ed d\u1ee5 cu\u1ed1i c\u00f9ng nh\u00e9.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ung_dung_ham_COUNTIF_loc_gia_tri_trung_lap\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">[iframe width=\u201d700\u2033 height=\u201d689\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21115&amp;authkey=%21AGBxOyCOXzaOtds&amp;em=2&amp;wdAllowInteractivity=False&amp;Item=\u2019%C4%90%E1%BA%BFm%20tr%C3%B9ng\u2019!A1%3AN32&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 tr\u00ean l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng \u0111\u01a1n gi\u1ea3n c\u1ee7a h\u00e0m COUNTIF trong c\u00e1c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 l\u1ecdc email kh\u00e1ch h\u00e0ng, l\u1ecdc t\u00ean\u2026 b\u1ecb tr\u00f9ng l\u1eb7p. C\u00f3 l\u1ebd t\u1edbi \u0111\u00e2y, c\u00e1c b\u1ea1n \u0111\u1ec1u \u0111\u00e3 nh\u1eadn ra c\u00e1ch l\u00e0m r\u1ed3i ph\u1ea3i kh\u00f4ng? H\u00e3y t\u00ednh s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb mu\u1ed1n t\u00ecm trong c\u1ed9t t\u1ed5ng v\u00e0 chuy\u1ec3n b\u00e0i to\u00e1n v\u1ec1 l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 theo s\u1ed1 t\u1ef1 nhi\u00ean.<\/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>V\u1edbi c\u00fa ph\u00e1p c\u1ee7a h\u00e0 Countif<\/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-1.png\" width=\"601\" height=\"344\" title=\"and-countif-2-1\"><\/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-1.png\" width=\"615\" height=\"537\" title=\"and-countif-4-1\"><\/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-1.png\" width=\"1021\" height=\"536\" title=\"and-countif-3-1\">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<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-ham-countif-dem-gia-tri-dung-sai.html\">\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ebfm gi\u00e1 tr\u1ecb \u0111\u00fang sai<\/a><\/strong><\/p>\n<p><strong>Video H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/43-%e2%97%8f-cach-su-dung-ham-countif-trong-excel.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif trong excel<\/a><\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span>L\u1eddi k\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1eebng qu\u00ean tr\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 nh\u1eefng v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a COUNTIF. C\u00f2n r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng \u0111ang ch\u1edd c\u00e1c b\u1ea1n kh\u00e1m ph\u00e1, b\u1edfi v\u1eady n\u00ean h\u00e3y luy\u1ec7n t\u1eadp th\u01b0\u1eddng xuy\u00ean nh\u00e9!<\/p>\n<p style=\"text-align: justify\">Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p><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-536.gif\" title=\"ex101_92019-nho-536\"><br \/>\n<\/a><\/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-536.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5984,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5983","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\/5983","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=5983"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5984"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}