{"id":13284,"date":"2015-09-14T04:49:13","date_gmt":"2015-09-14T04:49:13","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13284"},"modified":"2015-09-29T09:21:57","modified_gmt":"2015-09-29T09:21:57","slug":"cach-su-dung-ham-subtotal-trong-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13284","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong k\u1ebf to\u00e1n Excel"},"content":{"rendered":"

\"C\u00e1ch<\/h2>\n

K\u1ebf to\u00e1n Centax<\/strong><\/a> xin chia s\u1ebb c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL, m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n Excel.<\/span><\/p>\n

H\u00e0m Subtotal l\u00e0 h\u00e0m t\u00ednh to\u00e1n cho m\u1ed9t nh\u00f3m con trong m\u1ed9t danh s\u00e1ch ho\u1eb7c b\u1ea3ng d\u1eef li\u1ec7u tu\u1ef3 theo ph\u00e9p t\u00ednh m\u00e0 b\u1ea1n ch\u1ecdn l\u1ef1a trong \u0111\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t. \u0110\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t c\u1ee7a h\u00e0m Subtotal x\u00e1c \u0111\u1ecbnh h\u00e0m th\u1ef1c s\u1ef1 n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi t\u00ednh to\u00e1n trong danh s\u00e1ch d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

Tuy nhi\u00ean, \u0111\u1ed1i s\u1ed1 hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t khi l\u00e0m k\u1ebf to\u00e1n Excel l\u00e0 s\u1ed1 9<\/strong> – d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng trong b\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n, b\u1ea3ng t\u00ednh ti\u1ec1n l\u01b0\u01a1ng, b\u1ea3ng c\u00e2n \u0111\u1ed1i ph\u00e1t sinh, ho\u1eb7c t\u00ednh t\u1ed5ng cho t\u1eebng t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n,… H\u00e0m Subtotal t\u00ednh\u00a0 t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 thay \u0111\u1ed5i khi l\u1ecdc d\u1eef li\u1ec7u. Khi l\u1ecdc d\u1eef li\u1ec7u th\u00ec n\u00f3 s\u1ebd b\u1ecf qua kh\u00f4ng t\u00ednh to\u00e1n t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng b\u1ecb \u1ea9n b\u1edfi l\u1ec7nh Filter.<\/span><\/p>\n

\u00a0H\u00e0m Subtotal \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u00ednh to\u00e1n cho c\u00e1c c\u1ed9t s\u1ed1 li\u1ec7u theo chi\u1ec1u d\u1ecdc, n\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u00ednh theo chi\u1ec1u ngang.<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

 <\/p>\n

V\u00ed d\u1ee5: H\u00e0m Subtotal \u0111\u01b0\u1ee3c d\u00f9ng trong b\u1ea3ng t\u00ednh ti\u1ec1n l\u01b0\u01a1ng<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

M\u1eddi c\u00e1c b\u1ea1n xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel<\/a><\/span><\/p>\n

C\u00e1ch \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong Excel 2003, 2007, 2010, 2013<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Excel<\/a><\/span><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong k\u1ebf to\u00e1n Excel, m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1662],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13284"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13284"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13324"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13284"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}