{"id":6126,"date":"2024-12-21T13:39:11","date_gmt":"2024-12-21T13:39:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung\/"},"modified":"2024-12-21T13:39:11","modified_gmt":"2024-12-21T13:39:11","slug":"3-bien-the-cua-ham-sum-tinh-tong-theo-vung","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung\/","title":{"rendered":"3 \u201cbi\u1ebfn th\u1ec3\u201d c\u1ee7a h\u00e0m SUM t\u00ednh t\u1ed5ng theo v\u00f9ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">h\u00e0m SUM<\/a><\/strong> th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t h\u00e0ng hay m\u1ed9t c\u1ed9t, trong b\u00e0i vi\u1ebft n\u00e0y, ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u 3 c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung.html\"><strong>h\u00e0m SUM t\u00ednh t\u1ed5ng theo v\u00f9ng<\/strong> <\/a>m\u00e0 c\u00f3 th\u1ec3 tr\u01b0\u1edbc gi\u1edd \u00edt ai \u0111\u1ec3 \u00fd t\u1edbi.<\/em><\/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-6766c4fea74cc\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung.html#Ham_SUM_tinh_tong_theo_vung_thong_thuong\" title=\"H\u00e0m SUM t\u00ednh t\u1ed5ng theo v\u00f9ng th\u00f4ng th\u01b0\u1eddng\">H\u00e0m SUM t\u00ednh t\u1ed5ng theo v\u00f9ng th\u00f4ng th\u01b0\u1eddng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung.html#Ham_SUM_tinh_tong_voi_nhieu_vung\" title=\"H\u00e0m SUM t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u v\u00f9ng\">H\u00e0m SUM t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u v\u00f9ng<\/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\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung.html#Ham_SUM_tinh_tong_vung_giao_nhau\" title=\"H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng giao nhau\">H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng giao nhau<\/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\/3-bien-the-cua-ham-sum-tinh-tong-theo-vung.html#Ham_SUM_tinh_tong_vung_lien_tuc\" title=\"H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng li\u00ean t\u1ee5c\">H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng li\u00ean t\u1ee5c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUM_tinh_tong_theo_vung_thong_thuong\"><\/span>H\u00e0m SUM t\u00ednh t\u1ed5ng theo v\u00f9ng th\u00f4ng th\u01b0\u1eddng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi h\u00e0m SUM th\u00f4ng th\u01b0\u1eddng ta c\u00f3 c\u00f4ng th\u1ee9c: =<strong>SUM(v\u00f9ng t\u00ednh t\u1ed5ng 1,\u2026).<\/strong> Ch\u1eb3ng h\u1ea1n \u0111\u1ec3 t\u00ednh t\u1ed5ng t\u1eeb \u00f4 A1 \u0111\u1ebfn A10 ta nh\u1eadp:<\/p>\n<blockquote>\n<p><em>=SUM(A1:A10)<\/em><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUM_tinh_tong_voi_nhieu_vung\"><\/span>H\u00e0m SUM t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u v\u00f9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a nhi\u1ec1u v\u00f9ng, ta s\u1eed d\u1ee5ng to\u00e1n t\u1eed (,) \u0111\u1ec3 tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a c\u00e1c v\u00f9ng th\u00e0nh ph\u1ea7n. Ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a 2 v\u00f9ng B5:B7 v\u00e0 C4:F4 trong h\u00ecnh, ta nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=SUM(B5:B7,C4:F4)<\/em><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32357 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-bien-the-ham-sum-1.png\" alt=\"ham-sum-tinh-tong-theo-vung-1\" width=\"538\" height=\"308\" title=\"3-bien-the-ham-sum-1\"><\/p>\n<p>K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 t\u1ed5ng c\u1ee7a 2 v\u00f9ng. \u0110\u00e2y c\u0169ng l\u00e0 c\u00e1ch th\u00f4ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn v\u00e0 s\u1eed d\u1ee5ng khi t\u00ednh t\u1ed5ng \u1edf c\u00e1c c\u1ed9t kh\u00e1c nhau.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUM_tinh_tong_vung_giao_nhau\"><\/span>H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng giao nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng giao \u0111i\u1ec3m c\u1ee7a 2 ho\u1eb7c nhi\u1ec1u v\u00f9ng nh\u01b0 h\u00ecnh, c\u00f4ng th\u1ee9c ta c\u1ea7n nh\u1eadp nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=SUM(B5:F5 C4:D7) (<b>ng\u0103n 2 v\u00f9ng b\u1eb1ng d\u1ea5u c\u00e1ch &lt;space&gt;<\/b><\/em>)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32358 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-bien-the-ham-sum-2.png\" alt=\"ham-sum-tinh-tong-theo-vung-2\" width=\"321\" height=\"82\" title=\"3-bien-the-ham-sum-2\"><\/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-550.gif\" title=\"ex101_92019-nho-550\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32359 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-bien-the-ham-sum-3.png\" alt=\"ham-sum-tinh-tong-theo-vung-3\" width=\"469\" height=\"330\" title=\"3-bien-the-ham-sum-3\"><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 t\u1ed5ng giao \u0111i\u1ec3m c\u1ee7a 2 ho\u1eb7c nhi\u1ec1u v\u00f9ng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng c\u1ee7a 2 \u00f4 C5 v\u00e0 D5 \u2013 giao c\u1ee7a 2 v\u00f9ng B5:F5 v\u1edbi C4:D7<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUM_tinh_tong_vung_lien_tuc\"><\/span>H\u00e0m SUM t\u00ednh t\u1ed5ng v\u00f9ng li\u00ean t\u1ee5c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>G\u1ea7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1ch t\u00ednh t\u1ed5ng 1 v\u00f9ng l\u1edbn, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed (:) \u0111\u1ec3 ph\u00e2n t\u00e1ch \u00f4 \u0111\u1ea7u ti\u00ean kh\u1ecfi \u00f4 cu\u1ed1i c\u00f9ng khi b\u1ea1n tham chi\u1ebfu \u0111\u00ea\u0301n ph\u1ea1m vi \u00f4 li\u00ean t\u1ee5c trong c\u00f4ng th\u1ee9c. Ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u00f9ng t\u1eeb B4 t\u1edbi F7, ngo\u00e0i c\u00e1ch nh\u1eadp\u00a0<em>=SUM(B4:F7)<strong>,\u00a0<\/strong><\/em>ta c\u00f3 th\u1ec3 nh\u1eadp theo nh\u1eefng ph\u01b0\u01a1ng th\u1ee9c kh\u00e1c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=SUM(B6:B7:E4:F4)<\/em><\/p>\n<p><em>=SUM(B7:B7:D4:F4)<\/em><\/p>\n<p><em>=SUM(B4:B7:B4:F4)<\/em><\/p>\n<\/blockquote>\n<p>\u2026.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-32360 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-bien-the-ham-sum-4.png\" alt=\"ham-sum-tinh-tong-theo-vung-4\" width=\"468\" height=\"344\" title=\"3-bien-the-ham-sum-4\"><\/p>\n<p>\u00a0<\/p>\n<p>Tr\u00ean th\u1ef1c t\u1ebf, nh\u1eefng bi\u1ebfn th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng d\u1ef1a tr\u00ean quy t\u1eafc v\u1ec1 <strong>to\u00e1n t\u1eed tham chi\u1ebfu<\/strong> trong Excel.<\/p>\n<p>Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc m\u1ed9t b\u00e0i vi\u1ebft kh\u00e1c t\u1eebng \u0111\u01b0\u1ee3c vi\u1ebft v\u1ec1 h\u00e0m SUM v\u1edbi c\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu do <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u00e3 bi\u00ean so\u1ea1n r\u1ea5t chi ti\u1ebft<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/dau-toan-tu-duoc-su-dung-voi-ham-sum.html\"><strong>S\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c to\u00e1n t\u1eed khi tham chi\u1ebfu t\u00ednh to\u00e1n v\u1edbi h\u00e0m SUM<\/strong><\/a><\/p>\n<p>\u00a0<\/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-550.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6127,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6126","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\/6126","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=6126"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6126\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6127"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}