{"id":864,"date":"2020-09-04T14:35:35","date_gmt":"2020-09-04T07:35:35","guid":{"rendered":"https:\/\/hoctin.vn\/?p=864"},"modified":"2020-09-04T14:45:23","modified_gmt":"2020-09-04T07:45:23","slug":"ham-countif-nang-cao","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-countif-nang-cao\/","title":{"rendered":"\u1ee8ng D\u1ee5ng S\u1eed D\u1ee5ng H\u00e0m COUNTIF N\u00e2ng Cao Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"864\" class=\"elementor elementor-864\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbc8bb4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbc8bb4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-170d3df\" data-id=\"170d3df\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5b9e350 elementor-widget elementor-widget-text-editor\" data-id=\"5b9e350\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <\/span><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\">h\u00e0m COUNTIF\u00a0<\/a><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho \u0111i\u1ec1u ki\u1ec7n l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u1ede b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd ti\u1ebfp t\u1ee5c gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1c \u1ee9ng d\u1ee5ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, b\u1ea3ng ch\u1ea5m c\u00f4ng, ki\u1ec3m tra kh\u00e1ch h\u00e0ng th\u00e2n thi\u1ebft, \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, \u0111\u1ebfm trong nhi\u1ec1u d\u1ea3i \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">C\u00fa ph\u00e1p h\u00e0m COUNTIF:<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; font-weight: bold; text-align: justify; white-space: pre-wrap;\">=COUNTIF(range, criteria)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Range: Ph\u1ea1m vi ch\u1ee9a c\u00e1c \u00f4 c\u1ea7n \u0111\u1ebfm<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Criteria: Ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m so\u00e1t \u00f4 n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ti\u00eau ch\u00ed c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, ng\u00e0y, v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t ph\u00e9p so s\u00e1nh.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m COUNTIF ch\u1ec9 c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-218dc43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"218dc43\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9a01cf4\" data-id=\"9a01cf4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c21d16 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"0c21d16\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f145ed6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f145ed6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-13d5528\" data-id=\"13d5528\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-af99a69 elementor-widget elementor-widget-heading\" data-id=\"af99a69\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-eadcd4b7-7fff-3068-0d05-5cae37643652\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, D\u00f9ng H\u00e0m COUNTIF \u0110\u1ebfm S\u1ed1 Ng\u00e0y L\u00e0m Vi\u1ec7c Tr\u00ean B\u1ea3ng Ch\u1ea5m C\u00f4ng<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9871004 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9871004\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-82f71f6\" data-id=\"82f71f6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ea54a9e elementor-widget elementor-widget-text-editor\" data-id=\"ea54a9e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-08282d4e-7fff-7237-9fd7-f88b9bf3cd6f\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u1ee8ng d\u1ee5ng h\u00e0m COUNTIF v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7a33362 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a33362\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-887dc43\" data-id=\"887dc43\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-be80d09 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"be80d09\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Nguy\u00ean t\u1eafc: \u0111\u1eb7t ra c\u00e1c k\u00fd hi\u1ec7u \u0111\u1ea1i di\u1ec7n \u0111\u1ec3 theo d\u00f5i t\u00ecnh tr\u1ea1ng l\u00e0m vi\u1ec7c c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng, v\u00ed d\u1ee5: \u0110- l\u00e0m \u0111\u1ee7 ng\u00e0y, N- l\u00e0m n\u1eeda ng\u00e0y, \u2026<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-49b4109d-7fff-3a98-6f1c-83e3257c596f\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 ng\u00e0y l\u00e0m \u0111\u1ee7 8h\/ ng\u00e0y, s\u1ed1 ng\u00e0y l\u00e0m n\u1eeda ng\u00e0y 4h\/ ng\u00e0y r\u1ed3i c\u1ed9ng l\u1ea1i ra s\u1ed1 ng\u00e0y l\u00e0m vi\u1ec7c b\u1eb1ng \u0110+ N\/2<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-bc5b5b0b-7fff-50f9-a0cd-54cacb9ca6cf\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">C\u00f3 th\u1ec3 theo d\u00f5i nh\u1eefng ng\u00e0y ngh\u1ec9 c\u00f3 ph\u00e9p v\u00e0 kh\u00f4ng ph\u00e9p \u0111\u1ec3 ki\u1ec3m tra k\u1ef7 lu\u1eadt v\u00e0 tu\u00e2n th\u1ee7 n\u1ed9i quy c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng: \u0111\u1ebfm NP- ngh\u1ec9 c\u00f3 ph\u00e9p, KP- ngh\u1ec9 kh\u00f4ng ph\u00e9p.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43b5ccb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43b5ccb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7dfc0b2\" data-id=\"7dfc0b2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5b0af3 elementor-widget elementor-widget-text-editor\" data-id=\"a5b0af3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-ed246c14-7fff-ad64-53fe-a02198ba11db\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 m\u1ed9t b\u1ea3ng ch\u1ea5m c\u00f4ng th\u00e1ng nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b2c492d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b2c492d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25a9d46\" data-id=\"25a9d46\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d7fdcc8 elementor-widget elementor-widget-image\" data-id=\"d7fdcc8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/bang-cham-cong-su-dung-ham-countif.png\" title=\"bang-cham-cong-su-dung-ham-countif\" alt=\"D\u00f9ng H\u00e0m COUNTIF \u0110\u1ebfm S\u1ed1 Ng\u00e0y L\u00e0m Vi\u1ec7c Tr\u00ean B\u1ea3ng Ch\u1ea5m C\u00f4ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6e467d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e467d0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-eeb5e2b\" data-id=\"eeb5e2b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-12e55f2 elementor-widget elementor-widget-text-editor\" data-id=\"12e55f2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIF \u1edf h\u00ecnh minh h\u1ecda tr\u00ean, c\u00f3 th\u1ec3 th\u1ea5y ch\u1ecb Nguy\u1ec5n Th\u1ecb Minh \u0111i l\u00e0m \u0111\u1ee7 18 ng\u00e0y v\u00e0 3 n\u1eeda ng\u00e0y, c\u00e1c ng\u00e0y c\u00f2n l\u1ea1i kh\u00f4ng ngh\u1ec9. Nh\u01b0 v\u1eady ng\u01b0\u1eddi lao \u0111\u1ed9ng n\u00e0y \u0111\u00e3 l\u00e0m 18+ 3\/2 = 19.5 ng\u00e0y trong th\u00e1ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">T\u00f9y v\u00e0o quy \u0111\u1ecbnh ng\u00e0y c\u00f4ng l\u00e0m vi\u1ec7c c\u1ee7a doanh nghi\u1ec7p m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh k\u00fd hi\u1ec7u v\u00e0 c\u00e1ch t\u00ednh ng\u00e0y l\u00e0m vi\u1ec7c trong b\u1ea3ng ch\u1ea5m c\u00f4ng.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-246b691 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"246b691\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16c99b5\" data-id=\"16c99b5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f406478 elementor-widget elementor-widget-heading\" data-id=\"f406478\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-8a66d6c4-7fff-d583-b11f-da7ce44f6d78\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, S\u1eed D\u1ee5ng H\u00e0m COUNTIF \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n \u0110\u1ec3 \u0110\u1ebfm S\u1ed1 L\u1ea7n Mua H\u00e0ng C\u1ee7a Kh\u00e1ch H\u00e0ng<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ae65d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ae65d5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-601c3db\" data-id=\"601c3db\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f5698c elementor-widget elementor-widget-text-editor\" data-id=\"4f5698c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u1ea7u h\u1ebft th\u1ed1ng k\u00ea mua\/ b\u00e1n h\u00e0ng h\u00f3a hi\u1ec7n t\u1ea1i c\u1ee7a c\u00e1c c\u00f4ng ty \u0111\u1ec1u \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean ph\u1ea7n m\u1ec1m t\u1ef1 \u0111\u1ed9ng, tuy nhi\u00ean vi\u1ec7c theo d\u00f5i b\u1eb1ng file b\u1ea3ng t\u00ednh Excel b\u00ean ngo\u00e0i v\u1eabn l\u00e0 m\u1ed9t trong nh\u1eefng vi\u1ec7c c\u1ea7n thi\u1ebft c\u1ee7a k\u1ebf to\u00e1n\/ nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng \u0111\u1ec3 backup d\u1eef li\u1ec7u.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n mua h\u00e0ng c\u1ee7a kh\u00e1ch h\u00e0ng trong ng\u00e0y, trong th\u00e1ng, v.v\u2026<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 c\u00f3 th\u1ed1ng k\u00ea mua h\u00e0ng m\u1ed9t ng\u00e0y c\u1ee7a c\u00f4ng ty. C\u1ea7n \u0111\u1ebfm s\u1ed1 l\u1ea7n mua h\u00e0ng c\u1ee7a t\u1eebng kh\u00e1ch h\u00e0ng:<\/span><\/p><p>\u00a0<\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Range: v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm l\u00e0 C\u1ed9t \u201cT\u00ean kh\u00e1ch h\u00e0ng\u201d<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Criteria: \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm, l\u00e0 t\u00ean c\u1ee7a t\u1eebng kh\u00e1ch h\u00e0ng.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-668f449 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"668f449\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0ca9104\" data-id=\"0ca9104\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fe469f2 elementor-widget elementor-widget-image\" data-id=\"fe469f2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-ham-countif-trong-Excel-de-dem-so-lan-mua-hang-cua-khach-hang.png\" title=\"su-dung-ham-countif-trong-Excel-de-dem-so-lan-mua-hang-cua-khach-hang\" alt=\"S\u1eed D\u1ee5ng H\u00e0m COUNTIF \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n \u0110\u1ec3 \u0110\u1ebfm S\u1ed1 L\u1ea7n Mua H\u00e0ng C\u1ee7a Kh\u00e1ch H\u00e0ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d7e3443 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7e3443\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7815c49\" data-id=\"7815c49\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b982bc2 elementor-widget elementor-widget-text-editor\" data-id=\"b982bc2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1ea1i \u00f4 F4, c\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 l\u1ea7n mua h\u00e0ng c\u1ee7a kh\u00e1ch h\u00e0ng c\u00f3 t\u00ean t\u1ea1i E4 l\u00e0:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=COUNTIF($A$4:$A$13,E4).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u0110\u1ec3 copy c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 t\u1eeb F5 tr\u1edf \u0111i, ch\u1ec9 c\u1ea7n c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel $A$4:$A$13 l\u00e0 v\u00f9ng ch\u1ee9a t\u00ean kh\u00e1ch h\u00e0ng trong th\u1ed1ng k\u00ea mua h\u00e0ng.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6a4b455 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a4b455\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-57a96f0\" data-id=\"57a96f0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a241953 elementor-widget elementor-widget-heading\" data-id=\"a241953\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-03a1b998-7fff-6da3-c751-30fb82ce7cb4\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, \u0110\u1ebfm C\u00e1c Gi\u00e1 Tr\u1ecb Duy Nh\u1ea5t Trong M\u1ed9t Ph\u1ea1m Vi V\u1edbi H\u00e0m COUNTIF<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-365258b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"365258b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-007053f\" data-id=\"007053f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d03d21c elementor-widget elementor-widget-text-editor\" data-id=\"d03d21c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-c9daff64-7fff-a27d-ede3-55775f98a39c\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u1ee8ng d\u1ee5ng h\u00e0m \u0111\u1ebfm d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng hay \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi \u00f4 Excel:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-16d0cb8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16d0cb8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b6633ce\" data-id=\"b6633ce\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d0eaa2e elementor-widget elementor-widget-heading\" data-id=\"d0eaa2e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-398e2a5f-7fff-ced8-f60c-b2c92b314c83\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">C\u00e1ch 1: S\u1eed D\u1ee5ng Nhi\u1ec1u H\u00e0m COUNTIF V\u00e0 C\u1ed9t Ph\u1ee5<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-92293cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"92293cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-94fc46a\" data-id=\"94fc46a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cef7bb9 elementor-widget elementor-widget-text-editor\" data-id=\"cef7bb9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 m\u1ed9t danh s\u00e1ch nhi\u1ec1u lo\u1ea1i qu\u1ea3 trong \u0111\u00f3 c\u00f3 m\u1ed9t s\u1ed1 qu\u1ea3 tr\u00f9ng l\u1eb7p xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n trong danh s\u00e1ch (V\u00ed d\u1ee5 Cam, Xo\u00e0i xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 2 l\u1ea7n) nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 lo\u1ea1i qu\u1ea3 ri\u00eang bi\u1ec7t (ki\u1ec3m tra danh s\u00e1ch c\u00f3 bao nhi\u00eau lo\u1ea1i qu\u1ea3), t\u1ea1i c\u1ed9t B, hoctin.vn \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a lo\u1ea1i qu\u1ea3 \u0111\u00f3 trong khu v\u1ef1c t\u1eeb \u0111\u1ea7u danh s\u00e1ch \u0111\u1ebfn d\u00f2ng \u0111ang \u0111\u1ebfm.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 s\u1ed1 lo\u1ea1i qu\u1ea3 \u1edf \u00f4 B20 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 \u1edf c\u1ed9t B c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 1, chi ti\u1ebft nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70144a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70144a5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3229551\" data-id=\"3229551\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3cfda2f elementor-widget elementor-widget-image\" data-id=\"3cfda2f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ham-countif-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi.png\" title=\"ham-countif-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi\" alt=\"\u0110\u1ebfm C\u00e1c Gi\u00e1 Tr\u1ecb Duy Nh\u1ea5t Trong M\u1ed9t Ph\u1ea1m Vi V\u1edbi H\u00e0m COUNTIF B\u1eb1ng C\u00e1ch S\u1eed D\u1ee5ng Nhi\u1ec1u H\u00e0m COUNTIF V\u00e0 C\u1ed9t Ph\u1ee5\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d95c26a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d95c26a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e9ad84e\" data-id=\"e9ad84e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7ace0e9 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7ace0e9\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-6742cb6e-7fff-e0fa-ecf8-0d13f9eb21d4\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u1ea1i c\u1ed9t B: x\u00e9t ri\u00eang Cam: c\u00f4ng th\u1ee9c \u1edf c\u1ed9t B nh\u1eb1m \u0111\u1ebfm Cam theo th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-a3b65a08-7fff-f430-344d-868100c0e8a4\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u00d4 B5 tr\u1ea3 v\u1ec1 1 l\u00e0 s\u1ed1 Cam t\u1eeb \u0111\u1ea7u danh s\u00e1ch \u0111\u1ebfn A5 t\u01b0\u01a1ng \u1ee9ng<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u00d4 B9 tr\u1ea3 v\u1ec1 2 l\u00e0 s\u1ed1 Cam t\u1eeb \u0111\u1ea7u danh s\u00e1ch \u0111\u1ebfn A9 t\u01b0\u01a1ng \u1ee9ng...<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-36cc861b-7fff-2c4b-57fe-fb99653cb0e7\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u01b0\u01a1ng t\u1ef1 \u0111\u1ebfn \u00d4 B17 tr\u1ea3 v\u1ec1 4 l\u00e0 s\u1ed1 Cam t\u1eeb \u0111\u1ea7u danh s\u00e1ch \u0111\u1ebfn A17<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e5f99cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e5f99cc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8cf8b87\" data-id=\"8cf8b87\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4a24644 elementor-widget elementor-widget-text-editor\" data-id=\"4a24644\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ed9t B c\u00f3 t\u00e1c d\u1ee5ng lo\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb qu\u1ea3 xu\u1ea5t hi\u1ec7n t\u1eeb l\u1ea7n th\u1ee9 2 tr\u1edf \u0111i (c\u00f3 gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t B &gt;2).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">S\u1ed1 lo\u1ea1i qu\u1ea3 trong danh s\u00e1ch l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a l\u1ec7nh \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb b\u1eb1ng 1 \u1edf c\u1ed9t B (\u0111\u1ebfm l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00e1c lo\u1ea1i qu\u1ea3).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c591aa0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c591aa0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1cbd372\" data-id=\"1cbd372\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab7210e elementor-widget elementor-widget-heading\" data-id=\"ab7210e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-466ec1ad-7fff-8210-4ebe-2227de664d40\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">C\u00e1ch 2: \u0110\u1ebfm Lo\u1ea1i B\u1ecf C\u00e1c Gi\u00e1 Tr\u1ecb Gi\u1ed1ng Nhau B\u1eb1ng C\u00e1ch K\u1ebft H\u1ee3p H\u00e0m COUNTIF v\u00e0 SUMPRODUCT<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aba4223 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aba4223\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6fcd2ed\" data-id=\"6fcd2ed\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4397fb0 elementor-widget elementor-widget-text-editor\" data-id=\"4397fb0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u01afu \u0111i\u1ec3m c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 kh\u00f4ng ph\u1ea3i th\u00eam c\u1ed9t ph\u1ee5 trong t\u00ednh to\u00e1n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u1ea3 tr\u01b0\u1eddng h\u1ee3p \u0111\u1ebfm \u00f4 tr\u1ed1ng l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 kh\u00f4ng \u0111\u1ebfm \u00f4 tr\u1ed1ng:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-219b8e1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"219b8e1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d1082b6\" data-id=\"d1082b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87c6fae elementor-widget elementor-widget-image\" data-id=\"87c6fae\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ham-countif-ket-hop-sumproduct-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi.png\" title=\"ham-countif-ket-hop-sumproduct-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi\" alt=\"\u0110\u1ebfm C\u00e1c Gi\u00e1 Tr\u1ecb Duy Nh\u1ea5t Trong M\u1ed9t Ph\u1ea1m Vi, \u0110\u1ebfm Lo\u1ea1i B\u1ecf C\u00e1c Gi\u00e1 Tr\u1ecb Gi\u1ed1ng Nhau B\u1eb1ng C\u00e1ch K\u1ebft H\u1ee3p H\u00e0m COUNTIF v\u00e0 SUMPRODUCT\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5bb5733 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5bb5733\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-91dc678\" data-id=\"91dc678\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5df03f2 elementor-widget elementor-widget-heading\" data-id=\"5df03f2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-93a79387-7fff-7eb4-2fb6-8d5a68929dba\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4, S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c M\u1ea3ng \u0110\u1ec3 D\u00f9ng H\u00e0m COUNTIF V\u1edbi D\u1ea3i \u00d4 Kh\u00f4ng Li\u1ec1n K\u1ec1<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7733d5a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7733d5a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4e24509\" data-id=\"4e24509\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63b436b elementor-widget elementor-widget-text-editor\" data-id=\"63b436b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; text-align: justify; white-space: pre-wrap;\">V\u1edbi c\u00e1c d\u1ea3i \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 m\u00e0 kh\u00f4ng th\u1ec3 nh\u1eadp chung l\u00e0m m\u1ed9t d\u1ea3i \u00f4 l\u1edbn, s\u1eed d\u1ee5ng nhi\u1ec1u l\u1ea7n h\u00e0m COUNTIF l\u00e0 c\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u kh\u00f4ng li\u00ean t\u1ee5c:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9cfb0f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9cfb0f5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2b6765c\" data-id=\"2b6765c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-30f9f50 elementor-widget elementor-widget-image\" data-id=\"30f9f50\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ket-hop-nhieu-ham-countif-voi-dai-o-khong-lien-nhau.png\" title=\"ket-hop-nhieu-ham-countif-voi-dai-o-khong-lien-nhau\" alt=\"V\u1edbi c\u00e1c d\u1ea3i \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 m\u00e0 kh\u00f4ng th\u1ec3 nh\u1eadp chung l\u00e0m m\u1ed9t d\u1ea3i \u00f4 l\u1edbn, s\u1eed d\u1ee5ng nhi\u1ec1u l\u1ea7n h\u00e0m COUNTIF l\u00e0 c\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u kh\u00f4ng li\u00ean t\u1ee5c\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dd23c2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd23c2f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-373041e\" data-id=\"373041e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-42cde95 elementor-widget elementor-widget-text-editor\" data-id=\"42cde95\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">M\u1ed9t c\u00e1ch kh\u00e1c kh\u00e1 hay nh\u01b0ng ph\u1ee9c t\u1ea1p h\u01a1n l\u00e0 s\u1eed d\u1ee5ng <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>k\u1ebft h\u1ee3p h\u00e0m SUM, INDIRECT V\u00c0 COUNTIF<\/b><\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m INDIRECT tham chi\u1ebfu t\u1edbi 1 v\u00f9ng th\u00f4ng qua vi\u1ec7c g\u1ecdi t\u00ean b\u1eb1ng m\u00f4\u0323t chu\u00f4\u0303i v\u0103n ba\u0309n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng h\u00e0m SUM m\u00e0 ch\u1ec9 s\u1eed d\u1ee5ng COUNTIF k\u1ebft h\u1ee3p h\u00e0m INDIRECT, k\u1ebft qu\u1ea3 c\u1ee7a v\u00ed d\u1ee5 sau s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 3, l\u00e0 s\u1ed1 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 10 trong m\u1ea3ng A5:A13 m\u00e0 kh\u00f4ng c\u1ed9ng k\u1ebft qu\u1ea3 \u1edf 2 m\u1ea3ng sau.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65c6ad2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65c6ad2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa21aa0\" data-id=\"fa21aa0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6f8395e elementor-widget elementor-widget-image\" data-id=\"6f8395e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ham-countif-voi-dai-o-khong-lien-nhau.png\" title=\"ham-countif-voi-dai-o-khong-lien-nhau\" alt=\"S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c M\u1ea3ng \u0110\u1ec3 D\u00f9ng H\u00e0m COUNTIF V\u1edbi D\u1ea3i \u00d4 Kh\u00f4ng Li\u1ec1n K\u1ec1\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6955ca3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6955ca3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-90cb277\" data-id=\"90cb277\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-18e4d5c elementor-widget elementor-widget-text-editor\" data-id=\"18e4d5c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 v\u00e0 \u1ee9ng d\u1ee5ng hay c\u1ee7a h\u00e0m COUNTIF n\u00e2ng cao trong Excel. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m COUNTIFS<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMIF<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\">H\u00e0m IF<\/a><br><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho \u0111i\u1ec1u ki\u1ec7n l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng. \u00a0 \u1ede b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd ti\u1ebfp t\u1ee5c gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1c \u1ee9ng d\u1ee5ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF &#8230; <a title=\"\u1ee8ng D\u1ee5ng S\u1eed D\u1ee5ng H\u00e0m COUNTIF N\u00e2ng Cao Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-countif-nang-cao\/\">Read more <span class=\"screen-reader-text\">\u1ee8ng D\u1ee5ng S\u1eed D\u1ee5ng H\u00e0m COUNTIF N\u00e2ng Cao Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[34],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/864"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/865"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}