{"id":1447,"date":"2024-12-02T05:07:18","date_gmt":"2024-12-02T05:07:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-so-vi-du-cong-thuc\/"},"modified":"2024-12-02T05:07:18","modified_gmt":"2024-12-02T05:07:18","slug":"cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-so-vi-du-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-so-vi-du-cong-thuc\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS v\u00e0 SUMIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u2013 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-sumifs-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html?ham-sumifs-trong-excel\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1ea3i th\u00edch s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c<strong> h\u00e0m SUMIF v\u00e0 SUMIFS trong excel<\/strong> theo c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a ch\u00fang, b\u00ean c\u1ea1nh \u0111\u00f3, c\u0169ng cung c\u1ea5p m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c \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 (<strong><em>AND<\/em><\/strong>) ho\u1eb7c t\u1ea5t c\u1ea3 kh\u00f4ng \u0111\u1ed3ng th\u1eddi x\u1ea3y ra (<strong>OR<\/strong>) trong phi\u00ean b\u1ea3n Excel 2013, 2010, 2007, 2003 v\u00e0 tr\u01b0\u1edbc n\u1eefa.<\/p>\n<\/blockquote>\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-674d40851bc12\" 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-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Ham_SUMIF_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:\">H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/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-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Ham_SUMIFS_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:\">H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/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-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Su_dung_SUMIFS_va_SUMIF_trong_Excel_%E2%80%93_mot_so_dieu_can_nho\" title=\"S\u1eed d\u1ee5ng SUMIFS v\u00e0 SUMIF trong Excel \u2013 m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ea7n nh\u1edb:\">S\u1eed d\u1ee5ng SUMIFS v\u00e0 SUMIF trong Excel \u2013 m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ea7n nh\u1edb:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#1_Trinh_tu_cua_cac_doi_so\" title=\"1. Tr\u00ecnh t\u1ef1 c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1\">1. Tr\u00ecnh t\u1ef1 c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#2_Kich_thuoc_cua_doi_so_sum_range_va_criteria_range\" title=\"2. K\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 sum_range v\u00e0 criteria_range\">2. K\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 sum_range v\u00e0 criteria_range<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Lam_the_nao_de_su_dung_SUMIFS_trong_Excel_%E2%80%93_vi_du_cong_thuc\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng SUMIFS trong Excel \u2013 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng SUMIFS trong Excel \u2013 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_1_Cong_thuc_SUMIFS_voi_toan_tu_so_sanh\" title=\"V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n t\u1eed so s\u00e1nh\">V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c SUMIFS v\u1edbi to\u00e1n t\u1eed so s\u00e1nh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_2_Su_dung_cong_thuc_SUMIFS_voi_ngay\" title=\"V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS v\u1edbi ng\u00e0y\">V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS v\u1edbi ng\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_3_Ham_SUMIFS_voi_o_trong_va_khong_trong\" title=\"V\u00ed d\u1ee5 3. H\u00e0m SUMIFS v\u1edbi \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng\">V\u00ed d\u1ee5 3. H\u00e0m SUMIFS v\u1edbi \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_4_Cach_viet_dieu_kien_ham_SUMIFS\" title=\"V\u00ed d\u1ee5 4: C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS\">V\u00ed d\u1ee5 4: C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Su_dung_ham_SUMIF_co_nhieu_dieu_kien_OR\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUMIF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR\">S\u1eed d\u1ee5ng h\u00e0m SUMIF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_1_SUMIF_SUMIF\" title=\"V\u00ed d\u1ee5 1. SUMIF + SUMIF\">V\u00ed d\u1ee5 1. SUMIF + SUMIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_2_SUM_SUMIF_voi_doi_so_mang\" title=\"V\u00ed d\u1ee5 2. SUM &amp; SUMIF v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng\">V\u00ed d\u1ee5 2. SUM &amp; SUMIF v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_3_SUMPRODUCT_SUMIF\" title=\"V\u00ed d\u1ee5 3. SUMPRODUCT &amp; SUMIF\">V\u00ed d\u1ee5 3. SUMPRODUCT &amp; SUMIF<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Excel_SUMIFS_co_nhieu_dieu_kien_OR\" title=\"Excel SUMIFS c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR\">Excel SUMIFS c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_1_SUMIFS_SUMIFS\" title=\"V\u00ed d\u1ee5 1. SUMIFS + SUMIFS\">V\u00ed d\u1ee5 1. SUMIFS + SUMIFS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_2_SUM_SUMIFS_voi_doi_so_mang\" title=\"V\u00ed d\u1ee5 2. SUM &amp; SUMIFS v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng\">V\u00ed d\u1ee5 2. SUM &amp; SUMIFS v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_3_SUMPRODUCT_SUMIFS\" title=\"V\u00ed d\u1ee5 3. SUMPRODUCT &amp; SUMIFS\">V\u00ed d\u1ee5 3. SUMPRODUCT &amp; SUMIFS<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Su_dung_ham_SUM_trong_cac_cong_thuc_mang\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUM trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng\">S\u1eed d\u1ee5ng h\u00e0m SUM trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_1_Sum_voi_cac_dieu_kien_AND_trong_Excel_2003_va_phien_ban_truoc_do\" title=\"V\u00ed d\u1ee5 1. Sum v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n AND trong Excel 2003 v\u00e0 phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3:\">V\u00ed d\u1ee5 1. Sum v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n AND trong Excel 2003 v\u00e0 phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Vi_du_2_Cac_cong_thuc_mang_SUM_trong_cac_phien_ban_Excel_hien_dai\" title=\"V\u00ed d\u1ee5 2. C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng SUM trong c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i\">V\u00ed d\u1ee5 2. C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng SUM trong c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html#Thong_tin_bo_ich_khac_trong_viec_ung_dung_ham_Sumifs\" title=\"Th\u00f4ng tin b\u1ed5 \u00edch kh\u00e1c trong vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m Sumifs\">Th\u00f4ng tin b\u1ed5 \u00edch kh\u00e1c trong vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m Sumifs<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_SUMIF_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m <strong><em>SUMIF<\/em><\/strong> \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>H\u00e0m SUMIF<\/strong><\/a> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. Ch\u00fang t\u00f4i \u0111\u00e3 th\u1ea3o lu\u1eadn v\u1ec1 c\u00fa ph\u00e1p c\u1ee7a n\u00f3 m\u1ed9t c\u00e1ch chi ti\u1ebft trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, v\u00ec v\u1eady, b\u00e2y gi\u1edd t\u00f4i h\u00e3y cho b\u1ea1n m\u1ed9t b\u1ea3n t\u00f3m t\u1eaft nhanh.<\/p>\n<p style=\"text-align: justify\"><strong><em><code>SUMIF (range, \u0111i\u1ec1u ki\u1ec7n, [sum_range])<\/code><\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>range<\/em><\/strong> \u2013 d\u1ea3i c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 theo \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u01b0a ra, mang t\u00ednh b\u1eaft bu\u1ed9c.<\/li>\n<li><strong><em>criteria \u2013<\/em><\/strong> \u0111i\u1ec1u ki\u1ec7n c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng, mang t\u00ednh b\u1eaft bu\u1ed9c<\/li>\n<li><strong><em>sum_range<\/em><\/strong> \u2013 c\u00e1c \u00f4 t\u00ednh t\u1ed5ng n\u1ebfu th\u1ecfa \u0111i\u1ec1u ki\u1ec7n, mang t\u00ednh t\u00f9y ch\u1ecdn.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel SUMIF ch\u1ec9 cho ph\u00e9p m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean, b\u00ean tr\u00ean, ch\u00fang t\u00f4i c\u00f3 n\u00f3i r\u1eb1ng Excel SUMIF c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. L\u00e0m th\u1ebf n\u00e0o m\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c? Th\u1ef1c t\u1ebf, b\u1ea1n c\u1ea7n th\u00eam c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a v\u00e0i h\u00e0m SUMIF v\u00e0 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c SUMIF v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u1ea3ng, nh\u01b0 trong v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_SUMIFS_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng<strong> h\u00e0m SUMIFS trong Excel<\/strong> \u0111\u1ec3 t\u00ecm m\u1ed9t t\u00ednh t\u1ed5ng c\u00f3 gi\u00e1 tr\u1ecb c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. <strong>H\u00e0m SUMIFS trong excel<\/strong> \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u trong Excel 2007, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2013, 2010 v\u00e0 2007.<\/p>\n<p style=\"text-align: justify\">So v\u1edbi SUMIF, th\u00ec c\u00fa ph\u00e1p SUMIFS ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat:<\/p>\n<p style=\"text-align: justify\"><strong><em><code>SUMIFS (sum_range, criteria_range1, criteria1, [criter_range2, criteria2], ...)<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, c\u00e1c range \u0111\u01b0\u1ee3c b\u1ed5 sung v\u00e0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n li\u00ean quan t\u1edbi ch\u00fang th\u00ec \u0111\u01b0\u1ee3c t\u00f9y ch\u1ecdn.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-41.gif\" title=\"vba101_92019-nho-41\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-105.gif\" title=\"ex101_92019-nho-105\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li><strong><em>sum_range <\/em><\/strong>\u2013 m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 t\u00ednh t\u1ed5ng, mang t\u00ednh b\u1eaft bu\u1ed9c. \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u00f4 duy nh\u1ea5t, m\u1ed9t d\u1ea3i \u00f4 ho\u1eb7c d\u1ea3i c\u00f3 t\u00ean. Ch\u1ec9 c\u00f3 c\u00e1c \u00f4 ch\u1ec9 ch\u1ee9a s\u1ed1 m\u1edbi \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng; C\u00f2n gi\u00e1 tr\u1ecb \u00f4 tr\u1ed1ng v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n th\u00ec s\u1ebd b\u1ecb b\u1ecf qua.<\/li>\n<li><strong><em>criteria_range1 \u2013<\/em><\/strong> range \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n li\u00ean quan, mang t\u00ednh b\u1eaft bu\u1ed9c.<\/li>\n<li><strong><em>criteria1 <\/em><\/strong>\u2013 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3. B\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p c\u00e1c \u0111i\u1ec1u ki\u1ec7n d\u01b0\u1edbi d\u1ea1ng m\u1ed9t s\u1ed1, bi\u1ec3u th\u1ee9c logic, tham chi\u1ebfu \u00f4, v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t h\u00e0m Excel kh\u00e1c. V\u00ed d\u1ee5 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 10, \u201c&gt; = 10\u201d, A1, \u201ccherries\u201d ho\u1eb7c TODAY ().<\/li>\n<li><strong><em>criteria_range2, criteria2, <\/em><\/strong>\u2026 \u2013 \u0111\u00e2y l\u00e0 c\u00e1c d\u1ea3i \u0111\u01b0\u1ee3c th\u00eam v\u00e0o v\u00e0 \u0111i\u1ec1u ki\u1ec7n li\u00ean quan t\u1edbi c\u00e1c d\u1ea3i n\u00e0y, do b\u1ea1n t\u00f9y ch\u1ecdn. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 127 d\u1ea3i \/ \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c SUMIFS.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd: H\u00e0m SUMIFS trong excel<\/strong> ho\u1ea1t \u0111\u1ed9ng v\u1edbi bi\u1ec3u th\u1ee9c logic v\u1edbi AND, ngh\u0129a l\u00e0 m\u1ed7i \u00f4 trong \u0111\u1ed1i s\u1ed1 sum_range ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 \u0111\u00fang cho \u00f4 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y xem h\u00e0m SUMIFS ho\u1ea1t \u0111\u1ed9ng v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng li\u1ec7t k\u00ea c\u00e1c l\u00f4 h\u00e0ng tr\u00e1i c\u00e2y t\u1eeb c\u00e1c nh\u00e0 cung c\u1ea5p kh\u00e1c nhau. B\u1ea1n c\u00f3 t\u00ean qu\u1ea3 trong c\u1ed9t A, t\u00ean c\u1ee7a nh\u00e0 cung c\u1ea5p trong c\u1ed9t B v\u00e0 s\u1ed1 l\u01b0\u1ee3ng trong c\u1ed9t C. B\u1ea1n mu\u1ed1n t\u00ecm ra s\u1ed1 ti\u1ec1n li\u00ean quan \u0111\u1ebfn qu\u1ea3 v\u00e0 nh\u00e0 cung c\u1ea5p, v\u00ed d\u1ee5: T\u1ea5t c\u1ea3 t\u00e1o (apples) \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi Pete.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-source-data.png\" alt=\"Data to be summed with two conditions\" title=\"excel-sumifs-source-data\"><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111ang ti\u1ebfp thu m\u1ed9t c\u00e1i m\u1edbi m\u1ebb, b\u1ea1n n\u00ean b\u1eaft \u0111\u1ea7u v\u1edbi nh\u1eefng \u0111i\u1ec1u \u0111\u01a1n gi\u1ea3n. V\u00ec v\u1eady, \u0111\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y x\u00e1c \u0111\u1ecbnh t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 cho c\u00f4ng th\u1ee9c SUMIFS c\u1ee7a ch\u00fang t\u00f4i:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>sum_range \u2013 C2: C9<\/em><\/strong><\/li>\n<li><strong><em>criteria_range1 \u2013 A2: A9<\/em><\/strong><\/li>\n<li><strong><em>criteria1 \u2013 \u201capples\u201d<\/em><\/strong><\/li>\n<li><strong><em>criteria_range2 \u2013 B2: B9<\/em><\/strong><\/li>\n<li><strong><em>criteria2 \u2013 \u201cPete\u201d<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd t\u1eadp h\u1ee3p c\u00e1c th\u00f4ng s\u1ed1 tr\u00ean, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c SUMIFS sau:<\/p>\n<p style=\"text-align: justify\"><strong><em><code>= SUMIFS (C2: C9, A2: A9, \"t\u00e1o\", B2: B9, \"Pete\")<\/code><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-function.png\" alt=\"An example of the Excel SUMIFS formula with two conditions\" title=\"excel-sumifs-function\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 khi\u1ebfn vi\u1ec7c ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf c\u00e1c ti\u00eau chu\u1ea9n v\u0103n b\u1ea3n \u201capples\u201d v\u00e0 \u201cPete\u201d b\u1eb1ng c\u00e1c tham chi\u1ebfu \u00f4. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i thay \u0111\u1ed5i c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n l\u01b0\u1ee3ng tr\u00e1i c\u00e2y kh\u00e1c t\u1eeb m\u1ed9t nh\u00e0 cung c\u1ea5p kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><code>= <strong><em>SUMIFS (C2: C9, A2: A9, F1, B2: B9, F2)<\/em><\/strong><\/code><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel v\u0103n ph\u00f2ng<\/a><\/p>\n<p>M\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i 2 videos sau \u0111\u00e2y v\u00e0 \u0111\u1eebng qu\u00ean download t\u00e0i li\u1ec7u k\u00e8m theo b\u00ean d\u01b0\u1edbi \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m SUMIFS nh\u00e9!<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Z73YOrndkEQ\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Video n\u00e2ng cao v\u1ec1 2 h\u00e0m SUMIF v\u00e0 SUMIFS s\u1ebd gi\u00fap c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 d\u1ea5u sao v\u00e0 h\u1ecfi ch\u1ea5m \u0111\u1ec3 t\u00ednh t\u1ed5ng n\u00e2ng cao:<\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1E52jQ-KH0A?autoplay=1&amp;loop=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_SUMIFS_va_SUMIF_trong_Excel_%E2%80%93_mot_so_dieu_can_nho\"><\/span>S\u1eed d\u1ee5ng SUMIFS v\u00e0 SUMIF trong Excel \u2013 m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ea7n nh\u1edb:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u00ec m\u1ee5c \u0111\u00edch c\u1ee7a h\u01b0\u1edbng d\u1eabn n\u00e0y l\u00e0 bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c c\u00e1ch c\u00f3 th\u1ec3 c\u00f3, \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta s\u1ebd th\u1ea3o lu\u1eadn c\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c v\u1edbi c\u1ea3 hai h\u00e0m \u2013 SUMIFS v\u00e0 SUMIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. \u0110\u1ec3 s\u1eed d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, b\u1ea1n c\u1ea7n ph\u1ea3i hi\u1ec3u r\u00f5 hai h\u00e0m n\u00e0y c\u00f3 \u0111i\u1ec3m g\u00ec chung v\u00e0 c\u00e1ch th\u1ee9c ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 n\u00e9t chung th\u00ec kh\u00e1 r\u00f5 r\u00e0ng \u2013 t\u01b0\u01a1ng \u0111\u1ed3ng v\u1ec1 \u0111i\u1ec3m \u0111\u1ebfn cho k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng v\u00e0 c\u00e1c tham s\u1ed1 \u2013 trong khi s\u1ef1 kh\u00e1c bi\u1ec7t d\u00f9 kh\u00f4ng r\u00f5 rang nh\u01b0ng v\u1eabn r\u1ea5t c\u1ea7n thi\u1ebft.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Trinh_tu_cua_cac_doi_so\"><\/span>1. Tr\u00ecnh t\u1ef1 c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong c\u00e1c h\u00e0m Excel SUMIF v\u00e0 SUMIFS, th\u1ee9 t\u1ef1 c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 kh\u00e1c nhau. C\u1ee5 th\u1ec3, sum_range l\u00e0 tham s\u1ed1 th\u1ee9 nh\u1ea5t trong SUMIFS, nh\u01b0ng l\u1ea1i \u0111\u1ee9ng th\u1ee9 3 trong c\u00f4ng th\u1ee9c SUMIF.<\/p>\n<p style=\"text-align: justify\">Khi b\u1eaft \u0111\u1ea7u h\u1ecdc, b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y c\u00f3 v\u1ebb nh\u01b0 Microsoft \u0111\u00e3 c\u1ed1 \u00fd l\u00e0m ph\u1ee9c t\u1ea1p h\u00f3a cho ng\u01b0\u1eddi h\u1ecdc v\u00e0 ng\u01b0\u1eddi d\u00f9ng n\u00f3. Tuy nhi\u00ean, khi xem x\u00e9t k\u1ef9 h\u01a1n, b\u1ea1n s\u1ebd th\u1ea5y l\u00fd do th\u1ef1c ch\u1ea5t \u0111\u1eb1ng sau n\u00f3. V\u1ea5n \u0111\u1ec1 l\u00e0 sum_range l\u00e0 t\u00f9y ch\u1ecdn trong SUMIF. N\u1ebfu b\u1ea1n b\u1ecf qua n\u00f3, kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1, SUMIF c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong range (tham s\u1ed1 \u0111\u1ea7u ti\u00ean).<\/p>\n<p style=\"text-align: justify\">Trong SUMIFS, sum_range l\u00e0 r\u1ea5t quan tr\u1ecdng v\u00e0 l\u00e0 b\u1eaft bu\u1ed9c, v\u00e0 \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao n\u00f3 \u0111\u1ebfn tr\u01b0\u1edbc. C\u00f3 th\u1ec3 nh\u1eefng ng\u01b0\u1eddi c\u1ee7a Microsoft ngh\u0129 r\u1eb1ng sau khi th\u00eam c\u00e1c d\u1ea3i\/\u0111i\u1ec1u ki\u1ec7n xem x\u00e9t th\u1ee9 10 ho\u1eb7c 100, th\u00ec c\u00f3 ai \u0111\u00f3 c\u00f3 th\u1ec3 qu\u00ean x\u00e1c \u0111\u1ecbnh d\u1ea3i \u0111\u1ec3 t\u00ednh t\u1ed5ng:)<\/p>\n<p style=\"text-align: justify\">T\u00f3m l\u1ea1i, n\u1ebfu b\u1ea1n \u0111ang sao ch\u00e9p v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c h\u00e0m n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u1eb7t c\u00e1c th\u00f4ng s\u1ed1 theo th\u1ee9 t\u1ef1 \u0111\u00fang.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Kich_thuoc_cua_doi_so_sum_range_va_criteria_range\"><\/span>2. K\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 <strong><em>sum_range v\u00e0 criteria_range<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong h\u00e0m SUMIF, \u0111\u1ed1i s\u1ed1 sum_range kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi \u0111\u1ed1i s\u1ed1 range, mi\u1ec5n l\u00e0 b\u1ea1n c\u00f3 \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i. Trong h\u00e0m SUMIFS, m\u1ed7i criteria_range ph\u1ea3i ch\u1ee9a c\u00f9ng m\u1ed9t s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u01b0 tham s\u1ed1 sum_range.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c <code><strong><em>= SUMIF (A2: A9, F1, C2: C18) <\/em><\/strong><\/code>s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u00fang v\u00ec Excel ch\u1ec9 xem \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i trong \u0111\u1ed1i s\u1ed1 sum_range (C2 trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u0111\u00fang) v\u00e0 sau \u0111\u00f3 bao g\u1ed3m s\u1ed1 c\u1ed9t v\u00e0 h\u00e0ng gi\u1ed1ng nh\u01b0 k\u00edch th\u01b0\u1edbc c\u1ee7a \u0111\u1ed1i s\u1ed1 range.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c SUMIFS<strong><em>:\u00a0 <code>= SUMIFS (C2: C9, A2: A9, \"apples\", B2: B10, \"Pete\") <\/code><\/em><\/strong>s\u1ebd b\u00e1o <strong><em>l\u1ed7i # VALUE!<\/em><\/strong> v\u00ec <strong><em>criter_range2 (B2: B10) <\/em><\/strong>kh\u00f4ng kh\u1edbp <strong><em>v\u1edbi criteria_range1 (A2: A9) <\/em><\/strong>v\u00e0 <strong><em>sum_range (C2: C9). <\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f3 v\u1ebb nh\u01b0 ch\u00fang ta \u0111\u00e3 ti\u1ebfp c\u1eadn t\u1ea1m xong l\u00fd thuy\u1ebft r\u1ed3i, n\u00ean m\u1ee5c sau ch\u00fang ta s\u1ebd chuy\u1ec3n sang thao t\u00e1c th\u1ef1c h\u00e0nh (ch\u00ednh l\u00e0 c\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c:)<\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u0103ng k\u00fd ngay:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_SUMIFS_trong_Excel_%E2%80%93_vi_du_cong_thuc\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng <strong><em>SUMIFS <\/em><\/strong>trong Excel \u2013 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1eeba n\u00e3y, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn v\u1ec1 m\u1ed9t c\u00f4ng th\u1ee9c SUMIFS \u0111\u01a1n gi\u1ea3n v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n v\u0103n b\u1ea3n. V\u1edbi ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Excel SUMIFS v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u1ec3 hi\u1ec7n b\u1eb1ng s\u1ed1, ng\u00e0y, bi\u1ec3u th\u1ee9c logic, v\u00e0 c\u00e1c h\u00e0m Excel kh\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_thuc_SUMIFS_voi_toan_tu_so_sanh\"><\/span>V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c <strong><em>SUMIFS <\/em><\/strong>v\u1edbi to\u00e1n t\u1eed so s\u00e1nh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong b\u1ea3ng cung c\u1ea5p tr\u00e1i c\u00e2y d\u01b0\u1edbi \u0111\u00e2y, gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c Mike cung c\u1ea5p v\u1edbi s\u1ed1 l\u01b0\u1ee3ng. t\u1eeb 200 tr\u1edf l\u00ean. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n s\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh \u201cl\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng\u201d (&gt; =) trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n 2 v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c SUMIFS sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMIFS (C2: C9, B2: B9, \u201cMike\u201d, C2: C9, \u201c&gt; = 200\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-comparison-operators.png\" alt=\"Excel SUMIFS formula with comparison operators\" title=\"excel-sumifs-comparison-operators\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: H\u00e3y l\u01b0u \u00fd r\u1eb1ng trong c\u00e1c c\u00f4ng th\u1ee9c SUMIFS, c\u00e1c bi\u1ec3u th\u1ee9c l\u00f4gic v\u1edbi c\u00e1c to\u00e1n t\u1eed so s\u00e1nh ph\u1ea3i lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p (\u201c\u201d).<\/p>\n<p style=\"text-align: justify\">Ch\u00fang t\u00f4i \u0111\u00e3 \u0111\u1ec1 c\u1eadp chi ti\u1ebft t\u1ea5t c\u1ea3 c\u00e1c to\u00e1n t\u1eed so s\u00e1nh c\u00f3 th\u1ec3 khi th\u1ea3o lu\u1eadn v\u1ec1 h\u00e0m Excel SUMIF, v\u00e0 c\u00e1c ch\u00fang c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong \u0111i\u1ec1u ki\u1ec7n SUMIFS. V\u00ed d\u1ee5: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2: C9 m\u00e0 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 200 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 300.<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMIFS (C2: C9, C2: C9, \u201c&gt; = 200\u201d, C2: C9, \u201c&lt;= 300\u201d)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Su_dung_cong_thuc_SUMIFS_voi_ngay\"><\/span>V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS v\u1edbi ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m TODAY () trong \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m SUMIFS c\u1ee7a b\u1ea1n, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y b\u00ean d\u01b0\u1edbi. C\u00f4ng th\u1ee9c sau \u0111\u00e2y t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u1ed9t D n\u1ebfu ng\u00e0y t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t C r\u01a1i v\u00e0o kho\u1ea3ng th\u1eddi gian 7 ng\u00e0y v\u1eeba qua, c\u00f3 bao g\u1ed3m ng\u00e0y h\u00f4m nay:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMIFS (D2: D10, C2: C10, \u201c&gt; =\u201d &amp; TODAY () \u2013 7, C2: C10, \u201c&lt;=\u201d &amp; TODAY ())<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-dates.png\" alt=\"Excel SUMIFS formula for dates\" title=\"excel-sumifs-dates\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. Khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m Excel kh\u00e1c c\u00f9ng v\u1edbi to\u00e1n t\u1eed logic trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u v\u00e0 (&amp;) \u0111\u1ec3 n\u1ed1i v\u1edbi 1 chu\u1ed7i, v\u00ed d\u1ee5 \u201c&lt;=\u201d &amp; TODAY ().<\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t d\u1ea3i c\u00f3 d\u1eef li\u1ec7u l\u00e0 ng\u00e0y x\u00e1c \u0111\u1ecbnh. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c SUMIFS sau s\u1ebd th\u00eam c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2: C9 n\u1ebfu ng\u00e0y trong c\u1ed9t B r\u01a1i trong kho\u1ea3ng gi\u1eefa ng\u00e0y 1 th\u00e1ng 10 n\u0103m 2014 v\u00e0 ng\u00e0y 31 th\u00e1ng 10 n\u0103m 2014, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= SUMIFS (C2: C9, B2: B9, \u201c&gt; = 10\/1\/2014\u201d, B2: B9, \u201c&lt;= 10\/31\/2014\u201d)<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c b\u1eb1ng c\u00e1ch t\u00ednh to\u00e1n s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a hai h\u00e0m SUMIF, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong v\u00ed d\u1ee5 n\u00e0y \u2013 C\u00e1ch s\u1eed d\u1ee5ng SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t d\u1ea3i ng\u00e0y x\u00e1c \u0111\u1ecbnh. Tuy nhi\u00ean, b\u1ea1n c\u0169ng th\u1ea5y r\u1eb1ng c\u00f4ng th\u1ee9c SUMIFS l\u00e0 d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n nhi\u1ec1u, ph\u1ea3i kh\u00f4ng n\u00e0o<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Ham_SUMIFS_voi_o_trong_va_khong_trong\"><\/span>V\u00ed d\u1ee5 3. H\u00e0m SUMIFS v\u1edbi \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi ph\u00e2n t\u00edch b\u00e1o c\u00e1o v\u00e0 d\u1eef li\u1ec7u kh\u00e1c, b\u1ea1n th\u01b0\u1eddng c\u1ea7n ph\u1ea3i t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 tr\u1ed1ng ho\u1eb7c kh\u00f4ng tr\u1ed1ng.<\/p>\n<table style=\"height: 822px\" width=\"938\">\n<tbody>\n<tr>\n<td width=\"73\"><\/td>\n<td width=\"62\"><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td width=\"278\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td width=\"323\"><strong>C\u00f4ng th\u01b0c v\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">Nh\u1eefng \u00f4 tr\u1ed1ng<\/td>\n<td>\u201c=\u201d<\/td>\n<td width=\"278\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 c\u00f3 \u00f4 tr\u1ed1ng t\u01b0\u01a1ng \u1ee9ng (ho\u00e0n to\u00e0n kh\u00f4ng ch\u1ee9a d\u0169 li\u1ec7u \u2013 kh\u00f4ng c\u00f4ng th\u1ee9c, v\u00e0 chu\u1ed7i c\u00f3 0 k\u00ed t\u1ef1)<\/td>\n<td width=\"323\"><strong>=SUMIFS(C2:C10, A2:A10, \u201c=\u201d, B2:B10, \u201c=\u201d)<\/strong><\/p>\n<p><strong>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4<\/strong> C2:C10 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi n\u00f3 trong c\u1ed9t A v\u00e0 B l\u00e0 \u00f4 ho\u00e0n to\u00e0n tr\u1ed1ng.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\u201c\u201d<\/td>\n<td width=\"278\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 tr\u1eafng \u201cnh\u1eadn \u0111\u1ecbnh tr\u1ef1c quan\u201d, bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb ch\u1ee9a c\u00e1c chu\u1ed7i r\u1ed7ng \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c (v\u00ed d\u1ee5: \u00f4 c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 = \u201c\u201d).<\/td>\n<td width=\"323\"><strong>=SUMIFS(C2:C10, A2:A10, \u201c\u201d, B2:B10, \u201c\u201d)<\/strong><\/p>\n<p>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 C2:C10 (c\u00f3 c\u00f9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n) nh\u01b0 c\u00f4ng th\u1ee9c \u1edf tr\u00ean, nh\u01b0ng c\u00f3 bao g\u1ed3m c\u00e1c chu\u1ed7i tr\u1ed1ng.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">Nh\u1eefng \u00f4 kh\u00f4ng tr\u1ed1ng<\/td>\n<td><strong>\u201c&lt;&gt;\u201d<\/strong><\/td>\n<td width=\"278\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng l\u00e0 c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng, v\u00e0 c\u00f3 bao g\u1ed3m chu\u1ed7i c\u00f3 chi\u1ec1u d\u00e0i b\u1eb1ng 0<\/td>\n<td width=\"323\"><strong>=SUMIFS(C2:C10, A2:A10, \u201c&lt;&gt;\u201d, B2:B10, \u201c&lt;&gt;\u201d)<\/strong><\/p>\n<p><strong>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4<\/strong> C2:C10 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi n\u00f3 trong c\u1ed9t A v\u00e0 B kh\u00f4ng l\u00e0 \u00f4 tr\u1ed1ng, c\u00f3 bao g\u1ed3m c\u00e1c \u00f4 v\u1edbi chu\u1ed7i tr\u1ed1ng.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>SUM-SUMIF<br \/>\nhay<br \/>\nSUM \/ LEN<\/td>\n<td width=\"278\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng l\u00e0 c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng, v\u00e0 kh\u00f4ng bao g\u1ed3m chu\u1ed7i c\u00f3 chi\u1ec1u d\u00e0i b\u1eb1ng 0<\/td>\n<td width=\"323\"><strong>=SUM(C2:C10) \u2013 SUMIFS(C2:C10, A2:A10, \u201c\u201d, B2:B10, \u201c\u201d)<\/strong><\/p>\n<p>=SUM((C2:C10) * (LEN(A2:A10)&gt;0)*(LEN(B2:B10)&gt;0))<\/p>\n<p><strong>T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4<\/strong> C2:C10 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi n\u00f3 trong c\u1ed9t A v\u00e0 B kh\u00f4ng l\u00e0 \u00f4 tr\u1ed1ng, v\u00e0 kh\u00f4ng bao g\u1ed3m c\u00e1c \u00f4 v\u1edbi chu\u1ed7i tr\u1ed1ng.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y c\u00f9ng xem c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u201ctr\u1ed1ng\u201d v\u00e0 \u201ckh\u00f4ng tr\u1ed1ng\u201d tr\u00ean d\u1eef li\u1ec7u th\u1ef1c nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 ng\u00e0y \u0111\u1eb7t h\u00e0ng trong c\u1ed9t B, ng\u00e0y giao h\u00e0ng trong c\u1ed9t C v\u00e0 s\u1ed1 l\u01b0\u1ee3ng trong c\u1ed9t D. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 s\u1ea3n ph\u1ea9m ch\u01b0a \u0111\u01b0\u1ee3c giao? Ngh\u0129a l\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u00f4 kh\u00f4ng r\u1ed7ng trong c\u1ed9t B v\u00e0 c\u00e1c \u00f4 r\u1ed7ng trong c\u1ed9t C.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS v\u1edbi 2 \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p style=\"text-align: justify\">= SUMIFS (D2: D10, B2: B10, \u201c&lt;&gt;\u201d, C2: C10, \u201c=\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-blank-nonblank.png\" alt=\"Excel SUMIFS formula for blank and non-blank cells\" title=\"excel-sumifs-blank-nonblank\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_4_Cach_viet_dieu_kien_ham_SUMIFS\"><\/span>V\u00ed d\u1ee5 4: C\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u0110\u1ec1 b\u00e0i:<\/strong>\u00a0Cho b\u1ea3ng d\u1eef li\u1ec7u t\u1ea1i v\u00f9ng F2:H10, t\u00ednh c\u00e1c k\u1ebft qu\u1ea3 t\u1ea1i v\u00f9ng B4:D7 theo c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1ea1i c\u1ed9t A (M\u00e3) v\u00e0 d\u00f2ng 3 (Ng\u00e0y)<br \/>\n<strong>B\u01b0\u1edbc 1: Ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i<\/strong><\/p>\n<ul>\n<li>\u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng theo 2\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 Ng\u00e0y v\u00e0 M\u00e3, do\u00a0\u0111\u00f3 ta kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF m\u00e0 ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m SUMIFS (\u1edf\u00a0\u0111\u00e2y ch\u00fang ta b\u1ecf qua c\u00e1c h\u00e0m kh\u00e1c m\u00e0 ch\u1ec9 x\u00e9t t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m SUMIF\/SUMIFS)<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh kh\u00f4ng ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh m\u00e0 t\u00f9y bi\u1ebfn, vi\u1ebft 1 h\u00e0m SUMIFS t\u1ea1i B4 r\u1ed3i copy h\u00e0m\u00a0\u0111\u00f3 sang c\u00e1c\u00a0\u00f4 kh\u00e1c\u00a0\u0111\u1ec3 t\u00ednh<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n M\u00e3 v\u00e0 Ng\u00e0y c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i trong c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p><span id=\"Buoc_2_Xay_dung_cong_thuc_SUMIFS\" class=\"ez-toc-section\"><\/span><strong>B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUMIFS<\/strong><br \/>\nC\u1ea5u tr\u00fac h\u00e0m\u00a0<strong>SUMIFS(sum_range, Criteria_range1, Criteria1, \u2026)<\/strong><\/p>\n<ul>\n<li><strong>Sum_range<\/strong>: l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria_range1<\/strong>: l\u00e0 c\u1ed9t M\u00e3 trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria1<\/strong>: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 M\u00e3 (\u0111\u1ec3 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi Criteria_range1), v\u1edbi\u00a0\u00f4 B4 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i\u00a0\u00f4 A4<\/li>\n<li><strong>Criteria_range2<\/strong>: l\u00e0 c\u1ed9t Ng\u00e0y trong v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u F2:H10<\/li>\n<li><strong>Criteria2<\/strong>: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n v\u1ec1 Ng\u00e0y (t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi Criteria_range2), v\u1edbi\u00a0\u00f4 B4 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i\u00a0\u00f4 B3<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 B4 c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p>B4=SUMIFS(H3:H10,F3:F10,A4,G3:G10,B3)<\/p>\n<div class=\"code-block code-block-1\">\n<div class=\"ad-inserterpro\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-105.gif\" title=\"ex101_92019-nho-105\"><\/a><\/div>\n<\/div>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/22-%E2%97%8F-cach-co-dinh-dong-co-dinh-cot-trong-excel.html\">C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/a><br \/>\n<span id=\"Buoc_3_Tuy_bien_dieu_kien_trong_ham_SUMIFS\" class=\"ez-toc-section\"><\/span><strong>B\u01b0\u1edbc 3: T\u00f9y bi\u1ebfn \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIFS<\/strong><br \/>\nV\u1edbi vi\u1ec7c copy sang b\u00ean ph\u1ea3i (FillRight t\u1eeb B4 t\u1edbi D4): v\u1edbi thao t\u00e1c n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i c\u1ed9t A, n\u00ean\u00a0\u00f4 A4 s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t l\u00e0 $A4<\/p>\n<p>V\u1edbi vi\u1ec7c copy xu\u1ed1ng d\u01b0\u1edbi (FillDown\u00a0t\u1eeb B4 t\u1edbi B7): v\u1edbi thao t\u00e1c n\u00e0y c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i d\u00f2ng 3, n\u00ean\u00a0\u00f4\u00a0B3 s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t l\u00e0 B$3<\/p>\n<p>V\u00f9ng d\u1eef li\u1ec7u F3:H10 c\u0169ng c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 khi copy c\u00f4ng th\u1ee9c th\u00ec v\u00f9ng n\u00e0y kh\u00f4ng thay\u00a0\u0111\u1ed5i<\/p>\n<p>Do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c t\u1ea1i B4 s\u1ebd\u00a0\u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng l\u1ea1i th\u00e0nh:<\/p>\n<blockquote>\n<p>B4=SUMIFS($H$3:$H$10,$F$3:$F$10,$A4,$G$3:$G$10,B$3)<\/p>\n<\/blockquote>\n<p>Khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c\u00a0\u00f4 c\u00f2n l\u1ea1i ta s\u1ebd\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3\u00a0\u0111\u00fang nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11673 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tc3b9y-bie1babfn-dk-02.png\" width=\"660\" height=\"410\" title=\"tc3b9y-bie1babfn-dk-02\"><\/p>\n<p><strong>*\u00a0\u00c1p d\u1ee5ng:<\/strong><\/p>\n<p>C\u00e1ch n\u00e0y th\u01b0\u1eddng d\u00f9ng trong c\u00e1c y\u00eau c\u1ea7u v\u1ec1 l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft, b\u00e1o c\u00e1o theo nhi\u1ec1u\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f9ng l\u00fac.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUMIF_co_nhieu_dieu_kien_OR\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUMIF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 l\u01b0u \u00fd \u1edf ph\u1ea7n \u0111\u1ea7u c\u1ee7a b\u00e0i n\u00e0y, th\u00ec h\u00e0m SUMIFS \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf v\u1edbi AND. Nh\u01b0ng n\u1ebfu b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR, ngh\u0129a l\u00e0 khi c\u00f3 \u00edt nh\u1ea5t m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng?<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_SUMIF_SUMIF\"><\/span>V\u00ed d\u1ee5 1. SUMIF + SUMIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 t\u00ednh t\u1ed5ng c\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi m\u1ed9t s\u1ed1 h\u00e0m SUMIF. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c sau \u0111\u00e2y s\u1ebd minh h\u1ecda c\u00e1ch t\u00ednh t\u1ed5ng s\u1ed1 s\u1ea3n ph\u1ea9m do Mike v\u00e0 John cung c\u1ea5p:<\/p>\n<p style=\"text-align: justify\">= SUMIF (C2: C9, \u201cMike\u201d, D2: D9) + SUMIF (C2: C9, \u201cJohn\u201d, D2: D9)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-multiple-conditions.png\" alt=\"Excel SUMIF formula with multiple OR criteria\" title=\"excel-sumif-multiple-conditions\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, h\u00e0m SUMIF \u0111\u1ea7u ti\u00ean cho bi\u1ebft s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u201cMike\u201d, c\u00f2n h\u00e0m SUMIF kia th\u00ec tr\u1ea3 l\u1ea1i s\u1ed1 ti\u1ec1n li\u00ean quan \u0111\u1ebfn \u201cJohn\u201d v\u00e0 sau \u0111\u00f3 b\u1ea1n c\u1ed9ng hai k\u1ebft qu\u1ea3 n\u00e0y l\u1ea1i.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_SUM_SUMIF_voi_doi_so_mang\"><\/span>V\u00ed d\u1ee5 2. SUM &amp; SUMIF v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00e1c gi\u1ea3i ph\u00e1p tr\u00ean r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 th\u1ef1c s\u1ef1 hi\u1ec7u qu\u1ea3 cao khi ch\u1ec9 c\u00f3 m\u1ed9t v\u00e0i \u0111i\u1ec1u ki\u1ec7n. Nh\u01b0ng m\u1ed9t c\u00f4ng th\u1ee9c SUMIF + SUMIF c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n r\u1ea5t nhi\u1ec1u n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n OR. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00e1ch ti\u1ebfp c\u1eadn t\u1ed1t h\u01a1n l\u00e0 s\u1eed d\u1ee5ng m\u1ed9t \u0111\u1ed1i s\u1ed1 nh\u01b0 \u0111i\u1ec1u ki\u1ec7n m\u1ea3ng trong h\u00e0m SUMIF, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n, \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1edfi d\u1ea5u ph\u1ea9y v\u00e0 sau \u0111\u00f3\u00a0 \u0111\u1eb7t ch\u00fang trong {d\u1ea5u ngo\u1eb7c nh\u1ecdn}, \u0111i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c s\u1ea3n ph\u1ea9m do John, Mike v\u00e0 Pete cung c\u1ea5p, \u0111i\u1ec1u ki\u1ec7n m\u1ea3ng c\u1ee7a b\u1ea1n s\u1ebd nh\u01b0 th\u1ebf n\u00e0y {\u201cJohn\u201d, \u201cMike\u201d, \u201cPete\u201d}. V\u00e0 h\u00e0m SUMIF ho\u00e0n ch\u1ec9nh l\u00e0: =SUMIF (C2: C9, {\u201cJohn\u201d, \u201cMike\u201d, \u201cPete\u201d}, D2: D9).<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i s\u1ed1 m\u1ea3ng bao g\u1ed3m 3 gi\u00e1 tr\u1ecb b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 trong c\u00f4ng th\u1ee9c SUMIF \u0111\u1ec3 tr\u1ea3 v\u1ec1 ba k\u1ebft qu\u1ea3 \u0111\u1ed9c l\u1eadp, nh\u01b0ng v\u00ec ch\u00fang ta vi\u1ebft c\u00f4ng th\u1ee9c trong m\u1ed9t \u00f4 duy nh\u1ea5t, n\u00f3 s\u1ebd ch\u1ec9 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean \u2013 t\u1ee9c l\u00e0 t\u1ed5ng s\u1ed1 s\u1ea3n ph\u1ea9m do John cung c\u1ea5p. \u0110\u1ec3 n\u00f3 ho\u1ea1t \u0111\u1ed9ng, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng v\u00e0i m\u1eb9o \u2013 l\u1ed3ng c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n trong m\u1ed9t h\u00e0m SUM, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= SUM (SUMIF (C2: C9, {\u201cJohn\u201d, \u201cMike\u201d, \u201cPete\u201d}, D2: D9))<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sum-sumif-or-conditions.png\" alt=\"Using SUM &amp; SUMIF with an array argument to sum values with multiple OR criteria\" title=\"excel-sum-sumif-or-conditions\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u1ea3ng nh\u01b0 tr\u00ean \u0111\u00e3 l\u00e0m cho c\u00f4ng th\u1ee9c nh\u1ecf g\u1ecdn h\u01a1n nhi\u1ec1u so v\u1edbi SUMIF + SUMIF, v\u00e0 ch\u00fang cho ph\u00e9p b\u1ea1n th\u00eam nhi\u1ec1u gi\u00e1 tr\u1ecb nh\u01b0 b\u1ea1n mu\u1ed1n trong m\u1ea3ng \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1ebd ch\u1ea1y v\u1edbi c\u00e1c con s\u1ed1 ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. V\u00ed d\u1ee5: n\u1ebfu thay v\u00ec b\u1ea1n c\u00f3 t\u00ean c\u00e1c nh\u00e0 cung c\u1ea5p trong c\u1ed9t C, m\u00e0 b\u1ea1n ch\u1ec9 c\u00f3 ID nh\u00e0 cung c\u1ea5p nh\u01b0 1, 2, 3, v.v \u2026 th\u00ec c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= SUM (SUMIF (C2: C9, {1,2,3}, D2: D9))<\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, c\u00e1c con s\u1ed1 kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c bao g\u1ed3m trong d\u1ea5u nh\u00e1y k\u00e9p trong \u0111\u1ed1i s\u1ed1 m\u1ea3ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_SUMPRODUCT_SUMIF\"><\/span>V\u00ed d\u1ee5 3. <strong><em>SUMPRODUCT &amp; SUMIF<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p, B\u1ea1n th\u00edch li\u1ec7t k\u00ea c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong v\u00e0i \u00f4 thay v\u00ec ch\u1ec9 \u0111\u1ecbnh ch\u00fang tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng SUMIF k\u1ebft h\u1ee3p v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SUMPRODUCT<\/a>\u00a0\u0111\u1ec3 nh\u00e2n nhi\u1ec1u th\u00e0nh ph\u1ea7n trong c\u00e1c m\u1ea3ng\u00a0 x\u00e1c \u0111\u1ecbnh r\u1ed3i tr\u1ea3 l\u1ea1i t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMPRODUCT (SUMIF (C2: C9, G2: G4, D2: D9))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p G2: G4 l\u00e0 c\u00e1c \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n, th\u00ec it\u00ean nh\u00e0 cung c\u1ea5p trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u01b0\u1ee3c minh h\u1ecda nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng t\u1ea5t nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n n\u1ebfu b\u1ea1n mu\u1ed1n li\u1ec7t k\u00ea c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u1ea3ng c\u1ee7a h\u00e0m SUMIF\u201d<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMPRODUCT (SUMIF (C2: C9, {\u201cMike\u201d, \u201cJohn\u201d, \u201cPete\u201d}, D2: D9))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi c\u1ea3 hai c\u00f4ng th\u1ee9c s\u1ebd gi\u1ed1ng nh\u01b0 nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y trong h\u00ecnh:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumproduct-sumif-multiple-criteria.png\" alt=\"Sum with multiple criteria using the SUMPRODUCT \/ SUMIF formula\" title=\"sumproduct-sumif-multiple-criteria\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Excel_SUMIFS_co_nhieu_dieu_kien_OR\"><\/span>Excel <strong><em>SUMIFS<\/em><\/strong> c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n <strong><em>OR<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb trong Excel th\u00ec kh\u00f4ng ch\u1ec9 li\u00ean quan t\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n OR, nh\u01b0ng v\u1edbi m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng SUMIFS thay v\u00ec SUMIF. C\u00e1c c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 nh\u1eefng g\u00ec m\u00e0 ch\u00fang ta v\u1eeba th\u1ea3o lu\u1eadn.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 th\u01b0\u1eddng l\u1ec7, m\u1ed9t v\u00ed d\u1ee5 c\u00f3 th\u1ec3 gi\u00fap minh h\u1ecda t\u1ed1t h\u01a1n \u0111i\u1ec1u tr\u00ean. Trong b\u1ea3ng c\u00e1c nh\u00e0 cung c\u1ea5p tr\u00e1i c\u00e2y c\u1ee7a ch\u00fang t\u00f4i, h\u00e3y th\u00eam Delivery Date (Ng\u00e0y giao h\u00e0ng) (c\u1ed9t E) v\u00e0 t\u00ecm t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng \u0111\u01b0\u1ee3c Mike, John v\u00e0 Pete giao v\u00e0o th\u00e1ng 10.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_SUMIFS_SUMIFS\"><\/span>V\u00ed d\u1ee5 1. <strong><em>SUMIFS + SUMIFS<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1edfi c\u00e1ch ph\u01b0\u01a1ng ph\u00e1p n\u00e0y bao g\u1ed3m nhi\u1ec1u l\u1ea7n l\u1eb7p \u0111i l\u1eb7p l\u1ea1i v\u00e0 tr\u00f4ng c\u00f3 v\u1ebb r\u01b0\u1eddm r\u00e0, tuy v\u1eady nh\u01b0ng n\u00f3 r\u1ea5t d\u1ec5 hi\u1ec3u, v\u00e0 \u0111i\u1ec3m quan tr\u1ecdng nh\u1ea5t l\u00e0 n\u00f3 ho\u1ea1t \u0111\u1ed9ng t\u1ed1t \ud83d\ude42<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUMIFS (D2: D9, C2: C9, \u201cMike\u201d, E2: E9, \u201c&gt; = 10\/1\/2014\u201d, E2: E9, \u201c&lt;= 10\/31\/2014\u201d) +<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>SUMIFS (D2: D9, C2: C9, \u201cJohn\u201d, E2: E9, \u201c&gt; = 10\/1\/2014\u201d, E2: E9, \u201c&lt;= 10\/31\/2014\u201d) +<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>SUMIFS (D2: D9, C2: C9, \u201cPete\u201d, E2: E9, \u201c&gt; = 10\/1\/2014\u201d, E2: E9, \u201c&lt;= 10\/31\/2014\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, khi b\u1ea1n vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c SUMIFS ri\u00eang cho t\u1eebng nh\u00e0 cung c\u1ea5p v\u00e0 th\u1ecfa c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u2013 t\u1eeb th\u00e1ng 10 (\u201c&gt; = 10\/1\/2014\u201d) tr\u1edf \u0111i v\u00e0 t\u1eeb 31 th\u00e1ng 10(\u201c&lt;= 10\/31\/2014\u201d) tr\u1edf v\u1ec1 tr\u01b0\u1edbc \u0111\u00f3, v\u00e0 sau \u0111\u00f3 b\u1ea1n t\u00ednh t\u1ed5ng c\u00e1c k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-multiple-or-conditions.png\" alt=\"Add several SUMIFS functions to sum values with multiple OR conditions\" title=\"excel-sumifs-multiple-or-conditions\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_SUM_SUMIFS_voi_doi_so_mang\"><\/span>V\u00ed d\u1ee5 2. SUM &amp; SUMIFS v\u1edbi \u0111\u1ed1i s\u1ed1 m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u00f4i \u0111\u00e3 c\u1ed1 g\u1eafng gi\u1ea3i th\u00edch b\u1ea3n ch\u1ea5t c\u1ee7a c\u00e1ch ti\u1ebfp c\u1eadn n\u00e0y trong v\u00ed d\u1ee5 v\u1edbi SUMIF, v\u00ec v\u1eady b\u00e2y gi\u1edd ch\u00fang ta ch\u1ec9 c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u00f3, thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c \u0111\u1ed1i s\u1ed1 (c\u00f3 s\u1ef1 kh\u00e1c nhau \u1edf SUMIF v\u00e0 SUMIFS \u2013 nh\u01b0 tr\u00ean \u0111\u00e3 \u0111\u1ec1 c\u1eadp) v\u00e0 th\u00eam c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung. C\u00f4ng th\u1ee9c k\u1ebft qu\u1ea3 sau s\u1ebd nh\u1ecf g\u1ecdn h\u01a1n SUMIFS + SUMIFS:<\/p>\n<p style=\"text-align: justify\">= SUM (SUMIFS (D2: D9, C2: C9, {\u201cMike\u201d, \u201cJohn\u201d, \u201cPete\u201d}, E2: E9, \u201c&gt; = 10\/1\/2014\u201d, E2: E9, \u201c&lt;= 10 \/ 31\/2014 \u201c))<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1eb1ng c\u00f4ng th\u1ee9c n\u00e0y gi\u1ed1ng nh\u01b0 nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_SUMPRODUCT_SUMIFS\"><\/span>V\u00ed d\u1ee5 3. SUMPRODUCT &amp; SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n nh\u1edb, th\u00ec c\u00e1ch ti\u1ebfp c\u1eadn SUMPRODUCT kh\u00e1c v\u1edbi hai c\u00e1ch tr\u01b0\u1edbc \u0111\u00f3 theo c\u00e1ch b\u1ea1n nh\u1eadp m\u1ed7i \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t thay v\u00ec nh\u1eadp ch\u00fang tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c. Trong tr\u01b0\u1eddng h\u1ee3p m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n, h\u00e0m SUMPRODUCT s\u1ebd kh\u00f4ng \u0111\u1ee7 v\u00e0 b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m ISNUMBER v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0h\u00e0m MATCH<\/a>.<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, gi\u1ea3 s\u1eed r\u1eb1ng c\u00e1c t\u00ean ng\u01b0\u1eddi cung c\u1ea5p n\u1eb1m trong c\u00e1c \u00f4 H1: H3, Ng\u00e0y b\u1eaft \u0111\u1ea7u (Start date) n\u1eb1m trong \u00f4 H4 v\u00e0 ng\u00e0y k\u1ebft th\u00fac (End date) trong \u00f4 H5, c\u00f4ng th\u1ee9c SUMPRODUCT c\u1ee7a ch\u00fang t\u00f4i c\u00f3 d\u1ea1ng sau:<\/p>\n<p style=\"text-align: justify\">= SUMPRODUCT (\u2013 (E2: E9&gt; = H4), \u2013 (E2: E9 &lt;= H5), \u2014 (ISNUMBER (MATCH (C2: C9, H1: H3,0)), D2: D9)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6362 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-168.png\" width=\"600\" height=\"254\" title=\"excel-dialog-box-launcher-1-168\"><\/p>\n<p style=\"text-align: justify\">S\u1ebd c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi t\u1ef1 h\u1ecfi r\u1eb1ng t\u1ea1i sao l\u1ea1i s\u1eed d\u1ee5ng 2 d\u1ea5u g\u1ea1ch ngang (\u2013) trong c\u00f4ng th\u1ee9c SUMPRODUCT. V\u1ea5n \u0111\u1ec1 \u0111\u1eb7t ra l\u00e0 h\u00e0m SUMPRODUCT b\u1ecf qua t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1, trong khi c\u00e1c to\u00e1n t\u1eed so s\u00e1nh trong c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta s\u1ebd tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb Boolean (TRUE \/ FALSE), kh\u00f4ng ph\u1ea3i s\u1ed1. \u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb Boolean n\u00e0y th\u00e0nh 1 v\u00e0 0, b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u hai ch\u1ea5m, \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb. C\u00e1c to\u00e1n t\u1eed \u0111\u01a1n v\u1ecb \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c g\u00e1n cho <strong><em>TRUE \/ FALSE<\/em><\/strong> nh\u01b0 l\u00e0 -1\/0, t\u01b0\u01a1ng \u1ee9ng. To\u00e1n t\u1eed \u0111\u01a1n v\u1ecb th\u1ee9 hai s\u1ebd ph\u1ee7 \u0111\u1ecbnh gi\u00e1 tr\u1ecb, t\u1ee9c l\u00e0 \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u, bi\u1ebfn ch\u00fang th\u00e0nh +1 v\u00e0 0, v\u00e0 h\u00e0m SUMPRODUCT c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">T\u00f4i hy v\u1ecdng l\u1eddi gi\u1ea3i th\u00edch tr\u00ean c\u00f3 \u00fd ngh\u0129a v\u1edbi b\u1ea1n. V\u00e0 th\u1eadm ch\u00ed n\u1ebfu kh\u00f4ng, th\u00ec th\u1ef1c s\u1ef1 l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb nguy\u00ean t\u1eafc n\u00e0y \u2013 s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u0111\u00f4i (\u2013) khi b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh trong c\u00e1c c\u00f4ng th\u1ee9c SUMPRODUCT.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUM_trong_cac_cong_thuc_mang\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUM trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, th\u00ec Microsoft \u0111\u00e3 th\u1ef1c hi\u1ec7n h\u00e0m SUMIFS trong Excel 2007. N\u1ebfu ai \u0111\u00f3 v\u1eabn s\u1eed d\u1ee5ng Excel 2003, 2000 ho\u1eb7c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3, th\u00ec b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng SUM \u0111\u1ec3 th\u00eam c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND. \u0110\u01b0\u01a1ng nhi\u00ean, ph\u01b0\u01a1ng ph\u00e1p ti\u1ebfp c\u1eadn n\u00e0y c\u0169ng ho\u1ea1t \u0111\u1ed9ng trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2013 \u2013 2007, v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c coi l\u00e0 s\u1ef1 l\u1ed7i th\u1eddi c\u1ee7a h\u00e0m SUMIFS.<\/p>\n<p style=\"text-align: justify\">Tuy trong c\u00e1c c\u00f4ng th\u1ee9c SUMIF \u0111\u00e3 th\u1ea3o lu\u1eadn \u1edf tr\u00ean c\u00f3 s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 m\u1ea3ng, nh\u01b0ng m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng l\u1ea1i l\u00e0 m\u1ed9t c\u00e1i g\u00ec \u0111\u00f3 kh\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Sum_voi_cac_dieu_kien_AND_trong_Excel_2003_va_phien_ban_truoc_do\"><\/span>V\u00ed d\u1ee5 1. Sum v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n AND trong Excel 2003 v\u00e0 phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ch\u00fang ta h\u00e3y quay l\u1ea1i v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean m\u00e0 ch\u00fang ta t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng \u1ee9ng v\u1edbi m\u1ed9t lo\u1ea1i tr\u00e1i c\u00e2y v\u00e0 nh\u00e0 cung c\u1ea5p nh\u1ea5t \u0111\u1ecbnh:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumifs-source-data.png\" alt=\"Data to be summed with two conditions\" title=\"excel-sumifs-source-data\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c SUMIFS th\u00f4ng th\u01b0\u1eddng:<\/p>\n<p style=\"text-align: justify\">= SUMIFS (C2: C9, A2: A9, \u201capples\u201d, B2: B9, \u201cPete\u201d)<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng xem v\u1ea5n \u0111\u1ec1 t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o trong phi\u00ean b\u1ea3n Excel \u201ckh\u00f4ng c\u00f3 SUMIFS\u201d. Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n vi\u1ebft ra t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng \u1edf d\u1ea1ng d\u1ea3i = \u201c\u0111i\u1ec1u ki\u1ec7n\u201d. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 hai c\u1eb7p d\u1ea3i \/ \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u ki\u1ec7n 1: A2: A9 = \u201capples\u201d<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u ki\u1ec7n 2: B2: B9 = \u201cPete\u201d<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c SUM c\u00f3 nh\u00e2n t\u1ea5t c\u1ea3 trong tr\u01b0\u1eddng h\u1ee3p: t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c c\u1eb7p d\u1ea3i \/ \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n, m\u1ed7i c\u1eb7p \u0111\u01b0\u1ee3c \u0111\u1eb7t trong ngo\u1eb7c \u0111\u01a1n. H\u1ec7 s\u1ed1 nh\u00e2n cu\u1ed1i c\u00f9ng l\u00e0 d\u1ea3i \u0111\u1ec3 t\u00ednh t\u1ed5ng, l\u00e0 C2: C9 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y:<\/p>\n<p style=\"text-align: justify\">= SUM ((A2: A9 = \u201capples\u201d) * (B2: B9 = \u201cPete\u201d) * (C2: C9))<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong h\u00ecnh b\u00ean d\u01b0\u1edbi, th\u00ec c\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng r\u1ea5t t\u1ed1t trong phi\u00ean b\u1ea3n Excel 2013 m\u1edbi nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sum-array-formula.png\" alt=\"An example of using Excel SUM in an array formula\" title=\"excel-sum-array-formula\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd:<\/strong> Khi nh\u1eadp b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0o, b\u1ea1n ph\u1ea3i nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter. Ch\u1ec9 nh\u01b0 v\u1eady th\u00ec c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong {d\u1ea5u ngo\u1eb7c nh\u1ecdn} \u2013 m\u1ed9t d\u1ea5u hi\u1ec7u cho bi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01b0\u1ee3c nh\u1eadp ch\u00ednh x\u00e1c. N\u1ebfu b\u1ea1n c\u1ed1 g\u00f5 d\u1ea5u ngo\u1eb7c b\u1eb1ng tay, th\u00ec c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 n\u00f3 s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Cac_cong_thuc_mang_SUM_trong_cac_phien_ban_Excel_hien_dai\"><\/span>V\u00ed d\u1ee5 2. C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng SUM trong c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ngay c\u1ea3 trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2013, 2010 ho\u1eb7c 2007, s\u1ee9c m\u1ea1nh c\u1ee7a h\u00e0m SUM kh\u00f4ng bao gi\u1edd b\u1ecb \u0111\u00e1nh gi\u00e1 th\u1ea5p. C\u00f4ng th\u1ee9c m\u1ea3ng SUM kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 luy\u1ec7n t\u1eadp h\u01b0\u1edbng suy ngh\u0129 m\u00e0 c\u00f2n c\u00f3 gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf, nh\u01b0 trong v\u00ed d\u1ee5 sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 hai c\u1ed9t, B v\u00e0 C, v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft \u0111\u01b0\u1ee3c c\u1ed9t C l\u1edbn h\u01a1n g\u1ea5p bao nhi\u00eau l\u1ea7n so v\u1edbi c\u1ed9t B, khi m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t C l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10. M\u1ed9t gi\u1ea3i ph\u00e1p m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 ra \u0111o l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng SUM:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM ((C1: C10&gt; = 10) * (C1: C10&gt; B1: B10))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-array-formula-excel2013.png\" alt=\"Using SUM array formulas in modern Excel versions\" title=\"sum-array-formula-excel2013\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n v\u1eabn kh\u00f4ng th\u1ea5y b\u1ea5t k\u1ef3 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf n\u00e0o \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c tr\u00ean? H\u00e3y suy ngh\u0129 v\u1ec1 n\u00f3 theo m\u1ed9t c\u00e1ch kh\u00e1c:)<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch \u0111\u01a1n \u0111\u1eb7t h\u00e0ng nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau s\u1ea3n ph\u1ea9m ch\u01b0a \u0111\u01b0\u1ee3c g\u1eedi \u0111\u1ea7y h\u1ebft trong m\u1ed9t ng\u00e0y x\u00e1c \u0111\u1ecbnh. Ch\u00fang t\u00f4i c\u00f3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau (\u0111\u01b0\u1ee3c d\u1ecbch sang ng\u00f4n ng\u1eef c\u1ee7a Excel):<\/p>\n<ul style=\"list-style-type: disc\">\n<li style=\"text-align: justify\"><strong>\u0110i\u1ec1u ki\u1ec7n 1<\/strong>: Gi\u00e1 tr\u1ecb trong c\u1ed9t B (Ordered items) l\u1edbn h\u01a1n 0<\/li>\n<li style=\"text-align: justify\"><strong>\u0110i\u1ec1u ki\u1ec7n 2<\/strong>: M\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t C (Delivered) \u00edt h\u01a1n trong c\u1ed9t B<\/li>\n<li style=\"text-align: justify\"><strong>\u0110i\u1ec1u ki\u1ec7n 3<\/strong>: Ng\u00e0y trong c\u1ed9t D (Due date) \u00edt h\u01a1n 11\/1\/2014.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1eb7t ba c\u1eb7p range \/ \u0111i\u1ec1u ki\u1ec7n l\u1ea1i v\u1edbi nhau, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>= SUM ((B2: B10&gt; = 0) * (B2: B10&gt; C2: C10) * (D2: D10 &lt;G2))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-array-multiple-conditions.png\" alt=\"An example of SUM array formula in Excel 2013\" title=\"sum-array-multiple-conditions\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c th\u1ea3o lu\u1eadn trong b\u00e0i n\u00e0y c\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a t\u1ea3ng b\u0103ng tr\u00f4i c\u1ee7a h\u00e0m SUMIFS v\u00e0 SUMIF. Nh\u01b0ng hy v\u1ecdng r\u1eb1ng, ch\u00fang \u0111\u00e3 ch\u1ec9 ra h\u01b0\u1edbng suy ngh\u0129 cho b\u1ea1n \u0111\u1ec3 hi\u1ec7n t\u1ea1i b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng t\u00ednh Excel (kh\u00f4ng quan t\u00e2m \u0111\u1ebfn r\u1eb1ng c\u00f3 bao nhi\u00eau \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p m\u00e0 c\u1ea7n b\u1ea1n c\u00e2n nh\u1eafc)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thong_tin_bo_ich_khac_trong_viec_ung_dung_ham_Sumifs\"><\/span><strong>Th\u00f4ng tin b\u1ed5 \u00edch kh\u00e1c trong vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m Sumifs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>V\u1edbi h\u00e0m SUMIFS, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam \u0111\u1ebfn 127 \u0111i\u1ec1u ki\u1ec7n hay ti\u00eau ch\u00ed m\u1ed9t l\u1ea7n. Tuy nhi\u00ean,c\u00e0ng nhi\u1ec1u ti\u00eau ch\u00ed c\u00e0ng d\u1eabn \u0111\u1ebfn sai s\u00f3t, v\u00ec v\u1eady h\u00e3y c\u1ed1 g\u1eafng vi\u1ebft ng\u1eafn g\u1ecdn.<\/li>\n<li>N\u1ebfu c\u00f3 b\u1ea5t k\u00ec \u00f4 tr\u1ed1ng n\u00e0o trong c\u00e1c d\u00e3y ti\u00eau ch\u00ed (criteria range), Excel s\u1ebd cho k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 \u201ckh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c\u201d. V\u00ec v\u1eady, h\u00e3y ki\u1ec3m tra v\u00e0 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 v\u00e0o c\u00e1c d\u00e3y, \u0111\u1eb7c bi\u1ec7t criteria range \u0111\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/li>\n<li>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong c\u00f4ng th\u1ee9c SUMIFS. V\u00ed d\u1ee5: \u201c?\u201d l\u00e0 t\u00ecm ki\u1ebfm m\u1ed9t ch\u1eef c\u00e1i v\u00e0 \u201c*\u201d l\u00e0 ph\u1ea7n c\u00f2n l\u1ea1i sau c\u00e1c ch\u1eef c\u00e1i c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3.<\/li>\n<\/ul>\n<p>Ngo\u00e0i h\u00e0m SumIf, SumIfS\u00a0gi\u00fap t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 SUMPRODUCT \u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y. Trong th\u1ef1c t\u1ebf th\u00ec y\u00eau c\u1ea7u t\u00ednh to\u00e1n v\u00e0 \u0111\u1eb7c \u0111i\u1ec3m d\u1eef li\u1ec7u s\u1ebd quy\u1ebft \u0111\u1ecbnh t\u1edbi vi\u1ec7c ch\u00fang ta s\u1ebd c\u1ea7n d\u00f9ng h\u00e0m n\u00e0o, d\u00f9ng nh\u01b0 th\u1ebf n\u00e0o. Do \u0111\u00f3 b\u1ea1n c\u1ea7n b\u1ed5 sung th\u00eam cho m\u00ecnh c\u00e0ng nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 h\u00e0m, v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u th\u00ec c\u00e0ng thu\u1eadn l\u1ee3i khi l\u00e0m vi\u1ec7c.<\/p>\n<p><strong>Xem th\u00eam: C\u00e1ch d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">h\u00e0m SUMIF trong Excel<\/a> 2021 \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 D\u1ec5 Hi\u1ec3u<\/strong><\/p>\n<p>Ti\u1ebfp \u0111\u00f3 l\u00e0 vi\u1ec7c c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel \u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c nh\u01b0: \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n, tr\u00edch l\u1ecdc, s\u1eafp x\u1ebfp, b\u00e1o c\u00e1o b\u1eb1ng Pivot Table, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-41.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1448,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1447","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\/1447","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=1447"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1447\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1448"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}