{"id":10869,"date":"2022-03-07T15:01:46","date_gmt":"2022-03-07T08:01:46","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10869"},"modified":"2022-03-07T15:03:37","modified_gmt":"2022-03-07T08:03:37","slug":"cong-thuc-tinh-tong-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/","title":{"rendered":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10869&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>\n<p><i><span style=\"font-weight: 400\">Xem ngay <\/span><\/i><b><i>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel<\/i><\/b><i><span style=\"font-weight: 400\"> \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c <\/span><b>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel<\/b><span style=\"font-weight: 400\">? B\u1ea1n l\u00e0 ng\u01b0\u1eddi r\u1ea5t \u201cg\u00e0\u201d trong vi\u1ec7c t\u00ednh to\u00e1n? \u0110i\u1ec1u n\u00e0y khi\u1ebfn cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n b\u1ecb \u1ea3nh h\u01b0\u1edfng kh\u00f4ng \u00edt. \u0110\u1eb7c bi\u1ec7t l\u00e0 b\u1ea1n s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian cho vi\u1ec7c t\u00ednh th\u1ee7 c\u00f4ng. N\u1ebfu b\u1ea1n \u0111ang g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 n\u00e0y th\u00ec \u0111\u1eebng lo l\u1eafng! V\u1edbi 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng chu\u1ea9n x\u00e1c trong b\u1ea3ng Excel m\u00e0 Teky s\u1eafp chia s\u1ebb d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng gi\u1ea3i quy\u1ebft b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch nhanh nh\u1ea5t.\u00a0\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/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:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Cong_thuc_tinh_tong_trong_mot_cot_Excel\" >C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong m\u1ed9t c\u1ed9t Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Su_dung_AutoSum_de_thuc_hien_cach_tinh_tong_cot_trong_Excel\" >S\u1eed d\u1ee5ng AutoSum \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch t\u00ednh t\u1ed5ng c\u1ed9t trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Dung_AutoSum_de_tinh_tong_hang_trong_Excel\" >D\u00f9ng AutoSum \u0111\u1ec3 t\u00ednh t\u1ed5ng h\u00e0ng trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_1\" >B\u01b0\u1edbc 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_2\" >B\u01b0\u1edbc 2<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Huong_dan_cach_dat_cong_thuc_tinh_tong_trong_Excel_bang_ham_SUM_chuan_xac\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel b\u1eb1ng h\u00e0m SUM chu\u1ea9n x\u00e1c<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_1-2\" >B\u01b0\u1edbc 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_2-2\" >B\u01b0\u1edbc 2<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Cach_tinh_tong_trong_Excel_nhanh_bang_Subtotal\" >C\u00e1ch t\u00ednh t\u1ed5ng trong Excel nhanh b\u1eb1ng Subtotal<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Cong_thuc_tinh_tong_dung_trong_Excel_bang_chuyen_doi_du_lieu\" >C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng d\u00f9ng trong Excel b\u1eb1ng chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_1-3\" >B\u01b0\u1edbc 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Buoc_2-3\" >B\u01b0\u1edbc 2<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Cach_tinh_tong_tai_cot_Excel_chi_voi_to_hop_phim_Alt%E2%80%9D\" >C\u00e1ch t\u00ednh t\u1ed5ng t\u1ea1i c\u1ed9t Excel ch\u1ec9 v\u1edbi t\u1ed5 h\u1ee3p ph\u00edm Alt+\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#Cong_thuc_tinh_tong_trong_bang_tinh_Excel_dua_tren_tieu_chi_chon\" >C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong b\u1ea3ng t\u00ednh Excel d\u1ef1a tr\u00ean ti\u00eau ch\u00ed ch\u1ecdn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tong_trong_mot_cot_Excel\"><\/span><b>C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong m\u1ed9t c\u1ed9t Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 \u00e1p d\u1ee5ng <\/span>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong b\u1ea3ng t\u00ednh Excel<span style=\"font-weight: 400\"> cho 1 c\u1ed9t kh\u00f4ng ph\u1ea3i l\u00e0 chuy\u1ec7n qu\u00e1 kh\u00f3 kh\u0103n. B\u1ea1n \u0111\u1ea7u ti\u00ean c\u1ea7n m\u1edf file Excel ra v\u00e0 l\u1ef1a ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. Sau \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p chu\u1ed9t. Th\u00ec h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u1ed5ng ngay b\u00ean d\u01b0\u1edbi thanh tr\u1ea1ng th\u00e1i.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10888\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-1.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"399\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-1-400x266.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_AutoSum_de_thuc_hien_cach_tinh_tong_cot_trong_Excel\"><\/span><b>S\u1eed d\u1ee5ng AutoSum \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch t\u00ednh t\u1ed5ng c\u1ed9t trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng <\/span><b><i>c\u00e1ch t\u00ednh t\u1ed5ng trong Excel <\/i><\/b><span style=\"font-weight: 400\">n\u00e0y. B\u1ea1n c\u1ea7n ti\u1ebfn h\u00e0nh m\u1edf t\u00e0i li\u1ec7u Excel mu\u1ed1n t\u00ednh t\u1ed5ng. Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn \u201cAutoSum\u201d. L\u00fac n\u00e0y, m\u00e0n h\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb h\u00e0m t\u00ednh t\u1ed5ng.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10889\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-2.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"314\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-2-400x209.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n n\u00fat \u201cEnter\u201d l\u00e0 k\u1ebft qu\u1ea3 t\u1ed5ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10890\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-3.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"347\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-3-400x231.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dung_AutoSum_de_tinh_tong_hang_trong_Excel\"><\/span><b>D\u00f9ng AutoSum \u0111\u1ec3 t\u00ednh t\u1ed5ng h\u00e0ng trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi c\u1ea7n t\u00ednh t\u1ed5ng theo h\u00e0ng ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? C\u00f3 m\u1ed9t <\/span><b>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng <\/b><span style=\"font-weight: 400\">\u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi hi\u1ec7n \u0111ang b\u1ecf qua. \u0110\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng AutoSum. Kh\u00e1c v\u1edbi c\u00e1ch t\u00ednh t\u1ed5ng theo c\u1ed9t n\u00f3i tr\u00ean, c\u00e1ch t\u00ednh t\u1ed5ng theo h\u00e0m v\u1edbi AutoSum s\u1ebd c\u1ea7n ti\u1ebfn h\u00e0nh v\u1edbi c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span><b><i>B\u01b0\u1edbc 1<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u1ea7n b\u00f4i \u0111en nhi\u1ec1u c\u1ed9t c\u1ea7n t\u00ednh t\u1ed5ng. B\u01b0\u1edbc n\u00e0y s\u1ebd gi\u00fap ph\u1ea7n m\u1ec1m c\u00f3 th\u1ec3 t\u00ednh ra t\u1ed5ng c\u1ee7a t\u1eebng c\u1ed9t theo h\u00e0ng t\u1ed5ng ph\u00eda d\u01b0\u1edbi.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10902\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-15.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"399\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-15-400x266.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-15-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span><b><i>B\u01b0\u1edbc 2<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b><i>C\u00e1ch t\u00ednh t\u1ed5ng trong Excel nhanh<\/i><\/b><span style=\"font-weight: 400\"> nh\u1ea5t cho h\u00e0ng ch\u00ednh l\u00e0 b\u1ea1n chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn tab Home v\u00e0 ch\u1ecdn m\u1ee5c \u201cEditing Group\u201d. B\u1ea1n ch\u1ecdn ti\u1ebfp m\u1ee5c \u201cAutoSum\u201d.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10903\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-16.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"144\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-16-400x96.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng m\u00e0 h\u1ec7 th\u1ed1ng t\u00ednh s\u1ebd l\u00e0 t\u1ed5ng c\u1ee7a t\u1eebng c\u1ed9t v\u00e0 b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c 1 h\u00e0ng t\u1ed5ng ch\u00ednh x\u00e1c nh\u01b0 h\u00ecnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10904\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"399\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17-400x266.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_dat_cong_thuc_tinh_tong_trong_Excel_bang_ham_SUM_chuan_xac\"><\/span><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel b\u1eb1ng h\u00e0m SUM chu\u1ea9n x\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u00f3 m\u1ed9t <\/span>c\u00e1ch \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng d\u00f9ng trong Excel<span style=\"font-weight: 400\"> m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi th\u01b0\u1eddng b\u1ecf qua khi mu\u1ed1n t\u00ednh t\u1ed5ng. \u0110\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUM.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1-2\"><\/span><b><i>B\u01b0\u1edbc 1<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u1ea7n ti\u1ebfn h\u00e0nh m\u1edf file Excel c\u1ea7n t\u00ednh t\u1ed5ng v\u00e0 nh\u1eadp h\u00e0m SUM. V\u00ed d\u1ee5, v\u1ecb tr\u00ed b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 t\u1eeb v\u00f9ng d\u1eef li\u1ec7u C2 \u0111\u1ebfn C11 th\u00ec b\u1ea1n s\u1ebd\u00a0 nh\u1eadp h\u00e0m \u201c=SUM(C2:C11).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10891\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-4.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"314\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-4-400x209.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2-2\"><\/span><b><i>B\u01b0\u1edbc 2<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n n\u00fat \u201cEnter\u201d \u0111\u1ec3 h\u1ec7 th\u1ed1ng hi\u1ec7n ra k\u1ebft qu\u1ea3 t\u1ed5ng cho v\u00f9ng d\u1eef li\u1ec7um\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n l\u00e0 xong. \u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng trong <\/span><b><i>c\u00e1ch t\u00ednh t\u1ed5ng ti\u1ec1n trong Excel<\/i><\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10892\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-5.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"347\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-5-400x231.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_tong_trong_Excel_nhanh_bang_Subtotal\"><\/span><b>C\u00e1ch t\u00ednh t\u1ed5ng trong Excel nhanh b\u1eb1ng Subtotal<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng Subtotal \u0111\u1ec3 th\u1ef1c hi\u1ec7n <\/span><b><i>c\u00e1ch t\u00ednh t\u1ed5ng trong Excel nhanh<\/i><\/b><span style=\"font-weight: 400\"> v\u00e0 \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c. T\u1ea5t nhi\u00ean, mu\u1ed1n t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng c\u1ee7a file th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i m\u1edf file l\u00ean tr\u01b0\u1edbc. Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn m\u1ed9t v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 v\u00e0 ch\u1ecdn ti\u1ebfp v\u00e0o m\u1ee5c \u201cData\u201d. B\u1ea1n ti\u1ebfp t\u1ee5c chuy\u1ec3n ch\u1ecdn m\u1ee5c \u201cFilter\u201d. C\u00e1c m\u1ee5c n\u00e0y \u0111\u1ec1u n\u1eb1m \u1edf thanh c\u00f4ng c\u1ee5 b\u00ean tr\u00ean.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10893\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-6.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"414\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-6-400x276.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, b\u1ea1n ch\u1ecdn v\u00e0o c\u1ed9t mu\u1ed1n l\u1ecdc v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh tam gi\u00e1c l\u1ed9n ng\u01b0\u1ee3c b\u00ean g\u00f3c \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t. B\u1ea1n ti\u1ebfp t\u1ee5c t\u00edch ch\u1ecdn c\u00e1c m\u1ee5c c\u1ea7n t\u00ednh t\u1ed5ng. K\u1ebft th\u00fac b\u01b0\u1edbc n\u00e0y b\u1eb1ng c\u00e1ch nh\u1ea5n OK.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10894\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-7.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"393\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-7-400x262.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c <\/span><b>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng \u1edf Excel<\/b><span style=\"font-weight: 400\"> ch\u00ednh x\u00e1c th\u00ec b\u1ea1n c\u1ea7n ti\u1ebfn h\u00e0nh th\u00eam b\u01b0\u1edbc ch\u1ecdn m\u1ee5c \u201cAutoSum\u201d. Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n Enter \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng c\u1ee7a c\u00e1c m\u1ee5c \u0111\u00e3 l\u1ecdc ph\u00eda tr\u00ean.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10895\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-8.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"287\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-8-400x191.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh tr\u00ean l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c m\u1ee5c \u0111\u01b0\u1ee3c l\u1ecdc.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10896 aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-9.jpg\" alt=\"\" width=\"600\" height=\"365\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-9-400x243.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tong_dung_trong_Excel_bang_chuyen_doi_du_lieu\"><\/span><b>C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng d\u00f9ng trong Excel b\u1eb1ng chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n <\/span><b><i>c\u00e1ch t\u00ednh \u0111i\u1ec3m t\u1ed5ng k\u1ebft trong Excel<\/i><\/b><span style=\"font-weight: 400\"> nh\u01b0ng kh\u00f4ng bi\u1ebft ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? V\u1eady b\u1ea1n h\u00e3y \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng b\u1eb1ng c\u00e1ch chuy\u1ec3n \u0111\u1ed5i c\u00e1c d\u1eef li\u1ec7u trong b\u1ea3ng Excel \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y. Vi\u1ec7c ho\u00e0n t\u1ea5t k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng s\u1ebd d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1-3\"><\/span><b><i>B\u01b0\u1edbc 1<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n m\u1ed5 file Excel c\u1ea7n t\u00ednh t\u1ed5ng v\u00e0 ti\u1ebfn h\u00e0nh b\u00f4i \u0111en b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh. Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n ch\u1ecdn t\u1ed5 h\u1ee3p ph\u00edm Ctr+OK.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10897 aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-10.jpg\" alt=\"\" width=\"600\" height=\"339\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-10-400x226.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2-3\"><\/span><b><i>B\u01b0\u1edbc 2<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong <\/span>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng d\u00f9ng trong Excel<span style=\"font-weight: 400\"> n\u00e0y, \u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i th\u1ef1c hi\u1ec7n b\u01b0\u1edbc click ch\u1ecdn m\u1ee5c \u201cTotal row\u201d. L\u00fac n\u00e0y, ph\u1ea7n m\u1ec1m Excel s\u1ebd th\u00eam 1 h\u00e0ng v\u00e0 t\u00ednh t\u1ed5ng t\u1ef1 \u0111\u1ed9ng gi\u00fap b\u1ea1n.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10898 aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-11.jpg\" alt=\"\" width=\"600\" height=\"319\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-11-400x213.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_tong_tai_cot_Excel_chi_voi_to_hop_phim_Alt%E2%80%9D\"><\/span><b>C\u00e1ch t\u00ednh t\u1ed5ng t\u1ea1i c\u1ed9t Excel ch\u1ec9 v\u1edbi t\u1ed5 h\u1ee3p ph\u00edm Alt<\/b><span style=\"font-weight: 400\">+<\/span><b>\u201d<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu ch\u01b0a bi\u1ebft <\/span><b>c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/b><span style=\"font-weight: 400\"> th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch t\u00ednh \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y. \u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd ch\u1ecdn \u00f4 trong b\u1ea3ng m\u00e0 m\u00ecnh mu\u1ed1n hi\u1ec3n th\u1ecb t\u1ed5ng.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10899 aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-12.jpg\" alt=\"\" width=\"600\" height=\"399\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-12-400x266.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-12-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, b\u1ea1n nh\u1ea5n c\u00f9ng l\u00fac t\u1ed5 h\u1ee3p ph\u00edm \u201cAlt v\u00e0 +\u201d. L\u00fac n\u00e0y, t\u1ea1i v\u1ecb tr\u00ed \u00f4 m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn \u1edf tr\u00ean s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng \u0111\u1ed1i v\u1edbi v\u00f9ng d\u1eef li\u1ec7u tr\u00ean n\u00f3.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10900 aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-13.jpg\" alt=\"\" width=\"600\" height=\"399\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-13-400x266.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-13-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 k\u1ebft th\u00fac c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n v\u00e0o n\u00fat Enter s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng nhanh g\u1ecdn, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10901\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-14.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"350\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-14-400x233.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tong_trong_bang_tinh_Excel_dua_tren_tieu_chi_chon\"><\/span><b>C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong b\u1ea3ng t\u00ednh Excel d\u1ef1a tr\u00ean ti\u00eau ch\u00ed ch\u1ecdn<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ch\u1ec9 mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong c\u1ed9t th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 <\/span>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng d\u00f9ng trong <a href=\"https:\/\/www.microsoft.com\/\">Excel<\/a> <span style=\"font-weight: 400\">d\u1ef1a tr\u00ean ti\u00eau ch\u00ed m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng. Ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c SUMIFS hay SUMIF l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c t\u1ed5ng nhanh v\u00e0 chu\u1ea9n x\u00e1c nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, trong b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n ch\u1ec9 mu\u1ed1n t\u00ecm nh\u1eefng k\u1ebft qu\u1ea3 c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb 500 tr\u1edf l\u00ean. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><b>(=SUMIF(B2:B11,\u201d&gt;500\u2033,B2:B11<\/b><span style=\"font-weight: 400\">).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10905\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-18.jpg\" alt=\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\" width=\"600\" height=\"383\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-18.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-18-400x255.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi c\u00e1ch t\u00ednh t\u1ed5ng n\u00e0y, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u0111\u1ec3 \u0111i\u1ec1u ki\u1ec7n l\u1ecdc \u0111\u1ec3 t\u00ednh t\u1ed5ng l\u00e0 s\u1ed1 hay l\u00e0 ch\u1eef \u0111\u1ec1u \u0111\u01b0\u1ee3c. C\u00e1ch n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong nhu c\u1ea7u <\/span><b><i>c\u00e1ch t\u00ednh \u0111i\u1ec3m t\u1ed5ng k\u1ebft trong Excel <\/i><\/b><span style=\"font-weight: 400\">hay t\u00ednh ti\u1ec1n ho\u1eb7c l\u1ecdc th\u00f4ng tin nh\u00e2n s\u1ef1&#8230;<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y, Teky \u0111\u00e3 gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c <\/span>c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng \u1edf Excel<span style=\"font-weight: 400\"> chu\u1ea9n x\u00e1c v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Hy v\u1ecdng, chia s\u1ebb c\u1ee7a ch\u00fang t\u00f4i s\u1ebd gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean hi\u1ec7u qu\u1ea3 v\u00e0 thu\u1eadn l\u1ee3i h\u01a1n. \u0110\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 th\u00f4ng tin hay t\u01b0 v\u1ea5n th\u00eam ki\u1ebfn th\u1ee9c v\u1ec1 k\u1ebf to\u00e1n. B\u1ea1n h\u00e3y \u0111\u1ebfn v\u1edbi Teky qua \u0111\u1ecba ch\u1ec9 <a href=\"https:\/\/teky.edu.vn\/\">Teky.edu.vn<\/a>. Ch\u00fang t\u00f4i cam k\u1ebft h\u1ed7 tr\u1ee3 b\u1ea1n 24\/7 v\u1edbi s\u1ef1 t\u1eadn t\u00e2m, vui v\u1ebb v\u00e0 chuy\u00ean nghi\u1ec7p nh\u1ea5t.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel? B\u1ea1n l\u00e0 ng\u01b0\u1eddi r\u1ea5t \u201cg\u00e0\u201d trong vi\u1ec7c t\u00ednh to\u00e1n? \u0110i\u1ec1u n\u00e0y khi\u1ebfn cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n b\u1ecb \u1ea3nh h\u01b0\u1edfng kh\u00f4ng \u00edt. \u0110\u1eb7c &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10904,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[183,184],"class_list":["post-10869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-cong-thuc-tinh-tong-trong-excel","tag-thu-thuat-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-07T08:01:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-07T08:03:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"399\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2022-03-07T08:01:46+00:00\",\"dateModified\":\"2022-03-07T08:03:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\"},\"wordCount\":1904,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\",\"keywords\":[\"c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel\",\"th\u1ee7 thu\u1eadt excel\"],\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\",\"name\":\"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\",\"datePublished\":\"2022-03-07T08:01:46+00:00\",\"dateModified\":\"2022-03-07T08:03:37+00:00\",\"description\":\"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg\",\"width\":600,\"height\":399,\"caption\":\"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c","og_url":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-07T08:01:46+00:00","article_modified_time":"2022-03-07T08:03:37+00:00","og_image":[{"width":600,"height":399,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2022-03-07T08:01:46+00:00","dateModified":"2022-03-07T08:03:37+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/"},"wordCount":1904,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg","keywords":["c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel","th\u1ee7 thu\u1eadt excel"],"articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/","name":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg","datePublished":"2022-03-07T08:01:46+00:00","dateModified":"2022-03-07T08:03:37+00:00","description":"Xem ngay c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c nh\u1ea5t. B\u1ea1n kh\u00f4ng n\u1eafm \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cong-thu-tinh-tong-trong-excel-17.jpg","width":600,"height":399,"caption":"C\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cong-thuc-tinh-tong-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"\u201cB\u1ecf t\u00fai\u201d ngay 8 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10869"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10904"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}