{"id":5111,"date":"2024-12-09T06:43:26","date_gmt":"2024-12-09T06:43:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/cach-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or\/"},"modified":"2024-12-09T06:43:26","modified_gmt":"2024-12-09T06:43:26","slug":"cach-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/cach-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or\/","title":{"rendered":"C\u00c1CH D\u00d9NG SUMIF TRONG EXCEL V\u1edaI NHI\u1ec0U \u0110I\u1ec0U KI\u1ec6N (H\u00c0M LOGIC OR)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh khi m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t kh\u00e1c \u0111\u00e1p \u1ee9ng b\u1ea5t k\u1ef3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n ri\u00eang l\u1ebb \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh. D\u01b0\u1edbi \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> chia s\u1ebb 3 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n<strong> h\u00e0m SUMIF<\/strong> s\u1eed d\u1ee5ng nhi\u1ec1u ti\u00eau ch\u00ed v\u00e0 h\u00e0m logic OR.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Microsoft Excel c\u00f3 m\u1ed9t ch\u1ee9c n\u0103ng \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 <strong>t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> \u2013 h\u00e0m SUMIFS. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi x\u1ea3y ra (AND) \u2013 m\u1ed9t \u00f4 ch\u1ec9 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o khi t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 TRUE cho \u00f4 \u0111\u00f3. Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 t\u1ec9nh t\u1ed5ng v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed kh\u00f4ng \u0111\u1ed3ng th\u1eddi x\u1ea3y ra, ngh\u0129a l\u00e0 th\u00eam m\u1ed9t \u00f4 khi b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n ri\u00eang l\u1ebb n\u00e0o l\u00e0 \u0111\u00fang. V\u00e0 \u0111\u00e2y l\u00e0 l\u00fac s\u1eed d\u1ee5ng h\u00e0m SUMIF.<\/span><\/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-6756918de9e86\" 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\/cach-su-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or.html#SUMIF_SUMIF_de_tinh_tong_cac_o_bang_cai_nay_hoac_cai_kia\" title=\"SUMIF + SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 b\u1eb1ng c\u00e1i n\u00e0y ho\u1eb7c c\u00e1i kia\">SUMIF + SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 b\u1eb1ng c\u00e1i n\u00e0y ho\u1eb7c c\u00e1i kia<\/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\/cach-su-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or.html#SUMIF_voi_hang_so_mang_%E2%80%93_cong_thuc_thu_gon_voi_nhieu_tieu_chi\" title=\"SUMIF v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng \u2013 c\u00f4ng th\u1ee9c thu g\u1ecdn v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed\">SUMIF v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng \u2013 c\u00f4ng th\u1ee9c thu g\u1ecdn v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed<\/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\/cach-su-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or.html#SUMPRODUCT_va_SUMIF_de_tinh_tong_cac_o_co_nhieu_dieu_kien_OR\" title=\"SUMPRODUCT v\u00e0 SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR\">SUMPRODUCT v\u00e0 SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR<\/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\/cach-su-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or.html#SUMIF_su_dung_nhieu_tieu_chi_voi_cac_ky_tu_dai_dien\" title=\"SUMIF s\u1eed d\u1ee5ng nhi\u1ec1u ti\u00eau ch\u00ed v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\">SUMIF s\u1eed d\u1ee5ng nhi\u1ec1u ti\u00eau ch\u00ed v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"SUMIF_SUMIF_de_tinh_tong_cac_o_bang_cai_nay_hoac_cai_kia\"><\/span><b>SUMIF + SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 b\u1eb1ng c\u00e1i n\u00e0y ho\u1eb7c c\u00e1i kia<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t c\u1ed9t v\u00e0 sau \u0111\u00f3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c c\u1ed9t \u0111\u00f3 th\u00ec gi\u1ea3i ph\u00e1p r\u00f5 r\u00e0ng nh\u1ea5t l\u00e0 x\u1eed l\u00fd t\u1eebng \u0111i\u1ec1u ki\u1ec7n ri\u00eang l\u1ebb sau \u0111\u00f3 c\u1ed9ng c\u00e1c k\u1ebft qu\u1ea3 l\u1ea1i v\u1edbi nhau.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">SUMIF(range, <\/span><i><span style=\"font-weight: 400\">criteria1<\/span><\/i><span style=\"font-weight: 400\">, sum_range) + SUMIF(range, <\/span><i><span style=\"font-weight: 400\">criteria2<\/span><\/i><span style=\"font-weight: 400\">, sum_range)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n c\u1ed9ng doanh s\u1ed1 cho hai s\u1ea3n ph\u1ea9m kh\u00e1c nhau nh\u01b0 Apple v\u00e0 Lemon. \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u ki\u1ec7n n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c m\u1ee5c quan t\u00e2m tr\u1ef1c ti\u1ebfp nh\u01b0 \u201c apple\u201d v\u00e0 \u201c lemon\u201d v\u00e0o ti\u00eau ch\u00ed c\u1ee7a 2<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong> h\u00e0m SUMIF<\/strong><\/a> kh\u00e1c nhau:<\/span><\/p>\n<p>\u00a0<\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUMIF(A2:A10, \u201capple\u201d, B2:B10) + SUMIF(A2:A10, \u201clemon\u201d, B2:B10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp ti\u00eau ch\u00ed v\u00e0o c\u00e1c \u00f4 ri\u00eang bi\u1ec7t v\u00e0 tham chi\u1ebfu c\u00e1c \u00f4 \u0111\u00f3:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUMIF(A2:A10, E1, B2:B10) + SUMIF(A2:A10, E2, B2:B10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3, A2:A10 l\u00e0 danh s\u00e1ch c\u00e1c m\u1ee5c (ph\u1ea1m vi), B2:B10 l\u00e0 c\u00e1c s\u1ed1 \u0111\u1ec3 t\u00ednh t\u1ed5ng (sum_range), E1 v\u00e0 E2 l\u00e0 c\u00e1c m\u1ee5c ti\u00eau ch\u00ed:<\/span><\/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-432.gif\" title=\"ex101_92019-nho-432\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-multiple-criteria.png\" alt=\"Excel SUMIF formula with multiple criteria\" title=\"sumif-multiple-criteria\"><\/p>\n<p><i><span style=\"font-weight: 400\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m SUMIF \u0111\u1ea7u ti\u00ean c\u1ed9ng doanh s\u1ed1 c\u1ee7a Apple, h\u00e0m SUMIF th\u1ee9 hai t\u1ec9nh t\u1ed5ng doanh s\u1ed1 lemon. C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd c\u1ed9ng c\u00e1c t\u1ed5ng ph\u1ee5 v\u1edbi nhau v\u00e0 xu\u1ea5t ra t\u1ed5ng ch\u00ednh.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SUMIF_voi_hang_so_mang_%E2%80%93_cong_thuc_thu_gon_voi_nhieu_tieu_chi\"><\/span><b>SUMIF v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng \u2013 c\u00f4ng th\u1ee9c thu g\u1ecdn v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ph\u01b0\u01a1ng ph\u00e1p SUMIF + SUMIF ho\u1ea1t \u0111\u1ed9ng t\u1ed1t khi c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu b\u1ea1n mu\u1ed1n t\u1ec9nh t\u1ed5ng v\u1edbi 3 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd qu\u00e1 l\u1edbn v\u00e0 kh\u00f3 \u0111\u1ecdc. Thay v\u00e0o \u0111\u00f3 s\u1eed d\u1ee5ng SUMIF v\u1edbi h\u1eb1ng s\u1ed1 m\u1ea3ng, c\u00f4ng th\u1ee9c nh\u1ecf g\u1ecdn h\u01a1n v\u00e0 v\u1eabn \u0111\u1ea1t k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">SUM(SUMIF(range, {<\/span><i><span style=\"font-weight: 400\">criteria1<\/span><\/i><span style=\"font-weight: 400\">, <\/span><i><span style=\"font-weight: 400\">criteria2<\/span><\/i><span style=\"font-weight: 400\">, <\/span><i><span style=\"font-weight: 400\">criteria3<\/span><\/i><span style=\"font-weight: 400\">, \u2026}, sum_range))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">H\u00e3y nh\u1edb r\u1eb1ng c\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed kh\u00f4ng \u0111\u1ed3ng th\u1eddi x\u1ea3y ra (OR) \u2013 m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng khi b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n l\u1ebb n\u00e0o \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 cho 3 m\u1eb7t h\u00e0ng kh\u00e1c nhau, c\u00f4ng th\u1ee9c l\u00e0:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUM(SUMIF(A2:A10, {\u201cApples\u201d,\u201dLemons\u201d,\u201dOranges\u201d}, B2:B10))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-multiple-criteria-array.png\" alt=\"SUMIF formula with array constant to sum cells with multiple OR criteria\" title=\"sumif-multiple-criteria-array\"><\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u1ee9c h\u00ecnh tr\u00ean, c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a c\u1ee9ng trong m\u1ed9t m\u1ea3ng, c\u00f3 ngh\u0129a b\u1ea1n ph\u1ea3i c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c v\u1edbi m\u1ecdi thay \u0111\u1ed5i trong \u0111i\u1ec1u ki\u1ec7n. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp \u0111i\u1ec1u ki\u1ec7n v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0 t\u1ea1o cho c\u00f4ng th\u1ee9c d\u01b0\u1edbi d\u1ea1ng tham chi\u1ebfu ph\u1ea1m vi (E1:E3 trong v\u00ed d\u1ee5 n\u00e0y).<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUM(SUMIF(A2:A10, E1:E3, B2:B10))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Trong Excel 365 h\u1ed7 tr\u1ee3 m\u1ea3ng \u0111\u1ed9ng <\/span><i><span style=\"font-weight: 400\">(dynamic array)<\/span><\/i><span style=\"font-weight: 400\">, n\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng v\u00e0 \u0111\u01b0\u1ee3c ho\u00e0n th\u00e0nh b\u1eb1ng ph\u00edm ENTER. Trong c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2019, Excel 2016, Excel 2013 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng ph\u00edm t\u1eaft <\/span><b><i>CTRL + SHIFT+ENTER<\/i><\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-multiple-criteria-range.png\" alt=\"SUM and SUMIF formula with multiple criteria in different cells\" title=\"sumif-multiple-criteria-range\"><\/p>\n<p><b><i>Ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng m\u00e0 \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c g\u1eafn v\u00e0o c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a SUMIF bu\u1ed9c n\u00f3 ph\u1ea3i tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng m\u1ed9t m\u1ea3ng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u00f3 l\u00e0 3 l\u01b0\u1ee3ng kh\u00e1c nhau: apple, lemon v\u00e0 orange.<\/span><\/p>\n<p><span style=\"font-weight: 400\">{425;425;565}<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Sum v\u00e0 h\u1ed7 tr\u1ee3 c\u00f4ng th\u1ee9c SUMIF.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SUMPRODUCT_va_SUMIF_de_tinh_tong_cac_o_co_nhieu_dieu_kien_OR\"><\/span><b>SUMPRODUCT v\u00e0 SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u1ea1n kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng m\u1ea3ng v\u00e0 \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t c\u00f4ng th\u1ee9c b\u00ecnh th\u01b0\u1eddng gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00e1c \u00f4 kh\u00e1c nhau? Thay v\u00ec Sum th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT x\u1eed l\u00fd m\u1ea3ng nguy\u00ean b\u1ea3n:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">SUMPRODUCT(SUMIF(range, <\/span><i><span style=\"font-weight: 400\">crireria_range<\/span><\/i><span style=\"font-weight: 400\">, sum_range))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed c\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong c\u00e1c \u00f4 E1, E2 v\u00e0 E3 th\u00ec c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUMPRODUCT(SUMIF(A2:A10, E1:E3, B2:B10))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b><i><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-sumif-multiple-criteria-1.png\" alt=\"SUMPRODUCT and SUMIF to sum cells with multiple OR conditions\" title=\"sumproduct-sumif-multiple-criteria-1\"><\/i><\/b><\/p>\n<p><b><i>C\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o:<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ed1ng v\u1edbi v\u00ed d\u1ee5 tr\u01b0\u1edbc, h\u00e0m SUMIF tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng s\u1ed1, \u0111\u1ea1i di\u1ec7n cho t\u1ed5ng t\u1eebng \u0111i\u1ec1u ki\u1ec7n ri\u00eang l\u1ebb. SUMPRODUCT c\u1ed9ng c\u00e1c s\u1ed1 n\u00e0y l\u1ea1i v\u1edbi nhau v\u00e0 xu\u1ea5t ra t\u1ed5ng cu\u1ed1i. Kh\u00f4ng gi\u1ed1ng v\u1edbi h\u00e0m SUM, h\u00e0m SUMPRODUCT \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 x\u1eed l\u00fd m\u1ea3ng, v\u00ec v\u1eady n\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng m\u00e0 b\u1ea1n kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm \u201c CTRL + Shift + Enter\u201d.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SUMIF_su_dung_nhieu_tieu_chi_voi_cac_ky_tu_dai_dien\"><\/span><b>SUMIF s\u1eed d\u1ee5ng nhi\u1ec1u ti\u00eau ch\u00ed v\u1edbi c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec h\u00e0m SUMIF trong Excel h\u1ed7 tr\u1ee3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n n\u00ean b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0a ch\u00fang v\u00e0o nhi\u1ec1u ti\u00eau ch\u00ed khi b\u1ea1n c\u1ea7n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng cho t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i apples v\u00e0 banana, c\u00f4ng th\u1ee9c l\u00e0:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">=SUM(SUMIF(A2:A10, {\u201c*Apples\u201d,\u201d*Bananas\u201d}, B2:B10))<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n nh\u1eadp v\u00e0o c\u00e1c \u00f4 ri\u00eang l\u1ebb, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n tr\u1ef1c ti\u1ebfp v\u00e0o c\u00e1c \u00f4 \u0111\u00f3 v\u00e0 cung c\u1ea5p tham chi\u1ebfu ph\u1ea1m vi l\u00e0m ti\u00eau ch\u00ed cho c\u00f4ng th\u1ee9c SUMPRODUCT SUMIF:<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-multiple-criteria-wildcards.png\" alt=\"SUMIF using multiple criteria with wildcards\" title=\"sumif-multiple-criteria-wildcards\"><\/p>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111\u1eb7t k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (*) tr\u01b0\u1edbc t\u00ean m\u1eb7t h\u00e0ng \u0111\u1ec3 kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 n\u00e0o \u0111\u1ee9ng tr\u01b0\u1edbc nh\u01b0 <\/span><i><span style=\"font-weight: 400\">Green Apples<\/span><\/i><span style=\"font-weight: 400\"> v\u00e0 <\/span><i><span style=\"font-weight: 400\">chu\u1ed1i Goldfinger<\/span><\/i><span style=\"font-weight: 400\">, \u0110\u1ec3 nh\u1eadn t\u1ed5ng s\u1ed1 b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong \u00f4 h\u00e3y \u0111\u1eb7t d\u1ea5u hoa th\u1ecb \u1edf c\u1ea3 2 b\u00ean, v\u00ed d\u1ee5 \u201c*apple*\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-sumif-trong-excel-voi-nhieu-dieu-kien-ham-logic-or.html\"><strong>h\u00e0m SUMIF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/a> trong Excel. Hy v\u1ecdng nh\u1eefng chia s\u1ebb tr\u00ean s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft t\u1ed1t nh\u1eefng v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn Excel.<\/span><\/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-432.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5112,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5111","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\/5111","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=5111"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5111\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5112"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}