{"id":9383,"date":"2025-01-02T03:08:35","date_gmt":"2025-01-02T03:08:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel\/"},"modified":"2025-01-02T03:08:35","modified_gmt":"2025-01-02T03:08:35","slug":"huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 4 c\u00e1ch x\u00e1c \u0111\u1ecbnh \u0111\u01a1n gi\u00e1 theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 (hay t\u00ednh\u00a0\u0111\u01a1n gi\u00e1) theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n th\u01b0\u1eddng khi\u1ebfn ch\u00fang ta g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n. B\u1eddi vi\u1ec7c n\u00e0y\u00a0\u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, bi\u1ebft c\u00e1ch t\u1ed5 ch\u1ee9c b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 c\u00f3 t\u01b0 duy logic t\u1ed1t.\u00a0\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n r\u00e8n luy\u1ec7n th\u00eam nh\u1eefng\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3, ch\u00fang ta h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a04 c\u00e1ch x\u00e1c \u0111\u1ecbnh \u0111\u01a1n gi\u00e1 theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong excel nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u b\u00e1n h\u00e0ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24602\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/de-bai-xac-dinh-don-gia-theo-nhieu-dieu-kien.png\" width=\"800\" height=\"409\" title=\"de-bai-xac-dinh-don-gia-theo-nhieu-dieu-kien\"><\/p>\n<p>\u0110\u01a1n gi\u00e1 c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh d\u1ef1a theo 2 y\u1ebfu t\u1ed1: M\u00e3 h\u00e0ng v\u00e0 M\u00e3 c\u00f4ng ty.<\/p>\n<p>Y\u00eau c\u1ea7u l\u00e0 h\u00e3y x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 d\u1ef1a v\u00e0o m\u00e3 c\u00f4ng ty k\u1ebft h\u1ee3p v\u1edbi m\u00e3 h\u00e0ng tra trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1\u00a0\u0111\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i v\u00f9ng G3:G9.<\/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-6776033315681\" 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\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel.html#Cach_thu_1_Dung_ham_VLOOKUP_ket_hop_ham_MATCH\" title=\"C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH\">C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH<\/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\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel.html#Cach_thu_2_Dung_ham_HLOOKUP_ket_hop_ham_MATCH\" title=\"C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m HLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH\">C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m HLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel.html#Cach_thu_3_Dung_ham_INDEX_va_MATCH\" title=\"C\u00e1ch\u00a0th\u1ee9 3: D\u00f9ng h\u00e0m INDEX v\u00e0 MATCH\">C\u00e1ch\u00a0th\u1ee9 3: D\u00f9ng h\u00e0m INDEX v\u00e0 MATCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-4-cach-xac-dinh-don-gia-theo-nhieu-dieu-kien-trong-excel.html#Cach_thu_4_Dung_ham_SUMPRODUCT_xac_dinh_don_gia_theo_nhieu_dieu_kien\" title=\"C\u00e1ch th\u1ee9 4: D\u00f9ng h\u00e0m SUMPRODUCT x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\">C\u00e1ch th\u1ee9 4: D\u00f9ng h\u00e0m SUMPRODUCT x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thu_1_Dung_ham_VLOOKUP_ket_hop_ham_MATCH\"><\/span>C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m VLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-ket-hop-ham-match-khi-tim-theo-nhieu-cot-chua-ket-qua.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m Match khi t\u00ecm theo nhi\u1ec1u c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/a><\/p>\n<p>Khi ngh\u0129 t\u1edbi vi\u1ec7c tham chi\u1ebfu 1 gi\u00e1 tr\u1ecb (c\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0\u00a0\u0111\u01a1n gi\u00e1) theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n (t\u1eeb 2\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean), ch\u00fang ta ngh\u0129 t\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">h\u00e0m VLOOKUP<\/a> k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\">h\u00e0m MATCH<\/a>.<\/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\/2025\/01\/ex101_92019-nho-46.gif\" title=\"ex101_92019-nho-46\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Tr\u1ecdng t\u00e2m c\u1ee7a c\u00e1ch l\u00e0m n\u00e0y l\u00e0 c\u00e1c b\u1ea1n ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh VLOOKUP theo gi\u00e1 tr\u1ecb n\u00e0o, MATCH theo gi\u00e1 tr\u1ecb n\u00e0o.\u00a0\u0110\u1ec3 l\u00e0m\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3, ch\u00fang ta ch\u00fa\u00a0\u00fd c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1:<\/p>\n<ul>\n<li><strong>M\u00e3 c\u00f4ng ty<\/strong> n\u1eb1m\u00a0\u1edf c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean trong b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 =&gt; Theo nguy\u00ean t\u1eafc h\u00e0m VLOOKUP th\u00ec gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm ph\u1ea3i n\u1eb1m\u00a0\u1edf c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean. V\u00ec v\u1eady VLOOKUP s\u1ebd t\u00ecm theo m\u00e3 c\u00f4ng ty.<\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm c\u1ee7a h\u00e0m VLOOKUP l\u00e0\u00a0\u0111\u01a1n gi\u00e1 c\u1ee7a c\u00e1c m\u00e3 h\u00e0ng, t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u1ed9t th\u1ee9 m\u1ea5y trong b\u1ea3ng. V\u00ec v\u1eady\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u1ed9t th\u1ee9 m\u1ea5y, ch\u00fang ta d\u00f9ng h\u00e0m MATCH\u00a0\u0111\u1ec3 x\u00e9t gi\u00e1 tr\u1ecb <strong>M\u00e3 h\u00e0ng<\/strong>.<\/li>\n<\/ul>\n<p>C\u1ea5u tr\u00fac nh\u01b0 sau: <strong>VLOOKUP(M\u00e3 c\u00f4ng ty, B\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1, MATCH(m\u00e3 h\u00e0ng, d\u00f2ng m\u00e3 h\u00e0ng, 0), 0)<\/strong><\/p>\n<p>Khi thay c\u00e1c n\u1ed9i dung th\u00e0nh t\u1ecda\u00a0\u0111\u1ed9 tham chi\u1ebfu ta c\u00f3:<\/p>\n<blockquote>\n<p>G3=VLOOKUP(C3,$B$14:$F$17,MATCH(B3,$B$13:$F$13,0),0)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24603\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-1-dung-vlookup-match-xac-dinh-don-gia-2-dk-1024x446-1.png\" width=\"800\" height=\"349\" title=\"cach-1-dung-vlookup-match-xac-dinh-don-gia-2-dk-1024x446-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thu_2_Dung_ham_HLOOKUP_ket_hop_ham_MATCH\"><\/span>C\u00e1ch th\u1ee9 2: D\u00f9ng h\u00e0m HLOOKUP k\u1ebft h\u1ee3p h\u00e0m MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/hlookup-tim-kiem-cho-nguoi-moi.html\">H\u00e0m HLOOKUP<\/a> c\u0169ng l\u00e0 1 h\u00e0m t\u00ecm ki\u1ebfm t\u01b0\u01a1ng t\u1ef1 v\u1edbi VLOOKUP, ch\u1ec9 thay\u00a0\u0111\u1ed5i v\u1ec1 ph\u01b0\u01a1ng h\u01b0\u1edbng, chi\u1ec1u t\u00ecm ki\u1ebfm. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta\u00a0bi\u1ec7n lu\u1eadn nh\u01b0 sau:<\/p>\n<ul>\n<li>\u0110\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm c\u1ee7a h\u00e0m HLOOKUP ph\u1ea3i n\u1eb1m\u00a0\u1edf d\u00f2ng\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng t\u00ecm ki\u1ebfm. V\u00ec v\u1eady ch\u00fang ta th\u1ea5y d\u00f2ng M\u00e3 h\u00e0ng (d\u00f2ng 13) l\u00e0 d\u00f2ng\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 h\u00e0ng h\u00f3a. Do\u00a0\u0111\u00f3\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng t\u00ecm ki\u1ebfm c\u1ee7a h\u00e0m HLOOKUP trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 <strong>M\u00e3 h\u00e0ng<\/strong>.<\/li>\n<li>Khi\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m HLOOKUP s\u1ebd l\u1ea5y t\u01b0\u01a1ng\u00a0\u1ee9ng xu\u1ed1ng bao nhi\u00eau d\u00f2ng? C\u0103n c\u1ee9 v\u00e0o m\u00e3 c\u00f4ng ty\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng. V\u00ec v\u1eady ch\u00fang ta d\u00f9ng h\u00e0m MATCH t\u00ecm theo <strong>M\u00e3 c\u00f4ng ty<\/strong>.<\/li>\n<\/ul>\n<p>C\u1ea5u tr\u00fac nh\u01b0 sau: H<strong>LOOKUP(M\u00e3 h\u00e0ng, B\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1, MATCH(M\u00e3 c\u00f4ng ty, c\u1ed9t M\u00e3 c\u00f4ng ty, 0), 0)<\/strong><\/p>\n<p>Khi thay c\u00e1c n\u1ed9i dung th\u00e0nh t\u1ecda\u00a0\u0111\u1ed9 tham chi\u1ebfu ta c\u00f3:<\/p>\n<blockquote>\n<p>G3=VLOOKUP(C3,$B$14:$F$17,MATCH(B3,$B$13:$F$13,0),0)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24604\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-2-dung-hlookup-match-xac-dinh-don-gia-2-dk-1024x442-1.png\" width=\"800\" height=\"345\" title=\"cach-2-dung-hlookup-match-xac-dinh-don-gia-2-dk-1024x442-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thu_3_Dung_ham_INDEX_va_MATCH\"><\/span>C\u00e1ch\u00a0th\u1ee9 3: D\u00f9ng h\u00e0m INDEX v\u00e0 MATCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng d\u00f9ng Index + Match th\u00ec t\u1ed1t h\u01a1n d\u00f9ng Vlookup hay Hlookup? N\u1ebfu kh\u00f4ng tin th\u00ec b\u1ea1n h\u00e3y xem l\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng INDEX MATCH nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p>Khi nh\u1eafc t\u1edbi INDEX MATCH, c\u00e1c b\u1ea1n h\u00e3y ghi nh\u1edb 3 y\u1ebfu t\u1ed1:<\/p>\n<ul>\n<li><strong>V\u00f9ng d\u1eef li\u1ec7u n\u00e0o<\/strong>? Ch\u00fang ta c\u1ea7n t\u00ednh\u00a0\u0111\u01a1n gi\u00e1, do\u00a0\u0111\u00f3 x\u00e9t v\u00f9ng <strong>B13:F17<\/strong> l\u00e0 B\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1.<\/li>\n<li>K\u1ebft qu\u1ea3 \u1edf\u00a0<strong>d\u00f2ng n\u00e0o<\/strong>? X\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng d\u1ef1a theo h\u00e0m MATCH, t\u00ecm theo M\u00e3 c\u00f4ng ty.<\/li>\n<li>K\u1ebft qu\u1ea3\u00a0\u1edf <strong>c\u1ed9t n\u00e0o<\/strong>? X\u00e1c\u00a0\u0111\u1ecbnh c\u1ed9t d\u1ef1a theo h\u00e0m MATCH, t\u00ecm theo M\u00e3 h\u00e0ng.<\/li>\n<\/ul>\n<p>C\u1ea5u tr\u00fac c\u1ee5 th\u1ec3: <strong>INDEX(B\u1ea3ng d\u1eef li\u1ec7u, MATCH(M\u00e3 c\u00f4ng ty, C\u1ed9t M\u00e3 c\u00f4ng ty,0), MATCH(M\u00e3 h\u00e0ng, d\u00f2ng M\u00e3 h\u00e0ng,0))<\/strong><\/p>\n<p>Khi thay c\u00e1c n\u1ed9i dung th\u00e0nh t\u1ecda\u00a0\u0111\u1ed9 tham chi\u1ebfu ta c\u00f3:<\/p>\n<blockquote>\n<p>G3=INDEX($B$13:$F$17,MATCH(C3,$B$13:$B$17,0),MATCH(B3,$B$13:$F$13,0))<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24605\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-3-dung-index-match-xac-dinh-don-gia-2-dk-1024x388-1.png\" width=\"800\" height=\"303\" title=\"cach-3-dung-index-match-xac-dinh-don-gia-2-dk-1024x388-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thu_4_Dung_ham_SUMPRODUCT_xac_dinh_don_gia_theo_nhieu_dieu_kien\"><\/span>C\u00e1ch th\u1ee9 4: D\u00f9ng h\u00e0m SUMPRODUCT x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m SUMPRODUCT l\u00e0 m\u1ed9t h\u00e0m s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p. V\u00e0\u00a0ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3\u00a0\u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y trong vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01a1n gi\u00e1 theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<ul>\n<li>Khi n\u00e0o\u00a0\u00e1p d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c? Khi b\u1ea3ng\u00a0\u0111\u01a1n gi\u00e1 kh\u00f4ng c\u00f3 c\u00e1c m\u00e3 tr\u00f9ng nhau.<\/li>\n<li>C\u00e1ch d\u00f9ng: X\u00e9t 2\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng m\u1ea3ng 2 chi\u1ec1u: M\u00e3 h\u00e0ng (v\u00f9ng C13:F13)\u00a0v\u00e0 M\u00e3 c\u00f4ng ty (v\u00f9ng B14:B17), k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng l\u1ea5y trong v\u00f9ng C14:F17<\/li>\n<\/ul>\n<p>Khi thay c\u00e1c n\u1ed9i dung th\u00e0nh t\u1ecda\u00a0\u0111\u1ed9 tham chi\u1ebfu ta c\u00f3:<\/p>\n<blockquote>\n<p>G3=SUMPRODUCT(($B$14:$B$17=C3)*($C$13:$F$13=B3)*$C$14:$F$17)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24606\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-4-dung-sumproduct-xac-dinh-don-gia-2-dk-1024x406-2.png\" width=\"800\" height=\"317\" title=\"cach-4-dung-sumproduct-xac-dinh-don-gia-2-dk-1024x406-2\"><\/p>\n<p>C\u1ea3 4 c\u00e1ch\u00a0\u0111\u1ec1u cho ra k\u1ebft qu\u1ea3 gi\u1ed1ng nhau.<\/p>\n<p>B\u1ea1n th\u1ea5y\u00a0\u0111\u00f3,\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n 1 y\u00eau c\u1ea7u trong\u00a0Excel ch\u00fang ta c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u c\u00e1ch l\u00e0m kh\u00e1c nhau. C\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng, k\u1ebft n\u1ed1i v\u1edbi nhau gi\u00fap ch\u00fang ta\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n. H\u00e3y t\u00ecm hi\u1ec3u th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c c\u1ee7a\u00a0Excel c\u00f9ng H\u1ecdc\u00a0Excel Online b\u1ea1n nh\u00e9.<\/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\/2025\/01\/ex101_92019-nho-46.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9383","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\/9383","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=9383"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9383\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9384"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}