{"id":7825,"date":"2024-12-21T18:35:07","date_gmt":"2024-12-21T18:35:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dem-o-chua-gia-tri-nhat-dinh-voi-ham-sumproduct\/"},"modified":"2024-12-21T18:35:07","modified_gmt":"2024-12-21T18:35:07","slug":"huong-dan-dem-o-chua-gia-tri-nhat-dinh-voi-ham-sumproduct","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dem-o-chua-gia-tri-nhat-dinh-voi-ham-sumproduct\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ebfm \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh v\u1edbi h\u00e0m SUMPRODUCT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/bi-kip-vo-lam-sumproduct-than-chuong.html\">SUMPRODUCT<\/a>\u00a0<\/strong>c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng m\u1ea1nh m\u1ebd v\u00e0 h\u1eefu \u00edch cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. M\u1ed9t trong s\u1ed1 \u0111\u00f3 l\u00e0 \u0111\u00f3 l\u00e0 \u0111\u1ebfm \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh \u0111\u01b0\u1ee3c ng\u01b0\u1eddi d\u00f9ng nh\u1eadp v\u00e0o. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n gi\u1ea3i quy\u1ebft y\u00eau c\u1ea7u n\u00e0y.<\/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-67670a5a6c6db\" 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\/dem-o-chua-gia-tri-nhat-dinh-sumproduct.html#Su_dung_ket_hop_SUMPRODUCT_ISNUMBER_FIND_va_N_dem_o_chua_gia_tri_nhat_dinh\" title=\"S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p SUMPRODUCT, ISNUMBER, FIND v\u00e0 N \u0111\u1ebfm \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh\">S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p SUMPRODUCT, ISNUMBER, FIND v\u00e0 N \u0111\u1ebfm \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dem-o-chua-gia-tri-nhat-dinh-sumproduct.html#Tim_kiem_ki_tu_trong_chuoi_voi_ham_FIND\" title=\"T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 trong chu\u1ed7i v\u1edbi h\u00e0m FIND\">T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 trong chu\u1ed7i v\u1edbi h\u00e0m FIND<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_SUMPRODUCT_ISNUMBER_FIND_va_N_dem_o_chua_gia_tri_nhat_dinh\"><\/span>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p SUMPRODUCT, ISNUMBER, FIND v\u00e0 N \u0111\u1ebfm \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 nh\u01b0 b\u1ea3ng sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30588\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-o-chua-gia-tri-nhat-dinh-sumproduct-1.png\" width=\"440\" height=\"515\" title=\"dem-o-chua-gia-tri-nhat-dinh-sumproduct-1\"><\/p>\n<p>V\u1edbi b\u00e0i to\u00e1n tr\u00ean, ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng gi\u1ea3i quy\u1ebft b\u1eb1ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html?fbclid=IwAR1eLZwwQaMVPtFWEswl3aoSnk0Rd3W0_U2Ifotk7nscC-urVFrjBMevIHI\"><strong>h\u00e0m<\/strong>\u00a0<\/a><strong><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html?fbclid=IwAR1eLZwwQaMVPtFWEswl3aoSnk0Rd3W0_U2Ifotk7nscC-urVFrjBMevIHI\">COUNTIF<\/a>\u00a0<\/strong>k\u1ebft h\u1ee3p\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html\">k\u00ed t\u1ef1 Wildcard<\/a>.\u00a0<\/strong>Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi c\u00e1c tr\u01b0\u1eddng h\u1ee3p ph\u00e2n bi\u1ec7t ch\u1eef c\u00e1i hoa \u2013 th\u01b0\u1eddng, ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1ebd cho k\u1ebft qu\u1ea3 sai. C\u1ee5 th\u1ec3 khi thay \u0111\u1ed5i\u00a0<strong>A<\/strong> th\u00e0nh\u00a0<strong>a<\/strong>, vi\u1ec7c t\u00ednh to\u00e1n v\u1edbi COUNTIF kh\u00f4ng c\u00f2n ch\u00ednh x\u00e1c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30589\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-o-chua-gia-tri-nhat-dinh-sumproduct-2.png\" width=\"236\" height=\"468\" title=\"dem-o-chua-gia-tri-nhat-dinh-sumproduct-2\"><\/p>\n<p>Gi\u1ea3i ph\u00e1p c\u1ee7a ta \u1edf \u0111\u00e2y l\u00e0 s\u1eed d\u1ee5ng\u00a0k\u1ebft h\u1ee3p <strong>SUMPRODUCT\u00a0<\/strong>v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 sau:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tim_kiem_ki_tu_trong_chuoi_voi_ham_FIND\"><\/span>T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 trong chu\u1ed7i v\u1edbi h\u00e0m FIND<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Kh\u00e1c v\u1edbi <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\">h\u00e0m\u00a0SEARCH<\/a>, FIND<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n\u00a0<strong>c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa\/th\u01b0\u1eddng.\u00a0<\/strong>C\u1ee5 th\u1ec3 ta s\u1ebd t\u00ecm nh\u1eefng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb \u201ca\u201d trong v\u00f9ng A2:A17 v\u1edbi c\u00f4ng th\u1ee9c\u00a0<em>=FIND(\u201ca\u201d,A2:A17).<\/em><\/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-703.gif\" title=\"ex101_92019-nho-703\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30591\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-o-chua-gia-tri-nhat-dinh-sumproduct-3.png\" width=\"402\" height=\"515\" title=\"dem-o-chua-gia-tri-nhat-dinh-sumproduct-3\"><\/p>\n<p>Ti\u1ebfp theo ta s\u1ebd lo\u1ea1i b\u1ecf nh\u1eefng gi\u00e1 tr\u1ecb #VALUE! b\u1eb1ng c\u00e1ch \u0111\u01b0a v\u1ec1\u00a0<strong>TRUE\/FALSE<\/strong> v\u1edbi h\u00e0m\u00a0<strong>ISNUMBER<\/strong> l\u1ed3ng b\u00ean ngo\u00e0i:\u00a0<em>=ISNUMBER(FIND(\u201ca\u201d,A2:A17)).<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30592\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-o-chua-gia-tri-nhat-dinh-sumproduct-4.png\" width=\"485\" height=\"516\" title=\"dem-o-chua-gia-tri-nhat-dinh-sumproduct-4\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng, ta \u0111\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb\u00a0<strong>TRUE<\/strong> sau khi \u0111\u00e3 \u0111\u01b0a v\u1ec1 0\/1 v\u1edbi c\u1ee5m d\u1ea5u\u00a0<strong>\u2014<\/strong> ho\u1eb7c h\u00e0m\u00a0<strong>N<\/strong>, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>SUMPRODUCT<\/strong> theo c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p><strong><em>=SUMPRODUCT(N(ISNUMBER(FIND(\u201ca\u201d,A2:A17))))<\/em><\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 ta nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0\u00a0<strong>2<\/strong>. Ta c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi\u00a0<strong>\u201cA1\u201d, \u201cB1\u201d, \u201ca1\u2033\u2026<\/strong> \u0111\u1ec1u s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-30593\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-o-chua-gia-tri-nhat-dinh-sumproduct-5.png\" width=\"568\" height=\"515\" title=\"dem-o-chua-gia-tri-nhat-dinh-sumproduct-5\"><\/p>\n<hr>\n<p>T\u00ecm hi\u1ec3u th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/nhan-biet-tat-ca-o-deu-trong-bang-ham-sumproduct.html\">Nh\u1eadn bi\u1ebft \u00f4 tr\u1ed1ng v\u1edbi SUMPRODUCT<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">\u1ee8ng d\u1ee5ng COUNTIF c\u01a1 b\u1ea3n trong Excel<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html\">So s\u00e1nh COUNTIFS v\u00e0 SUMPRODUCT khi \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/strong><\/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-703.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7826,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7825","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\/7825","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=7825"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7825\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7826"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}