{"id":6649,"date":"2024-12-21T15:51:42","date_gmt":"2024-12-21T15:51:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien\/"},"modified":"2024-12-21T15:51:42","modified_gmt":"2024-12-21T15:51:42","slug":"so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien\/","title":{"rendered":"So s\u00e1nh h\u00e0m COUNTIFS v\u1edbi SUMPRODUCT trong vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi n\u00f3i t\u1edbi y\u00eau c\u1ea7u \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta th\u01b0\u1eddng ngh\u0129 ngay t\u1edbi h\u00e0m \u0111\u1ebfm <a href=\"http:\/\/blog.ezworkapp.com\/ham-countifs-dem-theo-nhieu-dieu-kien.html\">COUNTIFS<\/a>. Nh\u01b0ng khi t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m SUMPRODUCT th\u00ec ch\u00fang ta l\u1ea1i bi\u1ebft \u0111\u01b0\u1ee3c r\u1eb1ng h\u00e0m n\u00e0y c\u00f3 th\u1ec3 thay th\u1ebf COUNTIFS trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p. \u0110\u1ec3 tr\u1ea3 l\u1eddi cho c\u00e2u h\u1ecfi tr\u01b0\u1eddng h\u1ee3p n\u00e0o th\u00ec d\u00f9ng COUNTIFS, tr\u01b0\u1eddng h\u1ee3p n\u00e0o th\u00ec d\u00f9ng SUMPRODUCT th\u00ec ch\u00fang ta h\u00e3y c\u00f9ng\u00a0So s\u00e1nh COUNTIFS v\u1edbi SUMPRODUCT trong vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>Ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y th\u00f4ng qua v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19719\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-sanh-sumproduct-countifs-de-bai.png\" width=\"1371\" height=\"491\" title=\"so-sanh-sumproduct-countifs-de-bai\"><\/p>\n<p>Trong b\u00e0i h\u1ecdc tr\u01b0\u1edbc ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho 2 y\u00eau c\u1ea7u n\u00e0y. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd kh\u00f4ng t\u00ecm hi\u1ec3u vi\u1ec7c vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 th\u1ebf n\u00e0o, b\u1edfi c\u00e1c n\u1ed9i dung n\u00e0y \u0111\u00e3 c\u00f3 nh\u1eefng b\u00e0i vi\u1ebft r\u1ea5t chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 r\u1ed3i. M\u1ee5c ti\u00eau c\u1ee7a b\u00e0i l\u00e0 gi\u00fap c\u00e1c b\u1ea1n ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c \u01b0u nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a 2 c\u00e1ch l\u00e0m n\u00e0y \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng\u00a0cho ph\u00f9 h\u1ee3p.<\/p>\n<p>K\u1ebft qu\u1ea3 v\u00e0 n\u1ed9i dung c\u1ee7a c\u00e1c h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<p><strong>Y\u00eau c\u1ea7u 1<\/strong><\/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-596.gif\" title=\"ex101_92019-nho-596\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">H2=COUNTIFS(C2:C18,\u201dCam\u201d,A2:A18,\u201d&gt;=\u201d&amp;DATE(2018,6,1),A2:A18,\u201d&lt;=\u201d&amp;DATE(2018,6,30))<\/p>\n<p style=\"padding-left: 30px\">I2=SUMPRODUCT((C2:C18=\u201dCam\u201d)*(MONTH(A2:A18)=6)*1)<\/p>\n<p>Y\u00eau c\u1ea7u 2<\/p>\n<p style=\"padding-left: 30px\">H4=COUNTIFS(C2:C18,\u201dT\u00e1o\u201d,A2:A18,\u201d&gt;=\u201d&amp;DATE(2018,6,1),A2:A18,\u201d&lt;=\u201d&amp;DATE(2018,6,30),B2:B18,1)<\/p>\n<p style=\"padding-left: 30px\">I4=SUMPRODUCT((C2:C18=\u201dCam\u201d)*(MONTH(A2:A18)=6)*(B2:B18=1)*1)<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766e40d62252\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html#Dung_ham_COUNTIFS\" title=\"D\u00f9ng h\u00e0m COUNTIFS:\">D\u00f9ng h\u00e0m COUNTIFS:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html#Dung_ham_SUMPRODUCT\" title=\"D\u00f9ng h\u00e0m SUMPRODUCT:\">D\u00f9ng h\u00e0m SUMPRODUCT:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dung_ham_COUNTIFS\"><\/span>D\u00f9ng h\u00e0m COUNTIFS:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u01afu \u0111i\u1ec3m<\/strong>:<\/p>\n<ul>\n<li>C\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m \u0111\u01b0\u1ee3c ph\u00e2n bi\u1ec7t b\u1edfi d\u1ea5u ph\u1ea9y n\u00ean r\u1ea5t r\u00f5 r\u00e0ng, d\u1ec5 s\u1eeda, d\u1ec5 ki\u1ec3m tra c\u00f4ng th\u1ee9c.<\/li>\n<li>Khi t\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u l\u1edbn v\u00e0 nhi\u1ec1u c\u00f4ng th\u1ee9c th\u00ec t\u00ednh nhanh h\u01a1n so v\u1edbi h\u00e0m Sumproduct<\/li>\n<\/ul>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/strong>: Khi ph\u1ea3i t\u00ednh v\u1edbi 1 th\u00e0nh ph\u1ea7n trong m\u1ea3ng (v\u00ed d\u1ee5 nh\u01b0 t\u00ednh gi\u00e1 tr\u1ecb Th\u00e1ng \u1edf c\u1ed9t Ng\u00e0y) th\u00ec kh\u00f4ng t\u00ednh tr\u1ef1c ti\u1ebfp \u0111\u01b0\u1ee3c m\u00e0 ph\u1ea3i th\u00f4ng qua gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u1ea7u th\u00e1ng v\u00e0 ng\u00e0y cu\u1ed1i th\u00e1ng \u0111\u00f3 (ho\u1eb7c ph\u1ea3i t\u1ea1o c\u1ed9t ph\u1ee5 \u0111\u1ec3 t\u00e1ch gi\u00e1 tr\u1ecb th\u00e1ng)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dung_ham_SUMPRODUCT\"><\/span>D\u00f9ng h\u00e0m SUMPRODUCT:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u01afu \u0111i\u1ec3m: <\/strong><\/p>\n<ul>\n<li>Vi\u1ebft nhanh v\u00e0 g\u1ecdn h\u01a1n h\u01a1n so v\u1edbi h\u00e0m COUNTIFS<\/li>\n<li>T\u00ednh \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng cho \u0111\u1ed1i t\u01b0\u1ee3ng m\u1ea3ng, x\u00e9t 1 ph\u1ea7n d\u1eef li\u1ec7u trong m\u1ea3ng<\/li>\n<\/ul>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m: <\/strong><\/p>\n<ul>\n<li>Ph\u1ea3i hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u t\u1ea1o ra b\u1edfi t\u1eebng th\u00e0nh ph\u1ea7n trong m\u1ea3ng th\u00ec m\u1edbi ra k\u1ebft qu\u1ea3 \u0111\u00fang<\/li>\n<li>T\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u l\u1edbn v\u00e0 nhi\u1ec1u c\u00f4ng th\u1ee9c th\u00ec ch\u1eadm h\u01a1n so v\u1edbi COUNTIFS<\/li>\n<li>N\u1ebfu trong v\u00f9ng d\u1eef li\u1ec7u c\u00f3 l\u1ed7i b\u1ea5t k\u1ef3 t\u1ea1i v\u1ecb tr\u00ed n\u00e0o th\u00ec k\u1ebft qu\u1ea3 s\u1ebd ra l\u1ed7i, trong khi h\u00e0m COUNTIFS b\u1ecf qua l\u1ed7i v\u00e0 t\u00ednh v\u1eabn \u0111\u00fang<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19721\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-sanh-sumproduct-countifs-loi-tai-sumproduct.png\" width=\"1374\" height=\"492\" title=\"so-sanh-sumproduct-countifs-loi-tai-sumproduct\"><\/p>\n<p>Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 k\u1ebft lu\u1eadn nh\u01b0 sau:<\/p>\n<ul>\n<li>Trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi \u0111\u1ed1i t\u01b0\u1ee3ng m\u1ea3ng th\u00ec n\u00ean d\u00f9ng h\u00e0m COUNTIFS<\/li>\n<li>Kh\u00f4ng n\u00ean d\u00f9ng SUMPRODUCT qu\u00e1 nhi\u1ec1u b\u1edfi ch\u1ec9 1 l\u1ed7i nh\u1ecf trong b\u1ea3ng d\u1eef li\u1ec7u c\u0169ng c\u00f3 th\u1ec3 khi\u1ebfn c\u00f4ng th\u1ee9c b\u00e1o l\u1ed7i. Ch\u1ec9 n\u00ean d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p nh\u1ecf, l\u1ebb ho\u1eb7c khi kh\u00f4ng th\u1ec3 d\u00f9ng \u0111\u01b0\u1ee3c COUNTIFS<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2tS4BcK\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-596.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6650,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6649","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\/6649","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=6649"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6649\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6650"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}