{"id":11113,"date":"2022-11-08T22:54:00","date_gmt":"2022-11-08T15:54:00","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11113"},"modified":"2022-12-06T11:20:34","modified_gmt":"2022-12-06T04:20:34","slug":"ham-countifs-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/","title":{"rendered":"H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n"},"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;11113&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;H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n&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;\"><i><span style=\"font-weight: 400;\">Hi\u1ec7n nay vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m t\u00ednh to\u00e1n trong excel v\u00f4 c\u00f9ng quan tr\u1ecdng. B\u1edfi v\u00ec n\u00f3 s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, c\u00f4ng s\u1ee9c h\u01a1n trong vi\u1ec7c ho\u00e0n thi\u1ec7n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u. V\u00e0 trong \u0111\u00f3, <\/span><\/i><b><i>h\u00e0m Countifs trong excel<\/i><\/b><i><span style=\"font-weight: 400;\"> c\u0169ng l\u00e0 m\u1ed9t \u201ctr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c\u201d \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi \u0111\u00e1nh gi\u00e1 cao. V\u1eady h\u00e0m n\u00e0y mang \u0111\u1ebfn ti\u1ec7n \u00edch g\u00ec c\u1ee5 th\u1ec3? S\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? T\u1ea5t t\u1ea7n t\u1eadt h\u00e3y \u0111\u1ec3 Teky gi\u1ea3i \u0111\u00e1p r\u00f5 r\u00e0ng. Mong r\u1eb1ng s\u1ebd gi\u00fap cho b\u1ea1n \u0111\u1ecdc s\u1eed d\u1ee5ng h\u00e0m Countifs d\u1ec5 d\u00e0ng h\u01a1n.\u00a0<\/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\/ham-countifs-trong-excel\/#Ban_biet_gi_ve_ham_count_ham_countif_ham_countifs_trong_Excel\" >B\u1ea1n bi\u1ebft g\u00ec v\u1ec1 h\u00e0m count, h\u00e0m countif, h\u00e0m countifs trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#Cach_su_dung_ham_Count_Countif_va_ham_Countifs_trong_excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Count, Countif v\u00e0 h\u00e0m Countifs trong excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#Cach_su_dung_ham_Count_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Count trong Excel<\/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\/ham-countifs-trong-excel\/#Cach_su_dung_ham_Countif_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Excel<\/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\/ham-countifs-trong-excel\/#Cach_su_dung_ham_Countifs_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#Tong_ket_chung\" >T\u1ed5ng k\u1ebft chung\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ban_biet_gi_ve_ham_count_ham_countif_ham_countifs_trong_Excel\"><\/span><b>B\u1ea1n bi\u1ebft g\u00ec v\u1ec1 h\u00e0m count, h\u00e0m countif, h\u00e0m countifs trong Excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh c\u00e1c h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n trong excel ph\u1ed5 bi\u1ebfn hi\u1ec7n nay nh\u01b0 SUM, Average, IF,&#8230; Th\u00ec h\u00e0m s\u1ed1 \u0111\u1ebfm c\u0169ng kh\u00e1 \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng b\u1edfi v\u00ec mang \u0111\u1ebfn nh\u1eefng l\u1ee3i \u00edch h\u1ebft s\u1ee9c thi\u1ebft th\u1ef1c. Khi\u1ebfn cho vi\u1ec7c s\u1eed d\u1ee5ng excel tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n. \u0110\u1eb7c bi\u1ec7t l\u00e0 h\u1ea1n ch\u1ebf nh\u1eefng sai h\u1ecfng kh\u00f4ng \u0111\u00e1ng x\u1ea3y ra. C\u1ee5 th\u1ec3, ng\u01b0\u1eddi ta th\u01b0\u1eddng d\u00f9ng h\u00e0m s\u1ed1 \u0111\u1ebfm n\u00e0y \u0111\u1ec3 th\u1ed1ng k\u00ea s\u1ed1 li\u1ec7u trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 trong h\u1ecdc t\u1eadp.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m count, h\u00e0m countif hay <\/span><b>h\u00e0m countifs trong Excel<\/b><span style=\"font-weight: 400;\"> nh\u00ecn chung \u0111\u1ec1u l\u00e0 c\u00e1c h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm. Song ch\u00fang c\u00f3 s\u1ef1 n\u00e2ng c\u1ea5p d\u1ea7n v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng t\u00ecnh hu\u1ed1ng nh\u1ea5t \u0111\u1ecbnh. N\u1ebfu coun ch\u1ec9 d\u00f9ng cho c\u00e1c \u00f4 c\u00f3 ch\u1ee9a s\u1ed1 th\u00ec h\u00e0m countif \u0111i k\u00e8m th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. C\u00f2n h\u00e0m countifs th\u00ec l\u1ea1i d\u00f9ng \u0111i k\u00e8m nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. T\u00f9y theo t\u1eebng t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng \u1edf d\u1ea1ng count, countif hay countifs. V\u00e0 c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng countis l\u00e0 d\u1ea1ng cao c\u1ea5p h\u01a1n c\u1ee7a hai d\u1ea1ng h\u00e0m count v\u00e0 countif.<\/span><\/p>\n<figure id=\"attachment_11114\" aria-describedby=\"caption-attachment-11114\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11114\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1-400x214.jpg\" alt=\"ham-countifs-trong-excel-1\" width=\"400\" height=\"214\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1-400x214.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1-768x410.jpg 768w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg 936w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11114\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Count_Countif_va_ham_Countifs_trong_excel\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Count, Countif v\u00e0 h\u00e0m Countifs trong excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 \u0111\u00e3 n\u00f3i \u0111\u1ebfn \u1edf tr\u00ean, h\u00e0m s\u1ed1 \u0111\u1ebfm \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng r\u1ed9ng r\u00e3i hi\u1ec7n nay. B\u1ea1n \u0111ang mu\u1ed1n t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ed1i v\u1edbi h\u00e0m Count, Countif v\u00e0 Countifs? V\u1eady th\u00ec h\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i \u0111\u1ec3 Teky gi\u1ea3i \u0111\u00e1p c\u1ee5 th\u1ec3 nh\u00e9!\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"27. H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif, Countifs trong Excel | B\u00e0i t\u1eadp\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/UWzDBBf4u3w?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<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Count_trong_Excel\"><\/span><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Count trong Excel<\/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 Count l\u00e0 d\u1ea1ng \u0111\u1ebfm \u0111\u01a1n gi\u1ea3n nh\u1ea5t hi\u1ec7n nay, d\u00f9ng cho c\u00e1c \u00f4 ch\u1ee9a s\u1ed1 v\u00e0 kh\u00f4ng c\u1ea7n x\u00e9t \u0111i\u1ec1u ki\u1ec7n. H\u00e0m Count c\u00f3 c\u00f4ng th\u1ee9c chung nh\u01b0 sau: = COUNT(gi\u00e1 tr\u1ecb 1, [gi\u00e1 tr\u1ecb 2], \u2026).\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, gi\u00e1 tr\u1ecb 1, gi\u00e1 tr\u1ecb 2 l\u00e0 c\u00e1c tham chi\u1ebfu \u00f4 b\u1ea1n c\u1ea7n \u0111\u1ebfm. Ho\u1eb7c n\u1ebfu mu\u1ed1n \u0111\u1ec3 nhanh g\u1ecdn h\u01a1n th\u00ec b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u00e9o r\u00ea chu\u1ed9t ch\u1ecdn kho\u1ea3ng \u0111\u1ec3 \u0111\u1ebfm cho nhanh.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m trong kho\u1ea3ng \u00f4 t\u1eeb B2 \u0111\u1ebfn B8. Th\u00ec c\u00f4ng th\u1ee9c l\u00e0 = COUNT(B2:B8).\u00a0<\/span><\/p>\n<figure id=\"attachment_11115\" aria-describedby=\"caption-attachment-11115\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11115\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-2-400x229.jpg\" alt=\"ham-countifs-trong-excel-2\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-2-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-2.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11115\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Count \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 t\u1eeb B2 \u0111\u1ebfn B8<\/figcaption><\/figure>\n<figure id=\"attachment_11116\" aria-describedby=\"caption-attachment-11116\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11116\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-3-400x229.jpg\" alt=\"ham-countifs-trong-excel-3\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-3-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-3.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11116\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng ra v\u00f4 c\u00f9ng ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f2n n\u1ebfu mu\u1ed1n \u0111\u1ebfm \u00f4 ch\u1ee9a k\u00fd t\u1ef1 th\u00ec s\u1eed d\u1ee5ng h\u00e0m Counta. C\u1ee5 th\u1ec3 h\u01a1n v\u00ed d\u1ee5 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay sau \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_11117\" aria-describedby=\"caption-attachment-11117\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11117\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-4-400x229.jpg\" alt=\"ham-countifs-trong-excel-4\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-4-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-4.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11117\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Counta \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 k\u00fd t\u1ef1<\/figcaption><\/figure>\n<figure id=\"attachment_11118\" aria-describedby=\"caption-attachment-11118\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11118\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-5-400x229.jpg\" alt=\"ham-countifs-trong-excel-5\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-5-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-5.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11118\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng h\u00e0m Counta \u0111\u1ec3 \u0111\u1ebfm \u00f4 c\u00f3 ch\u1ee9a k\u00fd t\u1ef1<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Count (c\u0169ng nh\u01b0 l\u00e0 Counta) trong ph\u00e9p to\u00e1n \u0111\u1ebfm. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng n\u00f3 h\u1ebft s\u1ee9c \u0111\u01a1n gi\u1ea3n, d\u1ec5 s\u1eed d\u1ee5ng v\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c. H\u00e3y s\u1eed d\u1ee5ng n\u00f3 khi b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 li\u1ec7u \u0111\u1ec3 tr\u00e1nh b\u1ecb sai s\u00f3t nh\u00e9!<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Countif_trong_Excel\"><\/span><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Excel<\/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;\">Ti\u1ebfp theo l\u00e0 Countif trong Excel, \u0111\u00e2y l\u00e0 m\u1ed9t d\u1ea1ng h\u00e0m \u0111\u1ebfm n\u00e2ng c\u1ea5p h\u01a1n m\u1ed9t ch\u00fat so v\u1edbi h\u00e0m Count. C\u1ee5 th\u1ec3 c\u00f4ng th\u1ee9c h\u00e0m s\u1ebd l\u00e0: = Countif(range, criteria). Trong \u0111\u00f3, range ch\u00ednh l\u00e0 v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n \u0111\u1ebfm. V\u00e0 criteria l\u1ea1i l\u00e0 \u0111i\u1ec1u ki\u1ec7n cho vi\u1ec7c \u0111\u1ebfm. L\u01b0u \u00fd l\u00e0 v\u1edbi countif th\u00ec \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 c\u00f3 1. V\u00ed d\u1ee5 nh\u01b0 s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh nam trong l\u1edbp nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_11119\" aria-describedby=\"caption-attachment-11119\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11119\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-6-400x229.jpg\" alt=\"ham-countifs-trong-excel-6\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-6-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-6.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11119\" class=\"wp-caption-text\">T\u00ednh t\u1ed5ng s\u1ed1 h\u1ecdc sinh nam nhanh ch\u00f3ng h\u01a1n b\u1eb1ng h\u00e0m Countif<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m Countif theo c\u00f4ng th\u1ee9c l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 gi\u1edbi t\u00ednh nam. L\u01b0u \u00fd l\u00e0 c\u1ea7n c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p ngo\u00e0i ch\u1eef Nam v\u00ec Nam l\u00e0 k\u00ed t\u1ef1. C\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p th\u00ec h\u00e0m m\u1edbi c\u00f3 ngh\u0129a.\u00a0\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Countifs_trong_Excel\"><\/span><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs trong Excel<\/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;\">Cu\u1ed1i c\u00f9ng l\u00e0 s\u1eed d\u1ee5ng <\/span><b>h\u00e0m Countifs trong Excel<\/b><span style=\"font-weight: 400;\">. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u1ebfm c\u00f3 s\u1ef1 n\u00e2ng c\u1ea5p h\u01a1n h\u1eb3n so v\u1edbi h\u00e0m Count v\u00e0 h\u00e0m Countif. H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 d\u1ef1a tr\u00ean nhi\u1ec1u d\u1eef\u00a0 li\u1ec7u \u0111i\u1ec1u ki\u1ec7n m\u1ed9t l\u00fac. \u0110\u1ea7u ti\u00ean, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m nh\u01b0 sau: = COUNTIFS(range1, criteria1, range2, criteria2,\u2026).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, range 1 v\u00e0 range 2 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00e9t (t\u1ed1i \u0111a 127 d\u00e3y). C\u00f3 th\u1ec3 ch\u1ee9a s\u1ed1, k\u00fd t\u1ef1,&#8230; C\u00f2n criteria1 v\u00e0 criteria 2 l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm. C\u1ee5 th\u1ec3 v\u00ed d\u1ee5 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam ngay sau \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_11120\" aria-describedby=\"caption-attachment-11120\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11120\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-7-400x229.jpg\" alt=\"ham-countifs-trong-excel-7\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-7-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-7.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11120\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh gi\u1edbi t\u00ednh n\u1eef \u0111\u1ea3m b\u1ea3o s\u1ed1 \u0111i\u1ec3m tr\u00ean 8<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng <\/span><b>h\u00e0m Countifs trong Excel,<\/b><span style=\"font-weight: 400;\"> b\u1ea1n c\u1ea7n x\u00e9t d\u1ef1a tr\u00ean hai d\u1eef ki\u1ec7n tr\u1edf n\u00ean. Nh\u01b0 \u1edf h\u00ecnh tr\u00ean v\u00e0 v\u1ec1 gi\u1edbi t\u00ednh v\u00e0 c\u1ea3 \u0111i\u1ec3m s\u1ed1. N\u00f3 s\u1ebd gi\u00fap b\u1ea1n l\u1ecdc ra \u0111\u00e1p \u00e1n cu\u1ed1i c\u00f9ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.\u00a0 <\/span><i><span style=\"font-weight: 400;\">\u00a0<\/span><\/i><\/p>\n<figure id=\"attachment_11121\" aria-describedby=\"caption-attachment-11121\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11121\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-8-400x229.jpg\" alt=\"ham-countifs-trong-excel-8\" width=\"400\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-8-400x229.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-8.jpg 700w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11121\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m Countifs cho ra k\u1ebft qu\u1ea3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh n\u1eef tr\u00ean 8 \u0111i\u1ec3m<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e1p \u00e1n cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c t\u00ednh ra m\u1ed9t c\u00e1ch h\u1ebft s\u1ee9c nhanh ch\u00f3ng l\u00e0 c\u00f3 1 h\u1ecdc sinh n\u1eef \u0111\u00e1p \u1ee9ng \u0111i\u1ec3m s\u1ed1 tr\u00ean 8 \u0111i\u1ec3m. \u0110\u00f3 ch\u00ednh\u00a0 l\u00e0 Tr\u1ea7n Th\u1ecb Xu\u00e2n &#8211; 10 \u0111i\u1ec3m. V\u00e0 n\u1ebfu nh\u01b0 b\u1ea1n t\u1ef1 \u0111\u1ebfm th\u1ee7 c\u00f4ng th\u00ec s\u1ebd kh\u00f4ng h\u1ec1 d\u1ec5 d\u00e0ng m\u00e0 ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nhanh ch\u00f3ng ch\u1ec9 trong v\u00e0i gi\u00e2y nh\u01b0 v\u1eady. Nh\u1ea5t l\u00e0 \u0111\u1ed1i v\u1edbi m\u1ed9t b\u1ea3ng s\u1ed1 li\u1ec7u h\u00e0ng tr\u0103m s\u1ed1 li\u1ec7u th\u00ec vi\u1ec7c n\u00e0y s\u1ebd c\u00f2n kh\u00f3 kh\u0103n h\u01a1n nhi\u1ec1u.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m find trong excel hi\u1ec7n nay<\/a>\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tong_ket_chung\"><\/span><b>T\u1ed5ng k\u1ebft chung\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng l\u00e0 h\u00e0m Count if, Count, Countifs \u0111\u1ec1u c\u1ef1c k\u1ef3 b\u1ed5 \u00edch khi s\u1eed d\u1ee5ng trong Excel. Mang \u0111\u1ebfn cho b\u1ea1n s\u1ef1 nhanh ch\u00f3ng, ti\u1ec7n l\u1ee3i v\u00e0 d\u1ec5 d\u00e0ng. H\u1ea1n ch\u1ebf vi\u1ec7c ph\u1ea3i t\u1ef1 \u0111\u1ebfm s\u1ed1 g\u00e2y ra sai s\u00f3t. V\u00ec th\u1ebf n\u00ean h\u00e3y tham kh\u1ea3o k\u1ef9 c\u00e1ch\u00a0 s\u1eed d\u1ee5ng \u0111\u1ed1i v\u1edbi\u00a0 h\u00e0m \u0111\u1ebfm tr\u00ean \u0111\u1ec3 s\u1eed d\u1ee5ng khi c\u1ea7n \u0111\u1ebfn nh\u00e9.\u00a0\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ea3m \u01a1n b\u1ea1n \u0111\u1ecdc v\u00ec \u0111\u00e3 theo d\u00f5i nh\u1eefng th\u00f4ng tin v\u1ec1 <\/span><b>h\u00e0m Countifs trong Excel<\/b><span style=\"font-weight: 400;\"> c\u0169ng\u00a0 nh\u01b0 c\u00e1c\u00a0 phi\u00ean b\u1ea3n kh\u00e1c \u0111\u01a1n gi\u1ea3n h\u01a1n c\u1ee7a n\u00f3 l\u00e0 Count v\u00e0 Countif. Mong r\u1eb1ng n\u00f3 s\u1ebd c\u00f3 \u00edch \u0111\u1ed1i v\u1edbi b\u1ea1n. H\u1eb9n g\u1eb7p l\u1ea1i \u1edf nh\u1eefng chuy\u00ean m\u1ee5c tin t\u1ef1 h\u1ecdc Excel kh\u00e1c c\u1ee7a Teky nh\u00e9.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Xem th\u00eam:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\" target=\"_blank\" rel=\"noopener\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n si\u00eau \u0111\u01a1n gi\u1ea3n trong Excel\u00a0<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cong-thuc-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1c c\u00f4ng th\u1ee9c trong excel b\u1ed5 \u00edch c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/day-be-hoc-so\/\" target=\"_blank\" rel=\"noopener\">N\u00ean d\u1ea1y b\u00e9 h\u1ecdc s\u1ed1 nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1t nh\u1ea5t?<\/a><\/li>\n<li style=\"text-align: justify;\"><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-dem-tu-trong-word-don-gian-chi-tiet-nhat\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn \u0111\u1ebfm t\u1eeb trong Word \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hi\u1ec7n nay vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m t\u00ednh to\u00e1n trong excel v\u00f4 c\u00f9ng quan tr\u1ecdng. B\u1edfi v\u00ec n\u00f3 s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, c\u00f4ng s\u1ee9c h\u01a1n trong vi\u1ec7c ho\u00e0n thi\u1ec7n c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u. V\u00e0 trong \u0111\u00f3, h\u00e0m Countifs trong excel c\u0169ng l\u00e0 m\u1ed9t \u201ctr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c\u201d \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi \u0111\u00e1nh gi\u00e1 &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11114,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11113","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>H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n<\/title>\n<meta name=\"description\" content=\"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky\" \/>\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\/ham-countifs-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-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-08T15:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T04:20:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"936\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\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\/ham-countifs-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n\",\"datePublished\":\"2022-11-08T15:54:00+00:00\",\"dateModified\":\"2022-12-06T04:20:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\"},\"wordCount\":1795,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\",\"name\":\"H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg\",\"datePublished\":\"2022-11-08T15:54:00+00:00\",\"dateModified\":\"2022-12-06T04:20:34+00:00\",\"description\":\"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg\",\"width\":936,\"height\":500,\"caption\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countifs-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\":\"H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n\"}]},{\"@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":"H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n","description":"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky","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\/ham-countifs-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n","og_description":"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky","og_url":"https:\/\/teky.edu.vn\/blog\/ham-countifs-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-08T15:54:00+00:00","article_modified_time":"2022-12-06T04:20:34+00:00","og_image":[{"width":936,"height":500,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-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\/ham-countifs-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n","datePublished":"2022-11-08T15:54:00+00:00","dateModified":"2022-12-06T04:20:34+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/"},"wordCount":1795,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/","name":"H\u00e0m Countifs trong excel - B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg","datePublished":"2022-11-08T15:54:00+00:00","dateModified":"2022-12-06T04:20:34+00:00","description":"H\u00e0m Countifs trong excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? C\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec khi s\u1eed d\u1ee5ng? H\u00e3y tham kh\u1ea3o c\u1ee5 th\u1ec3 h\u01a1n c\u00f9ng v\u1edbi Teky","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countifs-trong-excel-1.jpg","width":936,"height":500,"caption":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countifs \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-countifs-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":"H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n"}]},{"@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\/11113","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=11113"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11113\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11114"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}