{"id":5074,"date":"2024-12-09T01:56:49","date_gmt":"2024-12-09T01:56:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/ham-sumifs-tinh-tong-theo-tuan-thang-nam\/"},"modified":"2024-12-09T01:56:49","modified_gmt":"2024-12-09T01:56:49","slug":"ham-sumifs-tinh-tong-theo-tuan-thang-nam","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/ham-sumifs-tinh-tong-theo-tuan-thang-nam\/","title":{"rendered":"H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng theo tu\u1ea7n, th\u00e1ng, n\u0103m"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00f4m tr\u01b0\u1edbc \u0111i l\u00e0m, ph\u1ea3i l\u00e0m c\u00e1i b\u00e1o c\u00e1o t\u00ednh doanh thu trong c\u00e1c kho\u1ea3ng th\u1eddi gian, m\u1edbi \u0111\u1ea7u ngh\u0129 ngay \u0111\u1ebfn h\u00e0m MONTH l\u1ed3ng v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a> g\u00ec \u0111\u00f3 nh\u01b0ng ngh\u0129 l\u1ea1i th\u00ec d\u00f9ng th\u1ebf kh\u00f4ng \u1ed5n, ngh\u0129 h\u1ebft 5 gi\u00e2y n\u00ean vi\u1ebft ra b\u00e0i n\u00e0y \u0111\u1ec3 chia s\u1ebb c\u00f9ng c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng trong 1 kho\u1ea3ng th\u1eddi gian, c\u00f3 th\u1ec3 l\u00e0 t\u00ednh t\u1ed5ng theo tu\u1ea7n, theo th\u00e1ng hay theo n\u0103m ho\u1eb7c b\u1ea5t c\u1ee9 kho\u1ea3ng th\u1eddi gian n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c.<\/p>\n<ol>\n<li>T\u00ednh t\u1ed5ng theo th\u00e1ng<\/li>\n<li>T\u00ednh t\u1ed5ng theo n\u0103m<\/li>\n<li>T\u00ednh t\u1ed5ng trong kho\u1ea3ng th\u1eddi gian<\/li>\n<\/ol>\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-67564e60d5354\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html#Ham_SUMIFS_%E2%80%93_tinh_tong_trong_1_thang\" title=\"H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 th\u00e1ng\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html#Ham_SUMIFS_%E2%80%93_tinh_tong_trong_1_nam\" title=\"H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 n\u0103m\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 n\u0103m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html#Ham_sumifs_%E2%80%93_tinh_tong_trong_1_khoang_thoi_gian\" title=\"H\u00e0m sumifs \u2013 t\u00ednh t\u1ed5ng trong 1 kho\u1ea3ng th\u1eddi gian\">H\u00e0m sumifs \u2013 t\u00ednh t\u1ed5ng trong 1 kho\u1ea3ng th\u1eddi gian<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Ham_SUMIFS_%E2%80%93_tinh_tong_trong_1_thang\"><\/span><a id=\"tinh-tong-theo-thang\" href=\"\"><\/a>H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng theo th\u00e1ng s\u1eed d\u1ee5ng h\u00e0m sumifs, ta s\u1eed d\u1ee5ng c\u00fa ph\u00e1p sau \u0111\u00e2y v\u1edbi gi\u1ea3 s\u1eed v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 A1:A10 v\u00e0 v\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng l\u00e0 B1:B10<\/p>\n<p><strong>=SUMIFS(B1:B10,A1:A10,\u201d&gt;=\u201d&amp;DATE(2017,1,1),A1:A10,\u201d&lt;=\u201d&amp;DATE(2017,1,31))<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c tr\u00ean t\u00ednh t\u1ed5ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n ng\u00e0y t\u1eeb 01.01.2017 \u0111\u1ebfn 31.01.2017 (th\u00e1ng 1 n\u0103m 2017)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2463 size-large\" title=\"h\u00e0m sumifs trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-04-at-09-03-44-1024x587-1.png\" alt=\"h\u00e0m sumifs trong excel\" width=\"1024\" height=\"587\"><\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ham_SUMIFS_%E2%80%93_tinh_tong_trong_1_nam\"><\/span><a id=\"sumif-theo-nam\" href=\"\"><\/a>H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng trong 1 n\u0103m<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng theo n\u0103m s\u1eed d\u1ee5ng h\u00e0m sumifs, ta s\u1eed d\u1ee5ng c\u00fa ph\u00e1p sau \u0111\u00e2y v\u1edbi gi\u1ea3 s\u1eed v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 A1:A10 v\u00e0 v\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n ng\u00e0y th\u00e1ng l\u00e0 B1:B10<\/p>\n<p><strong>=SUMIFS ( A1:A10, B1:B10 , \u201c&gt;=\u201d &amp; DATE ( 2017 , 1 , 1), B1:B10, \u201c&lt;=\u201d &amp; DATE(2017,12,31))<\/strong><\/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-426.gif\" title=\"ex101_92019-nho-426\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd t\u00ednh t\u1ed5ng c\u1ee7a v\u00f9ng A1:A10 trong kho\u1ea3ng th\u1eddi gian t\u1eeb 01.01.2017 \u0111\u1ebfn 31.12.2017 (trong n\u0103m 2017)<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Ham_sumifs_%E2%80%93_tinh_tong_trong_1_khoang_thoi_gian\"><\/span><a id=\"sumif-trong-khoang-thoi-gian\" href=\"\"><\/a>H\u00e0m sumifs \u2013 t\u00ednh t\u1ed5ng trong 1 kho\u1ea3ng th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1eed d\u1ee5ng h\u00e0m sumifs, ta s\u1eed d\u1ee5ng nh\u01b0 sau:<\/p>\n<p><strong>=SUMIFS ( A1:A10, B1:B10 , \u201c&gt;=\u201d &amp; DATE ( 2017 , 1 , 18), B1:B10, \u201c&lt;=\u201d &amp; DATE(2017,4,23))<\/strong><\/p>\n<p>c\u0169ng gi\u1ed1ng nh\u01b0 v\u00ed d\u1ee5 t\u00ednh n\u0103m \u1edf tr\u00ean, b\u1ea1n ch\u1ec9 c\u1ea7n thay \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c c\u1ee7a ri\u00eang m\u00ecnh \u0111\u1ec3 t\u00ednh t\u1ed5ng trong v\u00f9ng A1:A10 trong kho\u1ea3ng th\u1eddi gian t\u1eeb 18.01.2017 t\u1edbi 23.04.2017.<\/p>\n<p>Nh\u01b0 v\u1eady trong b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n th\u1eddi gian k\u1ebft h\u1ee3p v\u1edbi h\u00e0m DATE, t\u1eeb nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0y, vi\u1ec7c t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean th\u1eddi gian k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TIME c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd t\u01b0\u01a1ng t\u1ef1. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u00f3 \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c v\u1ec1 SUMIFS sau \u0111\u00e2y:<\/p>\n<ol>\n<li><a href=\"https:\/\/blog.hocexcel.online\/excel-nang-cao-ket-hop-vlookup-sum-va-sumif.html\" target=\"_blank\" rel=\"noopener\">Excel n\u00e2ng cao: k\u1ebft h\u1ee3p SUMIF, VLOOKUP, SUM<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/ham-sumif-tinh-tong-excel.html\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMIF \/ SUMIFS t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMPRODUCT v\u00e0 s\u1ef1 kh\u00e1c nhau so v\u1edbi SUMIFS, COUNTIFS trong Excel<\/a><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem n\u1eb1m trong\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OCcDQs\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-426.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5074","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\/5074","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=5074"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5074\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5075"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}