{"id":24210,"date":"2021-05-08T15:05:03","date_gmt":"2021-05-08T08:05:03","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24210"},"modified":"2021-05-08T15:05:03","modified_gmt":"2021-05-08T08:05:03","slug":"ham-countifs-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-countifs-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel"},"content":{"rendered":"<p><strong>H\u00e0m Countifs trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m th\u1ed1ng k\u00ea, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 \u0111\u00e1p \u1ee9ng m\u1ed9t ho\u1eb7c nhi\u1ec1u ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. B\u00e0i vi\u1ebft sau \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u0169ng nh\u01b0 c\u00fa ph\u00e1p <strong>h\u00e0m Countifs trong Excel<\/strong>. B\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h2><strong>H\u00e0m Countif v\u00e0 h\u00e0m Countifs trong Excel<\/strong><\/h2>\n<p><strong>H\u00e0m Countifs trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm \u00f4 th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. \u0110\u00e2y l\u00e0 h\u00e0m Excel cao c\u1ea5p c\u1ee7a h\u00e0m Counif, ch\u1ec9 \u0111\u1ebfm \u00f4 v\u1edbi 1 \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/p>\n<p>\u0110i\u1ec3m kh\u00e1c bi\u1ec7t l\u1edbn nh\u1ea5t gi\u1eefa h\u00e0m Countif v\u00e0 <strong>h\u00e0m Countifs trong Excel<\/strong> l\u00e0 h\u00e0m Countif \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, ti\u00eau ch\u00ed duy nh\u1ea5t trong ph\u1ea1m vi \u00f4. Ng\u01b0\u1ee3c l\u1ea1i, h\u00e0m Countifs c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c ti\u00eau ch\u00ed kh\u00e1c nhau trong c\u00f9ng ho\u1eb7c c\u00e1c ph\u1ea1m vi kh\u00e1c nhau.<\/p>\n<figure id=\"attachment_24211\" aria-describedby=\"caption-attachment-24211\" style=\"width: 1280px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"720\" class=\"wp-image-24211 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel.jpg\" alt=\"h\u00e0m Countifs trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel.jpg 1280w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel-300x169.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel-1024x576.jpg 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel-768x432.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel-750x422.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-countifs-trong-excel-1140x641.jpg 1140w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><figcaption id=\"caption-attachment-24211\" class=\"wp-caption-text\">h\u00e0m Countifs trong Excel<\/figcaption><\/figure>\n<h3><strong>C\u00fa ph\u00e1p h\u00e0m Countifs trong Excel<\/strong><\/h3>\n<p><strong>H\u00e0m Countifs trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]\u2026)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3 h\u00e0m COUNTIFS s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 sau:<\/p>\n<p><strong>\u2013 Criteria_range1<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 v\u00f9ng ch\u1ecdn \u0111\u1ea7u ti\u00ean c\u1ea7n th\u1ed1ng k\u00ea.<\/p>\n<p><strong>\u2013 Criteria1<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ki\u1ec3m tra d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 \u1edf d\u1ea1ng s\u1ed1, bi\u1ec3u th\u1ee9c, tham chi\u1ebfu \u00f4 ho\u1eb7c v\u0103n b\u1ea3n.<\/p>\n<p><strong>\u2013 Criteria_range2, criteria2, \u2026<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): l\u00e0 c\u00e1c v\u1eb7p v\u00f9ng ch\u1ecdn v\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung. H\u00e0m Countifs cho ph\u00e9p tham s\u1ed1 n\u00e0y t\u1ed1i \u0111a l\u00ean \u0111\u1ebfn 127 c\u1eb7p ph\u1ea1m vi \/ ti\u00eau ch\u00ed.<\/p>\n<p>C\u00e1c ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho c\u00f3 th\u1ec3 l\u00e0:<\/p>\n<ul>\n<li>L\u00e0 gi\u00e1 tr\u1ecb s\u1ed1, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 nguy\u00ean, s\u1ed1 th\u1eadp ph\u00e2n, ng\u00e0y th\u00e1ng ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb logic.<\/li>\n<li>Chu\u1ed7i v\u0103n b\u1ea3n, c\u00f3 th\u1ec3 bao g\u1ed3m c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ch\u1eb3ng h\u1ea1n nh\u01b0 d\u1ea5u h\u1ecfi ch\u1ea5m, d\u1ea5u hoa th\u1ecb, \u2026 .<\/li>\n<\/ul>\n<h3><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel<\/strong><\/h3>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Countifs Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h3><strong>V\u00ed d\u1ee5 1<\/strong><\/h3>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"358\" class=\"aligncenter wp-image-17513 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-35.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-35-300x154.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-35.jpg 698w\" alt=\"1 35 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel - Ben Computer\" \/><\/p>\n<p>Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ebfm c\u00e1c m\u1eb7t h\u00e0ng trong kho (gi\u00e1 tr\u1ecb trong c\u1ed9t C l\u1edbn h\u01a1n 0) nh\u01b0ng ch\u01b0a \u0111\u01b0\u1ee3c b\u00e1n (gi\u00e1 tr\u1ecb c\u1ed9t D b\u1eb1ng 0).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"761\" height=\"467\" class=\"aligncenter wp-image-17514 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-32.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-32-300x184.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-32-750x460.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-32.jpg 761w\" alt=\"2 32 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel - Ben Computer\" \/><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, Brown Bread l\u00e0 m\u1eb7t h\u00e0ng duy nh\u1ea5t ch\u01b0a \u0111\u01b0\u1ee3c b\u00e1n. H\u00e0m Countifs s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"481\" class=\"aligncenter wp-image-17515 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-21.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-21-300x196.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-21.jpg 735w\" alt=\"3 21 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel - Ben Computer\" \/><\/p>\n<h3><strong>V\u00ed d\u1ee5 2<\/strong><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u00ecm s\u1ed1 h\u1ecdc sinh \u0111\u1ea1t tr\u00ean 85 \u0111i\u1ec3m trong c\u1ea3 2 k\u1ef3. Trong \u0111\u00f3 s\u1ed1 \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh trong k\u1ef3 1 \u0111\u01b0\u1ee3c l\u01b0u trong c\u1ed9t B v\u00e0 k\u1ef3 2 l\u00e0 trong c\u1ed9t C. C\u00f4ng th\u1ee9c h\u00e0m Countifs \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh \u0111\u1ea1t tr\u00ean 85 \u0111i\u1ec3m trong c\u1ea3 2 k\u1ef3 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"341\" class=\"aligncenter wp-image-17516 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-19.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-19-300x186.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-19.png 549w\" alt=\"4 19 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 h\u00e0m Countifs tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"339\" class=\"aligncenter wp-image-17517 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-14.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-14-300x198.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-14.png 514w\" alt=\"5 14 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel - Ben Computer\" \/><\/p>\n<h3><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Countifs Excel<\/strong><\/h3>\n<p>\u2013 H\u00e0m Countifs c\u00f3 s\u1eb5n tr\u00ean Excel 2000 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n.<\/p>\n<p>\u2013 H\u00e0m Countifs tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! n\u1ebfu:<\/p>\n<ul>\n<li>C\u00e1c m\u1ea3ng criteria_range \u0111\u00e3 cho \u0111\u1ed9 d\u00e0i kh\u00f4ng b\u1eb1ng nhau.<\/li>\n<li>C\u00e1c tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho l\u00e0 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n d\u00e0i h\u01a1n 255 k\u00fd t\u1ef1.<\/li>\n<\/ul>\n<p>\u2013 N\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 tham chi\u1ebfu \u0111\u1ebfn \u00f4 tr\u1ed1ng th\u00ec h\u00e0m Countifs s\u1ebd coi l\u00e0 0.<\/p>\n<p>\u2013 Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 d\u1ea5u hoa th\u1ecb hay d\u1ea5u h\u1ecfi ch\u1ea5m. Trong \u0111\u00f3 k\u00fd t\u1ef1 d\u1ea5u ? \u0111\u1ec3 thay th\u1ebf cho k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3 v\u00e0 k\u00fd t\u1ef1 d\u1ea5u * thay th\u1ebf cho c\u1ea3 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/p>\n<p><strong>L\u01b0u \u00fd quan tr\u1ecdng<\/strong>: \u0110\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1ea5u h\u1ecfi ho\u1eb7c d\u1ea5u hoa th\u1ecb, ch\u00fang ta s\u1ebd nh\u1eadp d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc d\u1ea5u hoa th\u1ecb ho\u1eb7c d\u1ea5u h\u1ecfi ch\u1ea5m (?).<\/p>\n<p>\u2013 C\u00e1c v\u00f9ng ch\u1ecdn b\u1ed5 sung c\u1ea7n ph\u1ea3i c\u00f9ng s\u1ed1 h\u00e0ng, c\u1ed9t v\u1edbi v\u00f9ng criteria_range1. C\u00e1c v\u00f9ng n\u00e0y c\u00f3 th\u1ec3 t\u00e1ch r\u1eddi.<\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t t\u1ea7n t\u1eadt c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng<strong> h\u00e0m Countifs trong Excel<\/strong>. Hy v\u1ecdng sau b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 h\u00e0m Excel n\u00e0y. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1c h\u00e0m trong Excel nh\u00e9.<\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-right-trong-excel\/\">H\u00e0m Right trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-index-va-match\/\">H\u00e0m Index v\u00e0 match<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-tach-ten-trong-excel\/\">H\u00e0m t\u00e1ch t\u00ean trong Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Countifs trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m th\u1ed1ng k\u00ea, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 \u0111\u00e1p \u1ee9ng m\u1ed9t ho\u1eb7c nhi\u1ec1u ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. B\u00e0i vi\u1ebft sau \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u0169ng nh\u01b0 c\u00fa ph\u00e1p h\u00e0m Countifs trong Excel. B\u1ea1n \u0111\u1ecdc c\u00f9ng tham [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24211,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24210","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24210"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24210\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24211"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}