{"id":5900,"date":"2024-12-21T11:15:20","date_gmt":"2024-12-21T11:15:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-danh-so-thu-tu-tu-dong-trong-excel-voi-ham-counta\/"},"modified":"2024-12-21T11:15:20","modified_gmt":"2024-12-21T11:15:20","slug":"huong-dan-cach-danh-so-thu-tu-tu-dong-trong-excel-voi-ham-counta","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-danh-so-thu-tu-tu-dong-trong-excel-voi-ham-counta\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m COUNTA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi\u00a0excel,\u00a0\u0111\u1eb7c bi\u1ec7t trong c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan t\u1edbi k\u1ebf to\u00e1n, th\u1ed1ng k\u00ea, qu\u1ea3n l\u00fd, ch\u00fang ta th\u01b0\u1eddng g\u1eb7p v\u1ea5n\u00a0\u0111\u1ec1 li\u00ean quan t\u1edbi vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 th\u1ed1ng k\u00ea nhanh\u00a0\u0111\u01b0\u1ee3c bao nhi\u00eau d\u00f2ng d\u1eef li\u1ec7u\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. Tuy nhi\u00ean l\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1\u00a0th\u1ee9 t\u1ef1 n\u00e0y\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng m\u00e0 kh\u00f4ng ph\u1ea3i l\u00e0m b\u1eb1ng tay? H\u00e0m n\u00e0o trong\u00a0excel c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y?<\/p>\n<p>V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, 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 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\"><strong>ha\u0300m COUNTA<\/strong><\/a> 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-1.gif\" width=\"325\" height=\"409\" title=\"pic01-1\"><\/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<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\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> \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<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-524.gif\" title=\"ex101_92019-nho-524\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-tu-dong-trong-excel-voi-ham-subtotal.html\">\u0110a\u0301nh s\u00f4\u0301 th\u01b0\u0301 t\u01b0\u0323 t\u01b0\u0323 \u0111\u00f4\u0323ng trong Excel v\u01a1\u0301i ha\u0300m SUBTOTAL<\/a><\/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-1.png\" width=\"479\" height=\"461\" title=\"pic-03-1\"><\/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>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2v3ZXJX\">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.\u00a0H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/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-524.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5901,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5900","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\/5900","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=5900"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5901"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}