{"id":876,"date":"2023-08-26T01:02:24","date_gmt":"2023-08-25T18:02:24","guid":{"rendered":"https:\/\/trannghiait.com\/?p=876"},"modified":"2023-08-26T01:02:25","modified_gmt":"2023-08-25T18:02:25","slug":"huong-dan-chi-tiet-hon-ve-ham-sum-cho-nguoi-moi-bat-dau-dung-excel","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-chi-tiet-hon-ve-ham-sum-cho-nguoi-moi-bat-dau-dung-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u01a1n v\u1ec1 h\u00e0m SUM cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u d\u00f9ng Excel"},"content":{"rendered":"\n<p>H\u00e0m SUM trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng t\u00ednh. Khi s\u1eed d\u1ee5ng h\u00e0m SUM, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c s\u1ed1, c\u00e1c gi\u00e1 tr\u1ecb logic ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng trong m\u1ed9t d\u00e3y. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i s\u00e2u v\u00e0o c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-chi-tiet-hon-ve-ham-sum-cho-nguoi-moi-bat-dau-dung-excel\/#Cu_phap_cua_ham_SUM\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-chi-tiet-hon-ve-ham-sum-cho-nguoi-moi-bat-dau-dung-excel\/#Cach_su_dung_ham_SUM\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_SUM\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(number1, &#91;number2], &#91;number3], ...)<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>number1<\/code>: l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/li>\n\n\n\n<li><code>number2<\/code>, <code>number3<\/code>,\u2026 (t\u00f9y ch\u1ecdn): l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n\n\n\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t d\u00e3y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u1ea1m vi \u00f4. V\u00ed d\u1ee5:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(A1:A10)<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3, <code>A1:A10<\/code> l\u00e0 d\u00e3y c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_SUM\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM, ch\u00fang ta s\u1ebd xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n. H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a th\u00f4ng tin v\u1ec1 doanh thu c\u1ee7a m\u1ed9t c\u00f4ng ty trong 3 qu\u00fd \u0111\u1ea7u n\u0103m nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Qu\u00fd<\/th><th>Doanh thu<\/th><\/tr><\/thead><tbody><tr><td>Q1<\/td><td>1000000<\/td><\/tr><tr><td>Q2<\/td><td>1500000<\/td><\/tr><tr><td>Q3<\/td><td>2000000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu c\u1ee7a c\u00f4ng ty trong 3 qu\u00fd \u0111\u1ea7u n\u0103m, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(B2:B4)<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong d\u00e3y B2 \u0111\u1ebfn B4, t\u1ee9c l\u00e0 1000000 + 1500000 + 2000000 = 4500000.<\/p>\n\n\n\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a c\u00f4ng ty trong qu\u00fd \u0111\u1ea7u ti\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUM nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMIF(A2:A4,\"Q1\",B2:B4)<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3, <code>A2:A4<\/code> l\u00e0 d\u00e3y c\u00e1c \u00f4 ch\u1ee9a th\u00f4ng tin v\u1ec1 qu\u00fd, <code>\"Q1\"<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n t\u00ecm ki\u1ebfm v\u00e0 <code>B2:B4<\/code> l\u00e0 d\u00e3y c\u00e1c \u00f4 ch\u1ee9a th\u00f4ng tin v\u1ec1 doanh thu. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong d\u00e3y B2 \u0111\u1ebfn B4 m\u00e0 t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb <code>\"Q1\"<\/code> trong d\u00e3y A2 \u0111\u1ebfn A4, t\u1ee9c l\u00e0 1000000.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u00e0m SUM trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t d\u00e3y c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t b\u1ea3ng <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/huong-dan-chi-tiet-hon-ve-ham-sum-cho-nguoi-moi-bat-dau-dung-excel\/\" title=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u01a1n v\u1ec1 h\u00e0m SUM cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u d\u00f9ng Excel\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-876","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=876"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/876\/revisions"}],"predecessor-version":[{"id":877,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/876\/revisions\/877"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}