{"id":2163,"date":"2024-12-02T07:06:58","date_gmt":"2024-12-02T07:06:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop\/"},"modified":"2024-12-02T07:06:58","modified_gmt":"2024-12-02T07:06:58","slug":"ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop\/","title":{"rendered":"H\u00e0m SUMIF trong Excel: v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 t\u1eebng tr\u01b0\u1eddng h\u1ee3p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"> <strong>h\u00e0m SUMIF<\/strong><\/a> \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 theo \u0111i\u1ec1u ki\u1ec7n<\/span><span style=\"font-weight: 400\">. <\/span><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft s\u1ebd t\u1eadp trung v\u00e0o c\u00e1c v\u00ed d\u1ee5 v\u1edbi ti\u00eau ch\u00ed ng\u00e0y th\u00e1ng, v\u0103n b\u1ea3n, s\u1ed1, k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, \u00f4 r\u1ed7ng (blank) v\u00e0 \u00f4 kh\u00f4ng r\u1ed7ng.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Microsoft Excel c\u00f3 ch\u1ee9c n\u0103ng t\u1ed5ng h\u1ee3p c\u00e1c d\u1eef li\u1ec7u l\u1edbn t\u1eeb c\u00e1c b\u00e1o c\u00e1o v\u00e0 ph\u00e2n t\u00edch. M\u1ed9t trong nh\u1eefng h\u00e0m h\u1eefu \u00edch nh\u1ea5t c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 b\u1eb1ng <strong>h\u00e0m SUMIF<\/strong>. Thay v\u00ec c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 trong m\u1ed9t ph\u1ea1m vi, n\u00f3 cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb \u0111\u00e1p \u1ee9ng ti\u00eau ch\u00ed. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>t\u00ecm hi\u1ec3u ngay sau \u0111\u00e2y.<\/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-674d5c91248f8\" 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\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Ham_SUMIF_trong_Excel\" title=\"H\u00e0m SUMIF trong Excel\">H\u00e0m SUMIF trong Excel<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Ham_SUMIF_co_ban\" title=\"H\u00e0m SUMIF c\u01a1 b\u1ea3n\">H\u00e0m SUMIF c\u01a1 b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Lam_the_nao_de_su_dung_ham_SUMIF_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_ve_ham_SUMIF_trong_Excel\" title=\"V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIF trong Excel\">V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIF trong Excel<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_1_SUMIF_lon_hon_va_nho_hon\" title=\"V\u00ed d\u1ee5 1: SUMIF l\u1edbn h\u01a1n v\u00e0 nh\u1ecf h\u01a1n\">V\u00ed d\u1ee5 1: SUMIF l\u1edbn h\u01a1n v\u00e0 nh\u1ecf h\u01a1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_2_SUMIF_bang\" title=\"V\u00ed d\u1ee5 2. SUMIF b\u1eb1ng\">V\u00ed d\u1ee5 2. SUMIF b\u1eb1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_3_SUMIF_khong_bang\" title=\"V\u00ed d\u1ee5 3: SUMIF kh\u00f4ng b\u1eb1ng\">V\u00ed d\u1ee5 3: SUMIF kh\u00f4ng b\u1eb1ng<\/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\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_4_SUMIF_khong_trong\" title=\"V\u00ed d\u1ee5 4: SUMIF kh\u00f4ng tr\u1ed1ng\">V\u00ed d\u1ee5 4: SUMIF 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-9\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_5_SUMIF_trong\" title=\"V\u00ed d\u1ee5 5. SUMIF tr\u1ed1ng\">V\u00ed d\u1ee5 5. SUMIF 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\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_6_Ky_tu_dai_dien_SUMIF_trong_Excel\" title=\"V\u00ed d\u1ee5 6. K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n SUMIF trong Excel\">V\u00ed d\u1ee5 6. K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n SUMIF trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Vi_du_7_SUMIF_trong_Excel_voi_ngay_thang\" title=\"V\u00ed d\u1ee5 7: SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng\">V\u00ed d\u1ee5 7: SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Cach_thuc_hien_SUMIF_tu_mot_sheet_khac\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n SUMIF t\u1eeb m\u1ed9t sheet kh\u00e1c\">C\u00e1ch th\u1ef1c hi\u1ec7n SUMIF t\u1eeb m\u1ed9t sheet kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html#Cong_thuc_SUMIF_phan_biet_chu_hoa_chu_thuong_trong_Excel\" title=\"C\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\">C\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIF_trong_Excel\"><\/span><b>H\u00e0m SUMIF trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n hay ti\u00eau ch\u00ed m\u00e0 b\u1ea1n \u0111\u01b0a ra.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u00f3 c\u00f3 c\u00fa ph\u00e1p v\u00e0 tham s\u1ed1 sau:<\/span><\/p>\n<table style=\"border-collapse: collapse;width: 100%;height: 23px\">\n<tbody>\n<tr style=\"height: 23px\">\n<td style=\"width: 100%;height: 23px\"><strong>SUMIF(range, criteria, [sum_range])<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Range<\/strong> (B\u1eaft bu\u1ed9c) \u2013 v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u theo ti\u00eau ch\u00ed.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Criteria<\/strong> (B\u1eaft bu\u1ed9c) \u2013 <\/span><span style=\"font-weight: 400\">\u0111i\u1ec1u ki\u1ec7n hay ti\u00eau ch\u00ed \u0111\u01b0a ra \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu v\u1edbi v\u00f9ng d\u1eef li\u1ec7u \u1edf tham s\u1ed1 \u0111\u1ea7u ti\u00ean<\/span><span style=\"font-weight: 400\">. N\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng m\u1ed9t s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, tham chi\u1ebfu \u00f4, bi\u1ec3u th\u1ee9c logic ho\u1eb7c h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Sum_range<\/strong> (t\u00f9y ch\u1ecdn) \u2013 <\/span><span style=\"font-weight: 400\">v\u00f9ng d\u1eef li\u1ec7u s\u1ebd t\u00ednh t\u1ed5ng<\/span><span style=\"font-weight: 400\">. N\u1ebfu b\u1ecb b\u1ecf qua, th\u00ec ph\u1ea1m vi s\u1ebd \u0111\u01b0\u1ee3c c\u1ed9ng l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">H\u00e0m c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUMIF_co_ban\"><\/span><b>H\u00e0m SUMIF c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, ch\u00fang ta h\u00e3y x\u00e2y d\u1ef1ng h\u00e0m SUMIF trong Excel \u1edf d\u1ea1ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/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-165.gif\" title=\"ex101_92019-nho-165\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng m\u1eabu b\u00ean d\u01b0\u1edbi, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c t\u1ed5ng doanh s\u1ed1 cho m\u1ed9t v\u00f9ng c\u1ee5 th\u1ec3, ch\u1eb3ng h\u1ea1n nh\u01b0 North. \u0110\u1ec3 ho\u00e0n t\u1ea5t, ch\u00fang ta x\u00e1c \u0111\u1ecbnh c\u00e1c tham s\u1ed1 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Range<\/strong> \u2013 danh s\u00e1ch c\u00e1c v\u00f9ng (B2:B10).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Criterion<\/strong> \u2013 \u201cNorth\u201d hay \u00f4 ch\u1ee9a v\u00f9ng quan t\u00e2m (F1).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Sum_range<\/strong> \u2013 s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng \u0111\u01b0\u1ee3c c\u1ed9ng v\u00e0o (C2:C10)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u0110\u1eb7t c\u00e1c tham s\u1ed1 l\u1ea1i v\u1edbi nhau, ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><strong>=SUMIF(B2:B10, \u201cnorth\u201d, C2:C10)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Hay<\/span><\/p>\n<p><strong>=SUMIF(B2:B10, F1, C2:C10)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u1ea3 hai ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 North:<\/span><\/p>\n<figure style=\"width: 418px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m SUMIF c\u01a1 b\u1ea3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-function-1.png\" alt=\"Using SUMIF function in Excel\" width=\"418\" height=\"259\"><figcaption class=\"wp-caption-text\">H\u00e0m SUMIF c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_ham_SUMIF_trong_Excel\"><\/span><b>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Tho\u1ea1t nh\u00ecn, SUMIF l\u00e0 m\u1ed9t h\u00e0m c\u00f3 c\u00fa ph\u00e1p kh\u00e1 ph\u1ee9c t\u1ea1p<\/span><span style=\"font-weight: 400\">. Nh\u1eefng l\u01b0u \u00fd sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 logic b\u00ean trong c\u1ee7a n\u00f3 v\u00e0 tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p.<\/span><\/p>\n<ol>\n<li><b> SUMIF ch\u1ec9 h\u1ed7 tr\u1ee3 m\u1ed9t ti\u00eau ch\u00ed<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF ch\u1ec9 c\u00f3 1 \u0111i\u1ec1u ki\u1ec7n. \u0110\u1ec3 t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUMIFS (c\u1ed9ng c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n) ho\u1eb7c x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUMIF v\u1edbi ti\u00eau ch\u00ed OR (t\u00ednh t\u1ed5ng c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng b\u1ea5t k\u00ec \u0111i\u1ec1u ki\u1ec7n n\u00e0o).<\/span><\/p>\n<ol start=\"2\">\n<li><b> C\u00fa ph\u00e1p ti\u00eau ch\u00ed SUMIF<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi ti\u00eau ch\u00ed, h\u00e0m SUMIF cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau bao g\u1ed3m v\u0103n b\u1ea3n, s\u1ed1, ng\u00e0y th\u00e1ng, tham s\u1ed1 \u00f4, ph\u00e9p to\u00e1n logic (&gt;, &lt;, =, &lt;&gt;), k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (?, *, ~) v\u00e0 c\u00e1c h\u00e0m kh\u00e1c.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu tham s\u1ed1 ti\u00eau ch\u00ed bao g\u1ed3m gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n ho\u1eb7c ph\u00e9p to\u00e1n logic theo sau l\u00e0 v\u0103n b\u1ea3n, s\u1ed1 ho\u1eb7c ng\u00e0y, h\u00e3y \u0111\u1eb7t to\u00e0n b\u1ed9 ti\u00eau ch\u00ed trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201cnorth*\u201d, C2:D10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:D10, \u201c&gt;100\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&lt;&gt;north\u201d, C2:D10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;=9\/10\/2020\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi m\u1ed9t ph\u00e9p to\u00e1n logic \u0111\u01b0\u1ee3c theo sau b\u1edfi m\u1ed9t tham chi\u1ebfu \u00f4 ho\u1eb7c m\u1ed9t h\u00e0m kh\u00e1c, c\u00e1c ti\u00eau ch\u00ed ph\u1ea3i \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng m\u1ed9t chu\u1ed7i. \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u v\u00e0 (&amp;) \u0111\u1ec3 n\u1ed1i m\u1ed9t ph\u00e9p to\u00e1n logic v\u00e0 m\u1ed9t tham chi\u1ebfu ho\u1eb7c h\u00e0m. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&gt;\u201d&amp;F1)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:D10, \u201c&lt;=\u201d&amp;TODAY(), B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Xin l\u01b0u \u00fd r\u1eb1ng c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p trong khi tham chi\u1ebfu \u00f4 th\u00ec kh\u00f4ng.<\/span><\/p>\n<ol start=\"3\">\n<li><b> Range v\u00e0 sum_range ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f4ng th\u1ee9c SUMIF ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, tham s\u1ed1 sum_range ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc v\u1edbi d\u1ea3i \u00f4, n\u1ebfu kh\u00f4ng b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sai l\u1ec7ch. V\u1ea5n \u0111\u1ec1 l\u00e0 sum_range ch\u1ec9 x\u00e1c \u0111\u1ecbnh \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i c\u1ee7a ph\u1ea1m vi s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng, v\u00f9ng c\u00f2n l\u1ea1i \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi k\u00edch th\u01b0\u1edbc v\u00e0 h\u00ecnh d\u1ea1ng c\u1ee7a tham s\u1ed1 ph\u1ea1m vi.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n tr\u00ean, c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd th\u1ef1c s\u1ef1 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong C2:C10 ch\u1ee9 kh\u00f4ng ph\u1ea3i trong C2:D10. T\u1ea1i sao? B\u1edfi v\u00ec d\u1ea3i \u00f4 bao g\u1ed3m 1 c\u1ed9t, 9 h\u00e0ng v\u00e0 sum_range c\u0169ng v\u1eady.<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201cnorth\u201d, C2:D10)<\/span><\/p>\n<ol start=\"4\">\n<li><b> Range v\u00e0 sum_range kh\u00f4ng th\u1ec3 l\u00e0 m\u1ea3ng<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">M\u1eb7c d\u00f9 SUMIF c\u00f3 th\u1ec3 x\u1eed l\u00fd m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng trong c\u00e1c ti\u00eau ch\u00ed nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb gi\u1ed1ng nh\u01b0 v\u00ed d\u1ee5 n\u00e0y, n\u00f3 kh\u00f4ng h\u1ed7 tr\u1ee3 c\u00e1c m\u1ea3ng trong d\u1ea3i \u00f4 v\u00e0 sum_range. Hai tham s\u1ed1 n\u00e0y ch\u1ec9 c\u00f3 th\u1ec3 l\u00e0 v\u00f9ng gi\u00e1 tr\u1ecb.<\/span><\/p>\n<ol start=\"5\">\n<li><b> SUMIF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Theo thi\u1ebft k\u1ebf, SUMIF trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, <\/span><span style=\"font-weight: 400\">ngh\u0129a l\u00e0 n\u00f3 coi ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng nh\u01b0 nhau.<\/span><span style=\"font-weight: 400\">. \u0110\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT c\u00f9ng v\u1edbi EXACT.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_ve_ham_SUMIF_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIF trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1c quy t\u1eafc ch\u00ednh c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel, \u0111\u00e3 \u0111\u1ebfn l\u00fac \u00e1p d\u1ee5ng ki\u1ebfn th\u1ee9c th\u1ef1c t\u1ebf v\u00e0 c\u1ea3i thi\u1ec7n c\u00e1c k\u1ef9 n\u0103ng \u0111\u00e3 h\u1ecdc.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_1_SUMIF_lon_hon_va_nho_hon\"><\/span><b>V\u00ed d\u1ee5 1: SUMIF l\u1edbn h\u01a1n v\u00e0 nh\u1ecf h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3, h\u00e3y \u0111\u1ecbnh d\u1ea1ng ti\u00eau ch\u00ed SUMIF b\u1eb1ng m\u1ed9t trong c\u00e1c ph\u00e9p to\u00e1n logic sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">L\u1edbn h\u01a1n (&gt;)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt; =)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ecf h\u01a1n (&lt;)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (&lt;=)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u201cTrong B2:B10\u201d, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n 200. \u0110\u1ec3 th\u1ec3 hi\u1ec7n \u0111i\u1ec1u ki\u1ec7n n\u00e0y, h\u00e3y \u0111\u1eb7t to\u00e1n ph\u00e9p to\u00e1n so s\u00e1nh (&gt;) tr\u01b0\u1edbc s\u1ed1 \u0111\u00f3 v\u00e0 \u0111\u1eb7t c\u1ea5u tr\u00fac trong d\u1ea5u ngo\u1eb7c k\u00e9p:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&gt;200\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong \u00f4 kh\u00e1c, gi\u1ea3 s\u1eed l\u00e0 E1, h\u00e3y n\u1ed1i ph\u00e9p to\u00e1n logic v\u00e0 tham chi\u1ebfu \u00f4:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&gt;\u201d&amp;E1)<\/span><\/p>\n<figure style=\"width: 469px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1c b\u00e0i to\u00e1n v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-greater-than.png\" alt=\"SUM IF greater than\" width=\"469\" height=\"258\"><figcaption class=\"wp-caption-text\">C\u00e1c b\u00e0i to\u00e1n v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 200 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n nh\u1ecf h\u01a1n (&lt;):<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&lt;200\u201d)<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_2_SUMIF_bang\"><\/span><b>V\u00ed d\u1ee5 2. SUMIF b\u1eb1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c SUMIF v\u1edbi ti\u00eau ch\u00ed \u201cb\u1eb1ng\u201d ho\u1ea1t \u0111\u1ed9ng cho c\u1ea3 s\u1ed1 v\u00e0 v\u0103n b\u1ea3n. Trong c\u00e1c ti\u00eau ch\u00ed nh\u01b0 v\u1eady, d\u1ea5u b\u1eb1ng kh\u00f4ng th\u1ef1c s\u1ef1 b\u1eaft bu\u1ed9c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u00ecm t\u1ed5ng s\u1ed1 c\u00e1c m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c giao trong 3 ng\u00e0y, b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o d\u01b0\u1edbi \u0111\u00e2y <\/span><span style=\"font-weight: 400\">s\u1ebd cho ch\u00fang ta k\u1ebft qu\u1ea3 \u0111\u00fang<\/span><span style=\"font-weight: 400\">:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, 3, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">hay<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c=3\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng n\u1ebfu b\u1eb1ng \u00f4, ch\u1ec9 c\u1ea7n cung c\u1ea5p cho tham chi\u1ebfu \u00f4 cho ti\u00eau ch\u00ed<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, F1, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 B2: B10 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng, C2: C10 l\u00e0 th\u1eddi gian v\u1eadn chuy\u1ec3n v\u00e0 F1 l\u00e0 th\u1eddi gian giao h\u00e0ng mong mu\u1ed1n.<\/span><\/p>\n<figure style=\"width: 470px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m sumif\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-equal-to.png\" alt=\"SUM IF equal to cell\" width=\"470\" height=\"258\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m sumif<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ti\u00eau ch\u00ed \u201cb\u1eb1ng\u201d v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. V\u00ed d\u1ee5: \u0111\u1ec3 c\u1ed9ng t\u1ea5t c\u1ea3 s\u1ed1 l\u01b0\u1ee3ng Apple, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(A2:A10, \u201capples\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(A2:A10, \u201c=apples\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(A2:A10, F1, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 A2: A10 l\u00e0 danh s\u00e1ch c\u00e1c m\u1ee5c \u0111\u1ec3 so s\u00e1nh v\u1edbi gi\u00e1 tr\u1ecb trong F1.<\/span><\/p>\n<figure style=\"width: 480px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 2 v\u1ec1 h\u00e0m sumif\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-text.png\" alt=\"SUM IF equal to text\" width=\"480\" height=\"258\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 2 v\u1ec1 h\u00e0m sumif<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: C\u00e1c c\u00f4ng th\u1ee9c tr\u00ean ng\u1ee5 \u00fd r\u1eb1ng ti\u00eau ch\u00ed ph\u00f9 h\u1ee3p v\u1edbi to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4. Do \u0111\u00f3, h\u00e0m SUMIF s\u1ebd c\u1ed9ng th\u00eam doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a Apple, nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00e0 Green Apple. \u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p, h\u00e3y x\u00e2y d\u1ef1ng ti\u00eau ch\u00ed \u201cn\u1ebfu \u00f4 ch\u1ee9a\u201d nh\u01b0 trong c\u00f4ng th\u1ee9c ph\u00e9p to\u00e1n \u0111\u1ea1i di\u1ec7n SUMIF.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_3_SUMIF_khong_bang\"><\/span><b>V\u00ed d\u1ee5 3: SUMIF kh\u00f4ng b\u1eb1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 x\u00e2y d\u1ef1ng ti\u00eau ch\u00ed \u201ckh\u00f4ng b\u1eb1ng\u201d, h\u00e3y s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n logic \u201c&lt;&gt;\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi m\u1ed9t gi\u00e1 tr\u1ecb, v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1, \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng ti\u00eau ch\u00ed, h\u00e3y nh\u1edb \u0111\u1eb7t to\u00e0n b\u1ed9 c\u1ea5u tr\u00fac b\u1eb1ng d\u1ea5u ngo\u1eb7c k\u00e9p.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n v\u1edbi l\u00f4 h\u00e0ng ngo\u00e0i 3 ng\u00e0y, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;&gt;3\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ecm t\u1ed5ng s\u1ed1 t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng ngo\u1ea1i tr\u1eeb T\u00e1o, c\u00f4ng th\u1ee9c l\u00e0:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(A2:A10, \u201c&lt;&gt;apples\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi gi\u00e1 tr\u1ecb ti\u00eau ch\u00ed n\u1eb1m trong m\u1ed9t \u00f4 kh\u00e1c, h\u00e3y n\u1ed1i ph\u00e9p to\u00e1n \u201ckh\u00f4ng b\u1eb1ng v\u1edbi\u201d v\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(A2:A10, \u201c&lt;&gt;\u201d&amp;F1, B2:B10)<\/span><\/p>\n<figure style=\"width: 621px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"\u1ee8 ng d\u1ee5ng h\u00e0m sumif 3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-not-equal-to.png\" alt=\"SUM IF not equal to\" width=\"621\" height=\"220\"><figcaption class=\"wp-caption-text\">\u1ee8 ng d\u1ee5ng h\u00e0m sumif 3<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_4_SUMIF_khong_trong\"><\/span><b>V\u00ed d\u1ee5 4: SUMIF kh\u00f4ng tr\u1ed1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u1ea1o lo\u1ea1i c\u00f4ng th\u1ee9c \u201cn\u1ebfu \u00f4 kh\u00f4ng tr\u1ed1ng th\u00ec t\u00ednh t\u1ed5ng\u201d, h\u00e3y s\u1eed d\u1ee5ng \u201c&lt;&gt;\u201d l\u00e0m ti\u00eau ch\u00ed. Thao t\u00e1c n\u00e0y s\u1ebd c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec trong \u0111\u00f3, bao g\u1ed3m c\u1ea3 c\u00e1c chu\u1ed7i c\u00f3 \u0111\u1ed9 d\u00e0i b\u1eb1ng kh\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng cho t\u1ea5t c\u1ea3 c\u00e1c khu v\u1ef1c, t\u1ee9c l\u00e0 trong \u0111\u00f3 c\u1ed9t B kh\u00f4ng tr\u1ed1ng:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c&lt;&gt;\u201d, C2:D10)<\/span><\/p>\n<figure style=\"width: 452px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif 4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-not-blank-1.png\" alt=\"SUM IF not blank\" width=\"452\" height=\"258\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m sumif 4<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_5_SUMIF_trong\"><\/span><b>V\u00ed d\u1ee5 5. SUMIF tr\u1ed1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong m\u1ed9t s\u1ed1 c\u1ed9t n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng trong m\u1ed9t c\u1ed9t kh\u00e1c tr\u1ed1ng, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c ti\u00eau ch\u00ed sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u201c\u201d \u2013 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 n\u1ebfu m\u1ed9t \u00f4 kh\u00e1c tr\u1ed1ng; c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i tr\u1ed1ng c\u0169ng \u0111\u01b0\u1ee3c coi l\u00e0 tr\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u201c=\u201d \u2013 \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 ho\u00e0n to\u00e0n tr\u1ed1ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang ta, c\u00f4ng th\u1ee9c sau s\u1ebd t\u00ednh t\u1ed5ng doanh s\u1ed1 cho c\u00e1c khu v\u1ef1c kh\u00f4ng x\u00e1c \u0111\u1ecbnh, t\u1ee9c l\u00e0 \u00f4 trong c\u1ed9t B tr\u1ed1ng:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c\u201d, C2:D10)<\/span><\/p>\n<figure style=\"width: 471px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp v\u1ec1 h\u00e0m sumif 5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-blank.png\" alt=\"SUM IF blank\" width=\"471\" height=\"257\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp v\u1ec1 h\u00e0m sumif 5<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_6_Ky_tu_dai_dien_SUMIF_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 6. K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n SUMIF trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 kh\u1edbp t\u1eebng ph\u1ea7n, bao g\u1ed3m m\u1ed9t trong c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong ti\u00eau ch\u00ed c\u1ee7a b\u1ea1n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1ea5u ch\u1ea5m h\u1ecfi (?) \u0110\u1ec3 thay th\u1ebf b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 \u0111\u01a1n n\u00e0o.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1ea5u hoa th\u1ecb (*) \u0111\u1ec3 thay th\u1ebf b\u1ea5t k\u1ef3 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 n\u00e0o.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd ch\u1ec9 t\u00ednh t\u1ed5ng doanh s\u1ed1 cho khu v\u1ef1c ph\u00eda B\u1eafc:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201cnorth\u201d, C2:D10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng cho t\u1ea5t c\u1ea3 c\u00e1c khu v\u1ef1c, bao g\u1ed3m North, North-East v\u00e0 North-West, hay \u0111\u1eb7t d\u1ea5y hoa th\u1ecb ngay sau v\u0103n b\u1ea3n:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201cnorth*\u201d, C2:D10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eadp v\u00f9ng quan t\u00e2m v\u00e0o m\u1ed9t \u00f4 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc (F1), sau \u0111\u00f3 n\u1ed1i m\u1ed9t tham chi\u1ebfu \u00f4 v\u00e0 m\u1ed9t k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, F1&amp;\u201d*\u201d, C2:D10)<\/span><\/p>\n<figure style=\"width: 452px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp 6 \u1ee9ng d\u1ee5ng h\u00e0m sumif\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-wildcard.png\" alt=\"SUMIF wildcard formula to sum if cell contains\" width=\"452\" height=\"258\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp 6 \u1ee9ng d\u1ee5ng h\u00e0m sumif<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 kh\u1edbp d\u1ea5u ch\u1ea5m h\u1ecfi ho\u1eb7c d\u1ea5u hoa th\u1ecb, h\u00e3y \u0111\u1eb7t d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc k\u00fd t\u1ef1, v\u00ed d\u1ee5 \u201c~?\u201d ho\u1eb7c \u201c~ *\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u1ed5ng h\u1ee3p doanh s\u1ed1 cho c\u00e1c khu v\u1ef1c \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u *, h\u00e3y s\u1eed d\u1ee5ng \u201c* ~ *\u201d cho ti\u00eau ch\u00ed. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, d\u1ea5u hoa th\u1ecb \u0111\u1ea7u ti\u00ean l\u00e0 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n v\u00e0 d\u1ea5u hoa th\u1ecb th\u1ee9 hai l\u00e0 k\u00fd t\u1ef1 d\u1ea5u hoa th\u1ecb.<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c*~*\u201d, C2:D10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu ti\u00eau ch\u00ed (* trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y) \u0111\u01b0\u1ee3c cho l\u00e0 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t, th\u00ec h\u00e3y n\u1ed1i m\u1ed9t d\u1ea5u ng\u00e3 v\u00e0 tham chi\u1ebfu \u00f4, nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(B2:B10, \u201c*\u201d&amp;\u201d~\u201d&amp;F1, C2:D10)<\/span><\/p>\n<figure style=\"width: 457px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c v\u00e0 b\u00e0i to\u00e1n h\u00e0m sumif\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-literal-wildcard.png\" alt=\"SUMIF formula with an asterisk as criteria\" width=\"457\" height=\"258\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c v\u00e0 b\u00e0i to\u00e1n h\u00e0m sumif<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_7_SUMIF_trong_Excel_voi_ngay_thang\"><\/span><b>V\u00ed d\u1ee5 7: SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Vi\u1ec7c s\u1eed d\u1ee5ng ng\u00e0y th\u00e1ng l\u00e0m ti\u00eau ch\u00ed SUMIF r\u1ea5t gi\u1ed1ng vi\u1ec7c s\u1eed d\u1ee5ng s\u1ed1. \u0110i\u1ec1u quan tr\u1ecdng nh\u1ea5t l\u00e0 thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng ng\u00e0y m\u00e0 Excel c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c. N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc \u0111\u1ecbnh d\u1ea1ng ng\u00e0y n\u00e0o \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 v\u00e0 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y n\u00e0o kh\u00f4ng, h\u00e0m DATE c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang t\u00ecm c\u00e1ch t\u00ednh t\u1ed5ng doanh s\u1ed1 ng\u00e0y 10\/9\/2020, ti\u00eau ch\u00ed c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ebb hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;9\/10\/2020\u201d, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">hay<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;\u201c&amp;DATE(2020,9,10), B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">hay<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;\u201c&amp;F1, B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 F1 l\u00e0 ng\u00e0y m\u1ee5c ti\u00eau.<\/span><\/p>\n<figure style=\"width: 524px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"V\u00ed d\u1ee5 7: SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-dates.png\" alt=\"SUMIF using dates as criteria\" width=\"524\" height=\"258\"><figcaption class=\"wp-caption-text\">V\u00ed d\u1ee5 7: SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay, bao g\u1ed3m h\u00e0m TODAY trong ti\u00eau ch\u00ed c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd t\u00ednh t\u1ed5ng doanh s\u1ed1 b\u00e1n h\u00e0ng v\u1edbi ng\u00e0y giao h\u00e0ng tr\u01b0\u1edbc ng\u00e0y h\u00f4m nay:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(C2:C10, \u201c&lt;\u201c&amp;TODAY(), B2:B10)<\/span><\/p>\n<figure style=\"width: 525px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sumif-today.png\" alt=\"Sum cells using today's date for criteria\" width=\"525\" height=\"258\"><figcaption class=\"wp-caption-text\">\u1ee8ng d\u1ee5ng h\u00e0m SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng trong m\u1ed9t chu\u1ed7i ng\u00e0y, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh ri\u00eang bi\u1ec7t ng\u00e0y nh\u1ecf h\u01a1n v\u00e0 l\u1edbn h\u01a1n. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ebf \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a h\u00e0m SUMIFS h\u1ed7 tr\u1ee3 nhi\u1ec1u ti\u00eau ch\u00ed.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u00ednh t\u1ed5ng n\u1ebfu m\u1ed9t ng\u00e0y n\u1eb1m gi\u1eefa hai ng\u00e0y, th\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c \u0111\u1ec3 s\u1eed d\u1ee5ng:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIFS(B2:B10, C2:C10, \u201c&gt;=\u201d&amp;F1, C2:C10, \u201c&lt;=\u201d&amp;G1)<\/span><\/p>\n<figure style=\"width: 574px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp h\u00e0m SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-date-range-1.png\" alt=\"SUMIF between two dates\" width=\"574\" height=\"258\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp h\u00e0m SUMIF trong Excel v\u1edbi ng\u00e0y th\u00e1ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 B2:B10 l\u00e0 t\u1ed5ng ph\u1ea1m vi, C2:C10 l\u00e0 danh s\u00e1ch ng\u00e0y c\u1ea7n ki\u1ec3m tra, F1 l\u00e0 ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 G1 l\u00e0 ng\u00e0y k\u1ebft th\u00fac.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thuc_hien_SUMIF_tu_mot_sheet_khac\"><\/span><b>C\u00e1ch th\u1ef1c hi\u1ec7n SUMIF t\u1eeb m\u1ed9t sheet kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c, ch\u1ec9 c\u1ea7n c\u0169ng c\u1ea5p tham chi\u1ebfu b\u00ean ngo\u00e0i cho c\u00e1c \u0111\u1ed1i s\u1ed1 SUMIF. C\u00e1ch d\u1ec5 nh\u1ea5t l\u00e0 b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c, chuy\u1ec3n sang sheet kh\u00e1c v\u00e0 ch\u1ecdn v\u00f9ng b\u1eb1ng chu\u1ed9t. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n t\u1ea5t c\u1ea3 c\u00e1c tham chi\u1ebfu m\u00e0 b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i lo l\u1eafng v\u1ec1 c\u00fa ph\u00e1p \u0111\u00fang.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb trong C2:C10 tr\u00ean Data sheet d\u1ef1a tr\u00ean ti\u00eau ch\u00ed tr\u00f2n B3 tr\u00ean Sheet 1:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIF(Data!B2:B10, B3, Data!C2:C10)<\/span><\/p>\n<figure style=\"width: 504px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n SUMIF t\u1eeb m\u1ed9t sheet kh\u00e1c\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-another-sheet.png\" alt=\"SUMIF from another sheet\" width=\"504\" height=\"315\"><figcaption class=\"wp-caption-text\">C\u00e1ch th\u1ef1c hi\u1ec7n SUMIF t\u1eeb m\u1ed9t sheet kh\u00e1c<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_SUMIF_phan_biet_chu_hoa_chu_thuong_trong_Excel\"><\/span><b>C\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, v\u1ec1 b\u1ea3n ch\u1ea5t,<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-trong-excel-vi-du-cong-thuc-cu-the-tung-truong-hop.html\"><strong> h\u00e0m SUMIF trong Excel<\/strong> <\/a>kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng. \u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n c\u00e2n nh\u1eafc c\u00e1c t\u1eeb vi\u1ebft hoa, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c, c\u1ee5 th\u1ec3 l\u00e0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\"><strong> h\u00e0m SUMPRODUCT<\/strong><\/a> v\u00e0 EXACT x\u1eed l\u00fd ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng l\u00e0 k\u00fd t\u1ef1 kh\u00e1c nhau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">SUMPRODUCT(\u2013(EXACT(range, criteria)), sum_range)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c m\u00e3 m\u1eb7t h\u00e0ng trong c\u1ed9t A, n\u01a1i m\u00e0 ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh kh\u00e1c nhau. M\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong c\u1ed9t B cho m\u1ed9t m\u1ee5c c\u1ee5 th\u1ec3, ch\u1eb3ng h\u1ea1n A-01.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 ho\u00e0n t\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u1ee5c \u0111\u00edch tr\u1ef1c ti\u1ebfp v\u00e0o \u0111\u1ed1i s\u1ed1 th\u1ee9 2 c\u1ee7a h\u00e0m EXACT:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMPRODUCT(\u2013(EXACT(A2:A10, \u201cA-01\u201d)), B2:B10)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c nh\u1eadp m\u00e3 m\u1eb7t h\u00e0ng v\u00e0o m\u1ed9t \u00f4 ri\u00eang (E1) nh\u01b0 trong h\u00ecnh:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMPRODUCT(\u2013(EXACT(A2:A10, E1)), B2:B10)<\/span><\/p>\n<figure style=\"width: 354px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/case-sensitive-sumif.png\" alt=\"Case-sensitive SUMIF formula\" width=\"354\" height=\"257\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c SUMIF ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/figcaption><\/figure>\n<p><em><strong>H\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/em><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m EXACT so s\u00e1nh m\u1eb7t h\u00e0ng m\u1ee5c ti\u00eau v\u1edbi t\u1eebng m\u1eb7t h\u00e0ng trong danh s\u00e1ch ngu\u1ed3n v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE n\u1ebfu t\u00ecm k\u1ebft qu\u1ea3 kh\u00f4ng kh\u1edbp, n\u1ebfu kh\u00f4ng th\u00ec l\u00e0 FALSE:<\/span><\/p>\n<p><span style=\"font-weight: 400\">{TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE}<\/span><\/p>\n<p><span style=\"font-weight: 400\">To\u00e1n t\u1eed \u0111\u01a1n ng\u00f4i k\u00e9p (\u2013) chuy\u1ec3n \u0111\u1ed5i TRUE v\u00e0 FALSE th\u00e0nh 1 v\u00e0 0, t\u01b0\u01a1ng \u1ee9ng:<\/span><\/p>\n<p><span style=\"font-weight: 400\">{1;0;0;0;0;0;1;0;0}<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m SUMPRODUCT nh\u00e2n c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng tr\u00ean v\u1edbi c\u00e1c m\u1ee5c t\u01b0\u01a1ng \u1ee9ng trong B2: B10:<\/span><\/p>\n<p><span style=\"font-weight: 400\">SUMPRODUCT({1;0;0;0;0;0;1;0;0}, {250;155;130;255;160;280;170;285;110})<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1edfi v\u00ec nh\u00e2n v\u1edbi 0 b\u1eb1ng 0 ch\u1ec9 nh\u1eefng m\u1ee5c m\u00e0 EXACT tr\u1ea3 v\u1ec1 TRUE (1) m\u1edbi t\u1ed3n t\u1ea1i:<\/span><\/p>\n<p><span style=\"font-weight: 400\">SUMPRODUCT({250;0;0;0;0;0;170;0;0})<\/span><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, SUMPRODUCT c\u1ed9ng c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 xu\u1ea5t ra t\u1ed5ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <strong>SUMIF<\/strong> trong Excel. Hy v\u1ecdng r\u1eb1ng, c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang t\u00f4i \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n m\u1ed9t s\u1ed1 hi\u1ec3u bi\u1ebft t\u1ed1t. D\u00f9 sao, c\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 hy v\u1ecdng s\u1ebd g\u1eb7p b\u1ea1n tr\u00ean blog c\u1ee7a ch\u00fang t\u00f4i v\u00e0o tu\u1ea7n t\u1edbi!<\/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-165.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2164,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2163","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\/2163","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=2163"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2164"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}