{"id":10761,"date":"2022-11-04T21:54:57","date_gmt":"2022-11-04T14:54:57","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10761"},"modified":"2022-12-06T13:20:35","modified_gmt":"2022-12-06T06:20:35","slug":"cac-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/","title":{"rendered":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft"},"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;10761&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;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&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;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft&quot;,&quot;width&quot;:&quot;142.5&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: 142.5px;\">\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            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><b><i>C\u00e1c c\u00f4ng th\u1ee9c trong excel<\/i><\/b><i><span style=\"font-weight: 400;\"> kh\u00e1 \u0111a d\u1ea1ng v\u00e0 mang l\u1ea1i nhi\u1ec1u ti\u1ec7n \u00edch tuy\u1ec7t v\u1eddi cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. Kh\u00f4ng nh\u1eefng nhanh ch\u00f3ng m\u00e0 l\u1ea1i c\u00f2n c\u1ef1c k\u1ef3 ch\u00ednh x\u00e1c, c\u00f3 th\u1ec3 t\u00ednh cho nhi\u1ec1u s\u1ed1 li\u1ec7u. Song v\u1edbi s\u1ed1 l\u01b0\u1ee3ng \u0111a d\u1ea1ng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n nh\u01b0 v\u1eady th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng n\u1eafm r\u00f5 t\u1ea5t t\u1ea7n t\u1eadt. Ti\u1ebfp theo \u0111\u00e2y Teky s\u1ebd cung c\u1ea5p nhanh m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n c\u01a1 b\u1ea3n trong excel b\u1ed5 \u00edch v\u00e0 quan tr\u1ecdng hi\u1ec7n nay!<\/span><\/i><\/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\/cac-cong-thuc-trong-excel\/#Cac_cong_thuc_trong_excel_duoc_su_dung_nhieu_hien_nay\" >C\u00e1c c\u00f4ng th\u1ee9c trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u hi\u1ec7n nay\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#Cong_thuc_ham_Sum\" >C\u00f4ng th\u1ee9c h\u00e0m Sum<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#Cong_thuc_ham_Average\" >C\u00f4ng th\u1ee9c h\u00e0m Average<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#Cong_thuc_ham_Count\" >C\u00f4ng th\u1ee9c h\u00e0m Count<\/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\/cac-cong-thuc-trong-excel\/#Cong_thuc_ham_If\" >C\u00f4ng th\u1ee9c h\u00e0m If<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#Cong_thuc_ham_MinMax\" >C\u00f4ng th\u1ee9c h\u00e0m Min\/Max<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#Tong_ket_chung\" >T\u1ed5ng k\u1ebft chung<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_cong_thuc_trong_excel_duoc_su_dung_nhieu_hien_nay\"><\/span><b>C\u00e1c c\u00f4ng th\u1ee9c trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u hi\u1ec7n nay\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c trong excel nh\u01b0: Sum, Average, If,&#8230; s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian th\u1ef1c hi\u1ec7n b\u1ea3ng bi\u1ec3u. T\u1ea1i sao \u01b0? B\u1edfi v\u00ec n\u1ebfu nh\u01b0 t\u1ef1 m\u00ecnh th\u1ef1c hi\u1ec7n h\u1ebft c\u00e1c ph\u00e9p t\u00ednh t\u1ed5ng, tr\u1eeb, nh\u00e2n, chia, trung b\u00ecnh,&#8230;. th\u00ec s\u1ebd r\u1ea5t t\u1ed1n th\u1eddi gian.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u1ecdc excel c\u1ea5p t\u1ed1c: L\u00e0m ch\u1ee7 c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong trong Excel (full 60p)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8EpM0Ysd9Z8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong khi \u0111\u00f3 c\u00f3 nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n nhi\u1ec1u. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb \u0111\u00fang c\u00f4ng th\u1ee9c h\u00e0m, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n nh\u1eadp s\u1ed1 li\u1ec7u v\u00e0o v\u00e0 th\u1ef1c hi\u1ec7n v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Nh\u01b0 v\u1eady l\u00e0 \u0111\u00e3 c\u00f3 \u0111\u00e1p \u00e1n cho h\u00e0ng lo\u1ea1t s\u1ed1 li\u1ec7u m\u00e0 kh\u00f4ng ph\u1ea3i t\u00ednh t\u1eebng c\u00e1i m\u1ed9t. Th\u1eadt \u0111\u01a1n gi\u1ea3n, \u0111\u00fang kh\u00f4ng n\u00e0o? Sau \u0111\u00e2y s\u1ebd l\u00e0 <\/span><b>c\u00e1c c\u00f4ng th\u1ee9c trong excel<\/b><span style=\"font-weight: 400;\"> ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u hi\u1ec7n nay:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Sum\"><\/span><b><i>C\u00f4ng th\u1ee9c h\u00e0m Sum<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m Sum &#8211; \u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng c\u1ee7a c\u00e1c s\u1ed1 li\u1ec7u theo h\u00e0ng d\u1ecdc, h\u00e0ng ngang ho\u1eb7c m\u1ed9t khu v\u1ef1c c\u00e1c \u00f4 t\u00ednh n\u00e0o \u0111\u00f3. H\u00e0m n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian t\u00ednh to\u00e1n, kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. C\u1ee5 th\u1ec3 c\u00e1ch t\u00ednh nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_10762\" aria-describedby=\"caption-attachment-10762\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10762\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-1\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10762\" class=\"wp-caption-text\">Ghi c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m Sum ra<\/figcaption><\/figure>\n<figure id=\"attachment_10763\" aria-describedby=\"caption-attachment-10763\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10763\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-2-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-2\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-2-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-2.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10763\" class=\"wp-caption-text\">B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y sau khi t\u00ednh h\u00e0m Sum \u1edf tr\u00ean<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi quy tr\u00ecnh \u0111\u01a1n gi\u1ea3n nh\u01b0 tr\u00ean, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u00ednh ra k\u1ebft qu\u1ea3 c\u1ee7a t\u1ed5ng s\u1ed1 ti\u1ec1n ph\u1ea3i thu c\u1ee7a 5 ng\u01b0\u1eddi trong b\u1ea3ng s\u1ed1 li\u1ec7u. C\u00f3 th\u1ec3 n\u00f3i l\u00e0 r\u1ea5t nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng so v\u1edbi t\u00ednh th\u1ee7 c\u00f4ng.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Average\"><\/span><b><i>C\u00f4ng th\u1ee9c h\u00e0m Average<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Average ph\u1ed5 bi\u1ebfn trong s\u1ed1 <\/span><span style=\"font-weight: 400;\">c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh trong excel <\/span><span style=\"font-weight: 400;\">hi\u1ec7n nay. C\u1ee5 th\u1ec3 th\u00ec n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh k\u1ebft qu\u1ea3 trung b\u00ecnh c\u1ee7a m\u1ed9t nh\u00f3m k\u1ebft qu\u1ea3 n\u00e0o \u0111\u00f3. V\u1ec1 c\u00f4ng th\u1ee9c th\u00ec t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m Sum. B\u1ea1n c\u0169ng vi\u1ebft t\u00ean h\u00e0m ra r\u1ed3i k\u00e9o r\u00ea chu\u1ed9t ch\u1ecdn kho\u1ea3ng c\u1ea7n t\u00ednh trung b\u00ecnh l\u00e0 \u0111\u01b0\u1ee3c. = Average([kho\u1ea3ng c\u1ea7n t\u00ednh]). V\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_10764\" aria-describedby=\"caption-attachment-10764\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10764\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-3-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-3\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-3-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-3.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10764\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Average \u0111\u1ec3 t\u00ednh trung b\u00ecnh s\u1ed1 ti\u1ec1n ph\u1ea3i thu<\/figcaption><\/figure>\n<figure id=\"attachment_10765\" aria-describedby=\"caption-attachment-10765\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10765\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-4-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-4\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-4-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-4.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10765\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 ph\u00e9p t\u00ednh khi s\u1eed d\u1ee5ng h\u00e0m Average<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_Count\"><\/span><b><i>C\u00f4ng th\u1ee9c h\u00e0m Count<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh c\u00e1c c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n trong excel \u0111\u00e3 nh\u1eafc \u0111\u1ebfn \u1edf tr\u00ean th\u00ec ng\u01b0\u1eddi ta c\u00f2n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m l\u1ea1 h\u01a1n. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m Count l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm v\u1edbi c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 nh\u01b0 sau: =COUNT([Kho\u1ea3ng c\u1ea7n x\u00e9t]).\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u01b0\u1eddng th\u00ec v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh nhi\u1ec1u s\u1ed1 li\u1ec7u, c\u00f3 m\u1ed9t s\u1ed1 \u00f4 b\u1ecb tr\u1ed1ng th\u00ec ng\u01b0\u1eddi ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Count \u0111\u1ec3 \u0111\u1ebfm xem c\u00f3 bao nhi\u00eau \u00f4 c\u00f3 s\u1ed1 li\u1ec7u. V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_10766\" aria-describedby=\"caption-attachment-10766\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10766\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-5-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-5\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-5-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-5.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10766\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Count \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng th\u00e0nh vi\u00ean n\u1ed9p ti\u1ec1n<\/figcaption><\/figure>\n<figure id=\"attachment_10767\" aria-describedby=\"caption-attachment-10767\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10767\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-6-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-6\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-6-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-6.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10767\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi d\u00f9ng h\u00e0m Count s\u1ebd \u0111\u1ebfm s\u1ed1 ng\u01b0\u1eddi tham gia n\u1ed9p ti\u1ec1n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong s\u1ed1<\/span><b> c\u00e1c c\u00e1c c\u00f4ng th\u1ee9c trong excel<\/b><span style=\"font-weight: 400;\"> th\u00ec h\u00e0m Count \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u hi\u1ec7n nay. B\u1edfi v\u00ec kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o s\u1ed1 li\u1ec7u trong b\u1ea3ng t\u00ednh c\u0169ng \u0111\u1ea7y \u0111\u1ee7, thay v\u00e0o \u0111\u00f3 n\u00f3 s\u1ebd b\u1ecb khuy\u1ebft \u1edf m\u1ed9t s\u1ed1 v\u1ecb tr\u00ed n\u00e0o \u0111\u00f3. \u0110\u00f2i h\u1ecfi b\u1ea1n c\u1ea7n d\u00f9ng h\u00e0m Count t\u00ednh to\u00e1n nhanh, tr\u00e1nh vi\u1ec7c \u0111\u1ebfm t\u1ed1n th\u1eddi gian v\u00e0 d\u1ec5 nh\u1ea7m l\u1eabn.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_If\"><\/span><b><i>C\u00f4ng th\u1ee9c h\u00e0m If<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m If t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi <\/span><b>c\u00e1c c\u00f4ng th\u1ee9c trong excel <\/b><span style=\"font-weight: 400;\">kh\u00e1c. \u0110\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i hi\u1ec3u khi s\u1eed d\u1ee5ng. H\u00e0m If t\u1ee9c l\u00e0 h\u00e0m c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p n\u00e0y ho\u1eb7c x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p kia. Mang t\u00ednh ch\u1ea5t l\u1ef1a ch\u1ecdn, \u0111em \u0111\u1ebfn cho b\u1ea1n \u0111\u00e1p \u00e1n ch\u00ednh x\u00e1c h\u01a1n. C\u1ee5 th\u1ec3, c\u00f4ng th\u1ee9c c\u1ee7a n\u00f3 l\u00e0: = IF (logical_test, [value_if_true], [value_if_false]).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: = If(C3&gt;8, \u201c\u0110\u1ea1t\u201d, \u201cKh\u00f4ng \u0111\u1ea1t\u201d). \u1ede \u0111\u00e2y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu k\u1ebft qu\u1ea3 \u00f4 C3 l\u1edbn h\u01a1n 8 th\u00ec k\u1ebft qu\u1ea3 \u1edf \u00f4 \u0111ang x\u00e9t s\u1ebd l\u00e0 \u0111\u1ea1t. C\u00f2n n\u1ebfu C3 &lt; ho\u1eb7c =8 th\u00ec \u00f4 \u0111ang x\u00e9t s\u1ebd l\u00e0 kh\u00f4ng \u0111\u1ea1t.\u00a0<\/span><\/p>\n<figure id=\"attachment_10769\" aria-describedby=\"caption-attachment-10769\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10769\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-7-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-7\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-7-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-7.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10769\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m If \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3 c\u1ee7a Nguy\u1ec5n Mai An<\/figcaption><\/figure>\n<figure id=\"attachment_10770\" aria-describedby=\"caption-attachment-10770\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10770\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-8-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-8\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-8-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-8.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10770\" class=\"wp-caption-text\">K\u00e9o r\u00ea chu\u1ed9t \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c th\u00e0nh vi\u00ean sau<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_MinMax\"><\/span><b><i>C\u00f4ng th\u1ee9c h\u00e0m Min\/Max<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi h\u00e0m Min\/Max th\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng v\u1edbi c\u00fa ph\u00e1p gi\u1ed1ng nhau, c\u1ee5 th\u1ec3: = Min (range) ho\u1eb7c = Max (range). H\u00e0m Min d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, c\u00f2n h\u00e0m Max d\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. V\u00ed d\u1ee5 nh\u01b0 b\u00ean d\u01b0\u1edbi c\u00e1c h\u00ecnh sau:<\/span><\/p>\n<figure id=\"attachment_10771\" aria-describedby=\"caption-attachment-10771\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10771\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-9-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-9\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-9-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-9.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10771\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m max t\u00ecm gi\u00e1 tr\u1ecb \u0111i\u1ec3m s\u1ed1 l\u1edbn nh\u1ea5t<\/figcaption><\/figure>\n<figure id=\"attachment_10772\" aria-describedby=\"caption-attachment-10772\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10772\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-10-400x200.jpg\" alt=\"cac-cong-thuc-trong-excel-10\" width=\"400\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-10-400x200.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-10.jpg 600w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10772\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m min t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb \u0111i\u1ec3m th\u1ea5p nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hai h\u00e0m n\u00e0y c\u00f3 c\u00e1ch s\u1eed d\u1ee5ng kh\u00e1 \u0111\u01a1n gi\u1ea3n, th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb Min, Max hi\u1ec7n nay. B\u1edfi v\u00ec nhanh ch\u00f3ng, ti\u1ec7n l\u1ee3i v\u00e0 r\u1ea5t kh\u00f3 b\u1ecb sai s\u00f3t s\u1ed1 li\u1ec7u. Note l\u1ea1i ngay \u0111\u1ec3 kh\u00f4ng qu\u00ean nh\u00e9!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tong_ket_chung\"><\/span><b>T\u1ed5ng k\u1ebft chung<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 <\/span><span style=\"font-weight: 400;\">c\u00e1c b\u01b0\u1edbc nh\u1eadp c\u00f4ng th\u1ee9c trong excel <\/span><span style=\"font-weight: 400;\">\u0111\u1ed1i v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c nhau. Vi\u1ec7c n\u1eafm r\u00f5 nh\u1eefng h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3m b\u1edbt th\u1eddi gian, thao t\u00e1c th\u1ef1c hi\u1ec7n. \u0110\u1eb7c bi\u1ec7t l\u00e0 k\u1ebft qu\u1ea3 thu l\u1ea1i s\u1ebd c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c cao h\u01a1n, nhanh ch\u00f3ng v\u00e0 \u0111\u00e1ng tin c\u1eady h\u01a1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Mong r\u1eb1ng <\/span><span style=\"font-weight: 400;\">c\u00e1c c\u00f4ng th\u1ee9c trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <\/span><span style=\"font-weight: 400;\">c\u1ee5 th\u1ec3, chi ti\u1ebft tr\u00ean s\u1ebd gi\u00fap b\u1ea1n nhi\u1ec1u h\u01a1n trong vi\u1ec7c th\u1ef1c hi\u1ec7n. H\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c excel \u0111\u1ec3 h\u1ea1n ch\u1ebf nh\u1eefng sai s\u00f3t \u0111\u1ebfn m\u1ee9c t\u1ed1i thi\u1ec3u. \u0110i\u1ec1u n\u00e0y th\u1ef1c s\u1ef1 r\u1ea5t quan tr\u1ecdng khi b\u1ea1n \u0111i l\u00e0m trong m\u00f4i tr\u01b0\u1eddng h\u00e0nh ch\u00ednh v\u0103n ph\u00f2ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00e0 \u0111\u1ed1i v\u1edbi c\u00e1c d\u1ea1ng m\u00e1y t\u00ednh, laptop v\u1edbi d\u1ea1ng excel 2010, 2013,2016, 2018,&#8230; th\u00ec h\u1ea7u nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec1u t\u01b0\u01a1ng t\u1ef1 nhau. V\u00ec th\u1ebf n\u00ean b\u1ea1n c\u00f3 th\u1ec3 y\u00ean t\u00e2m s\u1eed d\u1ee5ng. Ngo\u00e0i ra, c\u00f2n c\u00f3 nhi\u1ec1u h\u00e0m kh\u00e1c nh\u01b0 Autosum, Now, VLOOKUP, Sumif, Array,&#8230; B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam \u0111\u1ec3 ho\u00e0n thi\u1ec7n h\u01a1n v\u1ed1n hi\u1ec3u bi\u1ebft c\u1ee7a ch\u00ednh m\u00ecnh. C\u1ea3m \u01a1n \u0111\u00e3 \u0111\u00f3n \u0111\u1ecdc th\u00f4ng tin v\u1ec1 <\/span><b>c\u00e1c c\u00f4ng th\u1ee9c trong excel <\/b><span style=\"font-weight: 400;\">c\u1ee7a ch\u00fang t\u00f4i t\u1ea1i <a href=\"https:\/\/teky.edu.vn\/\">teky.<\/a><\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1c c\u00f4ng th\u1ee9c trong excel kh\u00e1 \u0111a d\u1ea1ng v\u00e0 mang l\u1ea1i nhi\u1ec1u ti\u1ec7n \u00edch tuy\u1ec7t v\u1eddi cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. Kh\u00f4ng nh\u1eefng nhanh ch\u00f3ng m\u00e0 l\u1ea1i c\u00f2n c\u1ef1c k\u1ef3 ch\u00ednh x\u00e1c, c\u00f3 th\u1ec3 t\u00ednh cho nhi\u1ec1u s\u1ed1 li\u1ec7u. Song v\u1edbi s\u1ed1 l\u01b0\u1ee3ng \u0111a d\u1ea1ng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n nh\u01b0 v\u1eady th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-10761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-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>C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/title>\n<meta name=\"description\" content=\"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng\" \/>\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\/cac-cong-thuc-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-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-11-04T14:54:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T06:20:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\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=\"8 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\/cac-cong-thuc-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft\",\"datePublished\":\"2022-11-04T14:54:57+00:00\",\"dateModified\":\"2022-12-06T06:20:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\"},\"wordCount\":1856,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\",\"name\":\"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg\",\"datePublished\":\"2022-11-04T14:54:57+00:00\",\"dateModified\":\"2022-12-06T06:20:35+00:00\",\"description\":\"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg\",\"width\":600,\"height\":300,\"caption\":\"Ghi c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m Sum ra\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-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\":\"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft\"}]},{\"@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":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft","description":"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng","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\/cac-cong-thuc-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft","og_description":"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng","og_url":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-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-11-04T14:54:57+00:00","article_modified_time":"2022-12-06T06:20:35+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft","datePublished":"2022-11-04T14:54:57+00:00","dateModified":"2022-12-06T06:20:35+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/"},"wordCount":1856,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/","name":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg","datePublished":"2022-11-04T14:54:57+00:00","dateModified":"2022-12-06T06:20:35+00:00","description":"Trong excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n n\u00e0o? H\u00e3y c\u00f9ng v\u1edbi Teky t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c trong excel hi\u1ec7n \u0111ang \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cac-cong-thuc-trong-excel-1.jpg","width":600,"height":300,"caption":"Ghi c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m Sum ra"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-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":"C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft"}]},{"@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\/10761","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=10761"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10761\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10762"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}