{"id":1237,"date":"2024-12-02T04:29:18","date_gmt":"2024-12-02T04:29:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cong-thuc-dem-so-lan-xuat-hien-trong-table\/"},"modified":"2024-12-02T04:29:18","modified_gmt":"2024-12-02T04:29:18","slug":"cong-thuc-dem-so-lan-xuat-hien-trong-table","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cong-thuc-dem-so-lan-xuat-hien-trong-table\/","title":{"rendered":"C\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n trong Table"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta hay s\u1eed d\u1ee5ng<strong> h\u00e0m COUNTIF<\/strong> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a 1 n\u1ed9i dung trong 1 v\u00f9ng. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> xin \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14762\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-countifs-table-01.png\" width=\"388\" height=\"255\" title=\"heo-countifs-table-01\"><\/p>\n<p>H\u00e0m ch\u00fang ta s\u1eed d\u1ee5ng l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\"><strong>h\u00e0m COUNTIF<\/strong><\/a>:<\/p>\n<p>Xem th\u00eam: <strong>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\">s\u1eed d\u1ee5ng h\u00e0m count<\/a> v\u00e0 counta \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 trong Excel<\/strong><\/p>\n<ul>\n<li>Range: V\u00f9ng\u00a0\u0111\u1ebfm\u00a0\u1edf\u00a0\u0111\u00e2y c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u A2, b\u1eaft\u00a0\u0111\u1ea7u v\u00f9ng\u00a0\u0111\u1ebfm s\u1ebd l\u00e0 t\u1eeb\u00a0\u00f4 A2<\/li>\n<li>Criteria:\u00a0\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ebfm l\u00e0 n\u1ed9i dung\u00a0\u00f4 A2<\/li>\n<\/ul>\n<p>Khi filldown (sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng ph\u00eda d\u01b0\u1edbi) ch\u00fang ta s\u1ebd l\u1ea5y\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a c\u00e1c n\u1ed9i dung t\u00ean t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u1ed9t A.<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch l\u00e0m th\u00f4ng th\u01b0\u1eddng v\u1edbi\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng RANGE<\/p>\n<p>V\u1eady v\u1edbi\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng TABLE th\u00ec sao?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14763\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-countifs-table-02.png\" width=\"432\" height=\"194\" title=\"heo-countifs-table-02\"><\/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-30.gif\" title=\"vba101_92019-nho-30\"><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-86.gif\" title=\"ex101_92019-nho-86\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u00e2y l\u00e0 v\u1ea5n\u00a0\u0111\u1ec1 r\u1ea5t hay x\u1ea3y ra khi ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng TABLE:<\/p>\n<ul>\n<li>Ban\u00a0\u0111\u1ea7u c\u00f4ng th\u1ee9c ho\u1ea1t\u00a0\u0111\u1ed9ng\u00a0\u0111\u00fang t\u1eeb d\u00f2ng 2 t\u1edbi d\u00f2ng 4 (C\u00e1c c\u00f4ng th\u1ee9c t\u1ea1i H2, H3, H4)<\/li>\n<li>Khi th\u00eam ti\u1ebfp d\u1eef li\u1ec7u v\u00e0o table\u00a0\u1edf c\u00e1c d\u00f2ng 5, 6, 7 th\u00ec h\u00e0m COUNTIF t\u1ef1\u00a0\u0111\u1ed9ng t\u1ea1o ra\u00a0\u1edf c\u00e1c\u00a0\u00f4 H5, H6, H7 nh\u01b0ng kh\u00f4ng ch\u00ednh x\u00e1c.<\/li>\n<li>Nguy\u00ean nh\u00e2n l\u00e0 b\u1edfi khi th\u00eam n\u1ed9i dung v\u00e0o Table th\u00ec t\u1ecda\u00a0\u0111\u1ed9 c\u1ee7a\u00a0\u0111i\u1ec3m cu\u1ed1i trong Table s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i gi\u1edbi h\u1ea1n. Ch\u00ednh v\u00ec th\u1ebf c\u00f4ng th\u1ee9c m\u1edbi t\u1ef1 \u0111\u1ed9ng t\u1ea1o ra \u0111\u00e3 kh\u00f4ng\u00a0\u0111\u00fang n\u1eefa.<\/li>\n<\/ul>\n<p>C\u00e1ch kh\u1eafc ph\u1ee5c vi\u1ec7c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? Hay c\u1ee5 th\u1ec3 h\u01a1n l\u00e0 s\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0nh\u01b0 th\u1ebf n\u00e0o\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 v\u1eabn\u00a0\u0111\u00fang khi th\u00eam gi\u00e1 tr\u1ecb m\u1edbi trong Table, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14764\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-countifs-table-03.png\" width=\"622\" height=\"242\" title=\"heo-countifs-table-03\"><\/p>\n<p>C\u00f4ng th\u1ee9c =COUNTIF([@[H\u1ecd t\u00ean]]:INDEX([H\u1ecd t\u00ean],1),[@[H\u1ecd t\u00ean]])<\/p>\n<p>[@[H\u1ecd t\u00ean]]\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 1 gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 t\u1ea1i d\u00f2ng\u00a0\u0111\u00f3. N\u1ed9i dung n\u00e0y\u00a0\u0111\u01b0\u1ee3c l\u1ea5y khi click chu\u1ed9t v\u00e0o c\u1ed9t H\u1ecd t\u00ean, d\u00f2ng ngang h\u00e0ng v\u1edbi\u00a0\u00f4\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c.<\/p>\n<p>[H\u1ecd t\u00ean]\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 to\u00e0n b\u1ed9 c\u1ed9t H\u1ecd t\u00ean trong table. N\u1ed9i dung n\u00e0y\u00a0\u0111\u01b0\u1ee3c l\u1ea5y b\u1eb1ng c\u00e1ch ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng n\u1ed9i dung c\u1ed9t H\u1ecd t\u00ean.<\/p>\n<p>H\u00e0m Index([H\u1ecd t\u00ean],1) l\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0\u0111\u1ea7u ti\u00ean trong table (\u0111i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u)<\/p>\n<p>v\u00f9ng\u00a0[@[H\u1ecd t\u00ean]]:INDEX([H\u1ecd t\u00ean],1) ch\u00ednh l\u00e0 t\u00ednh t\u1eeb\u00a0\u0111i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi d\u00f2ng hi\u1ec7n t\u1ea1i trong v\u00f9ng\u00a0\u0111\u1ebfm =&gt; Tr\u00e1nh vi\u1ec7c t\u1ef1\u00a0\u0111\u1ed9ng x\u00e1c\u00a0\u0111\u1ecbnh t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a table<\/p>\n<p>=&gt; To\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0:\u00a0\u0110\u1ebfm gi\u00e1 tr\u1ecb\u00a0\u1edf d\u00f2ng hi\u1ec7n t\u1ea1i trong table n\u1eb1m trong c\u1ed9t H\u1ecd t\u00ean, t\u00ednh t\u1eeb d\u00f2ng b\u1eaft\u00a0\u0111\u1ea7u t\u1edbi d\u00f2ng hi\u1ec7n t\u1ea1i.<\/p>\n<p>C\u00f4ng th\u1ee9c n\u00e0y v\u1ec1 b\u1ea3n ch\u1ea5t l\u00e0 t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00f4ng th\u1ee9c COUNTIF c\u1ee7a range, nh\u01b0ng c\u00e1ch di\u1ec5n\u00a0\u0111\u1ea1t trong Table v\u00e0 trong Range l\u1ea1i c\u00f3 s\u1ef1 kh\u00e1c nhau,\u00a0\u0111\u1ec3 ra\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u1ed1ng nhau.\u00a0\u0110\u00e2y l\u00e0 m\u1ed9t s\u1ef1 ch\u00fa\u00a0\u00fd quan tr\u1ecdng khi ch\u00fang ta l\u00e0m vi\u1ec7c v\u1edbi Table trong\u00a0excel.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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-30.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1238,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1237","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\/1237","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=1237"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1238"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}