{"id":1411,"date":"2024-12-02T05:03:57","date_gmt":"2024-12-02T05:03:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien\/"},"modified":"2024-12-02T05:03:57","modified_gmt":"2024-12-02T05:03:57","slug":"cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m COUNTIF v\u00e0 COUNTIFS v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong><em>H\u1ecdc Excel Online<\/em><\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>H\u00e0m COUNTIFS <\/em><\/strong>v\u00e0 s\u1eed d\u1ee5ng <strong><em>H\u00e0m COUNTIF trong Excel <\/em><\/strong>d\u1ef1a tr\u00ean thu\u1eadt logic <strong><em>AND <\/em><\/strong>v\u00e0 <strong><em>OR<\/em><\/strong>. B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y r\u1ea5t nhi\u1ec1u v\u00ed d\u1ee5 v\u1edbi c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau \u2013 s\u1ed1, ng\u00e0y th\u00e1ng, text v\u00e0 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-o-trong-excel-dung-ham-count-va-counta.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m Count trong Excel<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-o-trong-excel-dung-ham-count-va-counta.html\" target=\"_blank\" rel=\"noopener noreferrer\">H\u00e0m CountA trong Excel<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-danh-thu-tu-tu-dong-trong-excel-voi-ham-countif.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u00e1nh s\u1ed1 t\u1ef1 \u0111\u1ed9ng b\u1eb1ng h\u00e0m CountA<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">T\u1ef1 h\u1ecdc th\u00e0nh th\u1ea1o Excel\u00a0<\/a><\/li>\n<\/ul>\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-674d3fbbefe57\" 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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Ham_COUNTIFS_%E2%80%93_cong_thuc_va_cach_su_dung\" title=\"H\u00e0m COUNTIFS \u2013 c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">H\u00e0m COUNTIFS \u2013 c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#COUNTIFS_%E2%80%93_Nhung_dieu_can_luu_y\" title=\"COUNTIFS \u2013 Nh\u1eefng \u0111i\u1ec1u\u00a0c\u1ea7n l\u01b0u \u00fd:\">COUNTIFS \u2013 Nh\u1eefng \u0111i\u1ec1u\u00a0c\u1ea7n l\u01b0u \u00fd:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Cach_su_dung_ham_COUNTIFS_va_COUNTIF_trong_excel_voi_nhieu_tieu_chi\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIFS v\u00e0 COUNTIF trong excel v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIFS v\u00e0 COUNTIF trong excel v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Cach_dem_o_tinh_voi_nhieu_tieu_chi_AND_logic\" title=\"C\u00e1ch \u0111\u1ebfm \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (AND logic):\">C\u00e1ch \u0111\u1ebfm \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (AND logic):<\/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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Cach_dem_so_o_tinh_voi_nhieu_tieu_chi_OR_logic\" title=\"C\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (OR logic):\">C\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (OR logic):<\/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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Cach_dem_so_trong_khoang_cu_the\" title=\"C\u00e1ch \u0111\u1ebfm s\u1ed1 trong kho\u1ea3ng c\u1ee5 th\u1ec3:\">C\u00e1ch \u0111\u1ebfm s\u1ed1 trong kho\u1ea3ng c\u1ee5 th\u1ec3:<\/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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#Cach_su_dung_COUNTIFS_voi_cac_ky_tu_dai_dien\" title=\"C\u00e1ch s\u1eed d\u1ee5ng COUNTIFS v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n:\">C\u00e1ch s\u1eed d\u1ee5ng COUNTIFS v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\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\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html#COUNTIFS_va_COUNTIF_voi_nhieu_tieu_chi_ngay_thang\" title=\"COUNTIFS v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed ng\u00e0y th\u00e1ng:\">COUNTIFS v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed ng\u00e0y th\u00e1ng:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIFS_%E2%80%93_cong_thuc_va_cach_su_dung\"><\/span><strong>H\u00e0m COUNTIFS \u2013 c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c h\u00e0m <strong><em>COUNTIFS <\/em><\/strong>nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]\u2026)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>criteria_range1 <\/strong>\u2013 x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi \u0111\u1ea7u ti\u00ean \u00e1p d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean (criteria1), b\u1eaft bu\u1ed9c.<\/p>\n<p style=\"text-align: justify\"><strong>criteria1 <\/strong>\u2013 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n cho d\u1ea1ng <b><i>s\u1ed1<\/i><\/b>,<strong><em>\u00a0\u00f4 tham chi\u1ebfu<\/em><\/strong><em>,<strong>\u00a0chu\u1ed7i v\u0103n b\u1ea3n<\/strong>, <strong>m\u1ed9t m\u1ea3ng ho\u1eb7c m\u1ed9t h\u00e0m Excel kh\u00e1c<\/strong><\/em>, b\u1eaft bu\u1ed9c. Ti\u00eau ch\u00ed n\u00e0y x\u00e1c \u0111\u1ecbnh nh\u1eefng \u00f4 t\u00ednh n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm v\u00e0 c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n l\u00e0 10, \u201c&lt;=32\u201d, A6, \u201csweets\u201d.<\/p>\n<p style=\"text-align: justify\"><strong>[criteria_range2, criteria2]\u2026 <\/strong>\u2013 \u0111\u00e2y l\u00e0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung, t\u00f9y ch\u1ecdn.\u00a0 B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp t\u1edbi 127 c\u1eb7p \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-40.gif\" title=\"vba101_92019-nho-40\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-103.gif\" title=\"ex101_92019-nho-103\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Trong th\u1ef1c t\u1ebf, b\u1ea1n kh\u00f4ng ph\u1ea3i thu\u1ed9c l\u00f2ng c\u00fa ph\u00e1p c\u1ee7a h\u00e0m <strong><em>COUNTIFS<\/em><\/strong>. Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m ngay khi b\u1ea1n b\u1eaft \u0111\u1ea7u g\u00f5. \u0110\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o hi\u1ec7n t\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 \u0111\u1eadm.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countifs-function.png\" alt=\"The syntax of the Excel COUNTIFS function\" title=\"excel-countifs-function\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"COUNTIFS_%E2%80%93_Nhung_dieu_can_luu_y\"><\/span><strong>COUNTIFS \u2013 Nh\u1eefng \u0111i\u1ec1u\u00a0c\u1ea7n l\u01b0u \u00fd:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol style=\"text-align: justify\">\n<li>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <strong><em>COUNTIFS<\/em><\/strong> \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u01a1n l\u1ebb v\u1edbi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t c\u0169ng nh\u01b0 trong nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Trong tr\u01b0\u1eddng h\u1ee3p th\u1ee9 hai, ch\u1ec9 nh\u1eefng \u00f4 t\u00ednh <strong>\u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n<\/strong> m\u1edbi \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/li>\n<li>M\u1ed7i v\u00f9ng d\u1eef li\u1ec7u b\u1ed5 sung ph\u1ea3i c\u00f3 <strong>c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t<\/strong> nh\u01b0 v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean (\u0111\u1ed1i s\u1ed1 <strong><em>criteria_range1<\/em><\/strong>).<\/li>\n<li>C\u00f3 th\u1ec3 \u0111\u1ebfm nh\u1eefng v\u00f9ng d\u1eef li\u1ec7u <strong>li\u1ec1n k\u1ec1 <\/strong><em>v\u00e0<\/em><strong> kh\u00f4ng li\u1ec1n k\u1ec1<\/strong>.<\/li>\n<li>N\u1ebfu ti\u00eau ch\u00ed l\u00e0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t<strong> \u00f4 tr\u1ed1ng<\/strong>, h\u00e0m <strong><em>COUNTIFS<\/em><\/strong> x\u1eed l\u00fd n\u00f3 nh\u01b0 m\u1ed9t gi\u00e1 tr\u1ecb b\u1eb1ng kh\u00f4ng (0).<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c <strong><em>wildcard characters <\/em><\/strong>trong c\u00e1c ti\u00eau ch\u00ed \u2013 d\u1ea5u hoa th\u1ecb (*) v\u00e0 d\u1ea5u ch\u1ea5m h\u1ecfi (?).<\/li>\n<\/ol>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_COUNTIFS_va_COUNTIF_trong_excel_voi_nhieu_tieu_chi\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIFS v\u00e0 COUNTIF trong excel v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_o_tinh_voi_nhieu_tieu_chi_AND_logic\"><\/span><strong>C\u00e1ch \u0111\u1ebfm \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (AND logic):<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 1. C\u00f4ng th\u1ee9c COUNTIFS v\u1edbi c\u00e1c ti\u00eau ch\u00ed kh\u00e1c nhau<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch s\u1ea3n ph\u1ea9m nh\u01b0 trong h\u00ecnh b\u00ean d\u01b0\u1edbi. B\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 h\u00e0ng t\u1ed3n kho (gi\u00e1 tr\u1ecb c\u1ed9t B l\u1edbn h\u01a1n 0) nh\u01b0ng ch\u01b0a b\u00e1n \u0111\u01b0\u1ee3c (gi\u00e1 tr\u1ecb c\u1ed9t C b\u1eb1ng 0).<\/p>\n<p style=\"text-align: justify\">Nhi\u1ec7m v\u1ee5 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>= COUNTIFS (B2: B7, \u201c&gt; 0\u201d, C2: C7, \u201c= 0\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0 2 (<em>\u201cCherries\u201d<\/em> v\u00e0 <em>\u201cLemons\u201d<\/em>):<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-multiple-criteria.png\" alt=\"Counting cells with multiple criteria based on AND logic\" title=\"countifs-multiple-criteria\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 2. C\u00f4ng th\u1ee9c COUNTIFS v\u1edbi c\u00e1c ti\u00eau ch\u00ed gi\u1ed1ng nhau<\/strong><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c m\u1ee5c c\u00f3 c\u00e1c ti\u00eau ch\u00ed gi\u1ed1ng nhau, b\u1ea1n v\u1eabn ph\u1ea3i cung c\u1ea5p m\u1ed7i c\u1eb7p <em>criteria_range \/ criteria<\/em> m\u1ed9t c\u00e1ch ri\u00eang l\u1ebb.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c \u0111\u00fang \u0111\u1ec3 \u0111\u1ebfm c\u00e1c m\u1ee5c ch\u1ee9a 0 c\u1ea3 trong c\u1ed9t B v\u00e0 c\u1ed9t C:<\/p>\n<p style=\"text-align: justify\"><strong><em>= COUNTIFS ($B$2: $B$7, \u201c= 0\u201d, $C$2: $C$7, \u201c= 0\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c COUNTIFS n\u00e0y tr\u1ea3 v\u1ec1 1 v\u00ec ch\u1ec9 c\u00f3 \u201c<em>Grapes<\/em>\u201d c\u00f3 gi\u00e1 tr\u1ecb \u201c0\u201d trong c\u1ea3 hai c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-multiple-criteria2.png\" alt=\"COUNTIFS formula with identical criteria\" title=\"countifs-multiple-criteria2\"><\/p>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n h\u01a1n v\u1edbi m\u1ed9t <strong><em>criteria_range <\/em><\/strong>duy nh\u1ea5t nh\u01b0 COUNTIFS(B2: C7, \u201c= 0\u201d) s\u1ebd mang l\u1ea1i k\u1ebft qu\u1ea3 kh\u00e1c \u2013 t\u1ed5ng s\u1ed1 c\u00e1c \u00f4 t\u00ednh trong kho\u1ea3ng B2:C7 ch\u1ee9a 0 (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 4).<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: T\u1ed5ng h\u1ee3p ki\u1ebfn th\u1ee9c v\u1ec1 <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_so_o_tinh_voi_nhieu_tieu_chi_OR_logic\"><\/span><strong>C\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed (OR logic):<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y trong v\u00ed d\u1ee5 tr\u00ean, vi\u1ec7c \u0111\u1ebfm c\u00e1c \u00f4 t\u00ednh \u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed ch\u1ec9 \u0111\u1ecbnh r\u1ea5t d\u1ec5 d\u00e0ng b\u1edfi v\u00ec h\u00e0m COUNTIFS \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ho\u1ea1t \u0111\u1ed9ng theo c\u00e1ch n\u00e0y.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 <strong>\u00edt nh\u1ea5t m\u1ed9t trong c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 TRUE<\/strong>, ngh\u0129a l\u00e0 d\u1ef1a tr\u00ean logic OR th\u00ec sao? Nh\u00ecn chung, c\u00f3 hai c\u00e1ch \u0111\u1ec3 th\u1ef1c \u0111i\u1ec1u n\u00e0y \u2013 b\u1eb1ng c\u00e1ch th\u00eam m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c <strong>COUNTIF <\/strong>ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong>SUM COUNTIFS <\/strong>v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 1. Th\u00eam hai ho\u1eb7c nhi\u1ec1u c\u00f4ng th\u1ee9c COUNTIF ho\u1eb7c COUNITFS<\/strong><\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u00ednh c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng v\u1edbi tr\u1ea1ng th\u00e1i \u201c<em>Cancelled<\/em>\u201d v\u00e0 \u201c<em>Pending<\/em>\u201c, b\u1ea1n b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 vi\u1ebft 2 c\u00f4ng th\u1ee9c <strong>COUNTIF<\/strong> b\u00ecnh th\u01b0\u1eddng v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF($C$2:$C$11,\u201dCancelled\u201d)+COUNTIF($C$2:$C$11,\u201dPending\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-multiple-criteria-or-logic.png\" alt=\"Counting cells that meet any of the specified criteria\" title=\"countifs-multiple-criteria-or-logic\"><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p m\u1ed7i h\u00e0m ch\u1ee9a nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, s\u1eed d\u1ee5ng <strong>COUNTIFS<\/strong> thay v\u00ec <strong>COUNTIF<\/strong>. V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng <em>\u201cCancelled\u201d <\/em>\u00a0v\u00e0 <em>\u201cPending\u201d <\/em>\u0111\u1ed1i v\u1edbi <em>\u201cApples\u201d<\/em>, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS($A$2:$A$11,\u201dApples\u201d,$C$2:$C$11,\u201dCancelled\u201d)+COUNTIFS($A$2:$A$11,\u201dApples\u201d,$C$2:$C$11,\u201dPending\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-multiple-criteria-or-logic2.png\" alt=\"Another formula to count cells with multiple criteria and OR logic\" title=\"countifs-multiple-criteria-or-logic2\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 2. C\u00f4ng th\u1ee9c SUM COUNTIFS v\u1edbi h\u1eb1ng m\u1ea3ng<\/strong><\/p>\n<p style=\"text-align: justify\">Trong t\u00ecnh hu\u1ed1ng b\u1ea1n c\u1ea7n thi\u1ebft \u1eadp nhi\u1ec1u ti\u00eau ch\u00ed, c\u00e1ch ti\u1ebfp c\u1eadn tr\u00ean kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch t\u1ed1i \u01b0u b\u1edfi c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd qu\u00e1 d\u00e0i d\u00f2ng. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh t\u01b0\u01a1ng t\u1ef1 trong m\u1ed9t c\u00f4ng th\u1ee9c nh\u1ecf g\u1ecdn h\u01a1n, h\u00e3y li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed c\u1ee7a b\u1ea1n trong m\u1ea3ng v\u00e0 cung c\u1ea5p m\u1ea3ng \u0111\u00f3 cho <strong><em>criteria <\/em><\/strong>c\u1ee7a h\u00e0m <strong>COUNTIFS<\/strong>. \u0110\u1ec3 \u0111\u1ebfm t\u1ed5ng, k\u1ebft h\u1ee3p h\u00e0m <strong>COUNTIFS<\/strong> b\u00ean trong h\u00e0m <strong>SUM<\/strong> nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM (COUNTIFS (range, {\u201ccriteria1\u201d, \u201ccriteria2\u201d, \u201ccriteria3\u201d, \u2026}))<\/strong><\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang t\u00f4i, \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng c\u00f3 tr\u1ea1ng th\u00e1i \u201c<em>Cancelled<\/em>\u201c, \u201c<em>Pending<\/em>\u201d ho\u1eb7c \u201c<em>In transit<\/em>\u201c, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(COUNTIFS($C$2:$C$11,{\u201cCancelled\u201d,\u201dPending\u201d,\u201dIn Transit\u201d}))<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-countifs-multiple-criteria.png\" alt=\"A more compact formula to count cells with multiple criteria and OR logic\" title=\"sum-countifs-multiple-criteria\"><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 d\u1ef1a tr\u00ean hai ho\u1eb7c nhi\u1ec1u h\u01a1n c\u00e1c c\u1eb7p <strong><em>criteria_range\/criteria<\/em><\/strong>. V\u00ed d\u1ee5: \u0111\u1ec3 bi\u1ebft s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n \u0111\u1eb7t h\u00e0ng \u201c<em>Apples<\/em>\u201d trong tr\u1ea1ng th\u00e1i \u201c<em>Cancelled\u201d, \u201cPending\u201d, \u201cIn transit\u201d,<\/em> s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(COUNTIFS($A$2:$A$11,\u201dApples\u201d,$C$2:$C$11,{\u201cCancelled\u201d,\u201dPending\u201d,\u201dIn transit\u201d}))<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-countifs-multiple-criteria2.png\" alt=\"Counting cells with multiple criteria_range \/ criteria pairs and OR logic\" title=\"sum-countifs-multiple-criteria2\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dem_so_trong_khoang_cu_the\"><\/span><strong>C\u00e1ch \u0111\u1ebfm s\u1ed1 trong kho\u1ea3ng c\u1ee5 th\u1ec3:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 1. H\u00e0m COUNTIFS \u0111\u1ebfm c\u00e1c \u00f4 trong kho\u1ea3ng s\u1ed1<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm ra c\u00f3 bao nhi\u00eau s\u1ed1 gi\u1eefa 5 v\u00e0 10 (kh\u00f4ng bao g\u1ed3m 5 v\u00e0 10) \u0111\u01b0\u1ee3c ch\u1ee9a trong c\u00e1c \u00f4 C2 \u0111\u1ebfn C10, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(C2:C10,\u201d&gt;5\u2033,C2:C10,\u201d&lt;10\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 bao g\u1ed3m c\u1ea3 5 v\u00e0 10, s\u1eed d\u1ee5ng \u201cl\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng\u201d v\u00e0 \u201cnh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng\u201d:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(B2:B10,\u201d&gt;=5\u2033,B2:B10,\u201d&lt;=10\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-between-numbers.png\" alt=\"A COUNTIFS formula to count numbers between X and Y\" title=\"countifs-between-numbers\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c 2. C\u00f4ng th\u1ee9c COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 gi\u1eefa X v\u00e0 Y<\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>COUNTIF <\/em><\/strong>l\u1ed3ng gh\u00e9p v\u1edbi m\u1ed9t h\u00e0m kh\u00e1c kh\u00e1c \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1. C\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean \u0111\u1ebfm nh\u1eefng s\u1ed1 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n d\u01b0\u1edbi (v\u00ed d\u1ee5 l\u00e0 5). C\u00f4ng th\u1ee9c th\u1ee9 hai lo\u1ea1i b\u1ecf nh\u1eefng s\u1ed1 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 10). K\u1ebft qu\u1ea3 b\u1ea1n mu\u1ed1n t\u00ecm n\u1eb1m trong kho\u1ea3ng hai gi\u00e1 tr\u1ecb nh\u1eadn \u0111\u01b0\u1ee3c tr\u00ean.<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF(C2:C10,\u201d&gt;5\u2033)-COUNTIF(C2:C10,\u201d=10\u2033)<\/strong> \u2013 \u0111\u1ebfm c\u00f3 bao nhi\u00eau s\u1ed1 l\u1edbn h\u01a1n 5 nh\u1ecf h\u01a1n 10 trong v\u00f9ng d\u1eef li\u1ec7u C2:C10.<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF(C2:C10,\u201d&gt;=5\u2033)-COUNTIF(C2:C10,\u201d&gt;10\u2033) <\/strong>\u2013 c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00f3 bao nhi\u00eau s\u1ed1 trong \u0111o\u1ea1n t\u1eeb 5 \u0111\u1ebfn 10 thu\u1ed9c v\u00f9ng d\u1eef i\u1ec7u C2:C10, bao g\u1ed3m c\u1ea3 5 v\u00e0 10.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c COUNTIFS<\/strong><\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed logic nh\u01b0 \u201c&gt;\u201d, \u201c&lt;\u201c, \u201c&lt;=\u201d ho\u1eb7c \u201c&gt;=\u201d c\u00f9ng v\u1edbi c\u00e1c tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c <strong>COUNTIFS<\/strong>, l\u01b0u \u00fd h\u00e3y \u0111\u1eb7t c\u00e1c to\u00e1n t\u1eed trong ngo\u1eb7c k\u00e9p v\u00e0 th\u00eam d\u1ea5u (&amp;) tr\u01b0\u1edbc tham chi\u1ebfu \u00f4 \u0111\u1ec3 x\u00e2y d\u1ef1ng m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">Trong t\u1eadp d\u1eef li\u1ec7u m\u1eabu d\u01b0\u1edbi \u0111\u00e2y, h\u00e3y t\u00ednh c\u00e1c \u0111\u01a1n h\u00e0ng \u201c<em>Apples\u201d<\/em> v\u1edbi s\u1ed1 ti\u1ec1n l\u1edbn h\u01a1n $200. V\u1edbi <strong><em>criteria_range1<\/em><\/strong> trong A2: A11 v\u00e0 <strong><em>criteria_range2<\/em><\/strong> trong B2: B11, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS($A$2:$A$11,\u201dT\u00e1o\u201d,$B$2:$B$11,\u201d&gt;200\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb ti\u00eau ch\u00ed v\u00e0 nh\u1eefng \u00f4 nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5 F1 v\u00e0 F2, sau \u0111\u00f3 tham chi\u1ebfu nh\u1eefng \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS($A$2:$A$11,$F$1,$B$2:$B$11,\u201d&gt;&amp;$F$2)<\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u00fa \u00fd s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb <strong>tuy\u1ec7t \u0111\u1ed1i <\/strong>trong <strong><em>criteria <\/em><\/strong>v\u00e0 <strong><em>criteria_range <\/em><\/strong>\u0111\u1ec3 c\u00f4ng th\u1ee9c v\u1eabn \u0111\u00fang khi sao ch\u00e9p sang c\u00e1c \u00f4 t\u00ednh kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-formula-references.png\" alt=\"Using cell references in COUNTIFS formulas\" title=\"countifs-formula-references\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Kho\u00e1 h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_COUNTIFS_voi_cac_ky_tu_dai_dien\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng COUNTIFS v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong><em>D\u1ea5u h\u1ecfi (?)<\/em><\/strong> \u2013 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u01a1n n\u00e0o, s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><strong><em>D\u1ea5u hoa th\u1ecb (*)<\/em><\/strong> \u2013 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 d\u00e3y k\u00fd t\u1ef1 n\u00e0o, b\u1ea1n d\u00f9ng n\u00f3 \u0111\u1ec3 \u0111\u1ebfm \u00f4 ch\u1ee9a m\u1ed9t t\u1eeb c\u1ee5 th\u1ec3 ho\u1eb7c m\u1ed9t k1 t\u1ef1 trong \u00f4.<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd. <\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1ea5u h\u1ecfi ho\u1eb7c d\u1ea5u hoa th\u1ecb, g\u00f5 d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc d\u1ea5u hoa th\u1ecb ho\u1eb7c d\u1ea5u ch\u1ea5m h\u1ecfi.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch c\u00e1c d\u1ef1 \u00e1n trong c\u1ed9t A. B\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau d\u1ef1 \u00e1n \u0111\u00e3 k\u00fd k\u1ebft, t\u1ee9c l\u00e0 c\u1ed9t B c\u00f3 ch\u1ee9a t\u00ean ng\u01b0\u1eddi. H\u00e3y th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai \u2013 <em>End date <\/em>trong c\u1ed9t D.<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(B2:B10,\u201d*\u201d,D2:D10,\u201d&lt;&gt;\u201d&amp;\u201d\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd, b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong ti\u00eau ch\u00ed th\u1ee9 2 v\u00ec c\u1ed9t D ch\u1ee9a ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng ch\u1ee9 kh\u00f4ng ph\u1ea3i d\u1ea1ng text. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao b\u1ea1n s\u1eed d\u1ee5ng ti\u00eau ch\u00ed <strong>\u201c&lt;&gt;\u201d&amp;\u201d\u201d<\/strong> \u0111\u1ec3 t\u00ecm \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countifs-wildcard-chars.png\" alt=\"The COUNTIFS formula to count entries containing any text in one column and non-blank cells in another column.\" title=\"excel-countifs-wildcard-chars\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"COUNTIFS_va_COUNTIF_voi_nhieu_tieu_chi_ngay_thang\"><\/span><strong>COUNTIFS v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed ng\u00e0y th\u00e1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. \u0110\u1ebfm ng\u00e0y trong m\u1ed9t kho\u1ea3ng th\u1eddi gian c\u1ee5 th\u1ec3<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm ng\u00e0y trong m\u1ed9t kho\u1ea3ng th\u1eddi gian c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong>COUNTIFS<\/strong> v\u1edbi hai ti\u00eau ch\u00ed ho\u1eb7c k\u1ebft h\u1ee3p hai h\u00e0m <strong>COUNTIF<\/strong> v\u1edbi nhau.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ebfm s\u1ed1 ng\u00e0y trong c\u00e1c \u00f4 C2 \u0111\u1ebfn C10, kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y 1\/6\/2014 \u0111\u1ebfn 7\/7\/2014 bao g\u1ed3m:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(C2:C9,\u201d=6\/1\/2014\u2033,C2:C9,\u201d&lt;=6\/7\/2014\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF(C2:C9,\u201d=6\/1\/2014\u2033)-COUNTIF(C2:C9,\u201d6\/7\/2014\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countifs-dates-multiple-criteria.png\" alt=\"The COUNTIF formula with 2 conditions to count dates in a specific date range\" title=\"countifs-dates-multiple-criteria\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. \u0110\u1ebfm ng\u00e0y v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong>COUNTIFS<\/strong> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 ng\u00e0y trong c\u00e1c c\u1ed9t kh\u00e1c nhau \u0111\u00e1p \u1ee9ng t\u1eeb hai \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd t\u00ecm ra c\u00f3 bao nhi\u00eau s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c mua sau ng\u00e0y 20 th\u00e1ng 5 v\u00e0 giao h\u00e0ng sau ng\u00e0y 01 th\u00e1ng 6:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(C2:C9,\u201d&gt;5\/1\/2014\u2033,D2:D9,\u201d6\/7\/2014\u2033)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countifs-dates.png\" alt=\"The COUNTIF formula to count dates with multiple conditions\" title=\"excel-countifs-dates\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 3. \u0110\u1ebfm ng\u00e0y v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong>TODAY<\/strong><\/a> k\u1ebft h\u1ee3p v\u1edbi <strong>COUNTIF<\/strong> \u0111\u1ec3 t\u00ednh c\u00e1c ng\u00e0y d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c <strong>COUNTIF<\/strong> sau v\u1edbi hai v\u00f9ng d\u1eef li\u1ec7u v\u00e0 hai ti\u00eau ch\u00ed s\u1ebd cho b\u1ea1n bi\u1ebft c\u00f3 bao nhi\u00eau s\u1ea3n ph\u1ea9m \u0111\u00e3 \u0111\u01b0\u1ee3c mua nh\u01b0ng ch\u01b0a giao h\u00e0ng:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(C2:C9,\u201d&lt;\u201c&amp;TODAY(),D2:D9,\u201d&gt;\u201d&amp;TODAY())<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-countifs-today.png\" alt=\"The COUNTIF formula to count dates with multiple conditions based on the current date\" title=\"excel-countifs-today\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 ch\u1ee9a nhi\u1ec1u bi\u1ebfn. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 tinh ch\u1ec9nh n\u00f3 \u0111\u1ec3 \u0111\u1ebfm c\u00f3 bao nhi\u00eau s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c mua h\u01a1n m\u1ed9t tu\u1ea7n tr\u01b0\u1edbc v\u00e0 ch\u01b0a giao h\u00e0ng:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIFS(C2:C9,\u201d&lt;=\u201d&amp;TODAY()-7,D2:D9,\u201d&gt;\u201d&amp;TODAY())<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady v\u1edbi b\u00e0i vi\u1ebft n\u00e0y, blog.hocexecl.online \u0111\u00e3 chia s\u1ebb c\u0169ng nh\u01b0 h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c CountIFS v\u00e0 CountIF trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t, n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc n\u00e0o c\u00e1c b\u1ea1n h\u00e3y comment ngay \u1edf b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft \u0111\u1ec3 ch\u00fang t\u00f4i c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft m\u1ecdi th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch s\u1edbm nh\u1ea5t.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <strong>H\u1ecdc Excel Online<\/strong><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-40.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1412,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1411","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\/1411","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=1411"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1411\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1412"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}