{"id":5726,"date":"2024-12-20T13:54:35","date_gmt":"2024-12-20T13:54:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/nhung-bai-viet-hay-ve-viec-ung-dung-ham-sumproduct\/"},"modified":"2024-12-20T13:54:35","modified_gmt":"2024-12-20T13:54:35","slug":"nhung-bai-viet-hay-ve-viec-ung-dung-ham-sumproduct","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/nhung-bai-viet-hay-ve-viec-ung-dung-ham-sumproduct\/","title":{"rendered":"Nh\u1eefng b\u00e0i vi\u1ebft hay v\u1ec1 vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m SUMPRODUCT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Ch\u00e0o c\u00e1c b\u1ea1n,<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">H\u00e0m SUMPRODUCT<\/a> l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t h\u1eefu d\u1ee5ng trong\u00a0Excel, c\u00f3 th\u1ec3 thay th\u1ebf\u00a0\u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u h\u00e0m kh\u00e1c.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, blog.hocexcel.online s\u1ebd t\u1ed5ng k\u1ebft l\u1ea1i nh\u1eefng b\u00e0i vi\u1ebft hay v\u1ec1 h\u00e0m SUMPRODUCT\u00a0\u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ti\u1ec7n theo d\u00f5i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12225 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhe1bbafng-bc3a0i-vie1babft-hay-ve1bb81-vie1bb87c-e1bba9ng-de1bba5ng-hc3a0m-sumproduct.jpg\" width=\"1040\" height=\"666\" title=\"nhe1bbafng-bc3a0i-vie1babft-hay-ve1bb81-vie1bb87c-e1bba9ng-de1bba5ng-hc3a0m-sumproduct\"><\/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-6765771a60257\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhung-bai-viet-hay-ve-viec-ung-dung-ham-sumproduct.html#Ung_dung_trong_ke_toan\" title=\"\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n\">\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/nhung-bai-viet-hay-ve-viec-ung-dung-ham-sumproduct.html#Ung_dung_trong_cac_cong_viec_chung\" title=\"\u1ee8ng d\u1ee5ng trong c\u00e1c c\u00f4ng vi\u1ec7c chung\">\u1ee8ng d\u1ee5ng trong c\u00e1c c\u00f4ng vi\u1ec7c chung<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_trong_ke_toan\"><\/span>\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Seri b\u00e0i vi\u1ebft g\u1ed3m 4 ph\u1ea7n, c\u1ee7a gi\u1ea3ng vi\u00ean <strong>D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/strong>, m\u00f4 t\u1ea3 v\u00e0 ph\u00e2n t\u00edch\u00a0\u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n:<\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-ung-dung-ham-sumproduct-phan-1.html\">Ph\u1ea7n 1: C\u1ea5u tr\u00fac h\u00e0m SUMPRODUCT,\u00a0\u1ee9ng d\u1ee5ng v\u00e0o vi\u1ec7c t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, so s\u00e1nh v\u1edbi h\u00e0m SUMIFS<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-ung-dung-ham-sumproduct-phan-2.html\">Ph\u1ea7n 2:\u00a0T\u00ednh t\u1ed5ng ph\u00e1t sinh c\u1ee7a t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p d\u1ef1a tr\u00ean ghi s\u1ed5 c\u1ee7a t\u00e0i kho\u1ea3n chi ti\u1ebft<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-ung-dung-ham-sumproduct-phan-3.html\">Ph\u1ea7n 3:\u00a0\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong k\u1ebf to\u00e1n kho<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-ke-toan-ung-dung-ham-sumproduct-phan-4.html\">Ph\u1ea7n 4:\u00a0\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng: x\u1eed l\u00fd d\u1eef li\u1ec7u m\u00e1y ch\u1ea5m c\u00f4ng<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-ung-dung-ham-sumproduct-de-tinh-cong-no.html\">Video h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT\u00a0\u0111\u1ec3 t\u00ednh c\u00f4ng n\u1ee3 c\u1ee7a th\u1ea7y Thanh<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cham-cong-di-lam-muon.html\">\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong vi\u1ec7c ch\u1ea5m c\u00f4ng\u00a0\u0111i l\u00e0m mu\u1ed9n tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/xay-dung-cong-thuc-tinh-bao-cao-chi-phi-tien-luong-theo-bo-phan.html\">\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o chi ph\u00ed ti\u1ec1n l\u01b0\u01a1ng theo b\u1ed9 ph\u1eadn<\/a><\/li>\n<\/ul>\n<p>* Kh\u00f3a h\u1ecdc li\u00ean quan:<\/p>\n<ul>\n<li>TL01 \u2013\u00a0\u1ee8ng d\u1ee5ng\u00a0Excel v\u00e0 VBA v\u00e0o c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng v\u00e0 h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1<\/li>\n<li>IM101 \u2013 T\u1ef1 t\u1ea1o ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd kho v\u1edbi\u00a0Excel v\u00e0 VBA<\/li>\n<li>EX301 \u2013\u00a0\u1ee8ng d\u1ee5ng qu\u1ea3n l\u00fd c\u00f4ng n\u1ee3 v\u1edbi\u00a0Excel v\u00e0 VBA<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Ho\u0323c excel k\u1ebf to\u00e1n b\u00e1n h\u00e0ng<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_trong_cac_cong_viec_chung\"><\/span>\u1ee8ng d\u1ee5ng trong c\u00e1c c\u00f4ng vi\u1ec7c chung<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-sumproduct-trong-excel.html\">C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong\u00a0Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">H\u00e0m SUMPRODUCT \u2013 C\u00e1ch s\u1eed d\u1ee5ng v\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5\u00a0\u00e1p d\u1ee5ng<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-trong-so-trong-excel-bang-ham-sum-hoac-sumproduct.html\">C\u00e1ch t\u00ednh trung b\u00ecnh tr\u1ecdng s\u1ed1 trong\u00a0Excel b\u1eb1ng h\u00e0m SUMPRODUCT<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/47-%E2%97%8F-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\">H\u00e0m SUMPRODUCT v\u00e0 s\u1ef1 kh\u00e1c nhau so v\u1edbi h\u00e0m SUMIFS, COUNTIFS<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-co-dieu-kien-mot-gia-tri-cu-trong-nhieu-trang-tinh.html\">C\u00e1ch\u00a0\u0111\u1ebfm c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong nhi\u1ec1u trang t\u00ednh<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-tim-va-chon-dong-trung-nhau-trong-mot-day-du-lieu-trong-excel.html\">C\u00e1ch t\u00ecm v\u00e0 ch\u1ecdn d\u00f2ng tr\u00f9ng nhau trong m\u1ed9t d\u00e3y d\u1eef li\u1ec7u trong\u00a0Excel<\/a><\/li>\n<\/ul>\n<p>* Kh\u00f3a h\u1ecdc li\u00ean quan<\/p>\n<ul>\n<li>EX101 \u2013\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi\u00a0\u0111i l\u00e0m<\/li>\n<li>VBA101 \u2013\u00a0T\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a\u00a0Excel v\u00e0 VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft\u00a0\u0111\u1ea7u<\/li>\n<li>VBA201 \u2013 L\u1eadp tr\u00ecnh VBA n\u00e2ng cao trong\u00a0Excel<\/li>\n<\/ul>\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<p>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<p><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=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/09\/EX101_92019-nho.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5726","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\/5726","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=5726"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5726\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5727"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}