{"id":2192,"date":"2024-12-02T07:10:56","date_gmt":"2024-12-02T07:10:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tu-dong-danh-so-thu-tu-cot-trong-excel\/"},"modified":"2024-12-02T07:10:56","modified_gmt":"2024-12-02T07:10:56","slug":"tu-dong-danh-so-thu-tu-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tu-dong-danh-so-thu-tu-cot-trong-excel\/","title":{"rendered":"T\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>B\u00ecnh th\u01b0\u1eddng, \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u Excel, \u0111a s\u1ed1 c\u00e1c b\u1ea1n th\u01b0\u1eddng nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean, v\u00ed d\u1ee5 1 r\u1ed3i \u1edf \u00f4 ph\u00eda d\u01b0\u1edbi, b\u1ea1n nh\u1eadp h\u00e0m =\u201d\u00f4 \u0111\u1ea7u\u201d+1 r\u1ed3i k\u00e9o xu\u1ed1ng h\u1ebft c\u1ed9t mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, v\u1eady l\u00e0 xong. Tuy nhi\u00ean, n\u00f3 r\u1ea5t th\u1ee7 c\u00f4ng v\u00e0 kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch th\u00f4ng th\u01b0\u1eddng khi s\u1ed1 c\u1ed9t qu\u00e1 l\u1edbn.<\/strong><\/p>\n<p style=\"text-align: left\">Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y H\u1ecdc Excel Online\u00a0s\u1ebd chia s\u1ebb cho c\u00e1c b\u1ea1n c\u00e1c b\u01b0\u1edbc \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ef1c k\u00ec nhanh ch\u00f3ng v\u00e0 khoa h\u1ecdc.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d5d7fe6a33\" 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\/tu-dong-danh-so-thu-tu-cot-trong-excel.html#Cach_danh_so_thu_tu_tu_dong_don_gian\" title=\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng \u0111\u01a1n gi\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\/tu-dong-danh-so-thu-tu-cot-trong-excel.html#Danh_so_thu_tu_ket_qua_loc_Autofilter_voi_ham_Subtotal\" title=\"\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3 l\u1ecdc Autofilter v\u1edbi h\u00e0m Subtotal\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3 l\u1ecdc Autofilter v\u1edbi h\u00e0m Subtotal<\/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\/tu-dong-danh-so-thu-tu-cot-trong-excel.html#Cong_thuc_danh_so_thu_tu\" title=\"C\u00f4ng th\u1ee9c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1\">C\u00f4ng th\u1ee9c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/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\/tu-dong-danh-so-thu-tu-cot-trong-excel.html#Danh_gia_ket_qua\" title=\"\u0110\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3\">\u0110\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/tu-dong-danh-so-thu-tu-cot-trong-excel.html#Cach_danh_so_thu_tu_tu_dong_trong_excel_voi_ham_COUNTA\" title=\"C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m COUNTA\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m COUNTA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_tu_dong_don_gian\"><\/span>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1<\/strong>: Ta nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean, l\u00e0 1.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3438 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu.png\" width=\"600\" height=\"493\" title=\"so-thu-tu\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2<\/strong>: Trong ph\u1ea7n\u00a0 <strong>Editing<\/strong> ch\u1ecdn <strong>Fill \/ Series.<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3439 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-1.png\" width=\"600\" height=\"257\" title=\"so-thu-tu-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: H\u1ed9p tho\u1ea1i <strong>Series <\/strong>xu\u1ea5t hi\u1ec7n.<\/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-167.gif\" title=\"ex101_92019-nho-167\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><strong>Series in<\/strong>: Ch\u1ecdn <strong>Rows<\/strong> n\u1ebfu \u0111\u00e1nh s\u1ed1 theo h\u00e0ng c\u00f2n ch\u1ecdn\u00a0<strong>Columns<\/strong> n\u1ebfu \u0111\u00e1nh s\u1ed1 theo c\u1ed9t.<\/li>\n<\/ul>\n<ul>\n<li>Trong<strong> Type\u00a0<\/strong>c\u00f3 nh\u1eefng l\u1ef1a ch\u1ecdn sau:<\/li>\n<\/ul>\n<p><strong>+\u00a0<\/strong><strong>Linear<\/strong>: \u0110\u00e1nh s\u1ed1 theo ki\u1ec3u t\u0103ng d\u1ea7n.<\/p>\n<p><strong>+ Growth:<\/strong> Ki\u1ec3u l\u0169y ti\u1ebfn.<\/p>\n<p><strong>+ Date<\/strong>: Ki\u1ec3u ng\u00e0y th\u00e1ng.<\/p>\n<p><strong>+ Auto<\/strong><strong>Fill:<\/strong> Ki\u1ec3u t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3442 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-2.png\" width=\"600\" height=\"440\" title=\"so-thu-tu-2\"><\/p>\n<ul>\n<li><strong>Step value<\/strong> (B\u01b0\u1edbc nh\u1ea3y) : Kho\u1ea3ng c\u00e1ch gi\u1eefa hai s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n<li><strong>Stop value<\/strong> (Gi\u00e1 tr\u1ecb cu\u1ed1i) : Ch\u1ec9 \u0111\u00e1nh stt \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ed9t n\u00e0y.<\/li>\n<\/ul>\n<p><em>Ch\u1eb3ng h\u1ea1n, \u1edf \u0111\u00e2y m\u00ecnh ch\u1ecdn \u0111\u00e1nh s\u1ed1 theo <strong>Columns<\/strong> v\u00e0 Type l\u00e0 <strong>Linear<\/strong> v\u1edbi Step value l\u00e0 1 v\u00e0 Stop Value l\u00e0 20.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3443 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-3.png\" width=\"600\" height=\"404\" title=\"so-thu-tu-3\"><\/p>\n<p>=&gt; Nh\u1ea5n <strong>OK, <\/strong>v\u00e0\u00a0c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3444 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-4.png\" width=\"600\" height=\"491\" title=\"so-thu-tu-4\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Danh_so_thu_tu_ket_qua_loc_Autofilter_voi_ham_Subtotal\"><\/span>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3 l\u1ecdc Autofilter v\u1edbi h\u00e0m Subtotal<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00f4ng th\u01b0\u1eddng trong khi l\u00e0m vi\u1ec7c tr\u00ean Excel ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u1ed9t S\u1ed1 th\u1ee9 t\u1ef1\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm th\u1ee9 t\u1ef1 c\u00e1c d\u00f2ng n\u1ed9i dung trong b\u1ea3ng t\u00ednh. Tuy nhi\u00ean vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng s\u1ebd c\u00f3 h\u1ea1n ch\u1ebf khi ch\u00fang ta s\u1eed d\u1ee5ng t\u00ednh n\u0103ng l\u1ecdc d\u1eef li\u1ec7u b\u1eb1ng Autofilter.\u00a0\u0110\u1ec3 minh h\u1ecda r\u00f5 h\u01a1n\u00a0\u0111i\u1ec1u n\u00e0y ch\u00fang ta c\u00f9ng xem v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau, trong\u00a0\u0111\u00f3 c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh s\u1ed1 tr\u1ef1c ti\u1ebfp:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14503\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-subtotal-autofilter-01.png\" width=\"543\" height=\"675\" title=\"heo-subtotal-autofilter-01\"><\/p>\n<p>Khi l\u1ecdc n\u1ed9i dung trong b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean theo nh\u00e2n vi\u00ean Long (S\u1eed d\u1ee5ng AutoFilter v\u00e0 l\u1ecdc \u1edf c\u1ed9t D theo nh\u00e2n vi\u00ean Long)\u00a0th\u00ec k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14504\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-subtotal-autofilter-02.png\" width=\"559\" height=\"328\" title=\"heo-subtotal-autofilter-02\"><\/p>\n<p>Nh\u00ecn v\u00e0o c\u1ed9t STT ch\u00fang ta th\u1ea5y STT kh\u00f4ng thay\u00a0\u0111\u1ed5i khi ta th\u1ef1c\u00a0 hi\u1ec7n vi\u1ec7c\u00a0 l\u1ecdc. V\u00e0 v\u1edbi STT nh\u01b0 v\u1eady th\u00ec vi\u1ec7c theo d\u00f5i k\u1ebft qu\u1ea3 l\u1ecdc c\u1ee7a ch\u00fang ta s\u1ebd g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n, do c\u1ed9t STT kh\u00f4ng c\u00f2n th\u1ec3 hi\u1ec7n\u00a0\u0111\u00fang vai tr\u00f2 l\u00e0 th\u1ee9 t\u1ef1\u00a0c\u00e1c d\u00f2ng n\u1ed9i dung ph\u00e1t sinh.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 gi\u1eef\u00a0\u0111\u00fang b\u1ea3n ch\u1ea5t c\u1ee7a c\u1ed9t STT khi s\u1eed d\u1ee5ng AutoFilter, ch\u00fang ta s\u1ebd\u00a0\u00e1p d\u1ee5ng h\u00e0m SUBTOTAL trong c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_danh_so_thu_tu\"><\/span><strong>C\u00f4ng th\u1ee9c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Nguy\u00ean t\u1eafc c\u1ee7a vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/strong>\u00a0l\u00e0\u00a0<strong>\u0111\u1ebfm<\/strong>\u00a0nh\u1eefng d\u00f2ng c\u00f3 n\u1ed9i dung. V\u1edbi m\u1ed7i d\u00f2ng c\u00f3 n\u1ed9i dung ph\u00e1t sinh th\u00ec s\u1ebd t\u00ednh l\u00e0 1\u00a0\u0111\u01a1n\u00a0 v\u1ecb, d\u00f2ng ti\u1ebfp theo c\u00f3 ch\u1ee9a n\u1ed9i dung th\u00ec s\u1ebd b\u1eb1ng s\u1ed1 th\u1ee9 t\u1ef1\u00a0\u1edf d\u00f2ng tr\u01b0\u1edbc c\u1ed9ng th\u00eam 1.<\/p>\n<p>Khi nh\u1eafc t\u1edbi h\u00e0m\u00a0\u0111\u1ebfm trong\u00a0excel, ch\u00fang ta ngh\u0129 t\u1edbi COUNT<\/p>\n<p>Trong h\u00e0m Subtotal c\u0169ng h\u1ed7 tr\u1ee3 vi\u1ec7c\u00a0\u0111\u1ebfm: s\u1eed d\u1ee5ng\u00a0<strong>function_num l\u00e0 3<\/strong><\/p>\n<p>V\u00f9ng tham chi\u1ebfu c\u00f3 th\u1ec3 ch\u1ecdn l\u00e0 v\u00f9ng lu\u00f4n ch\u1eafc ch\u1eafn c\u00f3 n\u1ed9i dung (\u0111\u1ec3 tr\u00e1nh vi\u1ec7c tr\u00ean c\u00f9ng 1 d\u00f2ng m\u00e0\u00a0\u0111\u1ebfm\u00a0\u1edf v\u00f9ng kh\u00f4ng c\u00f3 n\u1ed9i dung th\u00ec d\u00f2ng\u00a0\u0111\u00f3 s\u1ebd kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u00ednh). V\u00ed d\u1ee5\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta ch\u1ecdn v\u1edbi c\u1ed9t D \u2013 c\u1ed9t Nh\u00e2n vi\u00ean.\u00a0\u0110\u1ebfm b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb d\u00f2ng th\u1ee9 2 n\u00ean s\u1ebd b\u1eaft\u00a0\u0111\u1ea7u v\u1edbi\u00a0\u00f4 D2. Khi\u00a0\u0111\u1ebfm c\u00e1c d\u00f2ng ti\u1ebfp theo th\u00ec s\u1ebd\u00a0\u0111\u1ebfm c\u1ea3 nh\u1eefng\u00a0\u00f4 tr\u01b0\u1edbc\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>S\u1ed1 th\u1ee9 t\u1ef1 t\u1ea1i d\u00f2ng 2 = COUNT(D2:D2)<\/li>\n<li>S\u1ed1 th\u1ee9 t\u1ef1 t\u1ea1i d\u00f2ng 3 = COUNT(D2:D3)<\/li>\n<li>S\u1ed1 th\u1ee9 t\u1ef1 t\u1ea1i d\u00f2ng\u00a04 = COUNT(D2:D4)<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 D2 lu\u00f4n xu\u1ea5t hi\u1ec7n trong c\u00e1c c\u00f4ng th\u1ee9c =&gt; C\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m D2<\/p>\n<p>Ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c\u00a0\u0111\u1ebfm s\u1ed1 th\u1ee9 t\u1ef1 t\u1ea1i\u00a0\u00f4 A2 nh\u01b0 sau:<\/p>\n<blockquote>\n<p>A2=SUBTOTALL(3, $D$2:D2)<\/p>\n<\/blockquote>\n<p>=&gt; Copy (filldown) c\u00f4ng th\u1ee9c t\u1ea1i A2 xu\u1ed1ng c\u00e1c d\u00f2ng ti\u1ebfp theo\u00a0\u1edf c\u1ed9t A<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_gia_ket_qua\"><\/span><span id=\"3_Danh_gia_ket_qua\" class=\"ez-toc-section\"><\/span><strong>\u0110\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Subtotal\u00a0\u1edf c\u1ed9t STT v\u00e0 s\u1eed d\u1ee5ng Autofilter v\u1edbi Nh\u00e2n vi\u00ean Long nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14505\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-subtotal-autofilter-04.png\" width=\"552\" height=\"352\" title=\"heo-subtotal-autofilter-04\"><\/p>\n<p>Nh\u01b0 v\u1eady s\u1ed1 th\u1ee9 t\u1ef1\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c thay\u00a0\u0111\u1ed5i 1 c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng d\u1ef1a theo k\u1ebft qu\u1ea3 l\u1ecdc.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_tu_dong_trong_excel_voi_ham_COUNTA\"><\/span>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m COUNTA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>chu\u0301ng t\u00f4i se\u0303 chia se\u0309 cho ca\u0301c ba\u0323n ca\u0301ch s\u01b0\u0309 du\u0323ng ha\u0300m \u0111a\u0301nh s\u00f4\u0301 th\u01b0\u0323 t\u01b0\u0323 t\u01b0\u0323 \u0111\u00f4\u0323ng trong excel v\u01a1\u0301i ha\u0300m COUNTA m\u00f4\u0323t ca\u0301ch \u0111\u01a1n gia\u0309n va\u0300 hi\u00ea\u0323u qua\u0309 nh\u00e2\u0301t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11290 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01.gif\" width=\"325\" height=\"409\" title=\"pic01\"><\/p>\n<p><strong>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3 c\u1ea7n\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c (di\u1ec5n\u00a0\u0111\u1ea1t b\u1eb1ng l\u1eddi)<\/strong><\/p>\n<ul>\n<li>\u0110\u00e1nh s\u1ed1\u00a0th\u1ee9 t\u1ef1 b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb d\u00f2ng th\u1ee9\u00a02<\/li>\n<li>N\u1ebfu n\u1ed9i dung H\u1ecd t\u00ean kh\u00f4ng c\u00f3 (d\u00f2ng tr\u1ed1ng) th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb r\u1ed7ng (b\u1ecf qua)<\/li>\n<li>N\u1ebfu c\u00f3 n\u1ed9i dung H\u1ecd t\u00ean th\u00ec\u00a0STT s\u1ebd l\u00e0\u00a0\u0111\u1ebfm t\u1ed5ng s\u1ed1 H\u1ecd t\u00ean\u00a0\u0111\u00e3 c\u00f3<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:\u00a0C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA<\/strong><\/p>\n<blockquote>\n<p>A2 =IF(B2=\u201d\u201d,0,COUNTA($B2:B2))<\/p>\n<\/blockquote>\n<p><strong>N\u1ed9i dung h\u00e0m\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 sau:<\/strong><\/p>\n<p><strong><em>IF(B2=\u201d\u201d,0,<\/em><\/strong>\u00a0 \u00a0 \u00a0l\u00e0 n\u1ebfu\u00a0\u00f4 B2 b\u1eb1ng r\u1ed7ng th\u00ec s\u1ebd nh\u1eadn k\u1ebft qu\u1ea3 stt = 0<\/p>\n<p><strong><em>COUNTA($B2:B2)<\/em><\/strong>\u00a0\u00a0tr\u01b0\u1eddng h\u1ee3p\u00a0\u00f4 B2 kh\u00f4ng r\u1ed7ng, s\u1ebd\u00a0\u0111\u1ebfm nh\u1eefng \u00f4 c\u00f3 d\u1eef li\u1ec7u\u00a0trong kho\u1ea3ng\u00a0\u00f4 B2\u00a0\u0111\u1ebfn\u00a0B2 (c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u l\u00e0\u00a0\u00f4 B2,\u00a0\u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 khi copy c\u00f4ng th\u1ee9c s\u1ebd c\u00f3 th\u1ec3 t\u1ef1 m\u1edf r\u1ed9ng tham chi\u1ebfu n\u00e0y)<\/p>\n<p>H\u00e0m\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ngay t\u1ea1i\u00a0\u00f4 A2.\u00a0\u0110i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u h\u00e0m CountA l\u00e0\u00a0\u00f4 B2,\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u n\u00e0y ph\u1ea3i\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh, c\u00f2n\u00a0\u0111i\u1ec3m cu\u1ed1i kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 khi thay\u00a0\u0111\u1ed5i v\u1ecb tr\u00ed\u00a0\u00f4 c\u1ea7n t\u00ednh STT\u00a0\u1edf c\u1ed9t A th\u00ec\u00a0\u0111\u1ed9 r\u1ed9ng c\u1ee7a v\u00f9ng h\u1ecd t\u00ean c\u1ea7n\u00a0\u0111\u1ebfm s\u1ebd thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11343 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic-03.png\" width=\"479\" height=\"461\" title=\"pic-03\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0IF, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u1ed9t STT trong\u00a0Excel.<\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> v\u1ec1 m\u1eb9o \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong c\u1ed9t c\u1ee7a Excel. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c t\u1ea1i Blog H\u1ecdc Excel Online\u00a0\u0111\u1ec3 t\u1ef1 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 Excel. Ngo\u00e0i ra, H\u1ecdc Excel Online c\u00f3 kh\u00f3a h\u1ecdc <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 chuy\u00ean gia<\/a>\u00a0h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n nh\u1ea5t t\u1edbi Excel n\u00e2ng cao. Sau kh\u00f3a h\u1ecdc, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 tin s\u1eed d\u1ee5ng Excel trong m\u1ecdi c\u00f4ng vi\u1ec7c m\u00e0 b\u1ea1n \u0111ang l\u00e0m. H\u01a1n n\u1eefa, th\u1eddi gian h\u1ecdc r\u1ea5t tho\u1ea3i m\u00e1i, b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o b\u1ea1n mu\u1ed1n tr\u00ean c\u00e1c thi\u1ebft b\u1ecb c\u00f3 k\u1ebft n\u1ed1i internet, qu\u00e1 d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/4-cach-danh-so-thu-tu-trong-excel-2007-2010-2013-2016.html\">C\u00f4ng th\u1ee9c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel<\/a> C\u1ef1c Hay<\/strong><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u00eam th\u00f4ng tin chi ti\u1ebft v\u1ec1 kh\u00f3a h\u1ecdc, b\u1ea1n xem t\u1ea1i link d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel c\u01a1 b\u1ea3n t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn chuy\u00ean gia<\/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-167.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2192","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\/2192","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=2192"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2193"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}