{"id":3146,"date":"2024-12-03T01:13:49","date_gmt":"2024-12-03T01:13:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/danh-so-thu-tu-tu-dong-trong-excel-voi-ham-subtotal\/"},"modified":"2024-12-03T01:13:49","modified_gmt":"2024-12-03T01:13:49","slug":"danh-so-thu-tu-tu-dong-trong-excel-voi-ham-subtotal","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/danh-so-thu-tu-tu-dong-trong-excel-voi-ham-subtotal\/","title":{"rendered":"\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m SUBTOTAL"},"content":{"rendered":"
\n

Trong b\u00e0i tr\u01b0\u1edbc, ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m COUNTA (b\u1ea1n n\u00e0o ch\u01b0a r\u00f5 c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1\u00a0\u0111\u1ed9ng b\u1eb1ng h\u00e0m COUNTA\u00a0)<\/p>\n

Trong b\u00e0i vi\u1ebft n\u00e0y,ho\u0323c excel online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t h\u00e0m kh\u00e1c h\u1ed7 tr\u1ee3 vi\u1ec7c\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n h\u00e0m COUNTA,\u00a0\u0111\u00f3 l\u00e0 h\u00e0m SUBTOTAL. Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u00e9:<\/p>\n

<\/p>\n

A3 =\u00a0IF(B3=\u201d\u201d,\u201d\u201d,SUBTOTAL(3,$B$2:B3))<\/p>\n

Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

IF(B3=\u201d\u201d,\u201d\u201d,\u00a0 : N\u1ebfu\u00a0\u00f4 h\u1ecd t\u00ean (c\u1ed9t B) l\u00e0 r\u1ed7ng th\u00ec s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb STT l\u00e0 r\u1ed7ng<\/p>\n

SUBTOTAL(3,$B$2:B3)\u00a0 : N\u1ebfu\u00a0\u00f4 h\u1ecd t\u00ean kh\u00f4ng r\u1ed7ng, s\u1ebd s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL(function_num, Ref1, \u2026)<\/p>\n

Function_num = 3: s\u1eed d\u1ee5ng c\u00e1ch t\u00ednh l\u00e0 COUNTA:\u00a0\u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 ph\u00e1t sinh<\/p>\n

\n
\n

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


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

Ref1 =\u00a0 $B$2:B3 : s\u1eed d\u1ee5ng\u00a0\u0111\u1ebfm k\u00fd t\u1ef1 ph\u00e1t sinh trong kho\u1ea3ng B2:B3, trong\u00a0\u0111\u00f3\u00a0\u00f4 B2\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh<\/p>\n

H\u00e0m n\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u t\u01b0\u01a1ng t\u1ef1 v\u1edbi COUNTA($B$2:B3)<\/p>\n

Xem th\u00eam<\/strong>: Ha\u0300m \u0111a\u0301nh s\u00f4\u0301 th\u01b0\u0301 t\u01b0\u0323 t\u01b0\u0323 \u0111\u00f4\u0323ng trong excel v\u01a1\u0301i ha\u0300m\u00a0COUNTA<\/a><\/p>\n

*** V\u1eady 2 h\u00e0m n\u00e0y c\u00f3 g\u00ec kh\u00e1c nhau khi \u1ee9ng d\u1ee5ng v\u00e0o tr\u01b0\u1eddng h\u1ee3p n\u00e0y? S\u1ef1 kh\u00e1c nhau n\u1eb1m \u1edf ch\u1ed7 khi ch\u00fang ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Filter nh\u01b0 sau:<\/p>\n

<\/p>\n

Khi s\u1eed d\u1ee5ng\u00a0ch\u1ee9c n\u0103ng Filter th\u00ec sau khi l\u1ecdc b\u1eb1ng Filter, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m COUNTA kh\u00f4ng thay \u0111\u1ed5i k\u1ebft qu\u1ea3, c\u00f2n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m SUBTOTAL th\u00ec s\u1ebd \u0111\u00e1nh s\u1ed1 l\u1ea1i theo c\u00e1c gi\u00e1 tr\u1ecb sau khi l\u1ecdc.<\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n

To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/p>\n

Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m subtotal<\/a> v\u00e0 nh\u1eefng \u1ee9ng d\u1ee5ng h\u1eefu \u00edch trong excel\u00a0<\/strong><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

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


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3146","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\/3146","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=3146"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3146\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3147"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}