{"id":5091,"date":"2024-12-09T03:40:00","date_gmt":"2024-12-09T03:40:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel\/"},"modified":"2024-12-09T03:40:00","modified_gmt":"2024-12-09T03:40:00","slug":"tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel\/","title":{"rendered":"T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Khi l\u00e0m b\u00e1o c\u00e1o, k\u1ebf ho\u1ea1ch \u0111\u1ea7u t\u01b0 ho\u1eb7c b\u1ea5t k\u1ef3 t\u1eadp d\u1eef li\u1ec7u n\u00e0o kh\u00e1c c\u00f3 ng\u00e0y th\u00e1ng, b\u1ea1n th\u01b0\u1eddng ph\u1ea3i t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd ch\u1ec9 cho b\u1ea1n m\u1ed9t gi\u1ea3i ph\u00e1p nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng \u2013 c\u00f4ng th\u1ee9c SUMIFS v\u1edbi ng\u00e0y l\u00e0m ti\u00eau ch\u00ed.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta xem qua 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> l\u1ea5y ng\u00e0y l\u00e0m ti\u00eau ch\u00ed. V\u1ea5n \u0111\u1ec1 l\u00e0 \u0111\u1ec3 <strong>t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y<\/strong>, b\u1ea1n c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh c\u1ea3 hai ng\u00e0y trong khi h\u00e0m SUMIF trong Excel ch\u1ec9 cho ph\u00e9p m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. Th\u1eadt may m\u1eafn khi c\u00f3 h\u00e0m SUMIFS h\u1ed7 tr\u1ee3 \u0111\u01b0\u1ee3c nhi\u1ec1u ti\u00eau ch\u00ed.<\/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-6756668f7b791\" 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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Lam_the_nao_de_tinh_tong_cac_gia_tri_giua_hai_ngay_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y trong Excel\u00a0\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y trong Excel\u00a0<\/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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Tinh_tong_dynamic_range_dua_tren_ngay_hom_nay\" title=\"T\u00ednh t\u1ed5ng dynamic range d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay\">T\u00ednh t\u1ed5ng dynamic range d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay<\/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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Tinh_tong_cac_gia_tri_giua_hai_ngay_va_mot_tieu_chi_khac\" title=\"T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y v\u00e0 m\u1ed9t ti\u00eau ch\u00ed kh\u00e1c\">T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y v\u00e0 m\u1ed9t ti\u00eau ch\u00ed kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Cu_phap_ham_SUMIFS_lay_tieu_chi_ngay\" title=\"C\u00fa ph\u00e1p h\u00e0m SUMIFS l\u1ea5y ti\u00eau ch\u00ed ng\u00e0y\">C\u00fa ph\u00e1p h\u00e0m SUMIFS l\u1ea5y ti\u00eau ch\u00ed ng\u00e0y<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Ham_SUMIFS_trong_Excel_giua_cac_ngay_khong_hoat_dong\" title=\"H\u00e0m SUMIFS trong Excel gi\u1eefa c\u00e1c ng\u00e0y kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng\">H\u00e0m SUMIFS trong Excel gi\u1eefa c\u00e1c ng\u00e0y kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Kiem_tra_dinh_dang_ngay_va_so\" title=\"Ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng ng\u00e0y v\u00e0 s\u1ed1\u00a0\">Ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng ng\u00e0y v\u00e0 s\u1ed1\u00a0<\/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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Su_dung_cu_phap_chinh_xac_cho_tieu_chi\" title=\"S\u1eed d\u1ee5ng c\u00fa ph\u00e1p ch\u00ednh x\u00e1c cho ti\u00eau ch\u00ed\">S\u1eed d\u1ee5ng c\u00fa ph\u00e1p ch\u00ednh x\u00e1c cho ti\u00eau ch\u00ed<\/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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Xac_minh_tinh_logic_cua_ham\" title=\"X\u00e1c minh t\u00ednh logic c\u1ee7a h\u00e0m\u00a0\">X\u00e1c minh t\u00ednh logic c\u1ee7a h\u00e0m\u00a0<\/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\/tinh-tong-cac-gia-tri-giua-hai-ngay-trong-excel.html#Dam_bao_rang_tat_ca_cac_pham_vi_deu_co_cung_kich_thuoc\" title=\"\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea1m vi \u0111\u1ec1u c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc\">\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea1m vi \u0111\u1ec1u c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tinh_tong_cac_gia_tri_giua_hai_ngay_trong_Excel\"><\/span><b>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t chu\u1ed7i ng\u00e0y nh\u1ea5t \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUMIFS v\u1edbi ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 ng\u00e0y k\u1ebft th\u00fac l\u00e0m ti\u00eau ch\u00ed. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIFS y\u00eau c\u1ea7u tr\u01b0\u1edbc ti\u00ean b\u1ea1n ch\u1ec9 \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n c\u1ed9ng (sum_range) sau \u0111\u00f3 cung c\u1ea5p c\u00e1c c\u1eb7p ph\u1ea1m vi\/ ti\u00eau ch\u00ed. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ph\u1ea1m vi (danh s\u00e1ch c\u00e1c ng\u00e0y) s\u1ebd gi\u1ed1ng nhau cho c\u1ea3 hai ti\u00eau ch\u00ed.<\/span><\/p>\n<p><span style=\"font-weight: 400\">X\u00e9t \u1edf tr\u00ean, c\u00e1c c\u00f4ng th\u1ee9c chung \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y c\u00f3 d\u1ea1ng sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Bao g\u1ed3m c\u00e1c ng\u00e0y r\u00e0ng bu\u1ed9c:<\/span><\/p>\n<p><strong><i>SUMIFS(sum_range, dates,\u201d&gt;=\u201d&amp;start_date, dates, \u201c&lt;=\u201d&amp;end_date)<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Kh\u00f4ng bao g\u1ed3m c\u00e1c ng\u00e0y r\u00e0ng bu\u1ed9c:<\/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-429.gif\" title=\"ex101_92019-nho-429\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong><i>SUMIFS(sum_range, dates,\u201d&gt;\u201d&amp;start_date, dates, \u201c&lt;\u201c&amp;end_date)<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 c\u00f3 th\u1ec3 th\u1ea5y, s\u1ef1 kh\u00e1c bi\u1ec7t ch\u1ec9 l\u00e0 \u1edf c\u00e1c ph\u00e9p to\u00e1n logic. Trong c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean, ch\u00fang ta s\u1eed d\u1ee5ng l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt;=) v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (&lt;=) \u0111\u1ec3 bao g\u1ed3m c\u00e1c gi\u1edbi h\u1ea1n d\u01b0\u1edbi v\u00e0 tr\u00ean trong k\u1ebft qu\u1ea3. C\u00f4ng th\u1ee9c th\u1ee9 hai ki\u1ec3m tra xem n\u1ebfu m\u1ed9t ng\u00e0y l\u1edbn h\u01a1n (&gt;) hay nh\u1ecf h\u01a1n (&lt;) th\u00ec lo\u1ea1i b\u1ecf ng\u00e0y b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n t\u1ed5ng h\u1ee3p c\u00e1c d\u1ef1 \u00e1n \u0111\u1ebfn h\u1ea1n trong m\u1ed9t chu\u1ed7i ng\u00e0y c\u1ee5 th\u1ec3. \u0110\u1ec3 ho\u00e0n t\u1ea5t, ch\u00fang ta nh\u1eadp ng\u00e0y b\u1eaft \u0111\u1ea7u G1 v\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 c\u1ed9ng ng\u00e2n s\u00e1ch trong B2:B10 gi\u1eefa hai ng\u00e0y n\u00e0y, bao g\u1ed3m:<\/span><\/p>\n<p><strong><i>=SUMIFS(B2:B10, C2:C10, \u201c&gt;=\u201d&amp;F1, C2:C10, \u201c&lt;=\u201d&amp;G1)<\/i><\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sum-if-between-dates.png\" alt=\"Formula to sum data between 2 dates\" title=\"sum-if-between-dates\"><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n thay ng\u00e0y trong c\u00f4ng th\u1ee9c, th\u00ec h\u00e3y nh\u1eadp ng\u00e0y ngay sau ph\u00e9p to\u00e1n logic v\u00e0 \u0111\u1eb7t to\u00e0n b\u1ed9 ti\u00eau ch\u00ed trong d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0 sau:<\/span><\/p>\n<p><strong><i>=SUMIFS(B2:B10, C2:C10, \u201c&gt;=9\/10\/2020\u201d, C2:C10, \u201c&lt;=9\/20\/2020\u201d)<\/i><\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u00e1nh nh\u1eefng sai l\u1ea7m c\u00f3 th\u1ec3 x\u1ea3y ra, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng b\u1eb1ng ch\u1ee9c n\u0103ng DATE:<\/span><\/p>\n<p><strong><i>=SUMIFS(B2:B10, C2:C10, \u201c&gt;=\u201d&amp;DATE(2020,9,10), C2:C10, \u201c&lt;=\u201d&amp;DATE(2020,9,20))<\/i><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_tong_dynamic_range_dua_tren_ngay_hom_nay\"><\/span><b>T\u00ednh t\u1ed5ng dynamic range d\u1ef1a tr\u00ean ng\u00e0y h\u00f4m nay<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p khi b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u v\u1edbi dynamic range (X ng\u00e0y tr\u1edf v\u1ec1 tr\u01b0\u1edbc ho\u1eb7c Y ng\u00e0y tr\u1edf v\u1ec1 sau), x\u00e2y d\u1ef1ng ti\u00eau ch\u00ed b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY, h\u00e0m n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ng\u00e0y hi\u1ec7n t\u1ea1i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5:\u00a0 t\u00ednh t\u1ed5ng ng\u00e2n s\u00e1ch \u0111\u1ebfn h\u1ea1n trong 7 ng\u00e0y qua bao g\u1ed3m ng\u00e0y h\u00f4m nay, h\u00e0m l\u00e0:<\/span><\/p>\n<p><strong>=SUMIFS(B2:B10, C2:C10, \u201c&lt;=\u201d&amp;TODAY(), C2:C10, \u201c&gt;\u201d&amp;TODAY()-7)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n t\u00ednh ng\u00e0y hi\u1ec7n t\u1ea1i trong k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng, h\u00e3y s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n logic nh\u1ecf h\u01a1n (&lt;) cho ti\u00eau ch\u00ed \u0111\u1ea7u ti\u00ean \u0111\u1ec3 lo\u1ea1i tr\u1eeb ng\u00e0y h\u00f4m nay v\u00e0 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt;=) cho ti\u00eau ch\u00ed th\u1ee9 hai \u0111\u1ec3 bao g\u1ed3m 7 ng\u00e0y tr\u01b0\u1edbc \u0111\u00f3:<\/span><\/p>\n<p><strong>=SUMIFS(B2:B10, C2:C10, \u201c&lt;\u201c&amp;TODAY(), C2:C10, \u201c&gt;=\u201d&amp;TODAY()-7)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-date-range-2.png\" alt=\"Sum values within a range based on today's date\" title=\"sumif-date-range-2\"><\/p>\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 n\u1ebfu l\u00e0 m\u1ed9t ng\u00e0y nh\u1ea5t \u0111\u1ecbnh v\u1ec1 sau.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0110\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c t\u1ed5ng s\u1ed1 ng\u00e2n s\u00e1ch \u0111\u1ebfn h\u1ea1n trong 3 ng\u00e0y t\u1edbi, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ng\u00e0y h\u00f4m nay \u0111\u01b0\u1ee3c bao g\u1ed3m trong k\u1ebft qu\u1ea3:<\/span><\/p>\n<p><strong>=SUMIFS(B2:B10, C2:C10, \u201c&gt;=\u201d&amp;TODAY(), C2:C10, \u201c&lt;\u201c&amp;TODAY()+3)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ng\u00e0y h\u00f4m nay kh\u00f4ng \u0111\u01b0\u1ee3c bao g\u1ed3m trong k\u1ebft qu\u1ea3:<\/span><\/p>\n<p><strong>=SUMIFS(B2:B10, C2:C10, \u201c&gt;\u201d&amp;TODAY(), C2:C10, \u201c&lt;=\u201d&amp;TODAY()+3)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-date-range-today.png\" alt=\"Sum values for a given number of days forward from today\" title=\"sumif-date-range-today\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_tong_cac_gia_tri_giua_hai_ngay_va_mot_tieu_chi_khac\"><\/span><b>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai ng\u00e0y v\u00e0 m\u1ed9t ti\u00eau ch\u00ed kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi ng\u00e0y \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u v\u00e0 \u0111\u00e1p \u1ee9ng m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u1ed9t kh\u00e1c, ch\u1ec9 c\u1ea7n th\u00eam m\u1ed9t ph\u1ea1m vi\/ ti\u00eau ch\u00ed n\u1eefa v\u00e0o c\u00f4ng th\u1ee9c SUMIFS:<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0110\u1ec3 t\u1ed5ng h\u1ee3p ng\u00e2n s\u00e1ch trong m\u1ed9t chu\u1ed7i ng\u00e0y nh\u1ea5t \u0111\u1ecbnh cho t\u1ea5t c\u1ea3 d\u1ef1 \u00e1n c\u00f3 ch\u1ee9a \u201ctip\u201d, h\u00e3y m\u1edf r\u1ed9ng c\u00f4ng th\u1ee9c v\u1edbi ti\u00eau ch\u00ed k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n:<\/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, A2:A10, \u201ctip*\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 A2:A10 l\u00e0 t\u00ean d\u1ef1 \u00e1n, B2:B10 l\u00e0 s\u1ed1 t\u1ed5ng, C2:C10 l\u00e0 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<p><span style=\"font-weight: 400\">T\u1ea5t nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec kh\u00f3 kh\u0103n khi b\u1ea1n nh\u1eadp ti\u00eau ch\u00ed th\u1ee9 ba v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t v\u00e0 tham chi\u1ebfu \u00f4 \u0111\u00f3 nh\u01b0 trong h\u00ecnh minh h\u1ecda:<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sumif-between-dates-another-criteria.png\" alt=\"Formula to sum if between two dates and another criteria\" title=\"sumif-between-dates-another-criteria\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_ham_SUMIFS_lay_tieu_chi_ngay\"><\/span><b>C\u00fa ph\u00e1p h\u00e0m SUMIFS l\u1ea5y ti\u00eau ch\u00ed ng\u00e0y<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi n\u00f3i \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng ng\u00e0y th\u00e1ng l\u00e0m ti\u00eau ch\u00ed cho c\u00e1c h\u00e0m SUMIF v\u00e0 SUMIFS trong Excel, b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0 ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean b\u1ed1i r\u1ed1i.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean, khi xem x\u00e9t k\u1ef9 h\u01a1n, t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng \u0111a d\u1ea1ng \u0111\u1ec1u t\u00f3m g\u1ecdn l\u1ea1i m\u1ed9t v\u00e0i quy t\u1eafc \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111\u1eb7t ng\u00e0y tr\u1ef1c ti\u1ebfp trong tham s\u1ed1 ti\u00eau ch\u00ed, th\u00ec h\u00e3y nh\u1eadp ph\u00e9p to\u00e1n logic\u00a0 (&gt;, &lt;, =, &lt;&gt;) ngay tr\u01b0\u1edbc ng\u00e0y v\u00e0 \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\">=SUMIFS(B2:B10, C2:C10, \u201c&gt;=9\/10\/2020\u201d, C2:C10, \u201c&lt;=9\/20\/2020\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc, h\u00e3y cung c\u1ea5p ti\u00eau ch\u00ed \u1edf d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n: \u0111\u1eb7t ph\u00e9p to\u00e1n logic trong d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 b\u1eaft \u0111\u1ea7u m\u1ed9t chu\u1ed7i v\u00e0 s\u1eed d\u1ee5ng d\u1ea5u v\u00e0 (&amp;) \u0111\u1ec3 n\u1ed1i v\u00e0 k\u1ebft th\u00fac chu\u1ed7i. V\u00ed d\u1ee5:<\/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<p><span style=\"font-weight: 400\">Khi ng\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng b\u1edfi h\u00e0m DATE ho\u1eb7c TODAY(), h\u00e3y n\u1ed1i m\u1ed9t ph\u00e9p to\u00e1n so s\u00e1nh v\u00e0 m\u1ed9t h\u00e0m. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SUMIFS(B2:B10, C2:C10, \u201c&gt;=\u201d&amp;DATE(2020,9,10), C2:C10, \u201c&lt;=\u201d&amp;TODAY())<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIFS_trong_Excel_giua_cac_ngay_khong_hoat_dong\"><\/span><b>H\u00e0m SUMIFS trong Excel gi\u1eefa c\u00e1c ng\u00e0y kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p c\u00f4ng th\u1ee9c c\u1ee7a bnaj kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ho\u1eb7c t\u1ea1o ra k\u1ebft qu\u1ea3 sai, c\u00e1c m\u1eb9o kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 sau \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0m s\u00e1ng t\u1ecf l\u00fd do t\u1ea1i sao n\u00f3 kh\u00f4ng th\u00e0nh c\u00f4ng v\u00e0 gi\u00fap b\u1ea1n kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Kiem_tra_dinh_dang_ngay_va_so\"><\/span><b>Ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng ng\u00e0y v\u00e0 s\u1ed1\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu c\u00f4ng th\u1ee9c SUMIFS c\u00f3 v\u1ebb \u0111\u00fang kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u00e0o ngo\u00e0i s\u1ed1 0, th\u00ec \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean c\u1ea7n ki\u1ec3m tra lsf ng\u00e0y th\u00e1ng c\u1ee7a b\u1ea1n c\u00f3 th\u1ef1c s\u1ef1 l\u00e0 ng\u00e0y th\u00e1ng, ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n gi\u1ed1ng ng\u00e0y th\u00e1ng. Ti\u1ebfp theo, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n \u0111ang t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 ch\u1ee9 kh\u00f4ng ph\u1ea3i c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n. C\u00e1c h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n v\u00e0 kh\u1eafc ph\u1ee5c nh\u1eefng v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1ch thay \u0111\u1ed5i \u201cng\u00e0y v\u0103n b\u1ea3n\u201d th\u00e0nh ng\u00e0y th\u1ef1c<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n th\u00e0nh s\u1ed1<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cu_phap_chinh_xac_cho_tieu_chi\"><\/span><b>S\u1eed d\u1ee5ng c\u00fa ph\u00e1p ch\u00ednh x\u00e1c cho ti\u00eau ch\u00ed<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi ki\u1ec3m tra ng\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng SUMIFS, m\u1ed9t ng\u00e0y n\u00ean \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0 \u201c&gt;=9\/10\/2020\u201d; tham chi\u1ebfu \u00f4 v\u00e0 ch\u1ee9c n\u0103ng ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t b\u00ean ngo\u00e0i d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0 \u201c&lt;=\u201d&amp;G1 hay \u201c&lt;=\u201d&amp;TODAY(). \u0110\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft \u0111\u1ea7y \u0111\u1ee7, vui l\u00f2ng c\u00fa ph\u00e1p ti\u00eau ch\u00ed ng\u00e0y.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_minh_tinh_logic_cua_ham\"><\/span><b>X\u00e1c minh t\u00ednh logic c\u1ee7a h\u00e0m\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t l\u1ed7i \u0111\u00e1nh m\u00e1y nh\u1ecf trong ng\u00e2n s\u00e1ch c\u00f3 th\u1ec3 ti\u00eau t\u1ed1n h\u00e0ng tri\u1ec7u USD. M\u1ed9t c\u00fa ph\u00e1p sai s\u00f3t trong c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 t\u1ed1n h\u00e0ng gi\u1edd \u0111\u1ec3 gi\u1ea3i quy\u1ebft. V\u00ec v\u1eady, khi t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb gi\u1eefa 2 ng\u00e0y, h\u00e3y ki\u1ec3m tra xem ng\u00e0y b\u1eaft \u0111\u1ea7u c\u00f3 \u0111\u1ee9ng tr\u01b0\u1edbc ph\u00e9p to\u00e1n logic l\u1edbn h\u01a1n (&gt;) ho\u1eb7c l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt;=) hay kh\u00f4ng; v\u00e0 ng\u00e0y k\u1ebft th\u00fac \u0111\u01b0\u1ee3c b\u1eaft \u0111\u1ea7u b\u1eb1ng ph\u00e9p to\u00e1n logic nh\u1ecf h\u01a1n (&lt;) ho\u1eb7c nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (&lt;=).\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dam_bao_rang_tat_ca_cac_pham_vi_deu_co_cung_kich_thuoc\"><\/span><b>\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea1m vi \u0111\u1ec1u c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 h\u00e0m SUMIFS ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, ph\u1ea1m vi t\u00ednh t\u1ed5ng v\u00e0 ph\u1ea1m vi ti\u00eau ch\u00ed ph\u1ea3i c\u00f3 k\u00edch th\u01b0\u1edbc b\u1eb1ng nhau, n\u1ebfu kh\u00f4ng th\u00ec l\u1ed7i #VALUE! L\u1ed7i x\u1ea3y ra. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c tham s\u1ed1 criteria_range c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u01b0 sum_range.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS trong Excel \u0111\u1ec3 t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u trong m\u1ed9t chu\u1ed7i ng\u00e0y. N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 gi\u1ea3i ph\u00e1p n\u00e0o th\u00fa v\u1ecb kh\u00e1c, h\u00e3y chia s\u1ebb v\u1edbi trong nh\u1eadn x\u00e9t. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 hy v\u1ecdng s\u1ebd g\u1eb7p l\u1ea1i b\u1ea1n trong 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-429.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5092,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5091","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\/5091","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=5091"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5091\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5092"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}