{"id":9882,"date":"2025-01-04T00:17:18","date_gmt":"2025-01-04T00:17:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/huong-dan-nhung-cach-tinh-tong-trong-excel-co-ban-nhat\/"},"modified":"2025-01-04T00:17:18","modified_gmt":"2025-01-04T00:17:18","slug":"huong-dan-nhung-cach-tinh-tong-trong-excel-co-ban-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/huong-dan-nhung-cach-tinh-tong-trong-excel-co-ban-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00e1ch t\u00ednh t\u1ed5ng trong Excel c\u01a1 b\u1ea3n nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>T\u00ednh t\u1ed5ng l\u00e0 m\u1ed9t trong nh\u1eefng thao t\u00e1c c\u01a1 b\u1ea3n nh\u1ea5t v\u00e0 c\u0169ng bi\u1ebfn h\u00f3a mu\u00f4n h\u00ecnh v\u1ea1n tr\u1ea1ng. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch t\u00ednh t\u1ed5ng trong Excel\u00a0th\u01b0\u1eddng g\u1eb7p cho ng\u01b0\u1eddi m\u1edbi \u1edf b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67787e0e176b2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-tong-trong-excel.html#Su_dung_toan_tu_%E2%80%9C%E2%80%9D_de_tinh_tong\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed\u00a0\u201c+\u201d \u0111\u1ec3 t\u00ednh t\u1ed5ng\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed\u00a0\u201c+\u201d \u0111\u1ec3 t\u00ednh t\u1ed5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-tong-trong-excel.html#Su_dung_ham_SUM\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUM\">S\u1eed d\u1ee5ng h\u00e0m SUM<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-tong-trong-excel.html#Su_dung_chuc_nang_AutoSum\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng AutoSum\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng AutoSum<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_%E2%80%9C%E2%80%9D_de_tinh_tong\"><\/span>S\u1eed d\u1ee5ng to\u00e1n t\u1eed\u00a0\u201c+\u201d \u0111\u1ec3 t\u00ednh t\u1ed5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tong-nhanh-trong-excel-nhieu-cach-hay-va-la.html\"><strong>t\u00ednh t\u1ed5ng trong Excel<\/strong><\/a> \u0111\u1ea7u ti\u00ean v\u00e0 c\u0169ng l\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t, \u0111\u00f3 l\u00e0 ta s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201c+\u201d \u0111\u1ed1i v\u1edbi c\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng. C\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=Gi\u00e1 tr\u1ecb 1 + Gi\u00e1 tr\u1ecb 2 + Gi\u00e1 tr\u1ecb 3 + \u2026 + Gi\u00e1 tr\u1ecb n<\/p>\n<\/blockquote>\n<p><em>L\u01b0u \u00fd: C\u00e1c gi\u00e1 tr\u1ecb l\u00e0\u00a0<strong>s\u1ed1 (Number)<\/strong> ho\u1eb7c <strong>tham chi\u1ebfu \u0111\u1ebfn (reference)<\/strong>\u00a0<strong>\u00f4 c\u00f3 gi\u00e1 tr\u1ecb Number.<\/strong><\/em><\/p>\n<p>Minh h\u1ecda c\u00e1ch 1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-22731\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-tong-co-ban-1-1-1024x197-1.png\" width=\"1024\" height=\"197\" title=\"tinh-tong-co-ban-1-1-1024x197-1\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y nh\u1eefng l\u1ed7i sau s\u1ebd xu\u1ea5t hi\u1ec7n khi d\u00f9ng c\u00e1ch tr\u00ean:<\/p>\n<ol>\n<li>L\u1ed7i #VALUE! khi kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n t\u1ea5t c\u1ea3 s\u1ed1 h\u1ea1ng c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1.<\/li>\n<li>L\u1ed7i #N\/A khi c\u1ed9ng v\u1edbi #N\/A<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUM\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\"><strong>H\u00e0m SUM<\/strong><\/a> cho ph\u00e9p t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM l\u00e0:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/EX101_92019-nho-105.gif\" title=\"EX101_92019-nho-105\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>=SUM(gi\u00e1 tr\u1ecb 1, [gi\u00e1 tr\u1ecb 2],\u2026)<\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Gi\u00e1 tr\u1ecb 1, gi\u00e1 tr\u1ecb 2<\/strong>\u2026 l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb s\u1ed1 h\u1ea1ng nh\u1eadp v\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng. M\u1ed7i gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, tham chi\u1ebfu, k\u00ed t\u1ef1\u2026 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng b\u1ecf qua c\u00e1c <strong>gi\u00e1 tr\u1ecb logic<\/strong> ho\u1eb7c <strong>tham chi\u1ebfu k\u00ed t\u1ef1.<\/strong><\/li>\n<li>Nh\u1eefng \u0111\u1ed1i s\u1ed1 trong d\u1ea5u [] l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c.<\/li>\n<\/ul>\n<p>\u0110i\u1ec3m kh\u00e1c bi\u1ec7t v\u1edbi to\u00e1n t\u1eed \u201c+\u201d l\u00e0 g\u00ec, h\u00e3y xem h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-22728\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-tong-co-ban-3-1024x238-1.png\" width=\"1024\" height=\"238\" title=\"tinh-tong-co-ban-3-1024x238-1\"><\/p>\n<p>So s\u00e1nh vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUM v\u1edbi c\u00e1ch 1, c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 s\u1ef1 kh\u00e1c bi\u1ec7t nh\u01b0:<\/p>\n<ul>\n<li>H\u00e0m\u00a0<strong>SUM<\/strong> b\u1ecf qua tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb d\u1ea1ng TEXT.<\/li>\n<li>H\u00e0m\u00a0<strong>SUM<\/strong> c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi name range.<\/li>\n<\/ul>\n<p><em>L\u01b0u \u00fd: C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C6 v\u00e0 E6 \u0111\u1ec1u l\u00e0 t\u1ed5ng c\u1ee7a gi\u00e1 tr\u1ecb \u201cnam\u201d v\u1edbi c\u00e1c tham chi\u1ebfu \u00f4 s\u1ed1, tuy nhi\u00ean \u00f4 C6 s\u1eed d\u1ee5ng tham chi\u1ebfu, \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 m\u1ed9t range, khi t\u00ednh to\u00e1n Excel t\u1ef1 \u0111\u1ed9ng b\u1ecf qua. T\u1ea1i \u00f4 E6, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c nh\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o, \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 m\u1ed9t value, Excel tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_AutoSum\"><\/span>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng AutoSum<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng AutoSum cho ph\u00e9p nhanh ch\u00f3ng \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ec3 t\u00ednh t\u1ed5ng cho m\u1ed9t v\u00f9ng.<\/p>\n<p>\u0110\u1ec3 \u00e1p d\u1ee5ng AutoSum ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-22837\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-tong-co-ban-2-1024x408-2.png\" width=\"1024\" height=\"408\" title=\"tinh-tong-co-ban-2-1024x408-2\"><\/p>\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng v\u00e0 n\u01a1i \u0111\u1eb7t k\u1ebft qu\u1ea3.<\/p>\n<p>B\u01b0\u1edbc 2: Ch\u1ecdn ch\u1ee9c n\u0103ng AutoSum.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-22838\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-tong-co-ban-2-2-1024x269-2.png\" width=\"1024\" height=\"269\" title=\"tinh-tong-co-ban-2-2-1024x269-2\"><\/p>\n<blockquote>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 SUM<\/a><\/p>\n<\/blockquote>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t, hay s\u1eed d\u1ee5ng nh\u1ea5t nh\u1eb1m h\u1ed7 tr\u1ee3 c\u00e1c b\u1ea1n trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u. H\u00e3y d\u00e0nh th\u1eddi gian h\u1ecdc h\u1ecfi v\u00e0 luy\u1ec7n t\u1eadp th\u1eadt nhi\u1ec1u \u0111\u1ec3 c\u1ee7ng c\u1ed1 th\u00eam nh\u00e9. Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/EX101_92019-nho-105.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9883,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9882","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9882","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=9882"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9882\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9883"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}