{"id":12407,"date":"2022-11-24T06:53:45","date_gmt":"2022-11-23T23:53:45","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12407"},"modified":"2022-12-08T16:01:16","modified_gmt":"2022-12-08T09:01:16","slug":"ham-countif-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/","title":{"rendered":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc"},"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;12407&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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc&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;\"><em><span style=\"font-weight: 400;\">Th\u1ebf gi\u1edbi to\u00e1n h\u1ecdc c\u00f3 th\u1ec3 n\u00f3i l\u00e0 v\u00f4 c\u00f9ng phong ph\u00fa v\u00e0 \u0111a d\u1ea1ng. C\u00e1c nh\u00e0 to\u00e1n h\u1ecdc uy\u00ean b\u00e1c \u0111\u00e3 t\u00ecm hi\u1ec3u ra c\u00e1c c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc gi\u00fap ch\u00fang ta t\u00ednh to\u00e1n nhanh h\u01a1n, c\u00f2n b\u00e2y gi\u1edd m\u00e1y m\u00f3c hi\u1ec7n \u0111\u1ea1i l\u1ea1i gi\u00fap ch\u00fang ta t\u00ednh lu\u00f4n c\u00f4ng th\u1ee9c \u0111\u00f3 m\u00e0 kh\u00f4ng c\u1ea7n \u0111\u1eb7t b\u00fat t\u00ednh to\u00e1n hay suy ngh\u0129 logic.\u00a0<\/span><span style=\"font-weight: 400;\">Trong nh\u1eefng ph\u00e1t minh v\u0129 \u0111\u1ea1i \u0111\u00f3 ph\u1ea3i k\u1ec3 \u0111\u1ebfn <\/span><b>h\u00e0m countif trong excel<\/b><span style=\"font-weight: 400;\">. <\/span><\/em><\/p>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">N\u1ebfu n\u00f3i excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch h\u1ed7 tr\u1ee3 c\u00e1c ho\u1ea1t \u0111\u1ed9ng t\u00ednh to\u00e1n, nghi\u00ean c\u1ee9u t\u1ec9 l\u1ec7 th\u00ec c\u00e1c h\u00e0m v\u00e0 th\u1ee7 thu\u1eadt trong excel s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap m\u1ecdi ng\u01b0\u1eddi t\u00ednh to\u00e1n d\u1ec5 h\u01a1n. H\u00e3y c\u00f9ng ch\u00fang t\u00f4i \u0111i t\u00ecm hi\u1ec3u v\u1ec1 <\/span><b>h\u00e0m countif trong excel<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/em><\/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-countif-trong-excel\/#Tac_dung_cua_ham_countif_trong_excel\" >T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m countif 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-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#Ham_countif_co_cu_phap_don_gian\" >H\u00e0m countif c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#Vi_du_ve_cach_su_dung_ham_countif\" >V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif<\/a><\/li><\/ul><\/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\/ham-countif-trong-excel\/#Nhung_luu_y_ve_ham_countif_khi_su_dung\" >Nh\u1eefng l\u01b0u \u00fd v\u1ec1 h\u00e0m countif khi s\u1eed d\u1ee5ng<\/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\/ham-countif-trong-excel\/#Ham_Dcount_co_giong_voi_ham_countif_khong\" >H\u00e0m Dcount c\u00f3 gi\u1ed1ng v\u1edbi h\u00e0m countif kh\u00f4ng?<\/a><\/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-countif-trong-excel\/#So_sanh_ham_countif_va_countifs_trong_excel\" >So s\u00e1nh h\u00e0m countif v\u00e0 countifs trong excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tac_dung_cua_ham_countif_trong_excel\"><\/span><b>T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m countif trong excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u1ea7n m\u1ec1m excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nhau \u0111\u1ec3 s\u1eafp x\u1ebfp, ch\u1ecdn l\u1ecdc v\u00e0 t\u00ednh to\u00e1n trong b\u1ea3ng. V\u00e0 h\u00e0m countif l\u00e0 m\u1ed9t trong s\u1ed1 \u0111\u00f3, \u0111\u00e2y l\u00e0 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel. Th\u00f4ng th\u01b0\u1eddng khi ph\u1ea3i th\u1ed1ng k\u00ea v\u00e0 ch\u1ecdn l\u1ecdc s\u1ed1 li\u1ec7u th\u00ec s\u1ebd c\u00f3 nh\u1eefng \u00f4 b\u1ecb tr\u00f9ng l\u1eb7p t\u00ean ho\u1eb7c gi\u1ed1ng nhau; v\u00ec th\u1ebf countif \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00f3.\u00a0<\/span><\/p>\n<figure id=\"attachment_12417\" aria-describedby=\"caption-attachment-12417\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12417 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-3.jpg\" alt=\"T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m countif trong excel\u00a0\" width=\"600\" height=\"416\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-3-400x277.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12417\" class=\"wp-caption-text\">T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m countif trong excel<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m countif trong excel c\u00f3 t\u00e1c d\u1ee5ng g\u00ec nh\u1ec9? H\u00e0m th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 th\u1ed1ng k\u00ea s\u1ed1 li\u1ec7u; c\u00e1c y\u00eau c\u1ea7u \u0111\u1ebfm s\u1ed1 c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho s\u1eb5n. S\u1eed d\u1ee5ng h\u00e0m countif kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p tuy nhi\u00ean b\u1ea1n c\u1ea7n bi\u1ebft trong excel c\u00fa ph\u00e1p h\u00e0m countif n\u00e0o \u0111\u00fang. N\u1ebfu nh\u1eadp sai c\u00fa ph\u00e1p th\u00ec m\u00e1y s\u1ebd kh\u00f4ng hi\u1ec7n k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m count v\u00e0 countif trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/k9qrrCPF8Sk?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<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_countif_co_cu_phap_don_gian\"><\/span><b>H\u00e0m countif c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a <\/span><b>h\u00e0m countif trong excel<\/b><span style=\"font-weight: 400;\"> kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb =COUNTIF(range;criteria). Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range l\u00e0 ph\u1ea7n d\u1eef li\u1ec7u m\u00ecnh mu\u1ed1n \u0111\u1ebfm xem l\u00e0 c\u00f3 bao nhi\u00eau. c\u00f3 th\u1ec3 ch\u1ee9a s\u1ed1 ho\u1eb7c tham chi\u1ebfu s\u1ed1 tr\u00ean \u00f4 excel. C\u00e1c gi\u00e1 tr\u1ecb tr\u1ed1ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c m\u00e1y ghi nh\u1eadn v\u00e0 b\u1ecf qua lu\u00f4n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n m\u00e0 h\u00e0m c\u1ea7n c\u0103n c\u1ee9 \u0111\u1ec3 ch\u1ecdn l\u1ecdc ph\u1ea7n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. C\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c g\u1ed3m bi\u1ec3u th\u1ee9c, v\u0103n b\u1ea3n, s\u1ed1 trong range.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng khi s\u1eed d\u1ee5ng <\/span><b>h\u00e0m countif trong excel;<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ebfm kh\u00e1c th\u00ec s\u1ebd d\u00f9ng c\u00e1c h\u00e0m kh\u00e1c.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_cach_su_dung_ham_countif\"><\/span><b>V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m countif \u0111\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng tr\u1ee9ng g\u00e0 trong b\u1ea3ng nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c =COUNTIF(B2:B8,\u201dtr\u1ee9ng g\u00e0\u201d) trong \u0111\u00f3 B2 l\u00e0 tham chi\u1ebfu \u00f4 t\u00ean tr\u1ee9ng g\u00e0. B8 l\u00e0 s\u1ed1 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm, \u1edf \u0111\u00e2y c\u00f3 8 lo\u1ea1i h\u00e0ng h\u00f3a trong b\u1ea3ng. \u201ctr\u1ee9ng g\u00e0\u201d l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 h\u00e0m \u0111\u1ebfm, ngh\u0129a l\u00e0 ch\u1ec9 \u0111\u1ebfm tr\u1ee9ng g\u00e0. Sau khi nh\u1eadp xong c\u00f4ng th\u1ee9c \u1ea5n enter \u0111\u1ec3 m\u00e1y t\u00ednh th\u1ef1c hi\u1ec7n thao t\u00e1c \u0111\u1ebfm.\u00a0<\/span><\/p>\n<figure id=\"attachment_12418\" aria-describedby=\"caption-attachment-12418\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12418 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-4.jpg\" alt=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif\" width=\"600\" height=\"702\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-4-342x400.jpg 342w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12418\" class=\"wp-caption-text\">V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m countif<\/figcaption><\/figure>\n<p>Xem th\u00eam b\u00e0i:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/doi-duoi-excel-sang-pdf\/\">\u0110\u1ed5i \u0111u\u00f4i excel sang PDF m\u1ed9t c\u00e1ch nhanh nh\u1ea5t, b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a?<\/a><\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\">H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_luu_y_ve_ham_countif_khi_su_dung\"><\/span><b>Nh\u1eefng l\u01b0u \u00fd v\u1ec1 h\u00e0m countif khi s\u1eed d\u1ee5ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m trong excel b\u1ea1n c\u1ea7n h\u1ecdc v\u00e0 t\u00ecm hi\u1ec3u k\u1ef9 v\u1ec1 excel; n\u1ebfu kh\u00f4ng ch\u1ec9 c\u1ea7n m\u1ed9t d\u1ea5u ch\u1ea5m trong thao t\u00e1c l\u1ec7nh c\u0169ng c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea3ng k\u1ebft qu\u1ea3 b\u1ecb sai h\u1ebft. T\u01b0\u1edfng t\u01b0\u1ee3ng n\u1ebfu nh\u01b0 b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 k\u1ebft qu\u1ea3 r\u1ea5t l\u1edbn th\u00ec b\u1ea1n s\u1ebd g\u1eb7p r\u1eafc r\u1ed1i n\u1ebfu sau h\u1ebft.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea5t k\u1ef3 h\u00e0m n\u00e0o trong excel c\u0169ng c\u00f3 nh\u1eefng \u0111i\u1ec3m m\u00e0 b\u1ea1n c\u1ea7n l\u01b0u \u00fd; khi s\u1eed d\u1ee5ng v\u00e0 h\u00e0m countif c\u0169ng v\u1eady.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m countif v\u1edbi s\u1ed1 v\u00e0 chu\u1ed7i tham chi\u1ebfu trong excel thay v\u00ec l\u1eb7p l\u1ea1i thao t\u00e1c g\u00f5 v\u00e0o \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 ta c\u00f3 th\u1ec3 thay b\u1eb1ng 1 s\u1ed1 ho\u1eb7c tham chi\u1ebfu tr\u1ef1c ti\u1ebfp l\u00ean cell.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 r\u1ed7ng \u0111\u1ec3 lo\u1ea1i b\u1ecf b\u1eb1ng countif =COUNTIF(range,\u201d\u201d).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi c\u00e1c ph\u00e9p to\u00e1n so s\u00e1nh l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, b\u1eb1ng&#8230; Ch\u00fang ta s\u1ebd d\u00f9ng cho \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 v\u1edbi ph\u00e9p to\u00e1n n\u00e0y.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12416\" aria-describedby=\"caption-attachment-12416\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12416 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel.jpg\" alt=\"Nh\u1eefng l\u01b0u \u00fd v\u1ec1 h\u00e0m countif khi s\u1eed d\u1ee5ng\" width=\"600\" height=\"420\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-400x280.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12416\" class=\"wp-caption-text\">Nh\u1eefng l\u01b0u \u00fd v\u1ec1 h\u00e0m countif khi s\u1eed d\u1ee5ng<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Dcount_co_giong_voi_ham_countif_khong\"><\/span><b>H\u00e0m Dcount c\u00f3 gi\u1ed1ng v\u1edbi h\u00e0m countif kh\u00f4ng?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 d\u1eef li\u1ec7u trong excel; ki\u1ec3u d\u1ea1ng c\u1ee7a s\u1ed1 trong danh s\u00e1ch ho\u1eb7c c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c nhau. H\u00e0m dcount c\u00f9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m countif; v\u00ec c\u00f3 th\u1ec3 \u0111\u1ebfm d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng h\u00e0m dcount trong excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u trong excel; n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3 th\u00f4ng qua c\u00e1c tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng c\u00f3 s\u1eb5n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m dcount kh\u00e1 gi\u1ed1ng v\u1edbi c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m countif; tuy nhi\u00ean h\u00e0m dcount c\u00f3 th\u1ec3 th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c nhi\u1ec1u d\u1eef li\u1ec7u kh\u00e1c nhau h\u01a1n. Th\u00f4ng th\u01b0\u1eddng s\u1ebd d\u00f9ng cho c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f2n h\u00e0m countif th\u00ec c\u00f3 th\u1ec3 \u0111\u1ebfm 1 \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/span><\/p>\n<figure id=\"attachment_12415\" aria-describedby=\"caption-attachment-12415\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12415 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countiff-trong-excel-1-e1648165846348.jpg\" alt=\"H\u00e0m Dcount c\u00f3 gi\u1ed1ng v\u1edbi h\u00e0m countif kh\u00f4ng?\" width=\"600\" height=\"379\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countiff-trong-excel-1-e1648165846348.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countiff-trong-excel-1-e1648165846348-400x253.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12415\" class=\"wp-caption-text\">H\u00e0m Dcount c\u00f3 gi\u1ed1ng v\u1edbi h\u00e0m countif kh\u00f4ng?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"So_sanh_ham_countif_va_countifs_trong_excel\"><\/span><b>So s\u00e1nh h\u00e0m countif v\u00e0 countifs trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 2 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n gi\u1ed1ng nhau v\u1ec1 m\u1eb7t c\u00f4ng d\u1ee5ng tuy nhi\u00ean c\u00e1ch s\u1eed d\u1ee5ng l\u1ea1i kh\u00e1c nhau.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m countif d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm v\u1edbi 1 \u0111i\u1ec1u ki\u1ec7n c\u1ed1 \u0111\u1ecbnh =COUNTIF(range, criteria).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m countifs c\u0169ng l\u00e0 \u0111\u1ebfm d\u1eef li\u1ec7u tuy nhi\u00ean s\u1eed d\u1ee5ng h\u00e0m countif c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. =COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2] \u2026).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 2 h\u00e0m th\u00ec h\u00e0m countif d\u1ec5 s\u1eed d\u1ee5ng v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n nhanh v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n countif. Th\u00f4ng th\u01b0\u1eddng khi s\u1eed d\u1ee5ng ng\u01b0\u1eddi d\u00f9ng s\u1ebd k\u1ebft h\u1ee3p h\u00e0m countifs v\u1edbi bi\u1ec3u th\u1ee9c AND; \u0111\u1ec3 th\u1ecfa m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n r\u1ed3i m\u1edbi ti\u1ebfn h\u00e0nh \u0111\u1ebfm \u00f4. Hai h\u00e0m kh\u00f4ng kh\u00e1c nhau nhi\u1ec1u v\u00ec th\u1ebf n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t r\u1ed9ng r\u00e3i trong ng\u00e0nh <a href=\"https:\/\/vi.wikipedia.org\/wiki\/Tin_h%E1%BB%8Dc\">tin h\u1ecdc<\/a> v\u00e0 gi\u00e1o d\u1ee5c.\u00a0<\/span><\/p>\n<figure id=\"attachment_12414\" aria-describedby=\"caption-attachment-12414\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12414 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-counif-trong-excel-2.jpg\" alt=\"So s\u00e1nh h\u00e0m countif v\u00e0 countifs trong excel\" width=\"600\" height=\"368\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-counif-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-counif-trong-excel-2-400x245.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12414\" class=\"wp-caption-text\">So s\u00e1nh h\u00e0m countif v\u00e0 countifs trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi nh\u1eefng th\u00f4ng tin v\u1ec1 <\/span><b>h\u00e0m countif trong excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 cung c\u1ea5p. Hy v\u1ecdng c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 nh\u1eefng hi\u1ec3u bi\u1ebft m\u1edbi v\u1ec1 excel c\u0169ng nh\u01b0 kh\u00e1m ph\u00e1 \u0111\u01b0\u1ee3c nh\u1eefng th\u00f4ng tin th\u00fa v\u1ecb v\u1ec1 ph\u1ea7n m\u1ec1m n\u00e0y. Ch\u00fac c\u00e1c b\u1ea1n s\u1edbm bi\u1ebft h\u1ebft v\u1ec1 c\u00e1c h\u00e0m trong excel \u0111\u1ec3 s\u1eed d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o nh\u1ea5t. \u0110\u1eebng qu\u00ean ti\u1ebfp t\u1ee5c \u1ee7ng h\u1ed9 ch\u00fang m\u00ecnh trong c\u00e1c s\u1ea3n ph\u1ea9m ti\u1ebfp theo nh\u00e9.\u00a0<\/span><\/p>\n<p><strong>Xem th\u00eam:\u00a0<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-countifs-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Countifs trong excel &#8211; B\u1eadt m\u00ed c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><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><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\">\u0110\u1ebfm t\u1eeb trong Word | H\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Th\u1ebf gi\u1edbi to\u00e1n h\u1ecdc c\u00f3 th\u1ec3 n\u00f3i l\u00e0 v\u00f4 c\u00f9ng phong ph\u00fa v\u00e0 \u0111a d\u1ea1ng. C\u00e1c nh\u00e0 to\u00e1n h\u1ecdc uy\u00ean b\u00e1c \u0111\u00e3 t\u00ecm hi\u1ec3u ra c\u00e1c c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc gi\u00fap ch\u00fang ta t\u00ednh to\u00e1n nhanh h\u01a1n, c\u00f2n b\u00e2y gi\u1edd m\u00e1y m\u00f3c hi\u1ec7n \u0111\u1ea1i l\u1ea1i gi\u00fap ch\u00fang ta t\u00ednh lu\u00f4n c\u00f4ng th\u1ee9c \u0111\u00f3 m\u00e0 kh\u00f4ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12419,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12407","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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?<\/title>\n<meta name=\"description\" content=\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc\" \/>\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-countif-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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-countif-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-23T23:53:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T09:01:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\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=\"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\/ham-countif-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc\",\"datePublished\":\"2022-11-23T23:53:45+00:00\",\"dateModified\":\"2022-12-08T09:01:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\"},\"wordCount\":1712,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\",\"name\":\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg\",\"datePublished\":\"2022-11-23T23:53:45+00:00\",\"dateModified\":\"2022-12-08T09:01:16+00:00\",\"description\":\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg\",\"width\":600,\"height\":338,\"caption\":\"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-countif-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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc\"}]},{\"@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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?","description":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc","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-countif-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?","og_description":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc","og_url":"https:\/\/teky.edu.vn\/blog\/ham-countif-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-23T23:53:45+00:00","article_modified_time":"2022-12-08T09:01:16+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.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":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc","datePublished":"2022-11-23T23:53:45+00:00","dateModified":"2022-12-08T09:01:16+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/"},"wordCount":1712,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/","name":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg","datePublished":"2022-11-23T23:53:45+00:00","dateModified":"2022-12-08T09:01:16+00:00","description":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 th\u00f4ng tin chi ti\u1ebft m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n \u0111\u1ecdc","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-countif-trong-excel-5.jpg","width":600,"height":338,"caption":"H\u00e0m countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc?"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-countif-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 countif trong excel c\u00f3 nh\u1eefng t\u00e1c d\u1ee5ng g\u00ec trong to\u00e1n h\u1ecdc"}]},{"@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\/12407","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=12407"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12407\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12419"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}