{"id":5167,"date":"2024-12-09T12:19:45","date_gmt":"2024-12-09T12:19:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-dcounta\/"},"modified":"2024-12-09T12:19:45","modified_gmt":"2024-12-09T12:19:45","slug":"4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-dcounta","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-dcounta\/","title":{"rendered":"4 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ho\u1eb7c \u2013 H\u00e0m DCOUNTA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c\u00a0\u0111\u1ebfm nh\u1eefng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n theo m\u1ed9t v\u00e0i\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u1ea5t\u00a0\u0111\u1ecbnh trong\u00a0Excel l\u00e0 c\u00f4ng vi\u1ec7c ch\u00fang ta th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi l\u00e0m vi\u1ec7c. Nh\u01b0ng vi\u1ec7c \u201ct\u1eadp\u00a0\u0111\u1ebfm\u201d kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng d\u1ec5 l\u00e0m,\u00a0\u0111\u1eb7c bi\u1ec7t khi ph\u1ea3i\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. Trong ch\u00f9m b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc\u00a0Excel Online s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch x\u1eed l\u00fd v\u1edbi vi\u1ec7c\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng HO\u1eb6C.\u00a0\u0110\u00e2y l\u00e0 d\u1ea1ng\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00f3 nh\u1ea5t trong vi\u1ec7c\u00a0\u0111\u1ebfm. Ch\u00fang ta s\u1ebd gi\u1ea3i quy\u1ebft y\u00eau c\u1ea7u n\u00e0y kh\u00f4ng ch\u1ec9 v\u1edbi 1 c\u00e1ch m\u00e0 c\u00f3 t\u1edbi 4 c\u00e1ch kh\u00e1c nhau. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch n\u00e0y nh\u00e9:<\/p>\n<p><strong>Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta nh\u01b0 sau<\/strong>:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14788\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-count-multi-or-criteria-01-2.png\" width=\"418\" height=\"373\" title=\"heo-count-multi-or-criteria-01-2\"><\/p>\n<p>\u0110\u1ebfm S\u1ed1 ng\u01b0\u1eddi c\u00f3 gi\u1edbi t\u00ednh l\u00e0 nam c\u00f3 tu\u1ed5i t\u1eeb 20 tr\u1edf l\u00ean, ho\u1eb7c c\u00f3 s\u1ed1 th\u1ebb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 50<\/p>\n<h2>Ph\u01b0\u01a1ng ph\u00e1p th\u1ee9\u00a02: S\u1eed d\u00f9ng h\u00e0m DCOUNTA<\/h2>\n<p>DCOUNTA l\u00e0 m\u1ed9t h\u00e0m n\u1eb1m trong chu\u1ed7i h\u00e0m v\u1ec1 Database, d\u00f9ng v\u1edbi m\u1ee5c\u00a0\u0111\u00edch x\u1eed l\u00fd d\u1eef li\u1ec7u n\u1eb1m trong 1 c\u01a1 s\u1edf d\u1eef li\u1ec7u. T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m DCOUNTA l\u00e0 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong m\u1ed9t c\u1ed9t c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u theo 1 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u1ea7n x\u00e2y d\u1ef1ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 s\u1eed d\u1ee5ng trong h\u00e0m DCOUNTA. Nguy\u00ean t\u1eafc x\u00e2y d\u1ef1ng \u0111i\u1ec1u ki\u1ec7n ch\u00ednh l\u00e0: t\u1ed5 h\u1ee3p c\u1ee7a nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng HO\u1eb6C<\/p>\n<p>Ta c\u00f3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/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-439.gif\" title=\"ex101_92019-nho-439\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Gi\u1edbi t\u00ednh l\u00e0 Nam<\/li>\n<li>Tu\u1ed5i &gt;=20<\/li>\n<li>S\u1ed1 th\u1ebb &gt;=50<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u00f3 3 \u0111i\u1ec1u ki\u1ec7n, v\u00e0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u00e0y kh\u00f4ng ph\u1ea3i \u0111\u1ed3ng th\u1eddi v\u1edbi nhau (d\u1ea1ng Ho\u1eb7c).<\/p>\n<p>C\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14868\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-count-multi-or-criteria-02-1.png\" width=\"278\" height=\"105\" title=\"heo-count-multi-or-criteria-02-1\"><\/p>\n<p>Y\u00eau c\u1ea7u v\u1ec1 \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng trong h\u00e0m C\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00f3 l\u00e0:<\/p>\n<ul>\n<li>Ph\u1ea3i bao g\u1ed3m ti\u00eau \u0111\u1ec1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi d\u00f2ng ti\u00eau \u0111\u1ec1 trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n d\u1ea1ng V\u00c0: c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t tr\u00ean c\u00f9ng 1 d\u00f2ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n d\u1ea1ng HO\u1eb6C: c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t kh\u00e1c d\u00f2ng, m\u1ed7i \u0111i\u1ec1u ki\u1ec7n tr\u00ean 1 d\u00f2ng<\/li>\n<\/ul>\n<p>C\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m DCOUNTA nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>database<\/strong>: V\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u l\u00e0m c\u01a1 s\u1edf t\u00ednh to\u00e1n: v\u00f9ng b\u1ea3ng g\u1ed3m c\u1ea3 d\u00f2ng ti\u00eau \u0111\u1ec1 A1:D13<\/li>\n<li><strong>field<\/strong>: th\u1ee9 t\u1ef1 c\u1ed9t trong v\u00f9ng b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u ch\u1ee9a n\u1ed9i dung c\u1ea7n \u0111\u1ebfm, \u1edf \u0111\u00e2y c\u00f3 th\u1ec3 \u0111\u1ebfm theo c\u1ed9t T\u00ean l\u00e0 c\u1ed9t th\u1ee9 1 trong b\u1ea3ng<\/li>\n<li><strong>criteria<\/strong>: \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ebfm, ch\u00ednh l\u00e0 v\u00f9ng b\u1ea3ng \u0111i\u1ec1u ki\u1ec7n v\u1eeba x\u00e2y d\u1ef1ng \u0111\u01b0\u1ee3c. V\u00ed d\u1ee5 ch\u00fang ta \u0111\u1eb7t v\u00f9ng b\u1ea3ng n\u00e0y trong v\u00f9ng F3:H6 (g\u1ed3m 3 c\u1ed9t, 3 h\u00e0ng)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14870\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-count-multi-or-criteria-03.png\" width=\"910\" height=\"390\" title=\"heo-count-multi-or-criteria-03\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u00fang r\u1ed3i.<\/p>\n<p><strong>\u01afu \u0111i\u1ec3m<\/strong><\/p>\n<ul>\n<li>C\u1ea5u tr\u00fac h\u00e0m \u0111\u01a1n gi\u1ea3n, d\u1ec5 vi\u1ebft<\/li>\n<li>K\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c ngay ch\u1ec9 v\u1edbi 1 h\u00e0m<\/li>\n<li>Kh\u00f4ng c\u1ea7n t\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng<\/li>\n<\/ul>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/strong><\/p>\n<ul>\n<li>X\u00e2y d\u1ef1ng \u0111i\u1ec1u ki\u1ec7n r\u1ea5t quan tr\u1ecdng. Ph\u1ea3i hi\u1ec3u \u0111\u00fang v\u1ec1 c\u00e1ch x\u00e2y d\u1ef1ng v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u00ec m\u1edbi c\u00f3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c<\/li>\n<li>Kh\u00f4ng filldown (copy c\u00f4ng th\u1ee9c) m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp \u0111\u01b0\u1ee3c =&gt; H\u1ea1n ch\u1ebf d\u00f9ng khi ph\u1ea3i t\u00ednh to\u00e1n nhi\u1ec1u\u00a0c\u00f3 s\u1ef1 thay \u0111\u1ed5i v\u1ec1\u00a0\u0111i\u1ec1u ki\u1ec7n<\/li>\n<\/ul>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel 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\/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-439.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5167","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\/5167","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=5167"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5168"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}