{"id":8950,"date":"2025-03-14T16:56:53","date_gmt":"2025-03-14T09:56:53","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=8950"},"modified":"2026-03-27T17:21:27","modified_gmt":"2026-03-27T10:21:27","slug":"subtotal-la-gi","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/kien-thuc-kinh-te\/subtotal-la-gi","title":{"rendered":"SUBTOTAL l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUBTOTAL trong Excel"},"content":{"rendered":"\n

Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t vi\u1ec7c c\u1ee5 th\u1ec3, SUBTOTAL c\u1ef1c k\u1ef3 linh ho\u1ea1t – c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n s\u1ed1 h\u1ecdc v\u00e0 logic kh\u00e1c nhau nh\u01b0 t\u00ednh t\u1ed5ng, t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t ho\u1eb7c l\u1edbn nh\u1ea5t\u2026 Trong b\u00e0i vi\u1ebft n\u00e0y, h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u SUBTOTAL l\u00e0 g\u00ec,<\/strong> c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL v\u00e0 c\u00e1c th\u00f4ng tin th\u00fa v\u1ecb kh\u00e1c nh\u00e9.<\/p>\n\n\n\n

\"SUBTOTAL<\/figure>\n\n\n\n

SUBTOTAL l\u00e0 g\u00ec?<\/h2>\n\n\n\n
\n

\u201cSUBTOTAL l\u00e0 m\u1ed9t h\u00e0m trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5 trong danh s\u00e1ch ho\u1eb7c c\u01a1 s\u1edf d\u1eef li\u1ec7u.\u201d<\/strong><\/p>\n<\/blockquote>\n\n\n\n

B\u1ea1n cung c\u1ea5p cho SUBTOTAL hai th\u1ee9: (1) ph\u1ea1m vi d\u1eef li\u1ec7u v\u00e0 (2) lo\u1ea1i t\u1ed5ng ph\u1ee5, \u0111\u1ed5i l\u1ea1i, SUBTOTAL s\u1ebd cung c\u1ea5p cho b\u1ea1n t\u1ed5ng ph\u1ee5 c\u1ee7a d\u1eef li\u1ec7u \u0111\u00f3.<\/p>\n\n\n\n

Kh\u00f4ng gi\u1ed1ng nh\u01b0 SUM, AVERAGE, COUNT\u2026 ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t vi\u1ec7c, SUBTOTAL r\u1ea5t linh ho\u1ea1t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 t\u00ednh t\u1ed5ng, t\u00ednh trung b\u00ecnh, \u0111\u1ebfm m\u1ed9t lo\u1ea1t \u00f4. SUBTOTAL c\u0169ng b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb \u1ea9n, \u0111i\u1ec1u m\u00e0 c\u00e1c h\u00e0m kh\u00e1c (nh\u01b0 SUM) kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c.<\/p>\n\n\n\n

H\u00e0m SUBTOTAL c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010, Excel 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n.<\/p>\n\n\n\n

H\u00e0m SUBTOTAL c\u00f3 g\u00ec kh\u00e1c v\u1edbi h\u00e0m SUM?<\/h2>\n\n\n\n

H\u00e0m SUM t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 trong m\u1ed9t ph\u1ea1m vi, kh\u00f4ng c\u00f3 s\u1ef1 t\u00f9y ch\u1ecdn. M\u1eb7t kh\u00e1c, SUBTOTAL c\u00f3 t\u00ednh ch\u1ecdn l\u1ecdc, c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00f9ng m\u1ed9t ph\u00e9p t\u00ednh t\u1ed5ng trong khi t\u00f9y \u00fd b\u1ecf qua c\u00e1c h\u00e0ng b\u1ea1n \u0111\u00e3 \u1ea9n ho\u1eb7c l\u1ecdc ra, khi\u1ebfn n\u00f3 tr\u1edf n\u00ean l\u00fd t\u01b0\u1edfng cho c\u00e1c t\u1eadp d\u1eef li\u1ec7u \u0111\u1ed9ng, thay \u0111\u1ed5i.<\/p>\n\n\n\n

H\u00e0m SUBTOTAL trong Microsoft Excel ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/h2>\n\n\n\n

H\u00e0m SUBTOTAL ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t ph\u1ea1m vi \u00f4 d\u1ef1a tr\u00ean m\u1ed9t h\u00e0m to\u00e1n h\u1ecdc kh\u00e1c.<\/p>\n\n\n\n

C\u00fa ph\u00e1p:<\/p>\n\n\n\n

=SUBTOTAL(function_num, ref1, [ref2],\u2026)<\/p>\n\n\n\n

Trong \u0111\u00f3:<\/p>\n\n\n\n

Function_num: l\u00e0 s\u1ed1 ch\u1ec9 \u0111\u1ecbnh h\u00e0m n\u00e0o s\u1ebd s\u1eed d\u1ee5ng cho t\u1ed5ng ph\u1ee5.<\/p>\n\n\n\n

Ref1, Ref2 \u2026: M\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 ho\u1eb7c ph\u1ea1m vi t\u00ednh t\u1ed5ng ph\u1ee5. \u0110\u1ed1i s\u1ed1 Ref \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c, c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00e1c (t\u1ed1i \u0111a l\u00e0 254) l\u00e0 t\u00f9y ch\u1ecdn.<\/p>\n\n\n\n

\u0110\u1ed1i s\u1ed1 Function_num c\u00f3 th\u1ec3 thu\u1ed9c v\u1ec1 m\u1ed9t trong c\u00e1c s\u1ed1 sau:<\/p>\n\n\n\n

1 \u2013 11 b\u1ecf qua c\u00e1c \u00f4 \u0111\u01b0\u1ee3c l\u1ecdc, nh\u01b0ng bao g\u1ed3m c\u00e1c h\u00e0ng \u1ea9n th\u1ee7 c\u00f4ng.<\/p>\n\n\n\n

101 \u2013 111 b\u1ecf qua t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1ea9n \u2013 \u0111\u01b0\u1ee3c l\u1ecdc v\u00e0 \u1ea9n th\u1ee7 c\u00f4ng.<\/p>\n\n\n\n

SUBTOTAL s\u1eed d\u1ee5ng t\u1edbi 11 h\u00e0m to\u00e1n h\u1ecdc kh\u00e1c nhau (t\u1eeb AVERAGE \u0111\u1ebfn VAR.P) \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb t\u1ed5ng ph\u00f9 h\u1ee3p, \u0111\u1ed3ng th\u1eddi l\u00e0m vi\u1ec7c trong c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m (v\u00ed d\u1ee5, b\u1ecf qua c\u00e1c c\u00f4ng th\u1ee9c SUBTOTAL kh\u00e1c).<\/p>\n\n\n\n

H\u00e0m s\u1ed1<\/td>Ch\u1ee9c n\u0103ng<\/td>Di\u1ec5n gi\u1ea3i<\/td><\/tr>
1<\/td>101<\/td>AVERAGE<\/td>Tr\u1ea3 v\u1ec1 trung b\u00ecnh c\u1ee7a c\u00e1c s\u1ed1<\/td><\/tr>
2<\/td>102<\/td>COUNT<\/td>\u0110\u1ebfm c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1<\/td><\/tr>
3<\/td>103<\/td>COUNTA<\/td>\u0110\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng<\/td><\/tr>
4<\/td>104<\/td>MAX<\/td>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/td><\/tr>
5<\/td>105<\/td>MIN<\/td>Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/td><\/tr>
6<\/td>106<\/td>PRODUCT<\/td>T\u00ednh k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c \u00f4<\/td><\/tr>
7<\/td>107<\/td>STDEV<\/td>Tr\u1ea3 v\u1ec1 \u0111\u1ed9 l\u1ec7ch chu\u1ea9n m\u1eabu d\u1ef1a tr\u00ean m\u1eabu<\/td><\/tr>
8<\/td>108<\/td>STDEVP<\/td>Tr\u1ea3 v\u1ec1 \u0111\u1ed9 l\u1ec7ch chu\u1ea9n d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 s\u1ed1<\/td><\/tr>
9<\/td>109<\/td>SUM<\/td>C\u1ed9ng c\u00e1c s\u1ed1<\/td><\/tr>
10<\/td>110<\/td>VAR<\/td>\u01af\u1edbc t\u00ednh \u0111\u1ed9 dao \u0111\u1ed9ng d\u1ef1a tr\u00ean m\u1eabu<\/td><\/tr>
11<\/td>111<\/td>VARP<\/td>\u01af\u1edbc t\u00ednh \u0111\u1ed9 dao \u0111\u1ed9ng d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 s\u1ed1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Tr\u00ean th\u1ef1c t\u1ebf, kh\u00f4ng c\u1ea7n ph\u1ea3i ghi nh\u1edb t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 h\u00e0m. Ngay khi b\u1ea1n b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c SUBTOTAL v\u00e0o \u00f4 ho\u1eb7c thanh c\u00f4ng th\u1ee9c, Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c s\u1ed1 h\u00e0m kh\u1ea3 d\u1ee5ng cho b\u1ea1n.<\/p>\n\n\n\n

\u0110\u1ec3 th\u00eam s\u1ed1 h\u00e0m v\u00e0o c\u00f4ng th\u1ee9c, h\u00e3y nh\u1ea5p \u0111\u00fap v\u00e0o h\u00e0m b\u1ea1n mu\u1ed1n t\u00ednh (v\u00ed d\u1ee5 h\u00e0m SUM s\u1ed1 9) sau \u0111\u00f3 nh\u1eadp d\u1ea5u ph\u1ea9y, ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi (C2:C8), nh\u1eadp d\u1ea5u ngo\u1eb7c \u0111\u01a1n \u0111\u00f3ng v\u00e0 nh\u1ea5n Enter. C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n

=SUBTOTAL(9,C2:C8)<\/p>\n\n\n\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c T\u1ed5ng ph\u1ee5 1 \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, T\u1ed5ng ph\u1ee5 2 \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 s\u1ed1, T\u1ed5ng ph\u1ee5 3 \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng\u2026<\/p>\n\n\n\n

L\u01b0u \u00fd, khi b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c T\u1ed5ng ph\u1ee5 v\u1edbi h\u00e0m t\u00f3m t\u1eaft nh\u01b0 SUM ho\u1eb7c AVERAGE, c\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 t\u00ednh to\u00e1n c\u00e1c \u00f4 c\u00f3 s\u1ed1, b\u1ecf qua \u00f4 tr\u1ed1ng v\u00e0 c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1.<\/p>\n\n\n\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc<\/h2>\n\n\n\n

N\u1ebfu b\u1ea1n mu\u1ed1n t\u1ea1o c\u00f4ng th\u1ee9c SUBTOTAL trong Microsoft Excel, b\u1ea1n s\u1ebd c\u1ea7n l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng<\/h3>\n\n\n\n

B\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch m\u1edf b\u1ea3ng t\u00ednh Excel (ch\u1ee9a d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n) v\u00e0 ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Sau khi ch\u1ecdn, h\u00e3y nh\u1ea5n thanh c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng con tr\u1ecf nh\u1ea5p nh\u00e1y \u0111ang ho\u1ea1t \u0111\u1ed9ng.<\/p>\n\n\n\n

T\u1eeb \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c SUBTOTAL m\u1edbi c\u1ee7a m\u00ecnh.<\/p>\n\n\n\n

B\u01b0\u1edbc 2: Nh\u1eadp ph\u01b0\u01a1ng th\u1ee9c function_num<\/h3>\n\n\n\n

Ti\u1ebfp theo, b\u1ea1n s\u1ebd c\u1ea7n b\u1eaft \u0111\u1ea7u t\u1ea1o c\u00f4ng th\u1ee9c SUBTOTAL m\u1edbi b\u1eb1ng c\u00fa ph\u00e1p v\u00e0 c\u1ea5u tr\u00fac \u0111\u01b0\u1ee3c n\u00eau \u1edf tr\u00ean. B\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch nh\u1eadp =SUBTOTAL v\u00e0o thanh c\u00f4ng th\u1ee9c.<\/p>\n\n\n\n

Th\u00e0nh ph\u1ea7n \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00f4ng th\u1ee9c SUBTOTAL l\u00e0 ph\u01b0\u01a1ng th\u1ee9c function_num, t\u01b0\u01a1ng quan v\u1edbi m\u1ed9t h\u00e0m to\u00e1n h\u1ecdc Excel kh\u00e1c. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y nh\u1eadp m\u1ed9t s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 11 \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c SUBTOTAL bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb \u1ea9n ho\u1eb7c t\u1eeb 101 \u0111\u1ebfn 111 \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c b\u1ecf qua ch\u00fang.<\/p>\n\n\n\n

V\u00ed d\u1ee5, =SUBTOTAL(101 s\u1ebd s\u1eed d\u1ee5ng h\u00e0m AVERAGE \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb trung b\u00ecnh t\u1eeb ph\u1ea1m vi \u00f4 \u0111\u00e3 ch\u1ecdn, lo\u1ea1i tr\u1eeb m\u1ecdi gi\u00e1 tr\u1ecb \u1ea9n. Khi b\u1ea1n b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00f4ng th\u1ee9c SUBTOTAL, m\u1ed9t menu t\u00f9y ch\u1ecdn s\u1ebd xu\u1ea5t hi\u1ec7n b\u00ean d\u01b0\u1edbi c\u00f4ng th\u1ee9c, cho ph\u00e9p b\u1ea1n t\u1ef1 \u0111\u1ed9ng ch\u1ecdn m\u1ed9t trong c\u00e1c ph\u01b0\u01a1ng ph\u00e1p n\u00e0y.<\/p>\n\n\n\n

B\u01b0\u1edbc 3: Ch\u1ecdn ph\u1ea1m vi SUBTOTAL<\/h3>\n\n\n\n

\u1ede b\u01b0\u1edbc ti\u1ebfp theo, b\u1ea1n s\u1ebd c\u1ea7n ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi \u00f4 ref2.<\/p>\n\n\n\n

\u0110\u00e2y l\u00e0 d\u1eef li\u1ec7u m\u00e0 c\u00f4ng th\u1ee9c SUBTOTAL s\u1ebd s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng ph\u1ee5. N\u1ebfu b\u1ea1n mu\u1ed1n t\u1ea1o t\u1ed5ng ph\u1ee5 b\u1eb1ng nhi\u1ec1u ph\u1ea1m vi \u00f4, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c ph\u1ea1m vi n\u00e0y (l\u1ea7n l\u01b0\u1ee3t) sau khi ph\u01b0\u01a1ng th\u1ee9c function_num \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n\n\n\n

V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 \u00f4 trong ph\u1ea1m vi A2:A9 v\u00e0 B2:B9, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =SUBTOTAL(102,A2:A9,B2:B9) , \u0111\u1ea3m b\u1ea3o \u0111\u00f3ng c\u00f4ng th\u1ee9c b\u1eb1ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n \u0111\u00f3ng.<\/p>\n\n\n\n

N\u1ebfu ph\u1ea1m vi ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 (v\u00ed d\u1ee5: chu\u1ed7i v\u0103n b\u1ea3n), th\u00ec Excel s\u1ebd tr\u1ea3 v\u1ec1 th\u00f4ng b\u00e1o l\u1ed7i. B\u1ea1n s\u1ebd c\u1ea7n x\u00f3a d\u1eef li\u1ec7u xung \u0111\u1ed9t ho\u1eb7c thay \u0111\u1ed5i ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c SUBTOTAL c\u1ee7a m\u00ecnh \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/p>\n\n\n\n

H\u00e0m SUBTOTAL c\u00f3 g\u00ec \u0111\u1eb7c bi\u1ec7t?<\/h2>\n\n\n\n

B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c SUBTOTAL trong Excel nh\u01b0ng b\u1ea1n c\u00f3 bi\u1ebft l\u00fd do n\u00ean s\u1eed d\u1ee5ng SUBTOTAL l\u00e0 g\u00ec<\/strong>? V\u00ec sao kh\u00f4ng s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m th\u00f4ng th\u01b0\u1eddng nh\u01b0 SUM, COUNT, MAX\u2026? B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00e2u tr\u1ea3 l\u1eddi ngay b\u00ean d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n\n\n\n

T\u00ednh gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u0111\u00e3 l\u1ecdc<\/h3>\n\n\n\n

V\u00ec h\u00e0m SUBTOTAL c\u1ee7a Excel b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u0111\u00e3 l\u1ecdc, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u1ea1o b\u1ea3n t\u00f3m t\u1eaft d\u1eef li\u1ec7u \u0111\u1ed9ng, trong \u0111\u00f3 c\u00e1c gi\u00e1 tr\u1ecb t\u1ed5ng ph\u1ee5 \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i t\u1ef1 \u0111\u1ed9ng theo b\u1ed9 l\u1ecdc.<\/p>\n\n\n\n

V\u00ed d\u1ee5, n\u1ebfu l\u1ecdc b\u1ea3ng \u0111\u1ec3 ch\u1ec9 hi\u1ec3n th\u1ecb doanh s\u1ed1 b\u00e1n h\u00e0ng cho khu v\u1ef1c ph\u00eda Nam, c\u00f4ng th\u1ee9c T\u1ed5ng ph\u1ee5 s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c khu v\u1ef1c kh\u00e1c kh\u1ecfi t\u1ed5ng s\u1ed1.<\/p>\n\n\n\n

B\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u00f4ng th\u1ee9c SUBTOTAL l\u1ed3ng nhau<\/h3>\n\n\n\n

N\u1ebfu ph\u1ea1m vi \u0111\u01b0\u1ee3c cung c\u1ea5p cho c\u00f4ng th\u1ee9c T\u1ed5ng ph\u1ee5 Excel c\u1ee7a b\u1ea1n ch\u1ee9a b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c T\u1ed5ng ph\u1ee5 n\u00e0o kh\u00e1c, c\u00e1c t\u1ed5ng ph\u1ee5 l\u1ed3ng nhau \u0111\u00f3 s\u1ebd b\u1ecb b\u1ecf qua, do \u0111\u00f3 c\u00e1c s\u1ed1 gi\u1ed1ng nhau s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh hai l\u1ea7n.<\/p>\n\n\n\n

Ch\u1ec9 t\u00ednh c\u00e1c \u00f4 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y<\/h3>\n\n\n\n

C\u00f4ng th\u1ee9c Subtotal v\u1edbi function_num t\u1eeb 101 \u0111\u1ebfn 111 s\u1ebd b\u1ecf qua t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1ea9n – \u0111\u01b0\u1ee3c l\u1ecdc ra v\u00e0 \u1ea9n th\u1ee7 c\u00f4ng. V\u00ec v\u1eady, khi b\u1ea1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Hide c\u1ee7a Excel \u0111\u1ec3 x\u00f3a d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan kh\u1ecfi ch\u1ebf \u0111\u1ed9 xem, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 101-111 \u0111\u1ec3 lo\u1ea1i tr\u1eeb c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c h\u00e0ng \u1ea9n kh\u1ecfi t\u1ed5ng ph\u1ee5.<\/p>\n\n\n\n

C\u00e1ch x\u1eed l\u00fd c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL<\/h2>\n\n\n\n

#NAME?: N\u1ebfu c\u00e1c \u00f4 xu\u1ea5t hi\u1ec7n l\u1ed7i n\u00e0y, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 vi\u1ebft sai ch\u00ednh t\u1ea3 \u201cSUBTOTAL\u201d. \u0110\u1ec3 s\u1eeda l\u1ed7i, h\u00e3y ki\u1ec3m tra ch\u00ednh t\u1ea3 nhanh v\u00e0 s\u1eeda t\u00ean h\u00e0m.<\/p>\n\n\n\n

#VALUE!: L\u1ed7i n\u00e0y cho th\u1ea5y s\u1ed1 h\u00e0m c\u1ee7a b\u1ea1n kh\u00f4ng n\u1eb1m trong ph\u1ea1m vi 1-11 ho\u1eb7c 101-111, ho\u1eb7c khi c\u00f3 tham chi\u1ebfu 3D. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, h\u00e3y ki\u1ec3m tra l\u1ea1i \u0111\u1ed1i s\u1ed1 function_num c\u1ee7a b\u1ea1n v\u00e0 thu h\u1eb9p c\u00e1c tham chi\u1ebfu c\u1ee7a b\u1ea1n ch\u1ec9 \u0111\u1ebfn chi\u1ec1u th\u1ee9 hai.<\/p>\n\n\n\n

#DIV\/0!: L\u1ed7i n\u00e0y x\u1ea3y ra khi m\u1ed9t h\u00e0m c\u1ee5 th\u1ec3, ch\u1eb3ng h\u1ea1n nh\u01b0 t\u00ednh to\u00e1n \u0111\u1ed9 l\u1ec7ch chu\u1ea9n ho\u1eb7c trung b\u00ecnh, chia cho s\u1ed1 0 trong m\u1ed9t ph\u1ea1m vi \u00f4 kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb s\u1ed1 n\u00e0o. \u0110\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y, h\u00e3y ki\u1ec3m tra d\u1eef li\u1ec7u v\u00e0 \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 \u00f4 n\u00e0o ch\u1ee9a gi\u00e1 tr\u1ecb 0 trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n.<\/p>\n\n\n\n

Tr\u00ean \u0111\u00e2y l\u00e0 n\u1ed9i dung chia s\u1ebb SUBTOTAL l\u00e0 g\u00ec<\/strong> trong Excel c\u00f9ng v\u1edbi \u01b0u \u0111i\u1ec3m khi s\u1eed d\u1ee5ng. \u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 nhi\u1ec1u thu\u1eadt ng\u1eef kh\u00e1c h\u1eefu \u00edch \u0111\u1ed1i v\u1edbi c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n, \u0111\u1eebng qu\u00ean truy c\u1eadp v\u00e0o Mb668s.com nh\u00e9. \u1ede \u0111\u00e2y c\u0169ng c\u00f3 r\u1ea5t nhi\u1ec1u vi\u1ec7c l\u00e0m m\u1edbi h\u1ea5p d\u1eabn \u0111ang ch\u1edd b\u1ea1n kh\u00e1m ph\u00e1.<\/p>\n\n\n\n

Hu\u1ef3nh Tr\u00e2m<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t vi\u1ec7c c\u1ee5 th\u1ec3, SUBTOTAL c\u1ef1c k\u1ef3 linh ho\u1ea1t – c\u00f3 …<\/p>\n","protected":false},"author":58,"featured_media":8951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[66],"class_list":["post-8950","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-kinh-te","tag-excel"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/8950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=8950"}],"version-history":[{"count":2,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/8950\/revisions"}],"predecessor-version":[{"id":15661,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/8950\/revisions\/15661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/8951"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=8950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=8950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=8950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}