{"id":278161,"date":"2023-11-08T12:46:52","date_gmt":"2023-11-08T05:46:52","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=278161"},"modified":"2023-11-08T12:47:40","modified_gmt":"2023-11-08T05:47:40","slug":"ham-subtotal","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-subtotal\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong Excel d\u1ec5 hi\u1ec3u k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Microsoft Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh t\u1ed5ng h\u1ee3p tr\u00ean d\u1eef li\u1ec7u v\u1edbi h\u00e0m SUBTOTAL. H\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng, m\u00e0 c\u00f2n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u lo\u1ea1i ph\u00e9p t\u00ednh kh\u00e1c nhau, nh\u01b0 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, ho\u1eb7c nh\u1ecf nh\u1ea5t. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u v\u00e0 minh h\u1ecda c\u1ee5 th\u1ec3 b\u1eb1ng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3, \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n

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

H\u00e0m SUBTOTAL trong Microsoft Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb subtotal (t\u1ed5ng con) t\u1eeb m\u1ed9t ph\u1ea1m vi \u00f4 d\u1eef li\u1ec7u. \u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t c\u1ee7a h\u00e0m n\u00e0y l\u00e0 kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb subtotal trong khi b\u1ecf qua c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u1ea9n ho\u1eb7c \u0111\u01b0\u1ee3c l\u1ecdc trong d\u1eef li\u1ec7u. N\u00f3 cho ph\u00e9p b\u1ea1n \u00e1p d\u1ee5ng c\u00e1c h\u00e0m to\u00e1n h\u1ecdc kh\u00e1c nhau, ch\u1eb3ng h\u1ea1n nh\u01b0 SUM, AVERAGE, COUNT, MAX, MIN, v\u00e0 nhi\u1ec1u h\u00e0m kh\u00e1c, \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed5ng con d\u1ef1a tr\u00ean d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb.<\/p>\n

H\u00e0m SUBTOTAL cung c\u1ea5p t\u00ednh n\u0103ng hi\u1ec7u qu\u1ea3 trong vi\u1ec7c t\u1ea1o c\u00e1c b\u00e1o c\u00e1o v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb t\u1eadp d\u1eef li\u1ec7u l\u1edbn, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc ho\u1eb7c \u1ea9n. N\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Excel.<\/p>\n

\"H\u00e0m<\/picture><\/p>\n

H\u00e0m SUBTOTAL d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/h2>\n

H\u00e0m SUBTOTAL gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn t\u1ed5ng s\u1ed1 chung. B\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t c\u00f4ng th\u1ee9c SUBTOTAL v\u00e0o m\u1ed9t ph\u1ea1m vi \u00f4 m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i t\u1ed5ng s\u1ed1 chung, v\u00ec SUBTOTAL s\u1ebd t\u1ef1 \u0111\u1ed9ng b\u1ecf qua c\u00e1c \u00f4 kh\u00e1c ch\u1ee9a c\u00f4ng th\u1ee9c SUBTOTAL.<\/p>\n

H\u00e0m SUBTOTAL c\u0169ng t\u01b0\u01a1ng t\u00e1c t\u1ed1t v\u1edbi c\u00e1c t\u00ednh n\u0103ng kh\u00e1c c\u1ee7a Excel, nh\u01b0 b\u1ed9 l\u1ecdc \u00f4. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc \u0111\u1ec3 hi\u1ec3n th\u1ecb m\u1ed9t ph\u1ea1m vi gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3, c\u00f4ng th\u1ee9c SUBTOTAL s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt \u0111\u1ec3 t\u00ednh to\u00e1n d\u1ef1a tr\u00ean ph\u1ea1m vi hi\u1ec3n th\u1ecb. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb ph\u1ee5 thu\u1ed9c v\u00e0o b\u1ed9 l\u1ecdc. H\u01a1n n\u1eefa, SUBTOTAL h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb \u1ea9n, \u0111i\u1ec1u m\u00e0 c\u00e1c h\u00e0m SUM hay c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec1u ch\u01b0a th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/p>\n

\"ham-subtotal-5\"<\/picture><\/p>\n

H\u00e0m SUBTOTAL cho ph\u00e9p b\u1ea1n k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m Excel kh\u00e1c nhau v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t. C\u00f3 t\u1ed5ng c\u1ed9ng 11 ph\u01b0\u01a1ng ph\u00e1p SUBTOTAL kh\u00e1c nhau, m\u1ed7i ph\u01b0\u01a1ng ph\u00e1p li\u00ean quan \u0111\u1ebfn m\u1ed9t h\u00e0m Excel hi\u1ec7n c\u00f3.<\/p>\n

S\u1eed d\u1ee5ng SUBTOTAL r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n m\u1ed9t c\u00f4ng th\u1ee9c, v\u00ed d\u1ee5 nh\u01b0 t\u1ed5ng SUM, ho\u1ea1t \u0111\u1ed9ng tr\u00ean c\u00e1c \u00f4 b\u1ecb l\u1ecdc v\u00e0 \u0111\u1ed3ng th\u1eddi b\u1ecf qua c\u00e1c c\u00f4ng th\u1ee9c SUBTOTAL kh\u00e1c m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n t\u00ednh v\u00e0o k\u1ebft qu\u1ea3. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf SUBTOTAL b\u1eb1ng vi\u1ec7c t\u1ea1o m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p, nh\u01b0ng vi\u1ec7c \u0111\u00f3 s\u1ebd y\u00eau c\u1ea7u nhi\u1ec1u c\u00f4ng \u0111o\u1ea1n h\u01a1n<\/p>\n

C\u00e1ch h\u00e0m SUBTOTAL ho\u1ea1t \u0111\u1ed9ng trong Microsoft Excel<\/h2>\n

C\u00f4ng th\u1ee9c SUBTOTAL c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u1ea1o d\u1ec5 d\u00e0ng b\u1eb1ng c\u1ea5u tr\u00fac sau:<\/p>\n

\n
=SUBTOTAL(function_num, ref1, ref2, …)<\/em><\/strong><\/div>\n<\/div>\n