{"id":3759,"date":"2024-12-03T03:53:33","date_gmt":"2024-12-03T03:53:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-su-dung-ham-subtotal-de-tinh-tong-thay-cho-ham-sum\/"},"modified":"2024-12-03T03:53:33","modified_gmt":"2024-12-03T03:53:33","slug":"huong-dan-cach-su-dung-ham-subtotal-de-tinh-tong-thay-cho-ham-sum","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-su-dung-ham-subtotal-de-tinh-tong-thay-cho-ham-sum\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Subtotal \u0111\u1ec3 t\u00ednh t\u1ed5ng thay cho h\u00e0m sum"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-subtotal\" cite=\"https:\/\/blog.hocexcel.online\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html?ham-subtotal\">\n<p><em>Ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft h\u00e0m SUM l\u00e0 m\u1ed9t h\u00e0m quen thu\u1ed9c d\u00f9ng\u00a0\u0111\u1ec3 <strong>t\u00ednh t\u1ed5ng trong\u00a0Excel<\/strong>. Nh\u01b0ng c\u00f2n c\u00f3 1 h\u00e0m t\u1ed1t h\u01a1n\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c\u00a0\u0111\u00f3, ch\u00ednh l\u00e0 h\u00e0m SUBTOTAL trong Excel. T\u1ed1t h\u01a1n nh\u01b0 th\u1ebf n\u00e0o? h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y.<\/em><\/p>\n<\/blockquote>\n<p>H\u00e3y xem v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23791\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-dung-subtotal-thay-ham-sum.png\" width=\"811\" height=\"220\" title=\"de-bai-dung-subtotal-thay-ham-sum\"><\/p>\n<p>Th\u00f4ng th\u01b0\u1eddng\u00a0\u1edf d\u00f2ng T\u1ed5ng c\u1ed9ng, ch\u00fang ta s\u1ebd hay s\u1eed d\u1ee5ng h\u00e0m SUM\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c c\u1ed9t C, D, E, F.<\/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-674e80bc72b01\" 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\/huong-dan-cach-su-dung-ham-subtotal-trong-excel-de-tinh-tong.html#Nhuoc_diem_cua_ham_SUM\" title=\"Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m c\u1ee7a h\u00e0m SUM\">Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m c\u1ee7a h\u00e0m SUM<\/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\/huong-dan-cach-su-dung-ham-subtotal-trong-excel-de-tinh-tong.html#Dung_ham_SUBTOTAL_thay_the_ham_SUM\" title=\"D\u00f9ng h\u00e0m SUBTOTAL\u00a0thay th\u1ebf h\u00e0m SUM\">D\u00f9ng h\u00e0m SUBTOTAL\u00a0thay th\u1ebf h\u00e0m SUM<\/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\/huong-dan-cach-su-dung-ham-subtotal-trong-excel-de-tinh-tong.html#Nhan_xet_ve_ham_subtotal_trong_Excel\" title=\"Nh\u1eadn x\u00e9t v\u1ec1 h\u00e0m subtotal trong Excel\">Nh\u1eadn x\u00e9t v\u1ec1 h\u00e0m subtotal trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhuoc_diem_cua_ham_SUM\"><\/span>Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m c\u1ee7a h\u00e0m SUM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m SUM, k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23792\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-su-dung-ham-sum.png\" width=\"807\" height=\"238\" title=\"ket-qua-su-dung-ham-sum\"><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng l\u00e0m th\u00eam thao t\u00e1c g\u00ec th\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m SUM l\u00e0\u00a0\u0111\u00fang.<\/p>\n<p>Tuy nhi\u00ean th\u1eed h\u00ecnh dung b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y l\u1edbn h\u01a1n, v\u00e0 ch\u00fang ta c\u1ea7n ph\u1ea3i l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng, v\u00ed d\u1ee5 l\u1ecdc nh\u1eefng ng\u01b0\u1eddi\u00a0\u1edf b\u1ed9 ph\u1eadn Kinh doanh. Khi\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea3ng t\u00ednh l\u00e0:<\/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-293.gif\" title=\"ex101_92019-nho-293\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23793\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-su-dung-ham-sum-khi-loc-du-lieu.png\" width=\"809\" height=\"188\" title=\"ket-qua-su-dung-ham-sum-khi-loc-du-lieu\"><\/p>\n<p>Ch\u00fang ta th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea3ng t\u1ea1i d\u00f2ng T\u1ed5ng c\u1ed9ng v\u1eabn gi\u1eef nguy\u00ean, m\u1eb7c d\u00f9 d\u1eef li\u1ec7u\u00a0\u0111\u00e3 l\u1ecdc b\u1ecf\u00a0\u0111i b\u1ed9 ph\u1eadn k\u1ebf to\u00e1n.<\/p>\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 khi l\u1ecdc d\u1eef li\u1ec7u, k\u1ebft qu\u1ea3 s\u1ebd ch\u1ec9 t\u00ednh t\u1ed5ng nh\u1eefng gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a b\u1ea3ng t\u00ednh, b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb l\u1ecdc\u00a0 b\u1ecf? Ch\u00fang ta s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng h\u00e0m SUM n\u1eefa m\u00e0 chuy\u1ec3n sang d\u00f9ng h\u00e0m SUBTOTAL trong excel<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dung_ham_SUBTOTAL_thay_the_ham_SUM\"><\/span>D\u00f9ng h\u00e0m SUBTOTAL\u00a0thay th\u1ebf h\u00e0m SUM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m Subtotal nh\u01b0 sau:<\/p>\n<p>SUBTOTAL(function_num,ref1,\u2026)<\/p>\n<p>trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>function_num l\u00e0 c\u00e1c ph\u00e9p t\u00ednh. C\u00f3 r\u1ea5t nhi\u1ec1u ph\u00e9p t\u00ednh trong h\u00e0m n\u00e0y, v\u00e0\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng th\u00ec ch\u00fang ta d\u00f9ng s\u1ed1 9 ho\u1eb7c 109<\/li>\n<li>ref1\u2026: l\u00e0 c\u00e1c v\u00f9ng tham chi\u1ebfu t\u1edbi c\u00e1c\u00a0\u00f4 c\u1ea7n t\u00ednh t\u1ed5ng<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 khi s\u1eed d\u1ee5ng Subtotal nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23794\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-su-dung-ham-subtotal-tinh-tong-khi-loc.png\" width=\"804\" height=\"187\" title=\"ket-qua-su-dung-ham-subtotal-tinh-tong-khi-loc\"><\/p>\n<p>M\u1eb7c d\u00f9 h\u00e0m\u00a0\u0111\u00e3 tham chi\u1ebfu t\u1eeb C2:C6 nh\u01b0ng k\u1ebft qu\u1ea3 ch\u1ec9 t\u00ednh t\u1ed5ng cho c\u00e1c\u00a0\u00f4 C2, C3, C4,\u00a0 c\u00f2n c\u00e1c\u00a0\u00f4\u00a0\u0111\u00e3 b\u1ecb\u00a0\u1ea9n l\u00e0 C5, C6 s\u1ebd kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u00ednh.\u00a0\u0110\u00e2y\u00a0 ch\u00ednh l\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t r\u1ea5t l\u1edbn gi\u1eefa Sum v\u00e0 Subtotal.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhan_xet_ve_ham_subtotal_trong_Excel\"><\/span>Nh\u1eadn x\u00e9t v\u1ec1 h\u00e0m subtotal trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu nh\u01b0 d\u00f9ng h\u00e0m SUM,\u00a0\u01b0u\u00a0\u0111i\u1ec3m r\u1ea5t l\u1edbn l\u00e0 s\u1ef1 ti\u1ec7n l\u1ee3i, nhanh ch\u00f3ng. H\u00e0m vi\u1ebft nhanh h\u01a1n,\u00a0\u00edt tham s\u1ed1 h\u01a1n,\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0\u00a0excel c\u00f2n h\u1ed7 tr\u1ee3 ch\u00fang ta ph\u01b0\u01a1ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-autosum-trong-excel.html\">AutoSum<\/a> r\u1ea5t ti\u1ec7n l\u1ee3i.<\/p>\n<p>C\u00f2n khi s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL,\u00a0\u01b0u\u00a0\u0111i\u1ec3m l\u1edbn nh\u1ea5t ch\u00ednh l\u00e0 hi\u1ec7u qu\u1ea3. C\u00f4ng vi\u1ec7c c\u1ee7a ch\u00fang ta kh\u00f4ng\u00a0\u0111\u01a1n thu\u1ea7n l\u00e0 t\u00ednh ra k\u1ebft qu\u1ea3, m\u00e0 k\u1ebft qu\u1ea3\u00a0\u0111\u00f3 ph\u1ea3i d\u1ec5 d\u00e0ng t\u00f9y bi\u1ebfn,\u00a0\u0111\u00fang v\u1edbi m\u1ecdi tr\u01b0\u1eddng h\u1ee3p. C\u00e1c thao t\u00e1c\u00a0\u1ea9n, l\u1ecdc d\u1eef li\u1ec7u r\u1ea5t hay\u00a0\u0111\u01b0\u1ee3c\u00a0s\u1eed d\u1ee5ng trong\u00a0Excel, khi\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb\u00a0\u0111\u00fang,\u00a0 ch\u00fang ta c\u1ea7n t\u1edbi h\u00e0m Subtotal.<\/p>\n<p>Vi\u1ec7c vi\u1ebft t\u00ean h\u00e0m d\u00e0i h\u01a1n, nhi\u1ec1u ph\u00e9p t\u00ednh h\u01a1n c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n b\u1ed1i r\u1ed1i khi m\u1edbi t\u00ecm hi\u1ec3u. Nh\u01b0ng khi\u00a0\u0111\u00e3 quen v\u1edbi\u00a0h\u00e0m n\u00e0y, ch\u00fang ta s\u1ebd\u00a0g\u1ea7n nh\u01b0 ch\u1ec9 s\u1eed d\u1ee5ng\u00a0 h\u00e0m n\u00e0y m\u00e0 th\u00f4i.<\/p>\n<p>Tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft kh\u00e1c v\u1ec1 h\u00e0m Subtotal:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-tu-dong-trong-excel-voi-ham-subtotal.html\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m SUBTOTAL<\/a><\/p>\n<p style=\"padding-left: 30px\"><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\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m Sum trong Excel \u2013 C\u00e1ch ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c c\u1ed9t, h\u00e0ng ho\u1eb7c \u00f4 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb<\/a><\/p>\n<p style=\"padding-left: 30px\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\">H\u00e0m Subtotal<\/a>, c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a Subtotal trong Excel<\/strong><\/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-293.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3760,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3759","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\/3759","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=3759"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3759\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3760"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}