{"id":7183,"date":"2024-12-21T17:05:10","date_gmt":"2024-12-21T17:05:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te\/"},"modified":"2024-12-21T17:05:10","modified_gmt":"2024-12-21T17:05:10","slug":"ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te\/","title":{"rendered":"H\u00e0m SUMIF trong Excel, chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 th\u1ef1c t\u1ebf"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u00e0i t\u00fat n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 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>trong Excel qua nh\u1eefng v\u00ed d\u1ee5 th\u1ef1c t\u1ebf \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c nhu c\u1ea7u t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 c\u1ea7n thi\u1ebft khi l\u00e0m b\u00e1o c\u00e1o.<\/em><\/p>\n<p>M\u1ed9t khi b\u1ea1n hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF th\u00ec vi\u1ec7c t\u00ecm hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n SUMIFS, \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n \u2013 COUNTIF, t\u00ednh trung b\u00ecnh theo \u0111i\u1ec1u ki\u1ec7n AVERAGEIFS kh\u00e1c c\u0169ng s\u1ebd r\u1ea5t nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng.<\/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-6766f54530004\" 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-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Ham_SUMIF_%E2%80%93_cu_phap_va_cach_viet\" title=\"H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch vi\u1ebft\">H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch vi\u1ebft<\/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\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Ham_SUMIF_%E2%80%93_cac_dieu_kien_di_kem\" title=\"H\u00e0m SUMIF \u2013 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m\">H\u00e0m SUMIF \u2013 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_so\" title=\"H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi s\u1ed1\">H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi s\u1ed1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_chuoi\" title=\"H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i\">H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i<\/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\/ham-sumif-trong-excel-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Cach_viet_ham_SUMIF_so_sanh_voi_tham_chieu_o\" title=\"C\u00e1ch vi\u1ebft h\u00e0m SUMIF so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4\">C\u00e1ch vi\u1ebft h\u00e0m SUMIF so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4<\/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-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Cach_viet_ham_SUMIF_voi_dieu_kien_kem_ky_tu_dai_dien\" title=\"C\u00e1ch vi\u1ebft h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n k\u00e8m k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\">C\u00e1ch vi\u1ebft h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n k\u00e8m k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/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-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Cach_viet_ham_SUMIF_de_tinh_tong_theo_o_trong\" title=\"C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 tr\u1ed1ng\">C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 tr\u1ed1ng<\/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-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Cach_viet_ham_SUMIF_de_tinh_tong_theo_o_khong_trong\" title=\"C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 kh\u00f4ng tr\u1ed1ng\">C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 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-chi-tiet-cach-su-dung-va-vi-du-thuc-te.html#Su_dung_ham_SUMIF_voi_dieu_kien_ngay_thang_nam\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng n\u0103m\">S\u1eed d\u1ee5ng h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng n\u0103m<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIF_%E2%80%93_cu_phap_va_cach_viet\"><\/span>H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch vi\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00fang ta h\u00e3y c\u00f9ng nhau nh\u00ecn v\u00e0o v\u00ed d\u1ee5 sau \u0111\u00e2y.<\/p>\n<figure id=\"attachment_31564\" aria-describedby=\"caption-attachment-31564\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ham-sum-if-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31564 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sum-if-trong-excel-01-1024x531-1.png\" alt=\"H\u00e0m SUMIF trong Excel v\u00e0 v\u00ed d\u1ee5\" width=\"1024\" height=\"531\" title=\"ham-sum-if-trong-excel-01-1024x531-1\"><\/a><figcaption id=\"caption-attachment-31564\" class=\"wp-caption-text\">H\u00e0m SUMIF trong Excel v\u00e0 v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>Y\u00eau c\u1ea7u trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y: ch\u00fang ta c\u1ea7n t\u00ednh s\u1ea3n l\u01b0\u1ee3ng xu\u1ea5t kh\u1ea9u c\u1ee7a s\u1ea3n ph\u1ea9m Chu\u1ed1i, hay n\u00f3i c\u00e1ch kh\u00e1c: t\u00ednh t\u1ed5ng c\u1ed9t B \u1edf c\u00e1c d\u00f2ng c\u00f3 ch\u1eef Chu\u1ed1i \u1edf c\u1ed9t A.<\/p>\n<p>H\u00e0m SUMIF hay h\u00e0m t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 c\u1ed9ng gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 tr\u00ean Excel theo \u0111i\u1ec1u ki\u1ec7n. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(range, criteria, [sum_range])<\/code><\/p>\n<p>H\u00e0m SUMIF nh\u1eadn 3 tham s\u1ed1, 2 tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, tham s\u1ed1 th\u1ee9 3 kh\u00f4ng b\u1eaft bu\u1ed9c:<\/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-649.gif\" title=\"ex101_92019-nho-649\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"list-style-type: square\">\n<li><em>range:\u00a0<\/em>l\u00e0 v\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n c\u1ea7n so s\u00e1nh, trong v\u00ed d\u1ee5 tr\u00ean l\u00e0 v\u00f9ng A2:A7<\/li>\n<li><em>criteria:\u00a0<\/em>l\u00e0 \u0111i\u1ec1u ki\u1ec7n d\u00f9ng \u0111\u1ec3 so s\u00e1nh, trong v\u00ed d\u1ee5 tr\u00ean, t\u1eeb \u201cChu\u1ed1i\u201d \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 E1 gi\u00fap ch\u00fang ta linh ho\u1ea1t thay \u0111\u1ed5i h\u01a1n, kh\u00f4ng c\u1ea7n v\u00e0o t\u1eadn c\u00f4ng th\u1ee9c \u1edf E2 \u0111\u1ec3 thay \u0111\u1ed5i c\u00f4ng th\u1ee9c khi \u0111i\u1ec1u ki\u1ec7n thay \u0111\u1ed5i<\/li>\n<li><em>[sum_range]:<\/em> v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng, v\u00ec tham s\u1ed1 n\u00e0y kh\u00f4ng b\u1eaft bu\u1ed9c n\u00ean, n\u1ebfu b\u1ea1n b\u1ecf qua tham s\u1ed1 n\u00e0y, th\u00ec Excel s\u1ebd hi\u1ec3u v\u00e0 t\u00ednh t\u1ed5ng tr\u00ean v\u00f9ng\u00a0<em>range.\u00a0<\/em>Trong v\u00ed d\u1ee5 tr\u00ean,\u00a0<em>sum_range\u00a0<\/em>l\u00e0 B2:B7<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIF_%E2%80%93_cac_dieu_kien_di_kem\"><\/span>H\u00e0m SUMIF \u2013 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_so\"><\/span>H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m SUMIF c\u00f3 th\u1ec3 d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 so s\u00e1nh v\u1edbi m\u1ed9t con s\u1ed1, c\u00e1c ph\u00e9p to\u00e1n c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y c\u00f9ng v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c trong b\u1ea3ng sau \u0111\u00e2y:<\/p>\n<table style=\"width: 100%;border-collapse: collapse;border-style: solid\">\n<tbody>\n<tr>\n<td style=\"width: 25%\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td style=\"width: 12.5%\">To\u00e1n t\u1eed<\/td>\n<td style=\"width: 37.5%\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/td>\n<td style=\"width: 25%\">Gi\u1ea3i th\u00edch<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu l\u1edbn h\u01a1n<\/td>\n<td style=\"width: 12.5%\">&gt;<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c&gt;5\u201d)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n 5 trong v\u00f9ng A2:A10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu nh\u1ecf h\u01a1n<\/td>\n<td style=\"width: 12.5%\">&lt;<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c&lt;10\u201d, B2:B10)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu b\u1eb1ng<\/td>\n<td style=\"width: 12.5%\">=<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c=\u201d&amp;D1) ho\u1eb7c =SUMIF(A2:A10,D1)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong v\u00f9ng A2:A10, n\u1ebfu b\u1eb1ng D1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu kh\u00f4ng b\u1eb1ng<\/td>\n<td style=\"width: 12.5%\">&lt;&gt;<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c&lt;&gt;\u201d&amp;D1, B2:B10)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c gi\u00e1 tr\u1ecb \u1edf D1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td style=\"width: 12.5%\">&gt;=<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c&gt;=5\u201d)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 trong v\u00f9ng A2:A10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng n\u1ebfu nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td style=\"width: 12.5%\">&lt;=<\/td>\n<td style=\"width: 37.5%\">=SUMIF(A2:A10, \u201c&lt;=10\u201d, B2:B10)<\/td>\n<td style=\"width: 25%\">T\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong c\u1ed9t B, n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng, c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUMIF_tinh_tong_theo_dieu_kien_so_sanh_voi_chuoi\"><\/span>H\u00e0m SUMIF t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh v\u1edbi chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table style=\"width: 100%;border-collapse: collapse;border-style: solid\">\n<tbody>\n<tr>\n<td style=\"width: 24.2708%\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td style=\"width: 42.3958%\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/td>\n<td style=\"width: 33.3333%\">Gi\u1ea3i th\u00edch<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.2708%\">T\u00ednh t\u1ed5ng n\u1ebfu b\u1eb1ng ch\u00ednh x\u00e1c<\/td>\n<td style=\"width: 42.3958%\">=SUMIF(A2:A8, \u201cchu\u1ed1i\u201d, C2:C8)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c = \u201cchu\u1ed1i\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.2708%\">T\u00ednh t\u1ed5ng n\u1ebfu ch\u1ee9a ch\u1eef \u2026<\/td>\n<td style=\"width: 42.3958%\">=SUMIF(A2:A8, \u201c*chu\u1ed1i*\u201d, C2:C8)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 ch\u1ee9a ch\u1eef \u201cchu\u1ed1i\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.2708%\">T\u00ednh t\u1ed5ng n\u1ebfu kh\u00f4ng b\u1eb1ng<\/td>\n<td style=\"width: 42.3958%\">=SUMIF(A2:A8, \u201c&lt;&gt;chu\u1ed1i\u201d, C2:C8)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong c\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c \u201cchu\u1ed1i\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 24.2708%\">T\u00ednh t\u1ed5ng n\u1ebfu kh\u00f4ng ch\u1ee9a<\/td>\n<td style=\"width: 42.3958%\">=SUMIF(A2:A8, \u201c&lt;&gt;*chu\u1ed1i*\u201d, C2:C8)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong c\u1ed9t A kh\u00f4ng ch\u1ee9a ch\u1eef \u201cchu\u1ed1i\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_SUMIF_so_sanh_voi_tham_chieu_o\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m SUMIF so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_31564\" aria-describedby=\"caption-attachment-31564\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ham-sum-if-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31564 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sum-if-trong-excel-01-1024x531-1.png\" alt=\"H\u00e0m SUMIF trong Excel v\u00e0 v\u00ed d\u1ee5\" width=\"1024\" height=\"531\" title=\"ham-sum-if-trong-excel-01-1024x531-1\"><\/a><figcaption id=\"caption-attachment-31564\" class=\"wp-caption-text\">H\u00e0m SUMIF trong Excel v\u00e0 v\u00ed d\u1ee5<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 \u1edf \u1ea3nh minh ho\u1ea1 tr\u00ean, ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m SUMIF c\u00f9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1edbi 1 \u00f4 trong b\u1ea3ng t\u00ednh Excel. Ngo\u00e0i c\u00e1ch vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c SUMIF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A7,\"=\"&amp;E1,B2:B7)<\/code><\/p>\n<p>Trong c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng khi so s\u00e1nh \u0111i\u1ec1u ki\u1ec7n v\u1edbi chu\u1ed7i, ch\u00fang ta vi\u1ebft \u0111i\u1ec1u ki\u1ec7n v\u00e0o ngay trong c\u00f4ng th\u1ee9c cho d\u1ec5 h\u00ecnh dung nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8, \"chu\u1ed1i\", C2:C8)<\/code><\/p>\n<p>cho m\u1ee5c \u0111\u00edch v\u00ed d\u1ee5 th\u00ec vi\u1ec7c n\u00e0y kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec tuy nhi\u00ean, trong th\u1ef1c t\u1ebf s\u1eed d\u1ee5ng, b\u1ea1n n\u00ean vi\u1ebft t\u00e1ch r\u1eddi ph\u1ea7n \u0111i\u1ec1u ki\u1ec7n ra 1 \u00f4 kh\u00e1c, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m SUMIF tham chi\u1ebfu t\u1edbi \u00f4 \u0111\u00f3, nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 h\u1ea1n ch\u1ebf vi\u1ec7c s\u1eeda c\u00f4ng th\u1ee9c khi thay \u0111\u1ed5i \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau (gi\u1ea3 s\u1eed \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 E1<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8, E1, C2:C8)<\/code><\/p>\n<p>\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng SUMIF v\u1edbi k\u00fd t\u1ef1 d\u1ea5u sao *, th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 chuy\u1ec3n c\u00f4ng th\u1ee9c<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8, \"&lt;&gt;*chu\u1ed1i*\", C2:C8)<\/code><\/p>\n<p>th\u00e0nh:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8, \"&lt;&gt;*\" &amp; E1 &amp; \"*\", C2:C8)<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_SUMIF_voi_dieu_kien_kem_ky_tu_dai_dien\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n k\u00e8m k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c, h\u00e0m SUMIF h\u1ed7 tr\u1ee3 vi\u1ebft \u0111i\u1ec1u ki\u1ec7n k\u00e8m theo k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n l\u00e0 d\u1ea5u * ho\u1eb7c d\u1ea5u ?<\/p>\n<ul style=\"list-style-type: square\">\n<li>D\u1ea5u * \u0111\u1ea1i di\u1ec7n cho b\u1ea5t k\u1ef3 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 n\u00e0o<\/li>\n<li>D\u1ea5u ? \u0111\u1ea1i di\u1ec7n cho 1 k\u00fd t\u1ef1 b\u1ea5t k\u00ec t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh<\/li>\n<\/ul>\n<figure id=\"attachment_31571\" aria-describedby=\"caption-attachment-31571\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ham-sumif-tinh-tong-theo-dieu-kien.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31571 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sumif-tinh-tong-theo-dieu-kien-1024x531-1.png\" alt=\"H\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n\" width=\"1024\" height=\"531\" title=\"ham-sumif-tinh-tong-theo-dieu-kien-1024x531-1\"><\/a><figcaption id=\"caption-attachment-31571\" class=\"wp-caption-text\">H\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n<\/figcaption><\/figure>\n<ul style=\"list-style-type: square\">\n<li>\u0110\u1ec3 t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a \u201cChu\u1ed1i\u201d, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c<br \/>\n<code class=\"excel-formula\">=SUMIF(A2:A7, \"&lt;&gt;*\" &amp; E1 &amp; \"*\", B2:B7)<\/code><\/li>\n<li>\u0110\u1ec3 t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 m\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u00f3 b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cChu\u1ed1i\u201d, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c<br \/>\n<code class=\"excel-formula\">=SUMIF(A2:A7, E1 &amp; \"*\", B2:B7)<\/code><\/li>\n<\/ul>\n<ul style=\"list-style-type: square\">\n<li>\u0110\u1ec3 t\u00ednh t\u1ed5ng nh\u1eefng \u00f4 m\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u00f3 k\u1ebft th\u00fac b\u1eb1ng \u201cChu\u1ed1i\u201d, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c<br \/>\n<code class=\"excel-formula\">=SUMIF(A2:A7,\"*\" &amp; E1, B2:B7)<\/code><\/li>\n<\/ul>\n<p>C\u0169ng v\u1edbi h\u00ecnh minh ho\u1ea1 tr\u00ean, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u00e1c d\u00f2ng \u1edf c\u1ed9t B, m\u00e0 d\u1eef li\u1ec7u \u1edf c\u1ed9t A c\u00f3 ch\u00ednh x\u00e1c 3 k\u00fd t\u1ef1 (Cam, T\u00e1o), th\u00ec c\u00f4ng th\u1ee9c SUMIF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A7,\"???\", B2:B7)<\/code><\/p>\n<p><strong>L\u00e0m g\u00ec khi trong k\u1ebft qu\u1ea3 c\u0169ng c\u00f3 d\u1ea5u * ho\u1eb7c d\u1ea5u ?<\/strong><\/p>\n<p>Khi v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n c\u00f3 d\u1ea5u * ho\u1eb7c d\u1ea5u ?, th\u00ec ch\u00fang ta c\u1ea7n c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 n\u00f3i cho Excel bi\u1ebft \u0111i\u1ec1u n\u00e0y, trong tr\u01b0\u1eddng h\u1ee3p nh\u01b0 v\u1eady, ch\u00fang ta s\u1ebd d\u00f9ng d\u1ea5u ng\u00e3 ~, v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<figure id=\"attachment_31572\" aria-describedby=\"caption-attachment-31572\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ham-sumif-voi-wildcard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31572 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sumif-voi-wildcard-1024x552-1.png\" alt=\"H\u00e0m SUMIF v\u00e0 k\u00fd t\u1ef1 wildcard\" width=\"1024\" height=\"552\" title=\"ham-sumif-voi-wildcard-1024x552-1\"><\/a><figcaption id=\"caption-attachment-31572\" class=\"wp-caption-text\">H\u00e0m SUMIF v\u00e0 k\u00fd t\u1ef1 wildcard<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u1ea7n t\u00ednh t\u1ed5ng c\u1ee7a lo\u1ea1i s\u1ea3n ph\u1ea9m \u201csi\u00eau sao\u201d \u2013 c\u00f3 d\u1ea5u * \u1edf trong t\u00ean, c\u00f4ng th\u1ee9c cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8,\"*~**\",B2:B8)<\/code><\/p>\n<p>Ph\u1ea7n <code class=\"excel-formula\">~*<\/code> trong c\u00f4ng th\u1ee9c b\u00e1o cho Excel bi\u1ebft \u0111i\u1ec1u ki\u1ec7n ch\u00fang ta c\u1ea7n t\u00ecm c\u00f3 d\u1ea5u *. 2 d\u1ea5u * v\u1ec1 2 ph\u00eda c\u1ee7a <code class=\"excel-formula\">~*<\/code> b\u00e1o cho Excel bi\u1ebft ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm b\u1ea5t c\u1ee9 k\u00fd t\u1ef1 n\u00e0o v\u1ec1 2 ph\u00eda c\u1ee7a d\u1ea5u * \u0111\u00f3. K\u1ebft qu\u1ea3 l\u00e0 \u201cChu\u1ed1i *\u201d \u0111\u01b0\u1ee3c t\u00ecm ra, v\u00e0 c\u00f4ng th\u1ee9c SUMIF tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 1000.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_SUMIF_de_tinh_tong_theo_o_trong\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_31575\" aria-describedby=\"caption-attachment-31575\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ham-sumif-tinh-tong-theo-dieu-kien-o-rong.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31575 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sumif-tinh-tong-theo-dieu-kien-o-rong-1024x549-1.png\" alt=\"H\u00e0m SUMIF theo \u0111i\u1ec1u ki\u1ec7n \u00f4 r\u1ed7ng\" width=\"1024\" height=\"549\" title=\"ham-sumif-tinh-tong-theo-dieu-kien-o-rong-1024x549-1\"><\/a><figcaption id=\"caption-attachment-31575\" class=\"wp-caption-text\">H\u00e0m SUMIF theo \u0111i\u1ec1u ki\u1ec7n \u00f4 r\u1ed7ng<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 \u1edf \u1ea3nh tr\u00ean, ch\u00fang ta c\u1ea7n t\u00ednh t\u1ed5ng c\u1ed9t B t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u (\u00f4 tr\u1ed1ng trong c\u1ed9t A), c\u00f4ng th\u1ee9c cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8,\"=\",B2:B8)<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_ham_SUMIF_de_tinh_tong_theo_o_khong_trong\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u00f4 kh\u00f4ng tr\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f9ng v\u1edbi h\u00ecnh minh ho\u1ea1 cho tr\u01b0\u1eddng h\u1ee3p \u00f4 tr\u1ed1ng, \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ed9t B t\u01b0\u01a1ng \u1ee9ng v\u1edbi nh\u1eefng \u00f4 kh\u00f4ng r\u1ed7ng \u1edf c\u1ed9t A, ch\u00fang ta vi\u1ebft c\u00f4ng th\u1ee9c SUMIF nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=SUMIF(A2:A8,\"&lt;&gt;\",B2:B8)<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUMIF_voi_dieu_kien_ngay_thang_nam\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUMIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng n\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u01b0\u1eddng th\u00ec ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi ng\u00e0y th\u00e1ng n\u0103m c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch ch\u00fang ta \u0111\u00e3 bi\u1ebft khi s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u s\u1ed1, d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i. Tuy nhi\u00ean v\u1edbi d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng th\u00ec ch\u00fang ta c\u00f3 1 s\u1ed1 l\u01b0u \u00fd v\u00e0 c\u00e1ch vi\u1ebft nh\u01b0 sau<\/p>\n<table style=\"width: 100%;border-collapse: collapse;border-style: solid\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td style=\"width: 33.3333%\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/td>\n<td style=\"width: 33.3333%\">Gi\u1ea3i th\u00edch<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n l\u00e0 ng\u00e0y c\u1ee5 th\u1ec3<\/td>\n<td style=\"width: 33.3333%\">=SUMIF(B2:B9,\u201d10\/29\/2020\u2033,C2:C9)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C9 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong v\u00f9ng B2:B9 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng ng\u00e0y 29 th\u00e1ng 10 n\u0103m 2020<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng t\u1eeb sau m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3<\/td>\n<td style=\"width: 33.3333%\">=SUMIF(B2:B9,\u201d&gt;=10\/29\/2020\u2033,C2:C9)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C9 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong v\u00f9ng B2:B9 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y 29 th\u00e1ng 10 n\u0103m 2020<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng t\u1eeb sau m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3, v\u1edbi gi\u00e1 tr\u1ecb ng\u00e0y \u0111\u01b0\u1ee3c l\u01b0u trong 1 \u00f4 kh\u00e1c<\/td>\n<td style=\"width: 33.3333%\">=SUMIF(B2:B9,\u201d&gt;\u201d&amp;F1,C2:C9)<\/td>\n<td style=\"width: 33.3333%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong v\u00f9ng C2:C9 n\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng d\u00f2ng trong v\u00f9ng B2:B9 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ng\u00e0y \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 F1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>N\u1ebfu c\u00f4ng th\u1ee9c SUMIF c\u1ee7a b\u1ea1n kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng, h\u00e3y ki\u1ec3m tra l\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/cach-chinh-dung-dinh-dang-ngay-thang-nam-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch nh\u1eadp ng\u00e0y th\u00e1ng trong Excel<\/a> tr\u00ean m\u00e1y c\u1ee7a b\u1ea1n<\/p>\n<p>Thay v\u00e0o tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n trong tr\u01b0\u1eddng h\u1ee3p t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng ng\u00e0y th\u00e1ng ph\u00eda tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m TODAY() cho v\u00f9ng \u0111i\u1ec1u ki\u1ec7n n\u00e0y. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<table style=\"width: 100%;border-collapse: collapse;border-style: solid\">\n<tbody>\n<tr>\n<td style=\"width: 50%\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td style=\"width: 50%\">C\u00f4ng th\u1ee9c<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%\">T\u00ednh t\u1ed5ng d\u1ef1a v\u00e0o ng\u00e0y hi\u1ec7n t\u1ea1i<\/td>\n<td style=\"width: 50%\">=SUMIF(B2:B9, TODAY(), C2:C9)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb tr\u01b0\u1edbc ng\u00e0y h\u00f4m nay<\/td>\n<td style=\"width: 50%\">=SUMIF(B2:B9, \u201c&lt;\u201c&amp;TODAY(), C2:C9)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb sau ng\u00e0y h\u00f4m nay<\/td>\n<td style=\"width: 50%\">=SUMIF(B2:B9, \u201c&gt;\u201d&amp;TODAY(), C2:C9)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%\">T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb v\u00e0o ng\u00e0y n\u00e0y tu\u1ea7n t\u1edbi<\/td>\n<td style=\"width: 50%\">=SUMIF(B2:B9, \u201c=\u201d&amp;TODAY()+7, C2:C9)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n trong 1 kho\u1ea3ng ng\u00e0y, v\u00ed d\u1ee5 kho\u1ea3ng ng\u00e0y c\u1ee7a ch\u00fang ta l\u00e0 \u201ctrong th\u00e1ng 1 n\u0103m 2020\u201d, th\u00ec c\u00f4ng th\u1ee9c ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau<\/p>\n<p><code class=\"excel-formula\">=SUMIF(B2:B9, \"&gt;=1\/1\/2020\", C2:C9) - SUMIF(B2:B9, \"&gt;=2\/1\/2020\", C2:C9)<\/code><\/p>\n<p>Hi v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a<a href=\"http:\/\/blog.ezworkapp.com\"><strong> H\u1ecdc Excel Online<\/strong> <\/a>b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm v\u00e0 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m SUMIF \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c. B\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i th\u00eam video sau \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u th\u00eam v\u1ec1<strong> h\u00e0m SUMIF<\/strong><\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Z73YOrndkEQ?t=5s\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\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-649.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7184,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7183","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\/7183","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=7183"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7184"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}