{"id":2861,"date":"2024-12-02T09:06:37","date_gmt":"2024-12-02T09:06:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-dem-ky-tu-nam-trong-mot-chuoi-bang-ham-countif-trong-excel\/"},"modified":"2024-12-02T09:06:37","modified_gmt":"2024-12-02T09:06:37","slug":"huong-dan-cach-dem-ky-tu-nam-trong-mot-chuoi-bang-ham-countif-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-dem-ky-tu-nam-trong-mot-chuoi-bang-ham-countif-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm k\u00fd t\u1ef1 n\u1eb1m trong m\u1ed9t chu\u1ed7i b\u1eb1ng h\u00e0m COUNTIF trong Excel"},"content":{"rendered":"
\n

Ch\u00e0o c\u00e1c b\u1ea1n, trong b\u00e0i h\u1ecdc n\u00e0y H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd c\u00f9ng b\u1ea1n t\u00ecm hi\u1ec3u vi\u1ec7c \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m COUNTIF<\/strong> trong vi\u1ec7c \u0111\u1ebfm m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh n\u1eb1m trong m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/em><\/p>\n

V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n

<\/p>\n

Y\u00eau c\u1ea7u 1:\u00a0\u0110\u1ebfm nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean l\u00e0 Anh trong danh s\u00e1ch tr\u00ean?<\/strong><\/p>\n

\n

Xem th\u00eam:\u00a0H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n

C\u00e1ch l\u00e0m<\/strong>:<\/p>\n

* Ph\u00e2n t\u00edch t\u00ednh logic<\/em>:<\/p>\n

Nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean l\u00e0 Anh th\u00ec s\u1ebd c\u00f3 k\u1ebft th\u00fac k\u00fd t\u1ef1 h\u1ecd t\u00ean\u00a0b\u1edfi t\u1eeb \u201cAnh\u201d<\/p>\n

=>\u00a0\u0110\u1ebfm nh\u1eefng\u00a0\u00f4 c\u00f3 k\u00fd t\u1ef1 k\u1ebft th\u00fac l\u00e0 ANH<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

* S\u1eed d\u1ee5ng h\u00e0m<\/em>:<\/p>\n

Y\u00eau c\u1ea7u l\u00e0 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n, n\u00ean ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m COUNTIF. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y h\u00e0m \u0111\u1ebfm th\u00f4ng th\u01b0\u1eddng l\u00e0 h\u00e0m count<\/strong><\/a> s\u1ebd kh\u00f4ng th\u1ec3 gi\u1ea3i \u0111\u01b0\u1ee3c b\u00e0i to\u00e1n<\/p>\n

Range = \u201cA1:A6\u201d l\u00e0 v\u00f9ng c\u1ea7n\u00a0\u0111\u1ebfm<\/p>\n

Criteria =\u201d*Anh\u201d l\u00e0 k\u1ebft th\u00fac b\u1edfi t\u1eeb \u201cAnh\u201d. D\u1ea5u *\u00a0\u0111\u1eb7t\u00a0\u1edf tr\u01b0\u1edbc k\u00fd t\u1ef1 Anh\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3<\/p>\n

\n

B1 = COUNTIF(A1:A6,\u201d*Anh\u201d)<\/p>\n<\/blockquote>\n

K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m ra =2<\/p>\n

<\/p>\n

L\u01b0u\u00a0\u00fd<\/em><\/strong>: Trong v\u00ed d\u1ee5 tr\u00ean,\u00a0\u00f4 A6 c\u00f3 t\u00ean l\u00e0 \u201cL\u00ea Anh L\u00e2m\u201d c\u0169ng c\u00f3 t\u00ean Anh\u00a0\u1edf ph\u1ea7n t\u00ean\u00a0\u0111\u1ec7m, nh\u01b0ng kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u00ednh, b\u1edfi t\u1eeb \u201cAnh\u201d n\u1eb1m\u00a0\u1edf gi\u1eefa chu\u1ed7i n\u00ean s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0 \u1edf v\u1ecb tr\u00ed k\u1ebft th\u00fac.<\/p>\n

Y\u00eau c\u1ea7u 2:\u00a0\u0110\u1ebfm nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean\u00a0\u0111\u1ec7m l\u00e0 T\u00d9NG<\/strong><\/p>\n

* Ph\u00e2n t\u00edch t\u00ednh logic<\/em>:<\/p>\n

Nh\u1eefng ng\u01b0\u1eddi c\u00f3 t\u00ean\u00a0\u0111\u1ec7m l\u00e0 \u201cT\u00f9ng\u201d th\u00ec s\u1ebd c\u00f3\u00a0k\u00fd t\u1ef1 \u201cT\u00f9ng\u201d n\u1eb1m gi\u1eefa chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n

=> Ph\u00eda tr\u01b0\u1edbc v\u00e0 ph\u00eda sau ch\u1eef T\u00f9ng\u00a0\u0111\u1ec1u ph\u1ea3i c\u00f3 ch\u1ee9a k\u00fd t\u1ef1.<\/p>\n

Tuy nhi\u00ean tr\u01b0\u1eddng h\u1ee3p ch\u1eef T\u00f9ng l\u00e0 t\u00ean th\u00ec v\u1eabn\u00a0\u0111\u00fang trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u00ean s\u1ebd ph\u1ea3i lo\u1ea1i tr\u1eeb c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u00f3 t\u00ean l\u00e0 T\u00f9ng<\/p>\n

* S\u1eed d\u1ee5ng h\u00e0m<\/em><\/p>\n

H\u00e0m th\u1ee9 1:\u00a0\u0110\u1ebfm ng\u01b0\u1eddi c\u00f3 t\u00ean ho\u1eb7c t\u00ean\u00a0\u0111\u1ec7m l\u00e0 T\u00f9n<\/em><\/strong>g<\/p>\n

\n

COUNTIF(A1:A6,\u201d*T\u00f9ng*\u201d)<\/p>\n<\/blockquote>\n

Range = A1:A6<\/p>\n

Criteria = \u201c*T\u00f9ng*\u201d d\u1ea5u *\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t c\u1ea3\u00a0\u1edf tr\u01b0\u1edbc v\u00e0 sau k\u00fd t\u1ef1 T\u00f9ng\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n ph\u00eda tr\u01b0\u1edbc v\u00e0 sau ch\u1eef n\u00e0y\u00a0\u0111\u1ec1u c\u00f3 ch\u1ee9a k\u00fd t\u1ef1<\/p>\n

H\u00e0m th\u1ee9 2:\u00a0\u0110\u1ebfm ng\u01b0\u1eddi c\u00f3 t\u00ean l\u00e0 T\u00f9ng<\/em><\/strong><\/p>\n

\n

COUNTIF(A1:A6,\u201d*T\u00f9ng\u201d)<\/p>\n<\/blockquote>\n

H\u00e0m n\u00e0y s\u1eed d\u1ee5ng gi\u1ed1ng trong y\u00eau c\u1ea7u 1<\/p>\n

=> Gh\u00e9p hai h\u00e0m\u00a0\u0111\u1ec3 ra k\u1ebft qu\u1ea3:<\/p>\n

\n

B2 =\u00a0COUNTIF(A1:A6,\u201d*T\u00f9ng*\u201d)-COUNTIF(A1:A6,\u201d*T\u00f9ng\u201d)<\/p>\n<\/blockquote>\n

<\/p>\n

\n

\u0110\u0103ng k\u00ed ngay:\u00a0kh\u00f3a h\u1ecdc Word Excel<\/a><\/p>\n<\/blockquote>\n

K\u1ebft lu\u1eadn:<\/strong><\/p>\n

\u0110\u00e2y l\u00e0 m\u1ed9t\u00a0\u1ee9ng d\u1ee5ng r\u1ea5t hay c\u1ee7a h\u00e0m COUNTIF trong vi\u1ec7c x\u1eed l\u00fd\u00a0\u0111\u1ebfm k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh\u00a0trong m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n

\u1ee8ng d\u1ee5ng n\u00e0y\u00a0\u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 (theo t\u00ean, ch\u1ee9c v\u1ee5\u2026), trong k\u1ebf to\u00e1n, marketing (l\u1ecdc theo s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i kh\u00e1ch h\u00e0ng, th\u00f4ng tin kh\u00e1ch h\u00e0ng, t\u00ean, email\u2026)<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel<\/a><\/strong>\u00a0r\u1ea5t d\u1ec5 l\u00e0m v\u00e0 d\u1ec5 nh\u1edb. C\u00e1c b\u1ea1n h\u00e3y luy\u1ec7n t\u1eadp nhi\u1ec1u\u00a0\u0111\u1ec3\u00a0\u1ee9ng d\u1ee5ng v\u00e0o th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c nh\u00e9.<\/em><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2861","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\/2861","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=2861"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2862"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}