{"id":1206,"date":"2024-12-02T04:25:18","date_gmt":"2024-12-02T04:25:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel\/"},"modified":"2024-12-02T04:25:18","modified_gmt":"2024-12-02T04:25:18","slug":"cach-dung-ham-count-va-counta-de-dem-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m COUNT v\u00e0 COUNTA \u0111\u1ec3 \u0111\u1ebfm \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i h\u01b0\u1edbng d\u1eabn ng\u1eafn n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch c\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c <strong>h\u00e0m COUNT v\u00e0 COUNTA<\/strong>, \u0111\u1ed3ng th\u1eddi ch\u1ec9 ra m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ebfm trong Excel. B\u1ea1n c\u0169ng s\u1ebd h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c<strong> h\u00e0m COUNTIF v\u00e0 COUNTIFS<\/strong> \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng m\u1ed9t ho\u1eb7c nhi\u1ec1u ti\u00eau ch\u00ed \u0111\u1ecbnh s\u1eb5n.<\/em><\/p>\n<p>Khi s\u1eed d\u1ee5ng Excel, ngo\u00e0i vi\u1ec7c t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb, b\u1ea1n c\u0169ng c\u1ea7n \u0111\u1ebfm c\u00e1c \u00f4 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u2013 v\u1edbi b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o ho\u1eb7c v\u1edbi c\u00e1c lo\u1ea1i gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u0111\u1ebfm nhanh t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c trong danh s\u00e1ch ho\u1eb7c t\u1ed5ng s\u1ed1 c\u00e1c s\u1ed1 kho\u1ea3ng kh\u00f4ng qu\u1ea3ng c\u00e1o trong m\u1ed9t ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/p>\n<p>Microsoft Excel cung c\u1ea5p m\u1ed9t v\u00e0i ch\u1ee9c n\u0103ng \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4: h\u00e0m COUNT v\u00e0 h\u00e0m COUNTA. C\u1ea3 hai h\u00e0m n\u00e0y \u0111\u1ec1u r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng. V\u00ec v\u1eady tr\u01b0\u1edbc ti\u00ean, H\u1ecdc Excel Online s\u1ebd ph\u00e2n t\u00edch v\u1ec1 hai h\u00e0m n\u00e0y, v\u00e0 sau \u0111\u00f3 \u0111\u01b0a ra m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 \u0111\u00e1p \u1ee9ng (c\u00e1c) \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh v\u00e0 nh\u1eefng g\u1ee3i \u00fd nh\u1ecf khi \u0111\u1ebfm m\u1ed9t s\u1ed1 lo\u1ea1i gi\u00e1 tr\u1ecb.<\/p>\n<blockquote>\n<p>Chia s\u1ebb\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">t\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/a> c\u1ef1c hay<\/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-674d36ace7261\" 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-count-va-counta-de-dem-o-trong-excel.html#Ham_COUNT_%E2%80%93_dem_cac_o_co_so\" title=\"H\u00e0m COUNT \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 s\u1ed1:\">H\u00e0m COUNT \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 s\u1ed1:<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html#Cu_phap_cua_ham_Excel_COUNT_nhu_sau\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNT nh\u01b0 sau:\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNT nh\u01b0 sau:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html#Su_dung_ham_COUNT_trong_Excel_%E2%80%93_nhung_dieu_can_nho\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNT trong Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb\">S\u1eed d\u1ee5ng h\u00e0m COUNT trong Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb<\/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-count-va-counta-de-dem-o-trong-excel.html#Vi_du_cong_thuc_ham_COUNT_trong_Excel\" title=\"V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c h\u00e0m COUNT trong Excel\">V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c h\u00e0m COUNT trong Excel<\/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-count-va-counta-de-dem-o-trong-excel.html#Cu_phap_cua_ham_Excel_COUNTA_giong_voi_ham_COUNT\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNTA gi\u1ed1ng v\u1edbi h\u00e0m COUNT:\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNTA gi\u1ed1ng v\u1edbi h\u00e0m COUNT:<\/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-count-va-counta-de-dem-o-trong-excel.html#Ham_COUNTIF_%E2%80%93_dem_cac_o_dap_ung_dieu_kien_cho_san\" title=\"H\u00e0m COUNTIF \u2013 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n cho s\u1eb5n:\">H\u00e0m COUNTIF \u2013 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n cho s\u1eb5n:<\/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-count-va-counta-de-dem-o-trong-excel.html#Ham_Excel_COUNTIFS_%E2%80%93_dem_o_phu_hop_voi_mot_so_tieu_chi\" title=\"H\u00e0m Excel COUNTIFS \u2013 \u0111\u1ebfm \u00f4 ph\u00f9 h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 ti\u00eau ch\u00ed:\">H\u00e0m Excel COUNTIFS \u2013 \u0111\u1ebfm \u00f4 ph\u00f9 h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 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-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html#Dem_so_o_trong_mot_dai_cac_ham_ROWS_va_COLUMNS\" title=\"\u0110\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t d\u1ea3i (c\u00e1c h\u00e0m ROWS v\u00e0 COLUMNS)\">\u0110\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t d\u1ea3i (c\u00e1c h\u00e0m ROWS v\u00e0 COLUMNS)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_COUNT_%E2%80%93_dem_cac_o_co_so\"><\/span>H\u00e0m COUNT \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 s\u1ed1:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n s\u1eed d\u1ee5ng <strong>h\u00e0m COUNT<\/strong> trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_Excel_COUNT_nhu_sau\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNT nh\u01b0 sau:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>COUNT(gi\u00e1 tr\u1ecb1, [gi\u00e1 tr\u1ecb2], \u2026)<br \/>\nTrong \u0111\u00f3 gi\u00e1 tr\u1ecb1, gi\u00e1 tr\u1ecb2,\u2026 l\u00e0 c\u00e1c tham chi\u1ebfu \u00f4 ho\u1eb7c c\u00e1c d\u00e3y trong \u0111\u00f3 b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 b\u1eb1ng c\u00e1c con s\u1ed1.<\/p>\n<p>Trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2016, Excel 2013, Excel 2010 v\u00e0 Excel 2007, ch\u1ee9c n\u0103ng COUNT ch\u1ea5p nh\u1eadn t\u1edbi 255 \u0111\u1ed1i s\u1ed1. Trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p t\u1edbi 30 \u2018gi\u00e1 tr\u1ecb\u2019.<\/p>\n<p>V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c sau tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 \u00f4 s\u1ed1 trong d\u1ea3i A1:A100:<\/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-84.gif\" title=\"ex101_92019-nho-84\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>=COUNT(A1:A100)<\/p>\n<p>Ch\u00fa th\u00edch. Trong h\u1ec7 th\u1ed1ng Excel n\u1ed9i b\u1ed9, ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng s\u1ed1 s\u00ea-ri v\u00e0 do \u0111\u00f3 h\u00e0m Excel COUNT s\u1ebd \u0111\u1ebfm lu\u00f4n c\u1ea3 ng\u00e0y v\u00e0 th\u1eddi gian.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNT_trong_Excel_%E2%80%93_nhung_dieu_can_nho\"><\/span>S\u1eed d\u1ee5ng h\u00e0m COUNT trong Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c quy t\u1eafc ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m COUNT trong Excel<\/p>\n<p>N\u1ebfu m\u1ed9t (c\u00e1c) \u0111\u1ed1i s\u1ed1 c\u1ee7a m\u1ed9t c\u00f4ng th\u1ee9c h\u00e0m Count l\u00e0 m\u1ed9t tham chi\u1ebfu ho\u1eb7c d\u1ea3i \u00f4, ch\u1ec9 s\u1ed1, ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian \u0111\u01b0\u1ee3c t\u00ednh. C\u00e1c \u00f4 c\u00f3 th\u1ec3 \u0111\u1ebf tr\u1eafng ho\u1eb7c ch\u1ee9a b\u1ea5t c\u1ee9 d\u1eef li\u1ec7u n\u00e0o nh\u01b0ng kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u s\u1ed1.<br \/>\nN\u1ebfu b\u1ea1n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o \u0111\u1ed1i s\u1ed1 h\u00e0m COUNT, c\u00e1c gi\u00e1 tr\u1ecb sau s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh: s\u1ed1, ng\u00e0y th\u00e1ng, th\u1eddi gian, gi\u00e1 tr\u1ecb Boolean c\u1ee7a TRUE v\u00e0 FALSE, v\u00e0 bi\u1ec3u di\u1ec5n v\u0103n b\u1ea3n c\u1ee7a c\u00e1c con s\u1ed1 (ngh\u0129a l\u00e0 m\u1ed9t s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0 \u201c5\u201d).<br \/>\nV\u00ed d\u1ee5: COUNT c\u00f4ng th\u1ee9c sau \u0111\u00e2y tr\u1ea3 v\u1ec1 4, v\u00ec c\u00e1c gi\u00e1 tr\u1ecb sau \u0111\u01b0\u1ee3c t\u00ednh: 1, \u201c2\u201d, 1\/1\/2016 v\u00e0 TRUE.<\/p>\n<p>=COUNT(1, \u201capples\u201d, \u201c2\u201d, 1\/1\/2016, TRUE)<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Word Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_cong_thuc_ham_COUNT_trong_Excel\"><\/span>V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c h\u00e0m COUNT trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng <strong>h\u00e0m COUNT trong Excel<\/strong> v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau.<\/p>\n<p>\u0110\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 trong m\u1ed9t d\u00e3y, s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c t\u00ednh \u0111\u01a1n gi\u1ea3n nh\u01b0 =COUNT(A2:A10). \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda nh\u1eefng lo\u1ea1i d\u1eef li\u1ec7u n\u00e0o \u0111\u01b0\u1ee3c t\u00ednh v\u00e0 nh\u1eefng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c b\u1ecf qua:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7812\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-6.png\" width=\"293\" height=\"311\" title=\"1-6\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 \u0111\u1ebfm m\u1ed9t v\u00e0i ph\u1ea1m vi kh\u00f4ng ti\u1ebfp gi\u00e1p, ch\u00fang ta c\u1ea7n \u0111\u01b0a t\u1ea5t c\u1ea3 ch\u00fang v\u00e0o c\u00f4ng th\u1ee9c h\u00e0m COUNT. V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm \u00f4 c\u00f3 s\u1ed1 trong c\u1ed9t B v\u00e0 D, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNT(B2:B7, D2:D7)<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7813\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-6.png\" width=\"393\" height=\"271\" title=\"2-6\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\"><strong>M\u1eb9o:<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm nh\u1eefng s\u1ed1 th\u1ecfa m\u00e3n c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh th\u00ec h\u00e3y d\u00f9ng COUNTIF ho\u1eb7c COUNTIFS.<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu ngo\u00e0i s\u1ed1, b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u1ea3 c\u00e1c \u00f4 ch\u1ee9 v\u0103n b\u1ea3n, gi\u00e1 tr\u1ecb logic v\u00e0 c\u00e1c l\u1ed7i th\u00ec s\u1eed d\u1ee5ng h\u00e0m COUNTA.<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m Excel COUNTA \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb (kh\u00f4ng t\u00ednh \u00f4 \u0111\u1ec3 tr\u1ed1ng)<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m COUNTA trong Excel \u0111\u1ebfm s\u1ed1 \u00f4 trong d\u1ea3i kh\u00f4ng t\u00ednh \u00f4 \u0111\u1ec3 tr\u1ed1ng.<\/span><\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng trong excel <\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_Excel_COUNTA_giong_voi_ham_COUNT\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel COUNTA gi\u1ed1ng v\u1edbi h\u00e0m COUNT:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">COUNTA (value1, [value2], \u2026)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong \u0111\u00f3 value1, value2,\u2026 l\u00e0 tham chi\u1ebfu \u00f4 ho\u1eb7c d\u1ea3i \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n t\u00ednh c\u00e1c \u00f4 kh\u00f4ng ph\u1ea3i l\u00e0 \u00f4 tr\u1ed1ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm \u00f4 c\u00f3 gi\u00e1 tr\u1ecb trong d\u00e3y A1: A100, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTA(A1:A100)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng r\u1ed7ng trong m\u1ed9t s\u1ed1 ph\u1ea1m vi kh\u00f4ng li\u1ec1n k\u1ec1, s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c COUNTA t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTA(B2:B10, D2:D20, E2:F10)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n th\u1ea5y, ph\u1ea1m vi \u0111\u01b0\u1ee3c cung c\u1ea5p cho c\u00f4ng th\u1ee9c Excel COUNTA kh\u00f4ng nh\u1ea5t thi\u1ebft c\u1ea7n ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc, ngh\u0129a l\u00e0 m\u1ed7i d\u1ea3i \u00f4 c\u00f3 th\u1ec3 ch\u1ee9a m\u1ed9t s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Xin l\u01b0u \u00fd r\u1eb1ng ch\u1ee9c n\u0103ng COUNTA c\u1ee7a Excel \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 ch\u1ee9a b\u1ea5t k\u1ef3 lo\u1ea1i d\u1eef li\u1ec7u n\u00e0o, bao g\u1ed3m:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 S\u1ed1<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 Ng\u00e0y \/ th\u1eddi gian<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 Gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 C\u00e1c gi\u00e1 tr\u1ecb Boolean c\u1ee7a TRUE v\u00e0 FALSE<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 C\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i nh\u01b0 #VALUE ho\u1eb7c # N\/A<\/span><\/li>\n<li><span style=\"font-family: 'Times New Roman', Times\">\u2013 Chu\u1ed7i v\u0103n b\u1ea3n tr\u1ed1ng (\u201c\u201d)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecb b\u1ed1i r\u1ed1i b\u1edfi k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTA v\u00ec n\u00f3 kh\u00e1c v\u1edbi nh\u1eefng g\u00ec b\u1ea1n nh\u00ecn th\u1ea5y b\u1eb1ng m\u1eaft th\u01b0\u1eddng. V\u1ea5n \u0111\u1ec1 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c Excel c\u1ee7a h\u00e0m COUNTA c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 m\u00e0 tr\u1ef1c quan nh\u00ecn c\u00f3 v\u1ebb l\u00e0 \u00f4 r\u1ed7ng, nh\u01b0ng v\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt ch\u00fang kh\u00f4ng ph\u1ea3i \u00f4 r\u1ed7ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh g\u00f5 m\u1ed9t kho\u1ea3ng tr\u1ed1ng trong m\u1ed9t \u00f4, \u00f4 \u0111\u00f3 c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm. Ho\u1eb7c, n\u1ebfu m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng, th\u00ec \u00f4 \u0111\u00f3 c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u00f3i c\u00e1ch kh\u00e1c, c\u00e1c \u00f4 duy nh\u1ea5t m\u00e0 h\u00e0m COUNTA kh\u00f4ng \u0111\u1ebfm l\u00e0 nh\u1eefng \u00f4 ho\u00e0n to\u00e0n tr\u1ed1ng r\u1ed7ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau \u0111\u00e2y th\u1ec3 hi\u1ec7n s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa h\u00e0m COUNT v\u00e0 h\u00e0m COUNTA trong Excel<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7815\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1.png\" width=\"733\" height=\"389\" title=\"3-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n nhanh ch\u00f3ng \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng b\u1ecb b\u1ecf tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn, ch\u1ec9 c\u1ea7n nh\u00ecn v\u00e0o Thanh tr\u1ea1ng th\u00e1i \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a c\u1eeda s\u1ed5 Excel:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7817\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-6.png\" width=\"210\" height=\"33\" title=\"4-6\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_%E2%80%93_dem_cac_o_dap_ung_dieu_kien_cho_san\"><\/span><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m COUNTIF \u2013 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n cho s\u1eb5n:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m COUNTIF \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c m\u1ed9t ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh. C\u00fa ph\u00e1p c\u1ee7a n\u00f3 \u0111\u00f2i h\u1ecfi 2 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed1c:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">COUNTIF (range, criteria)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean, b\u1ea1n x\u00e1c \u0111\u1ecbnh m\u1ed9t ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4. V\u00e0 trong tham s\u1ed1 th\u1ee9 hai, b\u1ea1n ch\u1ec9 \u0111\u1ecbnh m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm bao nhi\u00eau \u00f4 trong ph\u1ea1m vi A2:A15 l\u00e0 \u201cApples\u201d, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c COUNTIF sau \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF(A2:A15, \u201capples\u201d)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Thay v\u00e0o \u0111\u00f3 n\u1ebfu g\u00f5 ti\u00eau ch\u00ed tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u1ed9t tham chi\u1ebfu \u00f4 nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh sau:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7818\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-6.png\" width=\"408\" height=\"378\" title=\"5-6\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Excel_COUNTIFS_%E2%80%93_dem_o_phu_hop_voi_mot_so_tieu_chi\"><\/span><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m Excel COUNTIFS \u2013 \u0111\u1ebfm \u00f4 ph\u00f9 h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 ti\u00eau ch\u00ed:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m COUNTIFS t\u01b0\u01a1ng t\u1ef1 nh\u01b0 COUNTIF, nh\u01b0ng n\u00f3 cho ph\u00e9p ch\u1ec9 \u0111\u1ecbnh nhi\u1ec1u ph\u1ea1m vi v\u00e0 nhi\u1ec1u ti\u00eau ch\u00ed. C\u00fa ph\u00e1p c\u1ee7a n\u00f3 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">COUNTIFS(criteria_range1, range1, [criteria_rang2, range2] \u2026)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">H\u00e0m COUNTIFS \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u trong Excel 2007 v\u00e0 c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n v\u1ec1 sau c\u1ee7a Excel nh\u01b0 2010, 2013 v\u00e0 2016.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm bao nhi\u00eau \u201capples\u201d (c\u1ed9t A) \u0111\u00e3 ki\u1ebfm \u0111\u01b0\u1ee3c 200 \u0111\u00f4 la v\u00e0 doanh s\u1ed1 b\u00e1n h\u00e0ng nhi\u1ec1u h\u01a1n (c\u1ed9t B), b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c COUNTIFS sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIFS(A2:A15,\u201dapples\u201d, B2:B15,\u201d&gt;=200\u2033)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, \u0111\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c COUNTIFS c\u1ee7a b\u1ea1n linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p c\u00e1c tham chi\u1ebfu \u00f4 l\u00e0m ti\u00eau ch\u00ed:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7819\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-6.png\" width=\"399\" height=\"385\" title=\"6-6\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_so_o_trong_mot_dai_cac_ham_ROWS_va_COLUMNS\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t d\u1ea3i (c\u00e1c h\u00e0m ROWS v\u00e0 COLUMNS)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm ra t\u1ed5ng s\u1ed1 c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi h\u00ecnh ch\u1eef nh\u1eadt, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m ROWS v\u00e0 COLUMNS \u0111\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t trong m\u1ed9t m\u1ea3ng, t\u01b0\u01a1ng \u1ee9ng:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=ROWS(range)*COLUMNS (range)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ecm ra c\u00f3 bao nhi\u00eau \u00f4 c\u00f3 trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh, nh\u01b0 ph\u1ea1m vi A1:D7, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=ROWS(A1:D7)*COLUMNS(A1:D7)<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7820\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-5.png\" width=\"585\" height=\"219\" title=\"7-5\"><\/p>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-danh-thu-tu-tu-dong-trong-excel-voi-ham-countif.html\">H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m COUNTA<\/a><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia 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\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a> c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/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-84.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1207,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1206","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\/1206","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=1206"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1206\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1207"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}