{"id":11530,"date":"2022-03-14T12:28:08","date_gmt":"2022-03-14T05:28:08","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11530"},"modified":"2022-03-20T22:42:17","modified_gmt":"2022-03-20T15:42:17","slug":"nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/","title":{"rendered":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0"},"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;11530&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;4&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 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0&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 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Sau qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng \u1edf Excel th\u00ec \u0111\u00f4i l\u00fac b\u1ea1n c\u0169ng c\u1ea7n x\u1eed l\u00ed v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng. B\u1ea1n s\u1ebd c\u00f3 nh\u1eefng l\u00fac th\u1ef1c s\u1ef1 c\u1ea7n th\u1ed1ng k\u00ea h\u1ebft l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. \u0110\u00f3 l\u00e0 l\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c<\/span><\/span><\/span><a href=\"https:\/\/teky.edu.vn\/\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> h\u00e0m th\u1ed1ng k\u1ebf trong excel<\/span><\/span><\/b><\/a> <span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">trong excel <\/span><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0111\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m th\u1ed1ng k\u00ea n\u00e0y nh\u00e9.\u00a0<\/span><\/span><\/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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#1_Ham_thong_ke_trong_Excel_COUNT\" >1. H\u00e0m th\u1ed1ng k\u00ea trong Excel COUNT.<\/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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#2_Ham_thong_ke_COUNTIF\" >2. H\u00e0m th\u1ed1ng k\u00ea COUNTIF.<\/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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#3_Ham_thong_ke_trong_Excel_COUNTIFS\" >3. H\u00e0m th\u1ed1ng k\u00ea trong Excel COUNTIFS.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#4_Ham_thong_ke_COUNTA\" >4. H\u00e0m th\u1ed1ng k\u00ea COUNTA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#5_Ham_thong_ke_SUMIF\" >5. H\u00e0m th\u1ed1ng k\u00ea SUMIF<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Ham_thong_ke_trong_Excel_COUNT\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">1. H\u00e0m th\u1ed1ng k\u00ea trong Excel COUNT.<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 <\/span><\/span><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel<\/span><\/span><\/strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> n\u00e0y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng theo h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows. K\u00e8m theo \u0111\u00f3 l\u00e0 phi\u00ean b\u1ea3n c\u1ee7a Excel 2019. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t v\u00e0 \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c h\u1ec7 \u0111i\u1ec1u h\u00e0nh t\u01b0\u01a1ng t\u1ef1. V\u1edbi c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau c\u1ee7a Excel nh\u01b0: Microsoft Excel 365, 2017, 2016, 2013, 2010, 2007.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea COUNT c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng trong Excel. H\u00e0m s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a t\u1ed5ng c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp c\u00e1c g\u00eda tr\u1ecb t\u1eeb tr\u01b0\u1edbc t\u1ee9c l\u00e0 c\u00e1c s\u00f4 trong \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh tr\u01b0\u1edbc.\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c \u0111\u1ec3 b\u1ea1n nh\u1eadp khi c\u1ea7n t\u00ednh \u0111\u1ec3 Excel x\u1eed l\u00ed d\u1eef li\u1ec7u:\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= COUNT (value1, value2, value3 &#8230;)<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0u \u00fd, trong \u0111\u00f3:<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Value1: l\u00e0 tham s\u1ed1 \u0111\u1ea7u ti\u00ean s\u1ebd tham chi\u1ebfu \u00f4 hay d\u00e3y c\u00e1c \u00f4 s\u1ebd c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n x\u1eed l\u00ed v\u1edbi n\u00f3.\u00a0<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Value2, value3: l\u00e0 c\u00e1c s\u1ed1 ti\u1ebfp theo \u0111\u1ec3 tham chi\u1ebfu d\u00e3y \u00f4 ho\u1eb7c \u00f4 \u0111\u1ec3 b\u1ed5 sung c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 ti\u1ebfp theo m\u00e0 b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n l\u00e0 vi\u1ec7c \u0111\u1ebfm.\u00a0\u00a0<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5 minh h\u1ecda: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh nh\u1eadn h\u1ecdc b\u1ed5ng\u00a0 trong l\u1edbp 11C11 trong b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u00e2y l\u00e0 l\u00fac b\u1ea1n \u00e1p d\u1ee5ng <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> hay r\u00f5 h\u01a1n l\u00e0 h\u00e0m COUNT b\u1eb1ng vi\u1ec7c nh\u1eadp c\u00f4ng th\u1ee9c: =COUNT(value1, value2,value3 &#8230;) v\u00e0 nh\u1ea5n n\u00fat Enter \u0111\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u1ebfm. T\u1eeb k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u00ednh ra b\u1ea1n s\u1ebd c\u00f3 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u1ecdc sinh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i t\u1ed1n qu\u00e1 nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 \u0111\u1ebfm.\u00a0<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11536 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: center\"><em><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea COUNT<\/span><\/span><\/span><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Ham_thong_ke_COUNTIF\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">2. H\u00e0m th\u1ed1ng k\u00ea COUNTIF.<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u00e2y l\u00e0 <\/span><\/span><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng trong Excel <\/span><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">c\u00f3 \u0111i\u1ec1u ki\u1ec7n. B\u1ea1n s\u1ebd d\u00f9ng h\u00e0m n\u00e0y \u0111\u1ec3 \u0111\u1ebfm cqsc s\u1ed1 l\u01b0\u1ee3ng \u00f4 \u0111\u00fang theo nh\u1eefng \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc t\u1eeb b\u1ea1n.\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COUNTIF m\u00e0 b\u1ea1n n\u00ean n\u1eafm ch\u1eafc: =COUNTIF(range,criteria).\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0u \u00fd, trong \u0111\u00f3:\u00a0<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">range:\u00a0 <\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u00e0 c\u00e1c v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n th\u1ed1ng k\u00ea c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u1ebfm. H\u00e3y b\u00f4i \u0111en v\u00f9ng \u0111\u00f3 \u0111\u1ec3 thao t\u00e1c di\u1ec5n ra ch\u00ednh x\u00e1c v\u00e0 nhanh nh\u1ea5t.\u00a0<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">criteria: <\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u01b0a ra \u0111\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u1ecdc b\u1edbt \u0111\u00fang theo y\u00eau c\u1ea7u. Trong t\u1ea5t c\u1ea3 c\u00e1c g\u00eda tr\u1ecb th\u00ec kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb n\u00e0o c\u0169ng \u0111\u00e1p \u1ee9ng \u0111\u00fang theo b\u1ea1n mu\u1ed1n. N\u00ean h\u00e3y \u0111\u01b0a ra \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang nh\u1ea5t \u0111\u1ec3 l\u1ecdc ra k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb ph\u1ee5c v\u1ee5 cho nhu c\u1ea7u h\u1ecdc v\u00e0 l\u00e0m c\u1ee7a b\u1ea1n.\u00a0<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5 minh h\u1ecda: H\u00e3y th\u1ed1ng k\u00ea ra s\u1ed1 l\u01b0\u1ee3ng c\u00e1c b\u1ea1n h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m trung b\u00ecnh t\u1eeb 8 tr\u1edf l\u00ean.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u00fac n\u00e0y, b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng <\/span><\/span><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng trong exce<\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">l <\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">theo h\u00e0m COUNTIF nh\u01b0 sau:<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1eadp \u0111\u00fang c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh: =COUNTIF(v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm,&#8221;&gt;=8&#8243;). Nh\u1ea5n Enter \u0111\u1ec3 ra k\u1ebft qu\u1ea3 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ebfm. S\u1ed1 l\u01b0\u1ee3ng t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u01b0a ra sau khi nh\u1ea5n Enter. \u0110\u00e2y l\u00e0 c\u00e1c s\u1ed1 l\u01b0\u1ee3ng c\u00e1c b\u1ea1n h\u1ecdc sinh d\u01b0\u1edbi trung b\u00ecnh t\u1ee9c l\u00e0 5 tr\u1edf xu\u1ed1ng.<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11537 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: center\"><em><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea COUNTIF<\/span><\/span><\/span><\/em><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Ham_thong_ke_trong_Excel_COUNTIFS\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">3. H\u00e0m th\u1ed1ng k\u00ea <\/span><\/span><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\">trong Excel <\/span><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">COUNTIFS.<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u00e2y l\u00e0 <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel <\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m COUNTIFS. Tuy nhi\u00ean, s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa hai h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng alf h\u00e0m COUNTIFS s\u1ebd \u0111\u1ebfm gi\u00e1 tr\u1ecb t\u1eeb \u00f4. Theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc thay v\u00ec m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u01b0 h\u00e0m COUNT.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c b\u1ea1n c\u1ea7n n\u1eafm c\u1ee7a h\u00e0m COUNTIFS l\u00e0:<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u00a0= COUNTIFS (ti\u00eau ch\u00ed_ d\u1ea3i \u00f41, ti\u00eau ch\u00ed1, d\u1ea3i ti\u00eau ch\u00ed2, ti\u00eau ch\u00ed2, d\u1ea3i ti\u00eau ch\u00ed3, ti\u00eau ch\u00ed3\u2026)<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0u \u00fd, trong \u0111\u00f3:\u00a0<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Criteria_range1: l\u00e0 kho\u1ea3ng v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n thao t\u00e1c \u0111\u1ec3 th\u1ed1ng k\u00ea ra.\u00a0<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Criteria1: l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 l\u1ecdc theo y\u00eau c\u1ea7u t\u1eeb criteria_range1.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Criteria_range2, criteria2, criteria_range3, criteria3 \u2026: \u0110\u00e2y l\u00e0 kho\u1ea3ng v\u00f9ng c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0a ra \u0111\u1ec3 b\u1ed5 sung c\u0169ng nh\u01b0 c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung \u0111\u1ec3 l\u1ecdc \u0111\u01b0\u1ee3c k\u1ebft qura \u0111\u00fang theo m\u1ee5c \u0111\u00edch nh\u1ea5t.\u00a0<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5 minh h\u1ecda: H\u00e3y th\u1ed1ng k\u1ebf s\u1ed1 l\u01b0\u1ee3ng \u0111\u00fang nh\u1ea5t v\u1ec1 s\u1ed1 h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m to\u00e1n thi cu\u1ed1i k\u00ec l\u00e0 10. V\u00e0 c\u00f3 t\u1ed5ng \u0111i\u1ec3m trung b\u00ecnh m\u00f4n t\u1eeb 8 tr\u1edf l\u00ean.\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u00c1p d\u1ee5ng <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> ta l\u00e0m theo nh\u1eadp h\u00e0m c\u00f4ng th\u1ee9c: =COUNTIFS(kho\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm,&#8221;=10 &#8220;,kho\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm,&#8221;&gt;=8&#8243;).<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Sau c\u00f9ng nh\u1ea5n n\u00fat Enter k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec7n ra. Th\u00ec \u0111\u00f3 ch\u00ednh l\u00e0 d\u1eef li\u1ec7u m\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc ra \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u. V\u1eeba c\u00f3 \u0111i\u1ec3m to\u00e1n l\u00e0 10 v\u00e0 t\u1ed5ng \u0111i\u1ec3m trung b\u00ecnh l\u00e0 8 tr\u1edf l\u00ean.\u00a0<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11535 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: center\"><em><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea COUNTIFS<\/span><\/span><\/span><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Ham_thong_ke_COUNTA\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">4. H\u00e0m th\u1ed1ng k\u00ea COUNTA<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u00e0 <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 kh\u00f4ng hay l\u00e0 \u00f4 tr\u1ed1ng trong c\u00e1c d\u00e3y \u00f4 m\u00e0 b\u1ea1n c\u1ea7n kh\u1ea3o s\u00e1t.\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng\u00a0 COUNTA l\u00e0:\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= COUNTA (gi\u00e1 tr\u1ecb1, gi\u00e1 tr\u1ecb2, gi\u00e1 tr\u1ecb3 &#8230;)<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0u \u00fd, trong \u0111\u00f3:\u00a0<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Value1: L\u00e0 c\u00e1c tham chi\u1ebfu c\u1ee7a \u00f4 hay d\u00e3y \u00f4 c\u00f3 ch\u1ee9a \u0111\u1ef1ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfn \u0111\u1ec3 \u0111\u1ebfm.\u00a0\u00a0<\/span><\/span><\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Value2, Value3: L\u00e0 c\u00e1c tham chi\u1ebfu c\u1ee7a \u00f4 hay d\u00e3y \u00f4 b\u1ed5 sung c\u00f3 ch\u1ee9a \u0111\u1ef1ng c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfn \u0111\u1ec3 \u0111\u1ebfm.\u00a0\u00a0<\/span><\/span><\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5 minh h\u1ecda: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u1eefng h\u1ecdc sinh \u0111\u01b0\u1ee3c \u0111\u00e1nh g\u00eda x\u1ebfp lo\u1ea1i l\u00e0 \u0111\u1ea1t trong b\u1ea3ng danh s\u00e1ch h\u1ecdc sinh.\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u00c1p d\u1ee5ng h\u00e0m COUNTA nh\u01b0 sau:\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1eadp \u0111\u00fang c\u00f4ng th\u1ee9c: =COUNTA(value1, value2,value3\u00a0 \u2026) sau \u0111\u00f3 nh\u1ea5n ch\u1ecdn Enter \u0111\u1ec3 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c \u0111\u01b0a ra. S\u00f4 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea3ng \u0111\u01b0a ra l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u1ecdc sinh \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i trong dah s\u00e1ch.\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11534 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-3.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-3-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-3-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: center\"><em><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea COUNTA<\/span><\/span><\/span><\/span><\/span><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Ham_thong_ke_SUMIF\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">5. H\u00e0m th\u1ed1ng k\u00ea SUMIF<\/span><\/span><\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u00e0 <\/span><\/span><\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea trong excel<\/span><\/span><\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> \u0111\u01b0\u1ee3c d\u00f9ng v\u1edbi ph\u00e9p t\u00ednh t\u1ed1ng t\u00ecm t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u01b0a ra t\u1eeb b\u1ea1n.\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SUMIF: =SUMIF(range, criteria, sum_range)<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0 \u00fd, trong \u0111\u00f3:<\/span><\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Range:<\/span><\/span><\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> \u0111\u1ea5y l\u00e0 kho\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c b\u1ea1n x\u1eed l\u00ed khi\u00a0 b\u1ea1n mu\u1ed1n d\u00f9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u00e9t t\u1ea1i \u0111\u00e2y.<\/span><\/span><\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Criteria: <\/span><\/span><\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u00a0C\u00f4ng c\u1ee5 s\u1ebd d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n n\u00e0y \u0111\u1ec3 x\u00e9t t\u00e1t c\u1ea3 \u00f4 m\u00e0 b\u1ea1n c\u1ea7n \u0111em ra \u0111\u1ec3 t\u00ednh t\u1ed5ng.\u00a0<\/span><\/span><\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Sum_range:<\/span><\/span><\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> Excel s\u1ebd l\u00e0m vi\u1ec7c v\u00e0 t\u00ednh t\u1ed5ng kho\u1ea3ng v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng d\u1eef li\u1ec7u c\u00f3 ph\u00f9 h\u1ee3p v\u00e0 \u0111\u00fang v\u1edbi \u0111i\u1ec1u ki\u1ec7n.<\/span><\/span><\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5: T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb h\u1ecdc b\u1ed5ng khuy\u1ebfn h\u1ecdc d\u00e0nh cho c\u00e1c b\u1ea1n h\u1ecdc sinh trong l\u1edbp khi c\u00f3 \u0111i\u1ec3m to\u00e1n l\u00e0 10.\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1eadp c\u00f4ng th\u1ee9c: =SUMIF(range,&#8221;=10&#8243;,\u00a0 sum_range) v\u00e0 nh\u1ea5n Enter. B\u1ea3ng s\u1ebd \u0111\u01b0a ra k\u1ebft qu\u1ea3 nagy l\u1eadp t\u1ee9c th\u00ec s\u1ed1 li\u1ec7u \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n t\u00ecm th\u1ecfa m\u00e3n y\u00eau c\u1ea7u \u0111\u01b0a ra.\u00a0<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11533 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-4.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: center\"><em><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m th\u1ed1ng k\u00ea SUMIF<\/span><\/span><\/span><\/span><\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u1ede b\u00e0i vi\u1ebft tr\u00ean l\u00e0 chi ti\u1ebft v\u1ec1\u00a0 c\u00e1c h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. Ngo\u00e0i nh\u1eefng h\u00e0m tr\u00ean \u0111\u00e2y m\u00e0 ch\u00fang t\u00f4i cung c\u1ea5p, c\u00f2n c\u00f3 nh\u1eefng<\/span><\/span><\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> h\u00e0m th\u1ed1ng k\u00ea trong excel <\/span><\/span><\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <\/span><\/span><\/span><\/span><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng trong excel <\/span><\/span><\/span><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">kh\u00e1c. Hy v\u1ecdng nh\u1eefng d\u1eef li\u1ec7u m\u00e0 ch\u00fang t\u00f4i cung c\u1ea5p s\u1ebd gi\u1ea3i \u0111\u00e1p c\u0169ng nh\u01b0 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft c\u00f4n vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. Ch\u00fac b\u1ea1n \u0111\u1ecdc s\u1ebd \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng theo h\u01b0\u1edbng d\u1eabn!<\/span><\/span><\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sau qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng \u1edf Excel th\u00ec \u0111\u00f4i l\u00fac b\u1ea1n c\u0169ng c\u1ea7n x\u1eed l\u00ed v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng. B\u1ea1n s\u1ebd c\u00f3 nh\u1eefng l\u00fac th\u1ef1c s\u1ef1 c\u1ea7n th\u1ed1ng k\u00ea h\u1ebft l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. \u0110\u00f3 l\u00e0 l\u00ed do c\u1ee7a s\u1ef1 &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11530","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>Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0<\/title>\n<meta name=\"description\" content=\"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0\" \/>\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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0\" \/>\n<meta property=\"og:description\" content=\"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-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-14T05:28:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-20T15:42:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\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=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0\",\"datePublished\":\"2022-03-14T05:28:08+00:00\",\"dateModified\":\"2022-03-20T15:42:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"},\"wordCount\":1836,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\",\"name\":\"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg\",\"datePublished\":\"2022-03-14T05:28:08+00:00\",\"dateModified\":\"2022-03-20T15:42:17+00:00\",\"description\":\"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-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\":\"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0\"}]},{\"@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\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0","description":"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0","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\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0","og_description":"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-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-14T05:28:08+00:00","article_modified_time":"2022-03-20T15:42:17+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0","datePublished":"2022-03-14T05:28:08+00:00","dateModified":"2022-03-20T15:42:17+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/"},"wordCount":1836,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/","name":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg","datePublished":"2022-03-14T05:28:08+00:00","dateModified":"2022-03-20T15:42:17+00:00","description":"L\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00e0m th\u1ed1ng k\u00ea trong excel l\u00e0 \u0111\u1ec3 h\u1ed7 tr\u1ee3 khi b\u1ea1n c\u1ea7n. H\u00e3y theo d\u00f5i nh\u1eefng th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c h\u00e0m n\u00e0y nh\u00e9.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-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":"Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0"}]},{"@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\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11530","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11530"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11530\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11532"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}