{"id":522,"date":"2020-07-20T20:17:23","date_gmt":"2020-07-20T13:17:23","guid":{"rendered":"https:\/\/hoctin.vn\/?p=522"},"modified":"2020-11-03T02:34:25","modified_gmt":"2020-11-02T19:34:25","slug":"ham-sumif-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"522\" class=\"elementor elementor-522\">\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-6c15fc4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c15fc4\" 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-e1cf8a1\" data-id=\"e1cf8a1\" 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-30981f7 elementor-widget elementor-widget-text-editor\" data-id=\"30981f7\" 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\u00e0m SUMIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng trong Excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/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;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft nh\u1ea5t t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng c\u00f9ng c\u00e1c l\u01b0u \u00fd quan tr\u1ecdng khi \u00e1p d\u1ee5ng h\u00e0m t\u1ed5ng c\u00f3 \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-a8159b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a8159b2\" 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-7b1763a\" data-id=\"7b1763a\" 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-788e955 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"788e955\" 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-226a7fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"226a7fe\" 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-5df4b09\" data-id=\"5df4b09\" 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-851295f elementor-widget elementor-widget-heading\" data-id=\"851295f\" 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-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00fa Ph\u00e1p H\u00e0m SUMIF Trong Excel<\/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-26bea9f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"26bea9f\" 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-d921c8f\" data-id=\"d921c8f\" 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-f63f9e1 elementor-widget elementor-widget-text-editor\" data-id=\"f63f9e1\" 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;\">L\u1ec7nh SUMIF c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/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; font-weight: bold; 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; font-weight: bold; white-space: pre-wrap;\">=SUMIF(range,criteria,[sum_range])<\/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;\">Trong \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-1af3c26 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1af3c26\" 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-2e16578\" data-id=\"2e16578\" 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-33c8de0 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"33c8de0\" 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-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-92e92838-7fff-3695-5dcd-dc516ebe9e38\"><span style=\"font-size: 11pt; 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;\">Range:<\/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;\"> ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 m\u00e0 theo \u0111\u00f3 c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n, m\u1ea3ng ho\u1eb7c tham chi\u1ebfu c\u00f3 ch\u1ee9a s\u1ed1.<\/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-c8d614f2-7fff-58d2-23f2-0612ea663481\"><span style=\"font-size: 11pt; 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;\">Criteria:<\/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;\"> ti\u00eau ch\u00ed \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, bi\u1ec3u th\u1ee9c ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, kh\u00f4ng \u0111\u01b0\u1ee3c d\u00e0i h\u01a1n 255 k\u00fd t\u1ef1.<\/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-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Sum_range:<\/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;\"> c\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n.<\/span><\/span><br><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;\">N\u1ebfu kh\u00f4ng nh\u1eadp sum_range, h\u00e0m SUMIF m\u1eb7c \u0111\u1ecbnh s\u1eed d\u1ee5ng Range l\u00e0m Sum_range.<\/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-3a09fb1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a09fb1\" 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-d6111f8\" data-id=\"d6111f8\" 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-5dfbd76 elementor-widget elementor-widget-text-editor\" data-id=\"5dfbd76\" 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 minh h\u1ecda c\u1ea5u tr\u00fac h\u00e0m SUMIF:<\/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;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c m\u00e1y trong c\u1ed9t A, gi\u00e1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B v\u00e0 t\u00ecnh tr\u1ea1ng l\u1eafp \u0111\u1eb7t trong c\u1ed9t C.<\/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;\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 m\u00e1y \u0111\u00e3 l\u1eafp \u0111\u1eb7t xong v\u1edbi c\u00f4ng th\u1ee9c =SUMIF(C:C,&#8221;Yes&#8221;,B:B), trong \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-cb373c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb373c8\" 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-fd751ed\" data-id=\"fd751ed\" 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-9ddf475 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9ddf475\" 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-check-circle\"><\/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-c4cf5acf-7fff-6575-3adc-369ec2744673\"><span style=\"font-size: 11pt; 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;\">Range:<\/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;\"> C:C &gt;&gt; to\u00e0n b\u1ed9 c\u1ed9t C<\/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-circle\"><\/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-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Criteria:<\/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;\"> \u201cYes\u201d &gt;&gt; ti\u00eau ch\u00ed l\u00e0 c\u00e1c m\u00e1y \u0111\u00e3 l\u1eafp \u0111\u1eb7t xong \u1edf c\u1ed9t C<\/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-circle\"><\/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-24c46e35-7fff-afa6-ee71-345af4e5659a\"><span style=\"font-size: 11pt; 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;\">Sum_range:<\/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;\"> B:B &gt;&gt; to\u00e0n b\u1ed9 c\u1ed9t B, n\u1ebfu m\u00e1y c\u00f3 tr\u1ea1ng th\u00e1i t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t C l\u00e0 \u201cYes\u201d th\u00ec c\u1ed9ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t B v\u00e0o k\u1ebft qu\u1ea3 h\u00e0m.<\/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-eabfe21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eabfe21\" 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-84eadef\" data-id=\"84eadef\" 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-4b128a4 elementor-widget elementor-widget-image\" data-id=\"4b128a4\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien\" alt=\"H\u00e0m SUMIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng trong Excel 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-2f1eb32 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f1eb32\" 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-7f27d39\" data-id=\"7f27d39\" 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-ff5a5f5 elementor-widget elementor-widget-heading\" data-id=\"ff5a5f5\" 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: 700; font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, L\u01b0u \u00dd Khi S\u1eed D\u1ee5ng H\u00e0m SUMIF<\/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-73c5e9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"73c5e9e\" 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-545585b\" data-id=\"545585b\" 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-f8843db elementor-widget elementor-widget-heading\" data-id=\"f8843db\" 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-49dfa3c2-7fff-707e-0813-9914905bf0b6\"><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;\">2.1, L\u01b0u \u00dd V\u1edbi \u0110\u1ed1i S\u1ed1<\/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-047ae9a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"047ae9a\" 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-b8af4a4\" data-id=\"b8af4a4\" 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-2650053 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"2650053\" 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-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-b5df10f0-7fff-1b44-31d3-8908b6019683\"><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;\">K\u00fd hi\u1ec7u v\u0103n b\u1ea3n ho\u1eb7c to\u00e1n h\u1ecdc\/logic (v\u00ed d\u1ee5 =, +, -, \/, *, &gt;, &lt;) trong Criteria ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p (\"\"), t\u1ee9c l\u00e0 \"Invoice\", \u201c=100\u201d, \u201c&gt;100\u201d<\/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-af04505d-7fff-5393-8281-2710e28bd2c4\"><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 s\u1eed d\u1ee5ng K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong Criteria, d\u1ea5u * \u0111\u1ea1i di\u1ec7n cho 1 ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1, d\u1ea5u ? \u0111\u1ea1i di\u1ec7n cho 1 v\u00e0 ch\u1ec9 1 k\u00fd t\u1ef1. \u0110\u1ec3 t\u00ecm d\u1ea5u ch\u1ea5m h\u1ecfi ho\u1eb7c d\u1ea5u hoa th\u1ecb, h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u ng\u00e3 (~) trong d\u1ea5u h\u1ecfi ph\u00eda tr\u01b0\u1edbc ho\u1eb7c d\u1ea5u hoa th\u1ecb (ngh\u0129a l\u00e0 ~?, ~ *).<\/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-c2be607d-7fff-2947-a2a3-67fa4e5766f7\"><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;\">N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong Range v\u00e0 Sum_range l\u00e0 kh\u00e1c nhau, th\u00ec h\u00e0m SUMIF \u01b0u ti\u00ean s\u1eed d\u1ee5ng k\u00edch th\u01b0\u1edbc c\u1ee7a Range.<\/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;\">H\u00e0m SUMIF ch\u1ec9 h\u1ed7 tr\u1ee3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. S\u1eed d\u1ee5ng h\u00e0m SUMIFS cho nhi\u1ec1u \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<\/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-035961b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"035961b\" 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-d5a3042\" data-id=\"d5a3042\" 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-b83c9ad elementor-widget elementor-widget-heading\" data-id=\"b83c9ad\" 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;\"><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;\">2.2, T\u1ea1i Sao H\u00e0m SUMIF Kh\u00f4ng Ho\u1ea1t \u0110\u1ed9ng<\/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-3d1da5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d1da5d\" 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-776bba7\" data-id=\"776bba7\" 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-40aa281 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"40aa281\" 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-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-1c94c604-7fff-67f6-d76a-2d087e44285f\"><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;\">Criteria l\u00e0 bi\u1ec3u th\u1ee9c so s\u00e1nh v\u1edbi tham chi\u1ebfu \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng, v\u00ed d\u1ee5 \u201c&lt;\u201dA1, \u201c&lt;A1\u201d th\u00ec h\u00e0m SUMIF kh\u00f4ng cho k\u1ebft qu\u1ea3 ho\u1eb7c k\u1ebft qu\u1ea3 sai. \u0110\u1ecbnh d\u1ea1ng \u0111\u00fang: \"&lt;\"&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><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;\">H\u00e0m SUMIF tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t ph\u1ea1m vi trong m\u1ed9t file\/ b\u1ea3ng t\u00ednh \u0111\u00e3 \u0111\u00f3ng s\u1ebd d\u1eabn \u0111\u1ebfn l\u1ed7i #VALUE!. B\u1ea1n c\u1ea7n m\u1edf file \u0111\u00e3 \u0111\u00f3ng \u0111\u00f3 v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng.<\/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-0aab534 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0aab534\" 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-d4b9a11\" data-id=\"d4b9a11\" 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-ccb6d82 elementor-widget elementor-widget-heading\" data-id=\"ccb6d82\" 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;\"><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\u00e1c V\u00ed D\u1ee5 Minh H\u1ecda C\u00e1ch D\u00f9ng H\u00e0m SUMIF<\/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-f285eaf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f285eaf\" 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-2c489db\" data-id=\"2c489db\" 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-4069373 elementor-widget elementor-widget-heading\" data-id=\"4069373\" 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-a1c4b3b7-7fff-1e86-cda8-3e9701f75dac\"><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, Ti\u00eau Ch\u00ed T\u1eeb M\u1ed9t \u00d4 Kh\u00e1c<\/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-54099c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54099c7\" 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-9e0b671\" data-id=\"9e0b671\" 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-95b2a4b elementor-widget elementor-widget-text-editor\" data-id=\"95b2a4b\" 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\u00e0m Sum c\u00f3 \u0111i\u1ec1u ki\u1ec7n, hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m SUMIF c\u00f3 th\u1ec3 \u0111\u01b0a \u0111i\u1ec1u ki\u1ec7n t\u1eeb m\u1ed9t tham chi\u1ebfu \u00f4 kh\u00e1c ch\u1ee9 kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c Excel. Gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t \u00f4 kh\u00e1c n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o ti\u00eau ch\u00ed (Criteria) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p n\u1ed1i &amp;.<\/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;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m SUMIF tr\u1ea3 l\u1ea1i t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng b\u00e1n c\u1ee7a c\u00e1c M\u00e3 S\u1ea3n Ph\u1ea9m c\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-6e877ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e877ac\" 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-12b677d\" data-id=\"12b677d\" 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-75e8141 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"75e8141\" 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-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-b8260689-7fff-d183-1e89-a67588b11a5c\"><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;\">&nbsp;S\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 200: Ti\u00eau ch\u00ed so s\u00e1nh c\u1ea7n \u0111\u1eb7t trong ngo\u1eb7c k\u00e9p \u201c&gt;200\u201d<\/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;\">S\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n so v\u1edbi gi\u00e1 tr\u1ecb trong F2: Ti\u00eau ch\u00ed c\u1ea7n \u0111\u1eb7t d\u1ea5u so s\u00e1nh (to\u00e1n t\u1eed &gt;) trong ngo\u1eb7c k\u00e9p v\u00e0 n\u1ed1i v\u1edbi tham chi\u1ebfu \u00f4 b\u1eb1ng ph\u00e9p n\u1ed1i &amp; nh\u01b0 sau: \u201c&gt;\u201d&amp;F2<\/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-b64ea1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b64ea1d\" 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-6d1f64a\" data-id=\"6d1f64a\" 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-135baf9 elementor-widget elementor-widget-image\" data-id=\"135baf9\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh\" alt=\"h\u00e0m SUMIF c\u00f3 th\u1ec3 \u0111\u01b0a \u0111i\u1ec1u ki\u1ec7n t\u1eeb m\u1ed9t tham chi\u1ebfu \u00f4 kh\u00e1c \u0111\u1ec3 so s\u00e1nh trong ti\u00eau ch\u00ed\" \/>\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-dc89ba5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc89ba5\" 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-d4f0772\" data-id=\"d4f0772\" 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-2cb27c4 elementor-widget elementor-widget-text-editor\" data-id=\"2cb27c4\" 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=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\"><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;\">M\u1ed9t c\u00e1ch nhanh h\u01a1n \u0111\u1ec3 kh\u00f4ng c\u1ea7n quan t\u00e2m \u0111\u1ebfn c\u00e1c d\u1ea5u ngo\u1eb7c k\u00e9p khi so s\u00e1nh \u0111\u01a1n thu\u1ea7n v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb nh\u01b0 \u201c&gt;200\u201d, l\u00e0 s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 l\u00e0 bi\u1ec3u th\u1ee9c logic. Bi\u1ec3u th\u1ee9c &gt;200 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o F3, v\u00e0 h\u00e0m SUMIF s\u1eed d\u1ee5ng F3 nh\u01b0 m\u1ed9t ti\u00eau ch\u00ed:<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-indent: 36pt;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-indent: 36pt;\">=SUMIF(C3:C9,F3,C3:C9)<\/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-3d5dae4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d5dae4\" 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-2880549\" data-id=\"2880549\" 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-4c903ed elementor-widget elementor-widget-image\" data-id=\"4c903ed\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-dung-toan-tu.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-dung-toan-tu\" alt=\"V\u00ed D\u1ee5 Minh H\u1ecda C\u00e1ch D\u00f9ng H\u00e0m SUMIF so s\u00e1nh tham chi\u1ebfu \u00f4 kh\u00e1c b\u1eb1ng c\u00e1ch \u0111\u1eb7t bi\u1ec3u th\u1ee9c logic trong 1 \u00f4 tham chi\u1ebfu\" \/>\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-80e7530 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"80e7530\" 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-a73154a\" data-id=\"a73154a\" 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-5ceb10b elementor-widget elementor-widget-text-editor\" data-id=\"5ceb10b\" 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\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-98ae630 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"98ae630\" 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-d10f665\" data-id=\"d10f665\" 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-66224c5 elementor-widget elementor-widget-heading\" data-id=\"66224c5\" 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-6dd30d93-7fff-e4a0-c947-401e28fcf10b\"><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, Ti\u00eau Ch\u00ed V\u0103n B\u1ea3n<\/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-89d2b47 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89d2b47\" 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-40610f5\" data-id=\"40610f5\" 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-0156c19 elementor-widget elementor-widget-text-editor\" data-id=\"0156c19\" 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;\">Khi d\u00f9ng h\u00e0m SUMIF trong Excel \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n c\u1ea7n l\u01b0u \u00fd lu\u00f4n \u0111\u1eb7t v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; 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; 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 b\u00ean d\u01b0\u1edbi t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi B3:B8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng trong ph\u1ea1m vi A3:A8 kh\u00f4ng ch\u1ee9a ch\u00ednh x\u00e1c \u201cM\u00e1y h\u00e0n\u201d.<\/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;\">=SUMIF(A3:A8,&#8221;&lt;&gt;M\u00e1y h\u00e0n&#8221;,B3:B8)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">Ho\u1eb7c c\u00f4ng th\u1ee9c =SUMIF(A3:A8,&#8221;&lt;&gt;&#8221;&amp;A3,B3:B8) c\u0169ng cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1: t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi B3:B8 n\u1ebfu c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng trong ph\u1ea1m vi A3:A8 kh\u00f4ng ch\u1ee9a ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb \u00f4 A3, \u1edf \u0111\u00e2y \u00f4 A3 c\u00f3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n l\u00e0 \u201cM\u00e1y h\u00e0n\u201d.<\/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-3eceee0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3eceee0\" 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-362892a\" data-id=\"362892a\" 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-d195895 elementor-widget elementor-widget-image\" data-id=\"d195895\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-khac-2.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-khac\" alt=\"S\u1eed d\u1ee5ng h\u00e0m sumif trong excel \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh kh\u00e1c\" \/>\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-4d3eb4d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4d3eb4d\" 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-62f32fc\" data-id=\"62f32fc\" 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-97e01f7 elementor-widget elementor-widget-text-editor\" data-id=\"97e01f7\" 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;\">\u00c1p d\u1ee5ng t\u00ednh t\u1ed5ng \u00f4 kh\u00f4ng r\u1ed7ng (tr\u1ed1ng), s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u201c&lt;&gt;\u201d, c\u00f4ng th\u1ee9c SUMIF khi \u0111\u00f3 \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/span><\/p><p>\u00a0<\/p><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;\">=SUMIF(A3:A8,&#8221;&lt;&gt;&#8221;,B3:B8)<\/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-41291d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"41291d6\" 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-5d9d951\" data-id=\"5d9d951\" 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-ab1cd36 elementor-widget elementor-widget-heading\" data-id=\"ab1cd36\" 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-55212fad-7fff-f4fa-e66c-a0af2e4640d4\"><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.3, Ti\u00eau Ch\u00ed S\u1eed D\u1ee5ng K\u00fd T\u1ef1 Thay Th\u1ebf (?\/*) \u0110\u1ec3 X\u00e9t \u0110i\u1ec1u Ki\u1ec7n V\u0103n B\u1ea3n Ch\u1ee9a M\u1ed9t Ho\u1eb7c M\u1ed9t S\u1ed1 K\u00fd T\u1ef1 Ch\u1ec9 \u0110\u1ecbnh<\/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-aed10ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aed10ab\" 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-0d661c1\" data-id=\"0d661c1\" 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-afe0aa1 elementor-widget elementor-widget-text-editor\" data-id=\"afe0aa1\" 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;\">Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, h\u00e0m SUMIF h\u1ed7 tr\u1ee3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 sao \u201c*\u201d \u0111\u1ec3 thay th\u1ebf m\u1ed9t ho\u1eb7c m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 v\u00e0 k\u00fd t\u1ef1 \u201c?\u201d \u0111\u1ec3 thay th\u1ebf cho m\u1ed9t v\u00e0 ch\u1ec9 m\u1ed9t k\u00fd t\u1ef1 trong \u0111\u1ed1i s\u1ed1 Criteria.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; 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; 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: trong 3 c\u1ee5m v\u0103n b\u1ea3n \u201cExcel\u201d, \u201cEx\u201d, \u201cEx cel\u201d \u0111\u1ec1u th\u1ecfa m\u00e3n \u201cE*\u201d nh\u01b0ng ch\u1ec9 c\u00f3 \u201cEx\u201d th\u1ecfa m\u00e3n \u201cE?\u201d.<\/span><\/p><p>\u00a0<\/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\u00e1c k\u00fd t\u1ef1 thay th\u1ec3 trong ti\u00eau ch\u00ed \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 M\u00e3 b\u1eaft \u0111\u1ea7u b\u1eb1ng A, ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng 1 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-ace2401 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ace2401\" 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-1ead823\" data-id=\"1ead823\" 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-984ae45 elementor-widget elementor-widget-image\" data-id=\"984ae45\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-luu-y-ky-tu-thay-the.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-luu-y-ky-tu-thay-the\" alt=\"Ti\u00eau Ch\u00ed H\u00e0m SUMIF S\u1eed D\u1ee5ng K\u00fd t\u1ef1 thay th\u1ebf (?\/*) \u0110\u1ec3 X\u00e9t \u0110i\u1ec1u Ki\u1ec7n V\u0103n B\u1ea3n Ch\u1ee9a M\u1ed9t Ho\u1eb7c M\u1ed9t S\u1ed1 K\u00fd T\u1ef1 Ch\u1ec9 \u0110\u1ecbnh\" \/>\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-4689716 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4689716\" 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-a1d6e5d\" data-id=\"a1d6e5d\" 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-364257a elementor-widget elementor-widget-heading\" data-id=\"364257a\" 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-0811dea2-7fff-cd7c-8205-90da5abc0a99\"><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.4, H\u00e0m SUMIF C\u00f3 Ti\u00eau Ch\u00ed Li\u00ean Quan \u0110\u1ebfn Ng\u00e0y Th\u00e1ng<\/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-42288da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"42288da\" 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-6a2ffe3\" data-id=\"6a2ffe3\" 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-d231d1f elementor-widget elementor-widget-text-editor\" data-id=\"d231d1f\" 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;\">C\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp ng\u00e0y th\u00e1ng n\u0103m v\u00e0o ti\u00eau ch\u00ed h\u00e0m SUMIF. Tuy nhi\u00ean c\u00e1ch n\u00e0y m\u1ea5t th\u1eddi gian trong vi\u1ec7c ki\u1ec3m tra v\u00e0 x\u00e1c nh\u1eadn th\u1ee9 t\u1ef1 nh\u1eadp ng\u00e0y th\u00e1ng l\u00e0 dd\/mm\/yyyy hay mm\/dd\/yyyy t\u00f9y v\u00e0o c\u00e0i \u0111\u1eb7t trong m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">C\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF v\u1edbi ng\u00e0y l\u00e0 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><\/p><p dir=\"ltr\" style=\"line-height: 1.38; 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; 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 d\u01b0\u1edbi \u0111\u00e2y cho c\u1ea3 ba ph\u01b0\u01a1ng ph\u00e1p:<\/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-bcda1b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bcda1b3\" 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-5e37956\" data-id=\"5e37956\" 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-4d9be35 elementor-widget elementor-widget-image\" data-id=\"4d9be35\" 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\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-co-ngay-thang.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-so-sanh-co-ngay-thang\" alt=\"H\u00e0m SUMIF C\u00f3 Ti\u00eau Ch\u00ed Li\u00ean Quan \u0110\u1ebfn Ng\u00e0y Th\u00e1ng\" \/>\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-0f5dceb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f5dceb\" 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-2927560\" data-id=\"2927560\" 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-5db900f elementor-widget elementor-widget-heading\" data-id=\"5db900f\" 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-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.5, S\u1eed D\u1ee5ng H\u00e0m SUMIFS \u0110\u1ec3 Thay Th\u1ebf H\u00e0m SUMIF Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n<\/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-40bad46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"40bad46\" 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-41a1f0b\" data-id=\"41a1f0b\" 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-88e45b1 elementor-widget elementor-widget-text-editor\" data-id=\"88e45b1\" 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\u00e0m SUMIF ch\u1ec9 h\u1ed7 tr\u1ee3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. Khi c\u1ea7n t\u00ednh t\u1ed5ng c\u00f3 t\u1eeb 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS v\u1edbi c\u00fa ph\u00e1p:<\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/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 d\u01b0\u1edbi \u0111\u00e2y s\u1eed d\u1ee5ng h\u00e0m SUMIFS t\u00ednh t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 M\u00e1y in \u0111\u00e3 l\u1eafp \u0111\u1eb7t xong v\u1edbi c\u00f4ng th\u1ee9c =SUMIF(B:B,C:C,&#8221;Yes&#8221;,A:A,&#8221;M\u00e1y in&#8221;), trong \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-0130ede elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0130ede\" 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-e785083\" data-id=\"e785083\" 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-75fdc72 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"75fdc72\" 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-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-771b3824-7fff-a4c0-97ae-7793e9e0dcd0\"><span style=\"font-size: 11pt; 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;\">Sum_range:<\/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;\"> B:B &gt;&gt; to\u00e0n b\u1ed9 c\u1ed9t B, n\u1ebfu M\u00e1y in \u1edf c\u1ed9t A c\u00f3 tr\u1ea1ng th\u00e1i t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t C l\u00e0 \u201cYes\u201d th\u00ec c\u1ed9ng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t B v\u00e0o k\u1ebft qu\u1ea3 h\u00e0m<\/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-f738427d-7fff-cf9a-e02c-a9d8b3746678\"><span style=\"font-size: 11pt; 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;\">Criteria_range1:<\/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;\"> C:C l\u00e0 ph\u1ea1m vi \u0111\u01b0\u1ee3c ki\u1ec3m tra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <\/span><span style=\"font-size: 11pt; 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;\">Criteria1<\/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-45eb15e4-7fff-e138-32c9-66ca7acd7acf\"><span style=\"font-size: 11pt; 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;\">Criteria1:<\/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;\"> \u201cYes\u201d l\u00e0 ti\u00eau ch\u00ed c\u1ee7a <\/span><span style=\"font-size: 11pt; 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;\">criteria_range1<\/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-8851c403-7fff-f555-73ba-bb9dbfb55681\"><span style=\"font-size: 11pt; 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;\">Criteria_range2: <\/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;\">A:A l\u00e0 ph\u1ea1m vi \u0111\u01b0\u1ee3c ki\u1ec3m tra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <\/span><span style=\"font-size: 11pt; 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;\">Criteria2<\/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-7f14ae62-7fff-3c5d-3b3f-0e5739f91b0c\"><span style=\"font-size: 11pt; 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;\">Criteria2:<\/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;\"> \u201cM\u00e1y in\u201d l\u00e0 ti\u00eau ch\u00ed c\u1ee7a <\/span><span style=\"font-size: 11pt; 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;\">criteria_range2<\/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-6076507 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6076507\" 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-f7469b8\" data-id=\"f7469b8\" 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-b2d1b24 elementor-widget elementor-widget-image\" data-id=\"b2d1b24\" 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\/07\/su-dung-ham-sumifs-trong-excel-de-tinh-tong-co-nhieu-dieu-kien.png\" title=\"su-dung-ham-sumifs-trong-excel-de-tinh-tong-co-nhieu-dieu-kien\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMIFS \u0110\u1ec3 Thay Th\u1ebf H\u00e0m SUMIF Nhi\u1ec1u \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-4466fb3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4466fb3\" 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-888f892\" data-id=\"888f892\" 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-7c7a476 elementor-widget elementor-widget-text-editor\" data-id=\"7c7a476\" 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;white-space:pre-wrap;\">\u0110\u1ec3 hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m SUMIF n\u00e2ng cao v\u00e0 \u1ee9ng d\u1ee5ng, c\u00e1c b\u1ea1n \u0111\u00f3n \u0111\u1ecdc <a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel-nang-cao\/\" target=\"_blank\">C\u00e1c V\u00ed D\u1ee5 H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng H\u00e0m SUMIF N\u00e2ng Cao<\/a>.<\/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: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\"><br><\/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: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">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 v\u1ec1 h\u00e0m SUMIF trong Excel. 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;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumifs-trong-excel\/\" target=\"_blank\">H\u00e0m SUMIFS<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/cac-cach-tinh-tong-trong-excel\/\" target=\"_blank\">H\u00e0m SUM v\u00e0 c\u00e1c c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\">H\u00e0m COUNTIF<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;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><p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumproduct-trong-excel\/\" target=\"_blank\">H\u00e0m SUMPRODUCT<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><br><\/p>\n<div><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;white-space:pre-wrap;\"><br><\/span><\/div>\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 SUMIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng trong Excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n. \u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft nh\u1ea5t t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng c\u00f9ng c\u00e1c l\u01b0u \u00fd quan tr\u1ecdng khi &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":551,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[9,10,12],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/522"}],"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=522"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/551"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}