{"id":2296,"date":"2024-12-02T07:23:05","date_gmt":"2024-12-02T07:23:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-subtotal-trong-excel\/"},"modified":"2024-12-02T07:23:05","modified_gmt":"2024-12-02T07:23:05","slug":"cach-su-dung-ham-subtotal-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-su-dung-ham-subtotal-trong-excel\/","title":{"rendered":"C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M SUBTOTAL TRONG EXCEL\u00a0"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><i><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn v\u1ec1 c\u00e1ch ch\u00e8n Subtotal t\u1ef1 \u0111\u1ed9ng trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Subtotal Feature<\/span><\/i><i><span style=\"font-weight: 400\">.<\/span><\/i><i><span style=\"font-weight: 400\">. H\u00f4m nay, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd ch\u1ec9 cho c\u00e1c b\u1ea1n <strong>c\u00e1ch t\u1ef1 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c Subtotal<\/strong> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9, ch\u1eafc ch\u1eafn s\u1ebd r\u1ea5t th\u00fa v\u1ecb \u0111\u1ea5y!<\/span><\/i><\/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-674d6058ad304\" 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\/cach-su-dung-ham-subtotal-trong-excel.html#Ham_SUBTOTAL_trong_Excel\" title=\"H\u00e0m SUBTOTAL trong Excel\">H\u00e0m SUBTOTAL trong Excel<\/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\/cach-su-dung-ham-subtotal-trong-excel.html#3_LY_DO_NEN_DUNG_HAM_SUBTOTAL\" title=\"3 L\u00dd DO N\u00caN D\u00d9NG H\u00c0M SUBTOTAL\">3 L\u00dd DO N\u00caN D\u00d9NG H\u00c0M SUBTOTAL<\/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\/cach-su-dung-ham-subtotal-trong-excel.html#Tinh_gia_tri_trong_cac_hang_duoc_chon\" title=\"T\u00ednh gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn\">T\u00ednh gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn<\/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\/cach-su-dung-ham-subtotal-trong-excel.html#Chi_tinh_cac_o_co_the_thay\" title=\"Ch\u1ec9 t\u00ednh c\u00e1c \u00f4 c\u00f3 th\u1ec3 th\u1ea5y\">Ch\u1ec9 t\u00ednh c\u00e1c \u00f4 c\u00f3 th\u1ec3 th\u1ea5y<\/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\/cach-su-dung-ham-subtotal-trong-excel.html#Bo_qua_gia_tri_trong_cong_thuc_SUBTOTAL_long_ghep\" title=\"B\u1ecf qua gi\u00e1 tr\u1ecb trong c\u00f4ng th\u1ee9c SUBTOTAL l\u1ed3ng gh\u00e9p\">B\u1ecf qua gi\u00e1 tr\u1ecb trong c\u00f4ng th\u1ee9c SUBTOTAL l\u1ed3ng gh\u00e9p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-subtotal-trong-excel.html#CAC_VI_DU_DUNG_HAM_SUBTOTAL_TRONG_EXCEL\" title=\"C\u00c1C V\u00cd D\u1ee4 D\u00d9NG H\u00c0M SUBTOTAL TRONG EXCEL\">C\u00c1C V\u00cd D\u1ee4 D\u00d9NG H\u00c0M SUBTOTAL TRONG EXCEL<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-subtotal-trong-excel.html#VI_DU_1_SUBTOTAL_9_VS_SUBTOTAL_109\" title=\"V\u00cd D\u1ee4 1. SUBTOTAL 9 VS. SUBTOTAL 109\">V\u00cd D\u1ee4 1. SUBTOTAL 9 VS. SUBTOTAL 109<\/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\/cach-su-dung-ham-subtotal-trong-excel.html#VI_DU_2_IF_SUBTOTAL_TINH_TONG_DU_LIEU\" title=\"V\u00cd D\u1ee4 2. IF + SUBTOTAL T\u00cdNH T\u1ed4NG D\u1eee LI\u1ec6U\">V\u00cd D\u1ee4 2. IF + SUBTOTAL T\u00cdNH T\u1ed4NG D\u1eee LI\u1ec6U<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-subtotal-trong-excel.html#NHUNG_LOI_THUONG_GAP_CUA_HAM_SUBTOTAL_TRONG_EXCEL\" title=\"NH\u1eeeNG L\u1ed6I TH\u01af\u1edcNG G\u1eb6P C\u1ee6A H\u00c0M SUBTOTAL TRONG EXCEL\">NH\u1eeeNG L\u1ed6I TH\u01af\u1edcNG G\u1eb6P C\u1ee6A H\u00c0M SUBTOTAL TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUBTOTAL_trong_Excel\"><\/span><b>H\u00e0m SUBTOTAL trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\"><strong>H\u00e0m SUBTOTAL trong Excel<\/strong> <\/a>c\u00f3 nhi\u1ec7m v\u1ee5 \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5 trong danh s\u00e1ch ho\u1eb7c c\u01a1 s\u1edf d\u1eef li\u1ec7u. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u201ct\u1ed5ng ph\u1ee5\u201d (subtotal) kh\u00f4ng ph\u1ea3i l\u00e0 t\u1ed5ng c\u00e1c con s\u1ed1 trong 1 d\u00e3y \u00f4 x\u00e1c \u0111\u1ecbnh. Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf ch\u1ec9 \u0111\u1ec3 th\u1ef1c hi\u1ec7n 1 ch\u1ee9c n\u0103ng c\u1ee5 th\u1ec3, h\u00e0m SUBTOTAL l\u1ea1i v\u00f4 c\u00f9ng linh ho\u1ea1t, c\u00f3 th\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u00e0m c\u00e1c ph\u00e9p logic nh\u01b0 \u0111\u1ebfm s\u1ed1 \u00f4, t\u00ednh trung b\u00ecnh, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\/nh\u1ecf nh\u1ea5t\u2026<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m SUBTOTAL c\u00f3 \u1edf t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel t\u1eeb 2016 \u0111\u1ebfn 2007 v\u00e0 c\u1ea3 phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n.<\/span><\/p>\n<p><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUBTOTAL trong Excel nh\u01b0 sau:<\/b><\/p>\n<p><strong>SUBTOTAL(function_num, ref1, [ref2],\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<p><b>Function_num: <\/b><span style=\"font-weight: 400\">con s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng th\u1ef1c hi\u1ec7n<\/span><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-176.gif\" title=\"ex101_92019-nho-176\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-74.gif\" title=\"vba101_92019-nho-74\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-176.gif\" title=\"ex101_92019-nho-176\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><b>Ref1, Ref2, \u2026: <\/b><span style=\"font-weight: 400\">1 ho\u1eb7c nhi\u1ec1u \u00f4, ho\u1eb7c d\u00e3y \u00f4 \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5. C\u1ea7n ph\u1ea3i c\u00f3 <\/span><b>Ref 1<\/b><span style=\"font-weight: 400\">, t\u1eeb Ref 2 \u0111\u1ebfn 254 l\u00e0 tu\u1ef3 ch\u1ecdn.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Function_num c\u00f3 th\u1ec3 l\u00e0 1 trong 2 lo\u1ea1i sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>1 -11 <\/b><span style=\"font-weight: 400\">b\u1ecf qua c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra, nh\u01b0ng \u0111\u1ec3 l\u1ea1i c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c \u1ea9n th\u1ee7 c\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><b>101 \u2013 111 <\/b><span style=\"font-weight: 400\">b\u1ecf qua c\u00e1c \u00f4 \u1ea9n \u2013 \u0111\u00e3 l\u1ecdc ra v\u00e0 \u1ea9n th\u1ee7 c\u00f4ng.<\/span><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\"><b>Function_num<\/b><\/td>\n<td><b>Ch\u1ee9c n\u0103ng<\/b><\/td>\n<td><b>M\u00f4 t\u1ea3<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">101<\/span><\/td>\n<td><span style=\"font-weight: 400\">AVERAGE<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ednh trung b\u00ecnh c\u00e1c con s\u1ed1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">102<\/span><\/td>\n<td><span style=\"font-weight: 400\">COUNT<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u0110\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<td><span style=\"font-weight: 400\">103<\/span><\/td>\n<td><span style=\"font-weight: 400\">COUNTA<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u0110\u1ebfm s\u1ed1 \u00f4 kh\u00f4ng tr\u1ed1ng<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">4<\/span><\/td>\n<td><span style=\"font-weight: 400\">104<\/span><\/td>\n<td><span style=\"font-weight: 400\">MAX<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">5<\/span><\/td>\n<td><span style=\"font-weight: 400\">105<\/span><\/td>\n<td><span style=\"font-weight: 400\">MIN<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">6<\/span><\/td>\n<td><span style=\"font-weight: 400\">106<\/span><\/td>\n<td><span style=\"font-weight: 400\">PRODUCT<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ednh k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c \u00f4<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">7<\/span><\/td>\n<td><span style=\"font-weight: 400\">107<\/span><\/td>\n<td><span style=\"font-weight: 400\">STDEV<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ednh \u0111\u1ed9 l\u1ec7ch chu\u1ea9n m\u1eabu d\u1ef1a tr\u00ean m\u1eabu<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">8<\/span><\/td>\n<td><span style=\"font-weight: 400\">108<\/span><\/td>\n<td><span style=\"font-weight: 400\">STDEVP<\/span><\/td>\n<td><span style=\"font-weight: 400\">T\u00ednh \u0111\u1ed9 l\u1ec7ch chu\u1ea9n d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 s\u1ed1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">9<\/span><\/td>\n<td><span style=\"font-weight: 400\">109<\/span><\/td>\n<td><span style=\"font-weight: 400\">SUM<\/span><\/td>\n<td><span style=\"font-weight: 400\">C\u1ed9ng c\u00e1c s\u1ed1<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">10<\/span><\/td>\n<td><span style=\"font-weight: 400\">110<\/span><\/td>\n<td><span style=\"font-weight: 400\">VAR<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u01af\u1edbc t\u00ednh \u0111\u1ed9 dao \u0111\u1ed9ng d\u1ef1a tr\u00ean m\u1eabu<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">11<\/span><\/td>\n<td><span style=\"font-weight: 400\">111<\/span><\/td>\n<td><span style=\"font-weight: 400\">VARP<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u01af\u1edbc t\u00ednh \u0111\u1ed9 dao \u0111\u1ed9ng d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 s\u1ed1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">Th\u1ef1c t\u1ebf, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1edb h\u1ebft c\u00e1c con s\u1ed1 ch\u1ee9c n\u0103ng. Ngay khi b\u1ea1n nh\u1eadp h\u00e0m SUBTOTAL v\u00e0o 1 \u00f4 ho\u1eb7c tr\u00ean thanh c\u00f4ng th\u1ee9c, Excel s\u1ebd \u0111\u01b0a ra ngay danh s\u00e1ch c\u00e1c con s\u1ed1 cho b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c SUBTOTAL 9 \u0111\u1ec3 c\u1ed9ng t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 t\u1eeb C2 \u0111\u1ebfn C8:<\/span><\/p>\n<figure id=\"attachment_33494\" aria-describedby=\"caption-attachment-33494\" style=\"width: 470px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33494\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-1.png\" alt=\"Excel SUBTOTAL 1\" width=\"470\" height=\"249\" title=\"excel-subtotal-1\"><figcaption id=\"caption-attachment-33494\" class=\"wp-caption-text\">Excel SUBTOTAL 1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u00eam 1 s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng(function_num) v\u00e0o c\u00f4ng th\u1ee9c, nh\u1ea5n \u0111\u00fap chu\u1ed9t, \u0111\u00e1nh d\u1ea5u ph\u1ea9y, x\u00e1c \u0111\u1ecbnh d\u00e3y \u00f4, \u0111\u00f3ng ngo\u1eb7c v\u00e0 nh\u1ea5n Enter. C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p><b>=SUBTOTAL(9,C2:C8)<\/b><\/p>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c SUBTOTAL 1 \u0111\u1ec3 t\u00ednh trung b\u00ecnh, SUBTOTAL 2 \u0111\u1ec3 \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1, SUBTOTAL 3 \u0111\u1ec3 \u0111\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng. Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng 3 ch\u1ee9c n\u0103ng:<\/span><\/p>\n<figure id=\"attachment_33495\" aria-describedby=\"caption-attachment-33495\" style=\"width: 358px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33495\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-2.png\" alt=\"Excel SUBTOTAL 2\" width=\"358\" height=\"261\" title=\"excel-subtotal-2\"><figcaption id=\"caption-attachment-33495\" class=\"wp-caption-text\">Excel SUBTOTAL 2<\/figcaption><\/figure>\n<p><b>L\u01b0u \u00fd:<\/b><\/p>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c SUBTOTAL v\u1edbi ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng nh\u01b0 SUM hay AVERAGE, Excel s\u1ebd ch\u1ec9 t\u00ednh c\u00e1c \u00f4 ch\u1ee9a s\u1ed1, b\u1ecf qua \u00f4 tr\u1ed1ng v\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd th\u00ec b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c SUBTOTAL trong Excel r\u1ed3i, c\u00e2u h\u1ecfi \u0111\u1eb7t ra l\u00e0 t\u1ea1i sao l\u1ea1i ph\u1ea3i h\u1ecdc h\u00e0m n\u00e0y? Sao kh\u00f4ng d\u00f9ng c\u00e1c h\u00e0m \u0111\u01a1n gi\u1ea3n, b\u00ecnh th\u01b0\u1eddng nh\u01b0 SUM, COUNT, MAX? L\u00fd do s\u1ebd c\u00f3 ngay d\u01b0\u1edbi \u0111\u00e2y th\u00f4i, \u0111\u1ecdc ti\u1ebfp nh\u00e9!<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_LY_DO_NEN_DUNG_HAM_SUBTOTAL\"><\/span><b>3 L\u00dd DO N\u00caN D\u00d9NG H\u00c0M SUBTOTAL<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">So s\u00e1nh v\u1edbi c\u00e1c h\u00e0m Excel truy\u1ec1n th\u1ed1ng, SUBTOTAL cho b\u1ea1n nh\u1eefng l\u1ee3i th\u1ebf sau:<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_gia_tri_trong_cac_hang_duoc_chon\"><\/span><b>T\u00ednh gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u00ec h\u00e0m Excel SUBTOTAL b\u1ecf qua c\u00e1c h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u 1 c\u00e1ch linh ho\u1ea1t, c\u00e1c gi\u00e1 tr\u1ecb trong t\u1ed5ng ph\u1ee5 \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u1ea1i theo b\u1ed9 l\u1ecdc.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, n\u1ebfu ch\u00fang ta l\u1ecdc b\u1ea3ng doanh s\u1ed1 b\u00e1n h\u00e0ng ch\u1ec9 c\u1ee7a khu v\u1ef1c Mi\u1ec1n \u0110\u00f4ng, c\u00f4ng th\u1ee9c SUBTOTAL s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 b\u1ecf qua t\u1ea5t c\u1ea3 v\u00f9ng kh\u00e1c khi t\u00ednh t\u1ed5ng.<\/span><\/p>\n<figure id=\"attachment_33496\" aria-describedby=\"caption-attachment-33496\" style=\"width: 240px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33496\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-3.png\" alt=\"Excel SUBTOTAL 3\" width=\"240\" height=\"186\" title=\"excel-subtotal-3\"><figcaption id=\"caption-attachment-33496\" class=\"wp-caption-text\">Excel SUBTOTAL 3<\/figcaption><\/figure>\n<p><b>L\u01b0u \u00fd:<\/b><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec c\u00e1c 2 b\u1ed9 s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng (1-11 v\u00e0 101-111) \u0111\u1ec1u b\u1ecf qua c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra n\u00ean b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c SUBTOTAL 9 ho\u1eb7c SUBTOTAL 109 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Chi_tinh_cac_o_co_the_thay\"><\/span><b>Ch\u1ec9 t\u00ednh c\u00e1c \u00f4 c\u00f3 th\u1ec3 th\u1ea5y<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c SUBTOTAL v\u1edbi s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng 101-111 s\u1ebd b\u1ecf qua c\u00e1c \u00f4 \u0111\u00e3 \u1ea9n, \u0111\u00e3 l\u1ecdc ra v\u00e0 \u1ea9n th\u1ee7 c\u00f4ng. V\u00ec th\u1ebf, khi b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u1ea9n c\u1ee7a Excel \u0111\u1ec3 \u1ea9n d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan, d\u00f9ng s\u1ed1 ch\u1ee9c n\u0103ng 101-111 \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb nh\u1eefng h\u00e0ng \u1ea9n kh\u1ecfi t\u1ed5ng ph\u1ee5.<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Bo_qua_gia_tri_trong_cong_thuc_SUBTOTAL_long_ghep\"><\/span><b>B\u1ecf qua gi\u00e1 tr\u1ecb trong c\u00f4ng th\u1ee9c SUBTOTAL l\u1ed3ng gh\u00e9p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">N\u1ebfu d\u00e3y \u00f4 trong h\u00e0m SUBTOTAL c\u00f3 ch\u1ee9a h\u00e0m SUBTOTAL kh\u00e1c, h\u00e0m SUBTOTAL \u0111\u01b0\u1ee3c l\u1ed3ng v\u00e0o s\u1ebd b\u1ecb b\u1ecf qua. V\u1eady n\u00ean con s\u1ed1 trong b\u1ea3ng s\u1ebd kh\u00f4ng ph\u1ea3i t\u00ednh 2 l\u1ea7n. Tuy\u1ec7t v\u1eddi ph\u1ea3i kh\u00f4ng?<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong h\u00ecnh d\u01b0\u1edbi, c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trung b\u00ecnh SUBTOTAL(1, C2:C10) b\u1ecf qua k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c SUBTOTAL trong \u00f4 C3 v\u00e0 C10, nh\u01b0 th\u1ec3 b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c AVERAGE v\u1edbi 2 ph\u1ea1m vi ri\u00eang bi\u1ec7t AVERAGE (C2:C5, C7:C9).<\/span><\/p>\n<figure id=\"attachment_33497\" aria-describedby=\"caption-attachment-33497\" style=\"width: 558px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33497\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-4.png\" alt=\"Excel SUBTOTAL 4\" width=\"558\" height=\"239\" title=\"excel-subtotal-4\"><figcaption id=\"caption-attachment-33497\" class=\"wp-caption-text\">Excel SUBTOTAL 4<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"CAC_VI_DU_DUNG_HAM_SUBTOTAL_TRONG_EXCEL\"><\/span><b>C\u00c1C V\u00cd D\u1ee4 D\u00d9NG H\u00c0M SUBTOTAL TRONG EXCEL<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu m\u1edbi h\u1ecdc qua h\u00e0m SUBTOTAL, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m n\u00e0y kh\u00e1 ph\u1ee9c t\u1ea1p, r\u1eafc r\u1ed1i, th\u1eadm ch\u00ed l\u00e0 v\u00f4 ngh\u0129a. Nh\u01b0ng khi b\u1ea1n d\u00f9ng n\u00f3 \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c, b\u1ea1n s\u1ebd nh\u1eadn ra h\u00e0m Subtotal n\u00e0y c\u1ef1c k\u1ef3 h\u1eefu \u00edch v\u00e0 vi\u1ec7c thu\u1ea7n th\u1ee5c h\u00e0m SUBTOTAL kh\u00f4ng h\u1ec1 kh\u00f3 ch\u00fat n\u00e0o. V\u00ed d\u1ee5 sau \u0111\u00e2y m\u00ecnh s\u1ebd m\u00e1ch b\u1ea1n m\u1ed9t s\u1ed1 m\u1eb9o nh\u1ecf khi d\u00f9ng h\u00e0m SUBTOTAL n\u00e8!<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"VI_DU_1_SUBTOTAL_9_VS_SUBTOTAL_109\"><\/span><b>V\u00cd D\u1ee4 1. SUBTOTAL 9 VS. SUBTOTAL 109<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, Excel SUBTOTAL ch\u1ea5p nh\u1eadn 2 b\u1ed9 s\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng 1-11 v\u00e0 101-111. C\u1ea3 2 b\u1ed9 s\u1ed1 \u0111\u1ec1u b\u1ecf qua c\u00e1c h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra, nh\u01b0ng 1-11 bao g\u1ed3m c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c \u1ea9n th\u1ee7 c\u00f4ng c\u00f2n 101-111 th\u00ec lo\u1ea1i tr\u1eeb. \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t n\u00e0y, xem v\u00ed d\u1ee5 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi t\u1ed5ng c\u00e1c h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u1ea3 SUBTOTAL 9 v\u00e0 SUBTOTAL 109 nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_33498\" aria-describedby=\"caption-attachment-33498\" style=\"width: 548px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33498\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-5.png\" alt=\"Excel SUBTOTAL 5\" width=\"548\" height=\"243\" title=\"excel-subtotal-5\"><figcaption id=\"caption-attachment-33498\" class=\"wp-caption-text\">Excel SUBTOTAL 5<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng n\u1ebfu c\u00f3 c\u00e1c h\u00e0ng kh\u00f4ng li\u00ean quan \u0111\u00e3 \u1ea9n th\u1ee7 c\u00f4ng b\u1eb1ng c\u00e1ch d\u00f9ng l\u1ec7nh <\/span><b>Hide Rows<\/b><span style=\"font-weight: 400\"> trong <\/span><b>Home tab &gt; Cells group &gt; Format &gt; Hide &amp; Unhide<\/b><span style=\"font-weight: 400\">, v\u00e0 nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c h\u00e0ng, sau \u0111\u00f3 <\/span><b>Hide<\/b><span style=\"font-weight: 400\">, m\u00e0 gi\u1edd b\u1ea1n ch\u1ec9 c\u1ea7n t\u1ed5ng gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng nh\u00ecn th\u1ea5y, l\u1ef1a ch\u1ecdn SUBTOTAL 109:<\/span><\/p>\n<figure id=\"attachment_33499\" aria-describedby=\"caption-attachment-33499\" style=\"width: 570px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33499\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-6.png\" alt=\"Excel SUBTOTAL 6\" width=\"570\" height=\"244\" title=\"excel-subtotal-6\"><figcaption id=\"caption-attachment-33499\" class=\"wp-caption-text\">Excel SUBTOTAL 6<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u1edbi c\u00e1c s\u1ed1 ch\u1ee9c n\u0103ng kh\u00e1c b\u1ea1n c\u0169ng l\u00e0m theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1. V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm \u00f4 \u0111\u00e3 l\u1ecdc kh\u00f4ng tr\u1ed1ng, b\u1ea1n d\u00f9ng SUBTOTAL 3 ho\u1eb7c SUBTOTAL 103. Nh\u01b0ng ch\u1ec9 SUBTOTAL 103 m\u1edbi c\u00f3 th\u1ec3 \u0111\u1ebfm ch\u00ednh x\u00e1c c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng n\u1ebfu c\u00f3 b\u1ea5t k\u00ec h\u00e0ng \u1ea9n n\u00e0o trong d\u00e3y.<\/span><\/p>\n<figure id=\"attachment_33500\" aria-describedby=\"caption-attachment-33500\" style=\"width: 508px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33500\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-7.png\" alt=\"Excel SUBTOTAL 7\" width=\"508\" height=\"265\" title=\"excel-subtotal-7\"><figcaption id=\"caption-attachment-33500\" class=\"wp-caption-text\">Excel SUBTOTAL 7<\/figcaption><\/figure>\n<p><b>L\u01b0u \u00fd:<\/b><span style=\"font-weight: 400\"> H\u00e0m SUBTOTAL trong Excel v\u1edbi s\u1ed1 ch\u1ee9c n\u0103ng 101-111 s\u1ebd b\u1ecf qua gi\u00e1 tr\u1ecb trong h\u00e0ng b\u1ecb \u1ea9n, kh\u00f4ng ph\u1ea3i c\u1ed9t b\u1ecb \u1ea9n. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c nh\u01b0 SUBTOTAL(109, A1:E1) \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong h\u00e0ng ngang, c\u1ed9t b\u1ecb \u1ea9n s\u1ebd kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn t\u1ed5ng ph\u1ee5.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"VI_DU_2_IF_SUBTOTAL_TINH_TONG_DU_LIEU\"><\/span><b>V\u00cd D\u1ee4 2. IF + SUBTOTAL T\u00cdNH T\u1ed4NG D\u1eee LI\u1ec6U<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng k\u1ebft, c\u1ea7n ph\u1ea3i \u0111\u01b0a ra c\u00e1c d\u1eef li\u1ec7u t\u1ed5ng k\u1ebft kh\u00e1c nhau nh\u01b0ng b\u1ea1n kh\u00f4ng c\u00f3 ch\u1ed7 tr\u1ed1ng cho t\u1ea5t c\u1ea3 s\u1ed1 li\u1ec7u, th\u00ec c\u00e1ch sau c\u00f3 th\u1ec3 l\u00e0 gi\u1ea3i ph\u00e1p:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong 1 \u00f4, t\u1ea1o 1 danh s\u00e1ch d\u1ea1ng th\u1ea3 xu\u1ed1ng (drop-down) c\u00f3 ch\u1ee9a t\u00ean c\u00e1c h\u00e0m nh\u01b0 Total, Max, Min\u2026<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong \u00f4 k\u1ebf \u00f4 danh s\u00e1ch, th\u00eam c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng gh\u00e9p c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c SUBTOTAL t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c h\u00e0m trong danh s\u00e1ch.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5 trong \u00f4 C12:C16, v\u00e0 danh s\u00e1ch trong \u00f4 A17 ch\u1ee9a Total, Average, Max, Min, c\u00f4ng th\u1ee9c h\u00e0m SUBTOTAL s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(A17=\u201dtotal\u201d, SUBTOTAL(9,C2:C16), IF(A17=\u201daverage\u201d, SUBTOTAL(1,C2:C16), IF(A17=\u201dmin\u201d, SUBTOTAL(5,C2:C16), IF(A17=\u201dmax\u201d, SUBTOTAL(4,C2:C16),\u201d\u201d))))<\/strong><\/p>\n<figure id=\"attachment_33493\" aria-describedby=\"caption-attachment-33493\" style=\"width: 563px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33493\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-subtotal-8.png\" alt=\"Excel SUBTOTAL 8\" width=\"563\" height=\"236\" title=\"excel-subtotal-8\"><figcaption id=\"caption-attachment-33493\" class=\"wp-caption-text\">Excel SUBTOTAL 8<\/figcaption><\/figure>\n<p><b>M\u1eb9o nh\u1ecf:<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111\u1ed9t nhi\u00ean danh s\u00e1ch v\u00e0 \u00f4 c\u00f4ng th\u1ee9c bi\u1ebfn m\u1ea5t kh\u1ecfi b\u1ea3ng t\u00ednh, th\u00ec b\u1ea1n h\u00e3y ch\u1ecdn l\u1ea1i ch\u00fang trong danh s\u00e1ch l\u1ecdc.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"NHUNG_LOI_THUONG_GAP_CUA_HAM_SUBTOTAL_TRONG_EXCEL\"><\/span><b>NH\u1eeeNG L\u1ed6I TH\u01af\u1edcNG G\u1eb6P C\u1ee6A H\u00c0M SUBTOTAL TRONG EXCEL<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu h\u00e0m SUBTOTAL tr\u1ea3 v\u1ec1 l\u1ed7i, th\u00ec nguy\u00ean nh\u00e2n c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t trong nh\u1eefng l\u00fd do sau \u0111\u00e2y<\/span><\/p>\n<p><b>#VALUE!<\/b><span style=\"font-weight: 400\"> S\u1ed1 x\u00e1c \u0111\u1ecbnh ch\u1ee9c n\u0103ng kh\u00f4ng n\u1eb1m trong kho\u1ea3ng 1-11 ho\u1eb7c 101-111 hay c\u00f3 tham chi\u1ebfu (ref) l\u00e0 tham chi\u1ebfu 3D.<\/span><\/p>\n<p><b>#DIV\/0!<\/b><span style=\"font-weight: 400\"> X\u1ea3y ra khi 1 t\u1ed5ng c\u1ee5 th\u1ec3 ph\u1ea3i chia cho 0 (v\u00ed d\u1ee5: t\u00ednh trung b\u00ecnh c\u1ed9ng ho\u1eb7c \u0111\u1ed9 l\u1ec7ch chu\u1ea9n c\u1ee7a 1 d\u00e3y \u00f4 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1)<\/span><\/p>\n<p><b>#NAME?<\/b><span style=\"font-weight: 400\"> t\u00ean h\u00e0m SUBTOTAL sai ch\u00ednh t\u1ea3.<\/span><\/p>\n<p><b>M\u1eb9o nh\u1ecf:<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n ch\u01b0a quen v\u1edbi <strong>h\u00e0m SUBTOTAL<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng SUBTOTAL Feature \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n v\u00e0 t\u1ef1 \u0111\u1ed9ng ch\u00e8n c\u00f4ng th\u1ee9c cho b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, \u0111\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-subtotal-cac-ung-dung-cua-subtotal-trong-excel.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Subtotal<\/strong><\/a> n\u00e0y, h\u00e3y m\u1edf ngay Excel ra v\u00e0 th\u1ef1c h\u00e0nh theo c\u00e1c v\u00ed d\u1ee5 c\u1ee7a m\u00ecnh! C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ed3ng h\u00e0nh, ti\u1ebfp t\u1ee5c theo d\u00f5i \u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng ki\u1ebfn th\u1ee9c m\u1edbi nh\u1ea5t nh\u00e9!<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-176.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2296","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=2296"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2296\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2297"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}