{"id":12323,"date":"2025-01-15T08:06:51","date_gmt":"2025-01-15T08:06:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-cach-tinh-tong-trong-excel-nhieu-cach-la-va-hay\/"},"modified":"2025-01-15T08:06:51","modified_gmt":"2025-01-15T08:06:51","slug":"cac-cach-tinh-tong-trong-excel-nhieu-cach-la-va-hay","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-cach-tinh-tong-trong-excel-nhieu-cach-la-va-hay\/","title":{"rendered":"C\u00e1c c\u00e1ch t\u00ednh t\u1ed5ng trong Excel, nhi\u1ec1u c\u00e1ch l\u1ea1 v\u00e0 hay"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Theo<a href=\"http:\/\/blog.ezworkapp.com\"><strong> H\u1ecdc Excel Online<\/strong><\/a> th\u00ec ch\u00fang ta c\u00f3 t\u1edbi <em><strong>4 c\u00e1ch t\u00ednh t\u1ed5ng<\/strong><\/em> trong excel, n\u1ebfu b\u1ea1n ch\u01b0a h\u00ecnh d\u00f9ng ra l\u00e0 nh\u1eefng c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0o h\u00e3y theo d\u00f5i ngay sau \u0111\u00e2y nh\u00e9.<\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 1. C\u00e1ch t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM\u00a0<\/strong><\/p>\n<p><em><strong>H\u00e0m SUM l\u00e0 c\u00e1ch\u00a0t\u00ednh t\u1ed5ng<\/strong><\/em> c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a excel, s\u1eed d\u1ee5ng t\u00ednh v\u1edbi s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb nhi\u1ec1u, kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c v\u1edbi c\u00e1c tr\u01b0\u1eddng h\u1ee3p ph\u00e2n t\u00e1ch gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n (nh\u01b0 t\u00ednh t\u1ed5ng th\u1ed1ng k\u00ea b\u00e1n h\u00e0ng, t\u00ednh l\u01b0\u01a1ng nh\u00e2n vi\u00ean theo c\u1ea5p b\u1eadc,\u2026) C\u00f3 3 ph\u01b0\u01a1ng th\u1ee9c th\u1ef1c hi\u1ec7n c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y:<\/p>\n<ul>\n<li>C\u00e1ch 1: <em><strong>=SUM(gi\u00e1 tr\u1ecb th\u1ee9 1, gi\u00e1 tr\u1ecb th\u1ee9 2, gi\u00e1 tr\u1ecb th\u1ee9 3,\u2026)<\/strong><\/em><\/li>\n<li>C\u00e1ch 2: <em><strong>=SUM(v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb th\u1ee9 1, v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb th\u1ee9 2, v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb th\u1ee9 3,\u2026)<\/strong><\/em><\/li>\n<li>C\u00e1ch 3: <em><strong>=SUM(v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb th\u1ee9 1: v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb th\u1ee9 n)<\/strong><\/em><\/li>\n<\/ul>\n<p>Quan s\u00e1t v\u00ed d\u1ee5 sau \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y h\u01a1n.<\/p>\n<figure id=\"attachment_3407\" aria-describedby=\"caption-attachment-3407\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3407\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-36.png\" width=\"600\" height=\"292\" title=\"1-36\"><figcaption id=\"caption-attachment-3407\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p><em><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong><\/em><strong>2. C\u00e1ch t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUMIF v\u00e0 SUMIFS<\/strong><\/p>\n<p>T\u1eeb ch\u00ednh nhu c\u1ea7u thi\u1ebft y\u1ebfu trong th\u1ed1ng k\u00ea l\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n \u1edf c\u00e1c khu v\u1ef1c kh\u00e1c nhau, t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM \u0111\u01b0\u1ee3c n\u00e2ng c\u1ea5p v\u00e0 excel c\u00f3 th\u00eam c\u00e1ch t\u00ednh t\u1ed5ng ph\u1ee9c t\u1ea1p h\u01a1n l\u00e0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong> h\u00e0m SUMIF<\/strong><\/a> v\u00e0 h\u00e0m SUMIFS.<\/p>\n<p>C\u00fa ph\u00e1p c\u00e1ch t\u00ednh t\u1ed5ng c\u1ee7a h\u00e0m SUMIF nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-76.gif\" title=\"vba101_92019-nho-76\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-383.gif\" title=\"ex101_92019-nho-383\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em><strong>=SUMIF(&lt;v\u00f9ng d\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n&gt;, &lt;\u0111i\u1ec1u ki\u1ec7n&gt;, &lt;v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng&gt;)<\/strong><\/em><\/p>\n<p>C\u00fa ph\u00e1p c\u00e1ch t\u00ednh t\u1ed5ng c\u1ee7a h\u00e0m SUMIFS nh\u01b0 sau:<\/p>\n<p><em><strong>=SUMIFS(&lt;v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng&gt;, &lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1&gt;, &lt; \u0111i\u1ec1u ki\u1ec7n 1&gt;, &lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2&gt;, &lt; \u0111i\u1ec1u ki\u1ec7n 2&gt;, \u2026)<\/strong><\/em><\/p>\n<p>Hai h\u00e0m n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1ea1i \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\"><strong> h\u00e0m SUMIF v\u00e0 SUMIFS<\/strong><\/a><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3. C\u00e1ch t\u00ednh t\u1ed5ng ch\u1ec9 s\u1eed d\u1ee5ng chu\u1ed9t<\/strong><\/p>\n<p>Trong c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y ch\u00fang ta t\u1eadn d\u1ee5ng c\u00f4ng c\u1ee5 AUTOSUM c\u1ee7a excel, c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<p><em><strong>B\u01b0\u1edbc 1:<\/strong><\/em> Ch\u1ecdn \u00f4 cu\u1ed1i c\u1ee7a c\u1ed9t gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng<\/p>\n<figure id=\"attachment_3408\" aria-describedby=\"caption-attachment-3408\" style=\"width: 604px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3408\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2-4.png\" width=\"604\" height=\"346\" title=\"2-4\"><figcaption id=\"caption-attachment-3408\" class=\"wp-caption-text\">Ch\u1ecdn \u00f4 cu\u1ed1i c\u1ee7a c\u1ed9t ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb mu\u1ed1n t\u00ednh t\u1ed5ng<\/figcaption><\/figure>\n<p><em><strong>B\u01b0\u1edbc 2:<\/strong><\/em> Ch\u1ecdn Home\/ AutoSum<\/p>\n<figure id=\"attachment_3409\" aria-describedby=\"caption-attachment-3409\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3409\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/3-3.png\" width=\"600\" height=\"112\" title=\"3-3\"><figcaption id=\"caption-attachment-3409\" class=\"wp-caption-text\">V\u1ecb tr\u00ed c\u00f4ng c\u1ee5 AutoSum<\/figcaption><\/figure>\n<p><em><strong>B\u01b0\u1edbc 3:<\/strong><\/em> V\u00f9ng \u0111\u01b0\u1eddng c\u1eaft s\u1ebd hi\u1ec7n ra ngay sau khi click c\u00f4ng c\u1ee5 AutoSum, n\u1ebfu b\u1ea1n \u0111\u1ed3ng \u00fd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong v\u00f9ng c\u1eaft n\u00e0y ch\u1ecdn th\u00ec Enter, n\u1ebfu b\u1ea1n ch\u01b0a \u0111\u1ed3ng \u00fd v\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y h\u00e3y d\u00f9ng chu\u1ed9t l\u1ef1a ch\u1ecdn \u0111\u1ec3 thay \u0111\u1ed5i v\u00f9ng c\u1eaft ch\u1ecdn r\u1ed3i Enter.<\/p>\n<p>\u00a0<\/p>\n<figure id=\"attachment_3410\" aria-describedby=\"caption-attachment-3410\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3410\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/4-2.png\" width=\"600\" height=\"296\" title=\"4-2\"><figcaption id=\"caption-attachment-3410\" class=\"wp-caption-text\">V\u00f9ng \u0111\u01b0\u1eddng c\u1eaft bao quanh l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng (b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i v\u00f9ng c\u1eaft n\u00e0y)<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p><em><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4. C\u00e1ch t\u00ednh t\u1ed5ng b\u1eb1ng ph\u00edm t\u1eaft<\/strong><\/em><\/p>\n<p>Th\u00e0nh th\u1ea1o c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n tr\u00ean Excel l\u00e0 l\u1ee3i th\u1ebf \u00edt ai bi\u1ebft, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u0169ng v\u1eady. C\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u201cALT\u201d \u00a0v\u00e0 \u201c+\u201d , \u0111\u00e2y l\u00e0 ph\u00edm t\u1eaft cho c\u00f4ng c\u1ee5 AutoSum \u1edf c\u00e1ch t\u00ednh t\u1ed5ng th\u1ee9 3 ph\u00eda tr\u00ean. Do \u0111\u00f3 c\u00e1c b\u01b0\u1edbc l\u00e0m ta thao t\u00e1c t\u01b0\u01a1ng t\u1ef1.<\/p>\n<figure id=\"attachment_3411\" aria-describedby=\"caption-attachment-3411\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3411\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/5-3.png\" width=\"600\" height=\"340\" title=\"5-3\"><figcaption id=\"caption-attachment-3411\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh t\u1ed5ng b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft \u201cALT\u201d v\u00e0 \u201c+\u201d<\/figcaption><\/figure>\n<p><em><strong>B\u01b0\u1edbc 1:<\/strong><\/em> Ch\u1ecdn \u00f4 cu\u1ed1i c\u1ee7a c\u1ed9t gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng<\/p>\n<p><em><strong>B\u01b0\u1edbc 2:\u00a0<\/strong><\/em>D\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft\u00a0\u201cALT\u201d \u00a0v\u00e0 \u201c+\u201d<\/p>\n<p><em><strong>B\u01b0\u1edbc 3:<\/strong><\/em> \u01afng \u00fd v\u1edbi v\u00f9ng \u0111\u01b0\u1eddng c\u1eaft \u0111\u00e3 bao quanh \u0111\u00fang c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng, nh\u1ea5n enter.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-76.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12323","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\/12323","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=12323"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12323\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12324"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}