{"id":1415,"date":"2020-09-30T20:15:15","date_gmt":"2020-09-30T13:15:15","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1415"},"modified":"2020-10-01T11:19:51","modified_gmt":"2020-10-01T04:19:51","slug":"ham-dem-co-dieu-kien","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-dem-co-dieu-kien\/","title":{"rendered":"H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n: H\u00e0m COUNTIF V\u00e0 COUNTIFS Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1415\" class=\"elementor elementor-1415\">\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-7eb4a2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7eb4a2e\" 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-48127ec\" data-id=\"48127ec\" 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-e5f05fa elementor-widget elementor-widget-text-editor\" data-id=\"e5f05fa\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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\u00e0m COUNTIF v\u00e0 COUNTIFS l\u00e0 c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t c\u1ee7a 2 h\u00e0m n\u00e0y l\u00e0 \u1edf s\u1ed1 l\u01b0\u1ee3ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">H\u00e0m COUNTIF trong Excel l\u00e0 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t, c\u00f2n h\u00e0m COUNTIFS trong Excel c\u00f3 th\u1ec3 \u0111\u1ebfm t\u1edbi 127 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIFS v\u00e0 COUNTIF v\u1edbi to\u00e1n t\u1eed logic AND v\u00e0 OR v\u00e0 c\u00e1c v\u00ed d\u1ee5 h\u00e0m \u0111\u1ebfm trong Excel.<\/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-99390a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"99390a5\" 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-f6f6537\" data-id=\"f6f6537\" 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-1da49ee elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"1da49ee\" 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-bb85fb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb85fb7\" 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-dbdedc7\" data-id=\"dbdedc7\" 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-98d8e5f elementor-widget elementor-widget-heading\" data-id=\"98d8e5f\" 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-09b580d2-7fff-866f-e358-d1ff0c3e2b02\"><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, C\u00e1ch D\u00f9ng H\u00e0m COUNTIF V\u00e0 COUNTIFS<\/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-cb11011 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb11011\" 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-d2e24b0\" data-id=\"d2e24b0\" 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-ab18e76 elementor-widget elementor-widget-text-editor\" data-id=\"ab18e76\" 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.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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\u00e0m \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIF c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=COUNTIF(range, criteria)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">L\u1ec7nh COUNTIFS h\u00e0m \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2] \u2026)<\/span><\/p><p><span style=\"color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p><span style=\"color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">T<\/span><span style=\"color: #000000; font-family: Arial; font-size: 12pt; text-align: justify; white-space: pre-wrap;\">rong \u0111\u00f3:<\/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-ac4ae99 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ac4ae99\" 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-ed1bc4b\" data-id=\"ed1bc4b\" 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-f21f736 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"f21f736\" 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-10587963-7fff-8bb8-511a-ce0647c9e3b1\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Range l\u00e0 c\u00e1c ph\u1ea1m vi c\u1ea7n \u0111\u00e1nh gi\u00e1 \u0111i\u1ec1u ki\u1ec7n, v\u1edbi h\u00e0m COUNTIFS th\u00ec c\u00e1c criteria_range ph\u1ea3i c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t v\u1edbi ph\u1ea1m vi \u0111\u1ea7u ti\u00ean criteria_range1.<\/span><\/span><br><span id=\"docs-internal-guid-393f4f5c-7fff-a1ae-62f2-ea8bfd1463c5\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m COUNTIFS c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 d\u1eef li\u1ec7u li\u1ec1n k\u1ec1 v\u00e0 kh\u00f4ng li\u1ec1n k\u1ec1.<\/span><\/span><br><\/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-3bb84b93-7fff-cc4a-2235-a141db48f776\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Criteria: \u0110i\u1ec1u ki\u1ec7n\/ ti\u00eau ch\u00ed l\u00e0 s\u1ed1\/ bi\u1ec3u th\u1ee9c\/ tham chi\u1ebfu \u00f4 ho\u1eb7c v\u0103n b\u1ea3n. Vi\u0301 du\u0323: ti\u00eau ch\u00ed c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb l\u00e0 1, \"&gt;1\", A1, \"ta\u0301o\".<\/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-388d16a0-7fff-e79f-a316-eda405798520\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Bi\u1ec3u th\u1ee9c so s\u00e1nh: so s\u00e1nh v\u1edbi s\u1ed1 \u201c&lt;=5\u201d, so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4 c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u n\u1ed1i \u201c&gt;=\u201d &amp; A1.<\/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-858c79d6-7fff-f9f2-f5f4-af73ee5c352e\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u1edbi criteria l\u00e0 v\u0103n b\u1ea3n: kh\u00f4ng ph\u00e2n bi\u1ec7t vi\u1ebft hoa vi\u1ebft th\u01b0\u1eddng, v\u00ed d\u1ee5 \u201ct\u00e1o\u201d, \u201cT\u00e1o\u201d, \u201cT\u00c1o\u201d \u0111\u1ec1u nh\u01b0 nhau trong c\u00f4ng th\u1ee9c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\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-17a40617-7fff-1c8e-b120-904cbcc54810\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 ng\u00e0y th\u00e1ng n\u0103m, c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp ng\u00e0y th\u00e1ng n\u0103m (dd\/mm\/yyyy hay mm\/dd\/yyyy ho\u1eb7c c\u00fa ph\u00e1p kh\u00e1c t\u00f9y v\u00e0o c\u00e0i \u0111\u1eb7t trong m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n) ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn ng\u00e0y h\u1ee3p l\u1ec7 trong m\u1ed9t \u00f4 kh\u00e1c ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m DATE v\u1edbi c\u00fa ph\u00e1p =DATE(year, month, day).<\/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-30d5170 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"30d5170\" 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-1f0806a\" data-id=\"1f0806a\" 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-8be8a74 elementor-widget elementor-widget-heading\" data-id=\"8be8a74\" 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-9f38e36e-7fff-86cb-5b2c-2401c803bec1\"><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, C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m COUNTIFS Thay Th\u1ebf H\u00e0m COUNTIF K\u1ebft H\u1ee3p H\u00e0m AND<\/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-672795e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"672795e\" 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-45efdd5\" data-id=\"45efdd5\" 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-eaeef59 elementor-widget elementor-widget-text-editor\" data-id=\"eaeef59\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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\u1edbi h\u00e0m COUNTIF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, \u0111\u1ec3 \u0111\u01a1n gi\u1ea3n khi vi\u1ebft c\u00f4ng th\u1ee9c, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m COUNTIFS.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u1ea3n ch\u1ea5t h\u00e0m COUNTIFS l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a nhi\u1ec1u h\u00e0m \u0111\u1ebfm COUNTIF v\u00e0 bi\u1ec3u th\u1ee9c logic AND. Khi t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n th\u00ec h\u00e0m COUNTIFS m\u1edbi \u0111\u1ebfm s\u1ed1 \u00f4 trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ch\u00ednh v\u00ec v\u1eady, c\u1ea7n l\u01b0u \u00fd trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ea7n \u0111\u1ebfm \u00f4 th\u1ecfa m\u00e3n 1 trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (bi\u1ec3u th\u1ee9c logic OR): d\u00f9 c\u00f3 \u0111\u1ebfm c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0ng kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIFS m\u00e0 ph\u1ea3i t\u00ednh t\u1ed5ng nhi\u1ec1u h\u00e0m COUNTIF &#8211; b\u1ea1n \u0111\u1ecdc vui l\u00f2ng chuy\u1ec3n \u0111\u1ebfn m\u1ee5c 3 \u0111\u1ec3 t\u00ecm hi\u1ec3u v\u00ed d\u1ee5 chi ti\u1ebft.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 \u0111\u01a1n h\u00e0ng c\u00f3 s\u1ea3n ph\u1ea9m l\u00e0 \u00e1o s\u01a1 mi \u0111\u1ed3ng th\u1eddi th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m b\u00e1n ra l\u1edbn h\u01a1n 5 chi\u1ebfc v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 8 chi\u1ebfc, s\u1eed d\u1ee5ng h\u00e0m COUNTIFS v\u1edbi 3 c\u1ee5m range\/ criteria s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=COUNTIFS(A4:A16,&#8221;\u00e1o s\u01a1 mi&#8221;,B4:B16,&#8221;&lt;=8&#8243;)<\/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-8d40cac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d40cac\" 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-2469984\" data-id=\"2469984\" 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-89fe4a4 elementor-widget elementor-widget-image\" data-id=\"89fe4a4\" 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-dem-co-dieu-kien-dung-ham-countifs-dem-2-dieu-kien-ket-hop-nam-trong-khoang-so.png\" title=\"ham-dem-co-dieu-kien-dung-ham-countifs-dem-2-dieu-kien-ket-hop-nam-trong-khoang-so\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m COUNTIFS Thay Th\u1ebf H\u00e0m COUNTIF K\u1ebft H\u1ee3p H\u00e0m AND - H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n\" \/>\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-d40d99a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d40d99a\" 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-b06e5a0\" data-id=\"b06e5a0\" 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-4a3cea5 elementor-widget elementor-widget-text-editor\" data-id=\"4a3cea5\" 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-8d797ec9-7fff-33da-96e6-3c6e78dd2d2b\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 tr\u00ean, d\u00f9 criteria_range2 v\u00e0 criteria_range3 c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u00f3 c\u00f9ng ph\u1ea1m vi nh\u01b0ng b\u1ea1n kh\u00f4ng th\u1ec3 r\u00fat g\u1ecdn c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n AND thay th\u1ebf cho criteria 2 v\u00e0 3. M\u1ed7i criteria ph\u1ea3i \u0111\u01b0\u1ee3c \u0111i c\u00f9ng ph\u1ea1m vi t\u01b0\u01a1ng \u1ee9ng criteria_range.<\/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-6e89d12 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e89d12\" 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-fb4459b\" data-id=\"fb4459b\" 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-8062362 elementor-widget elementor-widget-heading\" data-id=\"8062362\" 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-39a99d87-7fff-877f-9590-7f1d2a6da01f\"><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, C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n V\u1edbi \u0110i\u1ec1u Ki\u1ec7n Or<\/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-8ffce7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ffce7d\" 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-a32b6e9\" data-id=\"a32b6e9\" 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-4e7b3cc elementor-widget elementor-widget-text-editor\" data-id=\"4e7b3cc\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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;\">B\u1ea1n kh\u00f4ng th\u1ec3 \u0111\u1eb7t h\u00e0m OR l\u00e0m criteria trong h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n COUNTIF v\u00e0 COUNTIFS.<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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;\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 t\u00ednh th\u1ecfa m\u00e3n 1 trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, t\u1ee9c l\u00e0 d\u1ef1a tr\u00ean logic OR, b\u1ea1n n\u00ean d\u00f9ng ph\u00e9p c\u1ed9ng trong Excel \u0111\u1ec3 c\u1ed9ng nhi\u1ec1u h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi nhau.<\/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-fe26de2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fe26de2\" 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-f435c48\" data-id=\"f435c48\" 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-84ccc51 elementor-widget elementor-widget-heading\" data-id=\"84ccc51\" 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-97c9ca62-7fff-0fff-aeec-cb203c54fa8a\"><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;\">3.1, H\u00e0m COUNTIF C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Logic OR (Ho\u1eb7c\/ Th\u1ecfa M\u00e3n 1 Trong C\u00e1c \u0110i\u1ec1u Ki\u1ec7n)<\/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-a3c977a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3c977a\" 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-9ef2df7\" data-id=\"9ef2df7\" 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-0694067 elementor-widget elementor-widget-text-editor\" data-id=\"0694067\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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;\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng trong tr\u1ea1ng th\u00e1i \u201cComplete\u201d ho\u1eb7c \u201cIn progress\u201d, b\u1ea1n ch\u1ec9 c\u1ea7n vi\u1ebft 2 c\u00f4ng th\u1ee9c COUNTIF b\u00ecnh th\u01b0\u1eddng v\u00e0 c\u1ed9ng ch\u00fang l\u1ea1i:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=COUNTIF($D$4:$D$19,&#8221;In Progess&#8221;) + COUNTIF($D$4:$D$19,&#8221;Complete&#8221;)<\/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-ba1572f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ba1572f\" 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-feedcd5\" data-id=\"feedcd5\" 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-396aaef elementor-widget elementor-widget-image\" data-id=\"396aaef\" 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-dem-co-dieu-kien-dung-ham-countif-dem-2-dieu-kien-or.png\" title=\"ham-dem-co-dieu-kien-dung-ham-countif-dem-2-dieu-kien-or\" alt=\"H\u00e0m COUNTIF C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Logic OR (Ho\u1eb7c\/ Th\u1ecfa M\u00e3n 1 Trong C\u00e1c \u0110i\u1ec1u Ki\u1ec7n)- h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n\" \/>\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-585f2ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"585f2ab\" 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-51562d3\" data-id=\"51562d3\" 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-66989ad elementor-widget elementor-widget-heading\" data-id=\"66989ad\" 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-847de6f3-7fff-1912-ef9d-972ce204572b\"><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;\">3.2, H\u00e0m COUNTIFS C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Logic OR<\/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-57c5a90 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"57c5a90\" 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-4567dce\" data-id=\"4567dce\" 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-17aa8a0 elementor-widget elementor-widget-text-editor\" data-id=\"17aa8a0\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 tr\u01b0\u1eddng h\u1ee3p ch\u1ee9a nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m COUNTIFS thay v\u00ec COUNTIF.<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-77cf7059-7fff-013d-db6a-38974b815463\"><span style=\"font-size: 12pt; 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: \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng s\u1ea3n ph\u1ea9m \u00c1o thun trong tr\u1ea1ng th\u00e1i \u201cCancelled\u201d ho\u1eb7c \u201cpending\u201d, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n 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-8603ca3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8603ca3\" 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-923e0a2\" data-id=\"923e0a2\" 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-689af2f elementor-widget elementor-widget-image\" data-id=\"689af2f\" 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-dem-co-dieu-kien-dung-ham-countifs-dem-2-dieu-kien-or.png\" title=\"ham-dem-co-dieu-kien-dung-ham-countifs-dem-2-dieu-kien-or\" alt=\"H\u00e0m COUNTIFS C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Logic OR (Ho\u1eb7c\/ Th\u1ecfa M\u00e3n 1 Trong C\u00e1c \u0110i\u1ec1u Ki\u1ec7n) h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n\" \/>\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-5d98cbf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d98cbf\" 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-54b45bf\" data-id=\"54b45bf\" 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-c0a40d9 elementor-widget elementor-widget-text-editor\" data-id=\"c0a40d9\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 v\u00e0 COUNTIFS l\u00e0 c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i.&nbsp;<\/span><\/p>\n<p><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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;\">\u0110\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m COUNTIF v\u00e0 COUNTIFS t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 \u1ee9ng d\u1ee5ng, c\u00e1c b\u1ea1n \u0111\u00f3n \u0111\u1ecdc:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m COUNTIF<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\n<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">S\u1eed d\u1ee5ng <\/span><\/span><a href=\"https:\/\/hoctin.vn\/ham-countif-nang-cao\/\" target=\"_blank\">h\u00e0m COUNTIF n\u00e2ng cao<\/a><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> trong 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&#8230;<\/span><\/span><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">H\u00e0m COUNTIFS<\/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\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>H\u00e0m COUNTIF v\u00e0 COUNTIFS l\u00e0 c\u00e1c h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t c\u1ee7a 2 h\u00e0m n\u00e0y l\u00e0 \u1edf s\u1ed1 l\u01b0\u1ee3ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm. H\u00e0m COUNTIF trong Excel l\u00e0 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t, &#8230; <a title=\"H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n: H\u00e0m COUNTIF V\u00e0 COUNTIFS Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-dem-co-dieu-kien\/\">Read more <span class=\"screen-reader-text\">H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n: H\u00e0m COUNTIF V\u00e0 COUNTIFS Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[34,54],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1415"}],"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=1415"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1415\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1436"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}