{"id":12497,"date":"2025-01-15T09:04:59","date_gmt":"2025-01-15T09:04:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-tong-cua-cung-1-vung-tren-tat-ca-bang-tinh\/"},"modified":"2025-01-15T09:04:59","modified_gmt":"2025-01-15T09:04:59","slug":"tinh-tong-cua-cung-1-vung-tren-tat-ca-bang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-tong-cua-cung-1-vung-tren-tat-ca-bang-tinh\/","title":{"rendered":"T\u00ednh t\u1ed5ng c\u1ee7a c\u00f9ng 1 v\u00f9ng tr\u00ean t\u1ea5t c\u1ea3 b\u1ea3ng t\u00ednh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i n\u00e0y s\u1ebd l\u00e0 1 th\u1ee7 thu\u1eadn si\u00eau ng\u1eafn m\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc thu\u1ed9c ngay l\u1eadp t\u1ee9c: t\u00ednh t\u1ed5ng c\u1ee7a c\u00f9ng 1 v\u00f9ng tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh trong 1 file Excel.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau: 1 file excel c\u1ee7a b\u1ea1n c\u00f3 5 Sheets, tr\u00ean c\u1ea3 5 Sheets n\u00e0y v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng t\u1eeb A1:A10. \u1ede 1 Sheet s\u1ed1 6 d\u00f9ng l\u00e0m sheet t\u1ed5ng k\u1ebft ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUM(\u2018*\u2019!A1:A10)<\/strong><\/p>\n<\/blockquote>\n<p>Sau khi nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm, n\u1ebfu b\u1ea1n \u0111\u1ec3 \u00fd tr\u00ean thanh c\u00f4ng th\u1ee9c, s\u1ebd th\u1ea5y c\u00f4ng th\u1ee9c tr\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c Excel t\u1ef1 vi\u1ebft th\u00e0nh:<\/p>\n<blockquote>\n<p><strong>=SUM(Sheet1:Sheet5!A1:A10)<\/strong><\/p>\n<\/blockquote>\n<p>N\u1ebfu t\u00ean sheet c\u1ee7a b\u1ea1n c\u00f3 d\u1ea5u c\u00e1ch, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd tr\u1edf th\u00e0nh:<\/p>\n<blockquote>\n<p><strong>=SUM(\u2018Sheet 1:Sheet 5\u2019!A1:A10)<\/strong><\/p>\n<\/blockquote>\n<p>N\u1ebfu v\u1eabn ch\u01b0a h\u00ecnh dung ra \u0111\u01b0\u1ee3c, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i video sau \u0111\u00e2y:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/72wUuaC_mso\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><strong>C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn m\u1ed9t kho\u00e1 h\u1ecdc Excel \u0111\u1ea7y \u0111\u1ee7 v\u00e0 ch\u1ea5t l\u01b0\u1ee3ng nh\u1ea5t t\u1eeb tr\u01b0\u1edbc \u0111\u1ebfn nay:<\/strong><\/p>\n<p><a href=\"https:\/\/www.hocexcel.online\/ex101\">https:\/\/www.hocexcel.online\/ex101<\/a><\/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-405.gif\" title=\"ex101_92019-nho-405\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-405.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12497","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\/12497","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=12497"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12498"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}