{"id":10764,"date":"2025-01-14T23:36:22","date_gmt":"2025-01-14T23:36:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-dem-gia-tri-dung-sai-bang-ham-countif-trong-excel\/"},"modified":"2025-01-14T23:36:22","modified_gmt":"2025-01-14T23:36:22","slug":"huong-dan-cach-dem-gia-tri-dung-sai-bang-ham-countif-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-dem-gia-tri-dung-sai-bang-ham-countif-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm gi\u00e1 tr\u1ecb \u0111\u00fang sai b\u1eb1ng h\u00e0m COUNTIF trong Excel"},"content":{"rendered":"
\n

Ch\u00e0o c\u00e1c b\u1ea1n,<\/p>\n

Trong b\u00e0i h\u1ecdc n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u vi\u1ec7c\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m COUNTIF trong vi\u1ec7c\u00a0\u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb logic:\u00a0\u0110\u00fang (TRUE) ho\u1eb7c Sai (FALSE)<\/p>\n

Ch\u00fang ta c\u00f9ng x\u00e9t v\u00ed d\u1ee5 sau\u00a0\u0111\u1ec3 hi\u1ec3u\u00a0\u1ee9ng d\u1ee5ng n\u00e0y\u00a0\u00e1p d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o nh\u00e9:<\/p>\n

<\/p>\n

Y\u00eau c\u1ea7u:\u00a0\u0110\u1ebfm nh\u1eefng check box\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh d\u1ea5u.<\/strong><\/em><\/p>\n

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

B\u01b0\u1edbc 1: T\u00ecm hi\u1ec3u\u00a0\u0111\u1eb7c tr\u01b0ng c\u1ee7a Check Box<\/strong><\/p>\n

Check box\u00a0\u0111\u01b0\u1ee3c t\u1ea1o ra trong\u00a0Excel b\u1eb1ng c\u00e1ch:<\/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

Ch\u1ecdn tab Developer => b\u1ea5m ch\u1ecdn\u00a0Insert => T\u1ea1o ra Check box (v\u00ed d\u1ee5 ch\u1ecdn t\u1ea1i m\u1ee5c Form Control\u00a0\u0111\u1ec3 v\u1ebd Checkbox)<\/p>\n

M\u1ed7i check box s\u1ebd c\u00f3 kh\u1ea3 n\u0103ng li\u00ean k\u1ebft t\u1edbi 1 v\u1ecb tr\u00ed x\u00e1c\u00a0\u0111\u1ecbnh trong\u00a0Excel\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c Checkbox\u00a0\u0111\u00f3\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c Check hay ch\u01b0a (uncheck)<\/p>\n

<\/p>\n

Nh\u01b0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y,\u00a0\u00f4 Check box\u00a0\u0111\u01b0\u1ee3c li\u00ean k\u1ebft t\u1edbi v\u1ecb tr\u00ed\u00a0\u00f4 E3, k\u1ebft qu\u1ea3 l\u00e0 Unchecked (ch\u01b0a\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh d\u1ea5u),\u00a0\u0111\u1ed3ng th\u1eddi k\u1ebft qu\u1ea3 t\u1ea1i\u00a0\u00f4 E3 cho gi\u00e1 tr\u1ecb l\u00e0 FALSE<\/p>\n

N\u1ebfu Check box\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh d\u1ea5u th\u00ec s\u1ebd cho k\u1ebft qu\u1ea3 l\u00e0 TRUE t\u1ea1i\u00a0\u00f4 m\u00e0 n\u00f3 li\u00ean k\u1ebft t\u1edbi.<\/p>\n

\n

T\u00ecm hi\u1ec3u ngay:<\/strong> T\u1ed5ng h\u1ee3p c\u00e1c b\u00e0i h\u01b0\u1edbng d\u1eabn v\u1ec1\u00a0Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n

B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb TRUE\u00a0\/ FALSE<\/strong><\/p>\n

C\u1ea5u tr\u00fac h\u00e0m COUNTIF(Range, Criteria)<\/p>\n

Range l\u00e0 v\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 checkbox li\u00ean k\u1ebft t\u1edbi. V\u00f9ng n\u00e0y n\u00ean s\u1eafp x\u1ebfp th\u1ed1ng nh\u1ea5t v\u00e0o 1 c\u1ed9t\u00a0\u0111\u1ec3 d\u1ec5 d\u00e0ng h\u01a1n trong vi\u1ec7c d\u00f9ng c\u00f4ng th\u1ee9c.\u00a0\u1ede\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 v\u00f9ng t\u1eeb E2:E6<\/p>\n

Criteria l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n\u00a0\u0111\u1ebfm.\u00a0\u1ede\u00a0\u0111\u00e2y c\u00f3 2 gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE, ch\u00fang ta\u00a0\u0111\u1ebfm cho gi\u00e1 tr\u1ecb TRUE\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh xem Check box n\u00e0o\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn<\/p>\n

\n

E8 = COUNTIF(E2:E6,TRUE)<\/p>\n<\/blockquote>\n

Trong\u00a0Excel, gi\u00e1 tr\u1ecb TRUE \/ FALSE\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c\u00a0Excel quy\u00a0\u0111\u1ecbnh s\u1eb5n v\u1ec1 c\u00e1ch hi\u1ec3u, do\u00a0\u0111\u00f3 kh\u00f4ng c\u1ea7n ph\u1ea3i\u00a0\u0111\u1eb7t t\u1eeb TRUE v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p m\u00e0 ch\u00fang ta c\u00f3\u00a0 th\u1ec3 s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c.<\/p>\n

<\/p>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm cho c\u00e1c gi\u00e1 tr\u1ecb FALSE cho c\u00e1c\u00a0\u00f4 checkbox kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

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

Thao t\u00e1c\u00a0\u0111\u1ebfm b\u1eb1ng COUNTIF<\/a> r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n\u00a0\u0111\u00fang kh\u00f4ng n\u00e0o. Khi k\u1ebft h\u1ee3p v\u1edbi Checkbox\u00a0\u0111em l\u1ea1i hi\u1ec7u qu\u1ea3 kh\u00e1 cao trong vi\u1ec7c tr\u00ecnh b\u00e0y\u00a0trong\u00a0excel\u00a0\u0111\u00f3 b\u1ea1n.<\/p>\n

Ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u1ee9ng d\u1ee5ng vi\u1ec7c n\u00e0y trong c\u00e1c n\u1ed9i dung s\u1eed d\u1ee5ng nhi\u1ec1u checkbox, c\u1ea7n ki\u1ec3m so\u00e1t s\u1ed1 l\u01b0\u1ee3ng checkbox\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

Ho\u1eb7c\u00a0\u1ee9ng d\u1ee5ng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p ch\u1ea5m\u00a0\u0111i\u1ec3m tr\u1eafc nghi\u1ec7m d\u1ea1ng\u00a0\u0111\u00fang \/ sai<\/p>\n

Nh\u01b0 v\u00e2\u0323y, blog.hocexcel.online \u0111a\u0303 gi\u1edbi thi\u1ec7u \u0111\u1ebfn c\u00e1c b\u1ea1n\u00a0\u1ee9nng d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm gi\u00e1 tr\u1ecb \u0111\u00fang sai m\u00f4\u0323t ca\u0301c chi ti\u00ea\u0301t va\u0300 hi\u00ea\u0323u qua\u0309. N\u00ea\u0301u co\u0301 b\u00e2\u0301t ky\u0300 th\u0103\u0301c m\u0103\u0301c gi\u0300 ha\u0303y comment ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 \u0111\u01b0\u01a1\u0323c \u0111\u00f4\u0323i ngu\u0303 nh\u00e2n vi\u00ean co\u0301 nhi\u00ea\u0300u n\u0103m kinh se\u0303 gia\u0309i quy\u00ea\u0301t th\u0103\u0301c m\u0103\u0301c cu\u0309a ba\u0323n trong th\u01a1\u0300i gian s\u01a1\u0301m nh\u00e2\u0301t.<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n

Xem ngay:\u00a0h\u1ecdc Excel k\u1ebf to\u00e1n \u01a1\u0309 Ha\u0300 N\u00f4\u0323i<\/a>\u00a0v\u1edbi c\u00e1c chuy\u00ean gia<\/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":10765,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10764","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\/10764","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=10764"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10765"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}