{"id":1325,"date":"2020-09-29T14:41:30","date_gmt":"2020-09-29T07:41:30","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1325"},"modified":"2020-10-12T15:51:21","modified_gmt":"2020-10-12T08:51:21","slug":"ham-sumproduct-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-sumproduct-trong-excel\/","title":{"rendered":"H\u00e0m SUMPRODUCT T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao &#038; C\u00e1c V\u00ed D\u1ee5 Chi Ti\u1ebft"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1325\" class=\"elementor elementor-1325\">\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-a3ecd56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3ecd56\" 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-18bb510\" data-id=\"18bb510\" 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-c30f24f elementor-widget elementor-widget-text-editor\" data-id=\"c30f24f\" 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;\">Khi t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, ch\u1eafc nhi\u1ec1u b\u1ea1n hay s\u1eed d\u1ee5ng h\u00e0m t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF ho\u1eb7c SUMIFS. Tuy nhi\u00ean \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c m\u1ea3ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT hi\u1ec7u qu\u1ea3 h\u01a1n nhi\u1ec1u.<\/span><\/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;\">\u00a0<\/span><\/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;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, so s\u00e1nh d\u1eef li\u1ec7u \u1edf nhi\u1ec1u d\u1ea3i \u00f4 v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c m\u00e0 n\u1ebfu kh\u00f4ng nh\u1edd h\u00e0m SUMPRODUCT th\u00ec k\u1ebft qu\u1ea3 h\u00e0m m\u1ea3ng trong Excel th\u00f4ng th\u01b0\u1eddng \u0111\u00f3 s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c.<\/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-a7489f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a7489f9\" 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-dc899ad\" data-id=\"dc899ad\" 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-892387e elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"892387e\" 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-aad928e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aad928e\" 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-10d8e4f\" data-id=\"10d8e4f\" 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-937c245 elementor-widget elementor-widget-heading\" data-id=\"937c245\" 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-be9c63b0-7fff-c6e0-1eaa-086477f178c0\"><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, H\u00e0m SUMPRODUCT L\u00e0 G\u00ec? C\u00fa Ph\u00e1p V\u00e0 C\u00e1ch S\u1eed D\u1ee5ng<\/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-1116b92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1116b92\" 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-7f1b97f\" data-id=\"7f1b97f\" 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-ccfce94 elementor-widget elementor-widget-heading\" data-id=\"ccfce94\" 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-8bb2a5e3-7fff-0f3f-649d-789a8109cc6c\"><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;\">1.1, C\u00fa Ph\u00e1p H\u00e0m SUMPRODUCT<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f26d1e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f26d1e8\" 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-63362eb\" data-id=\"63362eb\" 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-638ba1e elementor-widget elementor-widget-text-editor\" data-id=\"638ba1e\" 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 SUMPRODUCT nh\u00e2n c\u00e1c d\u1ea3i \u00f4 ho\u1eb7c m\u1ea3ng v\u1edbi nhau v\u00e0 tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a c\u00e1c ph\u00e9p t\u00ednh nh\u00e2n \u0111\u00f3.<\/span><\/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;\">L\u1ec7nh SUMPRODUCT c\u00f3 c\u00fa ph\u00e1p:<\/span><\/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: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=SUMPRODUCT(array1, [array2], [array3], \u2026)<\/span><\/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;\">\u00a0<\/span><\/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;\">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-3b47227 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b47227\" 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-db5bc10\" data-id=\"db5bc10\" 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-95b77ae elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"95b77ae\" 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-1cc45237-7fff-e101-6eb9-a00eaa33b00c\"><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;\">Array1, array2, \u2026 l\u00e0 c\u00e1c d\u1ea3i \u00f4 li\u00ean t\u1ee5c ho\u1eb7c m\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n nh\u00e2n c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a ch\u00fang v\u1edbi nhau r\u1ed3i c\u1ed9ng l\u1ea1i \u0111\u1ec3 t\u00ednh t\u1ed5ng. T\u1ed1i \u0111a 255 m\u1ea3ng trong Excel 2007, 2010, 2013, 2016, 2019 v\u00e0 365.<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Array 1 l\u00e0 b\u1eaft bu\u1ed9c.<\/span><\/span><span><div style=\"text-align: justify;\"><\/div><\/span><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;\">C\u00e1ch h\u00e0m SUMPRODUCT ho\u1ea1t \u0111\u1ed9ng: nh\u00e2n, sau \u0111\u00f3 t\u00ednh t\u1ed5ng. N\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t m\u1ea3ng, SUMPRODUCT s\u1ebd ch\u1ec9 \u0111\u01a1n thu\u1ea7n t\u00ednh t\u1ed5ng c\u00e1c m\u1ee5c trong m\u1ea3ng.<\/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-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-e7fbf468-7fff-597f-4ed4-01f951e286df\"><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;\">T\u1ea5t c\u1ea3 m\u1ea3ng\/ array trong c\u00f4ng th\u1ee9c SUMPRODUCT ph\u1ea3i c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc, n\u1ebfu kh\u00f4ng th\u00ec h\u00e0m SUMPRODUCT s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/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-753470b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"753470b\" 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-c1b739d\" data-id=\"c1b739d\" 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-afd0143 elementor-widget elementor-widget-text-editor\" data-id=\"afd0143\" 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;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng l\u01b0u \u00fd c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m SUMPRODUCT.<\/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;\">C\u00e1c l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT n\u00e2ng cao cho c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn t\u1ea1i m\u1ee5c 2.<\/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-7d244c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d244c2\" 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-e471f70\" data-id=\"e471f70\" 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-8db2442 elementor-widget elementor-widget-heading\" data-id=\"8db2442\" 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-3e1c206d-7fff-337f-c46f-91377368454d\"><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;\">1.2, C\u00e1ch D\u00f9ng H\u00e0m SUMPRODUCT Trong Excel - Ch\u1ee9c N\u0103ng C\u01a1 B\u1ea3n Nh\u1ea5t<\/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-4078392 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4078392\" 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-0d40781\" data-id=\"0d40781\" 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-a0e457d elementor-widget elementor-widget-heading\" data-id=\"a0e457d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-8116f0d7-7fff-12ae-f282-de8c118b785b\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 1: T\u00ednh T\u1ed5ng C\u00e1c S\u1ed1 L\u01b0\u1ee3ng Nh\u00e2n \u0110\u01a1n Gi\u00e1<\/span><\/span><\/h4>\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-71a436f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71a436f\" 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-9441062\" data-id=\"9441062\" 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-463d054 elementor-widget elementor-widget-text-editor\" data-id=\"463d054\" 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\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho s\u1ed1 l\u01b0\u1ee3ng v\u00e0 \u0111\u01a1n gi\u00e1 c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m. Y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng doanh thu c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m (t\u1ed5ng c\u00e1c s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n \u0111\u01a1n gi\u00e1).<\/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;\">H\u00e0m SUMPRODUCT x\u1eed l\u00fd nhanh b\u00e0i to\u00e1n n\u00e0y v\u1edbi ch\u1ec9 1 c\u00e2u l\u1ec7nh, trong khi n\u1ebfu s\u1eed d\u1ee5ng ph\u00e9p c\u1ed9ng v\u00e0 l\u1ec7nh nh\u00e2n trong Excel m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, b\u1ea1n s\u1ebd ph\u1ea3i thao t\u00e1c v\u00e0 th\u00eam c\u1ed9t ph\u1ee5:<\/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-31fa901 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31fa901\" 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-fe27c06\" data-id=\"fe27c06\" 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-a5fb76d elementor-widget elementor-widget-image\" data-id=\"a5fb76d\" 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\/vi-du-ham-sumproduct-trong-excel.png\" title=\"vi-du-ham-sumproduct-trong-excel\" alt=\"C\u00e1ch D\u00f9ng H\u00e0m SUMPRODUCT Trong Excel T\u00ednh T\u1ed5ng C\u00e1c S\u1ed1 L\u01b0\u1ee3ng Nh\u00e2n \u0110\u01a1n Gi\u00e1\" \/>\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-16affd4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16affd4\" 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-b1d3a34\" data-id=\"b1d3a34\" 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-80a8304 elementor-widget elementor-widget-text-editor\" data-id=\"80a8304\" 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;\">Di\u1ec5n gi\u1ea3i h\u00e0m SUMPRODUCT trong v\u00ed d\u1ee5 tr\u00ean: M\u1ed7i \u00f4 trong c\u1ed9t B \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng h\u00e0ng ngang trong c\u1ed9t C v\u00e0 c\u1ed9ng c\u00e1c k\u1ebft qu\u1ea3 \u0111\u00f3 l\u1ea1i v\u1edbi nhau. T\u1ed5ng s\u1ed1 ti\u1ec1n l\u00e0 300.<\/span><\/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;\">= SUMPRODUCT ( {10, 5, 2}, {15, 10, 50})<\/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;\">= 10*15 + 5*10 + 2*50<\/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-0e6cbc7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e6cbc7\" 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-f54402f\" data-id=\"f54402f\" 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-6797f53 elementor-widget elementor-widget-heading\" data-id=\"6797f53\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-aebb87a9-7fff-6635-69db-1fa60cfcb8fb\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 2: C\u00e1ch S\u1eed D\u1ee5ng SUMPRODUCT L\u00e0m H\u00e0m T\u00ednh Trung B\u00ecnh<\/span><\/span><\/h4>\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-89c1503 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89c1503\" 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-6ec9e10\" data-id=\"6ec9e10\" 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-7de3893 elementor-widget elementor-widget-text-editor\" data-id=\"7de3893\" 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;\">C\u00f4ng th\u1ee9c SUMPRODUCT t\u00ednh trung b\u00ecnh c\u1ed9ng c\u00f3 tr\u1ecdng s\u1ed1:<\/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;\">SUMPRODUCT(gi\u00e1 tr\u1ecb, tr\u1ecdng s\u1ed1) \/ SUM(tr\u1ecdng s\u1ed1)<\/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-c60f87a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c60f87a\" 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-af4b182\" data-id=\"af4b182\" 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-8c1b27c elementor-widget elementor-widget-image\" data-id=\"8c1b27c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-ham-sumproduct-tinh-trung-binh-cong.png\" title=\"su-dung-ham-sumproduct-tinh-trung-binh-cong\" alt=\"C\u00e1ch S\u1eed D\u1ee5ng SUMPRODUCT L\u00e0m H\u00e0m T\u00ednh Trung B\u00ecnh\" \/>\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-933057e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"933057e\" 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-b5d2dfa\" data-id=\"b5d2dfa\" 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-08bce65 elementor-widget elementor-widget-heading\" data-id=\"08bce65\" 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-6d99df0c-7fff-1413-4dbb-f6873a2656d5\"><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\u00e1c V\u00ed D\u1ee5 C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT N\u00e2ng Cao Trong Excel V\u1edbi C\u00f4ng Th\u1ee9c M\u1ea3ng<\/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-60d098e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60d098e\" 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-95ff7d7\" data-id=\"95ff7d7\" 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-f3f59c0 elementor-widget elementor-widget-text-editor\" data-id=\"f3f59c0\" 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;\">N\u1ebfu ch\u1ec9 d\u1eebng l\u1ea1i \u1edf v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n s\u1ebd th\u1ea5y h\u00e0m SUMPRODUCT ph\u1ee9c t\u1ea1p v\u00e0 v\u00f4 ngh\u0129a v\u00ec h\u00e0m c\u1ed9ng v\u00e0 h\u00e0m nh\u00e2n trong Excel \u0111\u1ee7 \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n \u0111\u00f3 r\u1ed3i.<\/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;\">Nh\u01b0ng th\u1ef1c t\u1ebf, h\u00e0m SUMPRODUCT l\u00e0 linh ho\u1ea1t v\u00e0 nhi\u1ec1u c\u00f4ng d\u1ee5ng h\u01a1n r\u1ea5t nhi\u1ec1u khi t\u00ednh t\u1ed5ng theo \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;\">C\u00e1c v\u00ed d\u1ee5 \u1edf d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0m r\u00f5 \u0111i\u1ec1u \u0111\u00f3.<\/span><\/p><p><br \/><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd<\/span><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;\">: H\u00e0m SUMPRODUCT ho\u1ea1t \u0111\u1ed9ng v\u1edbi m\u1ea3ng, nh\u01b0ng n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u c\u00fa ph\u00e1p m\u1ea3ng b\u00ecnh th\u01b0\u1eddng (Ctrl + Shift + Enter) \u0111\u1ec3 ch\u1ea1y m\u00e0 ch\u1ec9 c\u1ea7n Enter nh\u01b0 b\u1ea5t k\u1ef3 h\u00e0m Excel c\u01a1 b\u1ea3n n\u00e0o kh\u00e1c.<\/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-ad27f22 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad27f22\" 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-83bd364\" data-id=\"83bd364\" 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-3b18102 elementor-widget elementor-widget-heading\" data-id=\"3b18102\" 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-26a10edb-7fff-9a55-a8a5-d5085fff2deb\"><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, S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT \u0110\u1ebfm C\u00f3 \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-3fa9450 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3fa9450\" 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-a9479f5\" data-id=\"a9479f5\" 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-74fa57c elementor-widget elementor-widget-heading\" data-id=\"74fa57c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-3734df7c-7fff-dacf-8277-8ee0dc391b84\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 3: \u0110\u1ebfm S\u1ed1 S\u1ea3n Ph\u1ea9m Th\u1ecfa M\u00e3n \u0110i\u1ec1u Ki\u1ec7n So S\u00e1nh V\u1edbi 1 S\u1ed1<\/span><\/span><\/h4>\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-7865754 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7865754\" 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-18e0282\" data-id=\"18e0282\" 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-79747e3 elementor-widget elementor-widget-text-editor\" data-id=\"79747e3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"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 n\u00e0y c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01a1n gi\u1ea3n b\u1eb1ng h\u00e0m COUNTIF, tuy nhi\u00ean \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o \u0111\u1ec3 c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m SUMPRODUCT c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi m\u1ea3ng:<\/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-b064a8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b064a8e\" 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-c982b53\" data-id=\"c982b53\" 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-986cadc elementor-widget elementor-widget-image\" data-id=\"986cadc\" 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\/vi-du-ham-sumproduct-co-dieu-kien-so-sanh-voi-1-so-trong-excel.png\" title=\"vi-du-ham-sumproduct-co-dieu-kien-so-sanh-voi-1-so-trong-excel\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n \u0110\u1ebfm S\u1ed1 S\u1ea3n Ph\u1ea9m Th\u1ecfa M\u00e3n \u0110i\u1ec1u Ki\u1ec7n So S\u00e1nh V\u1edbi 1 S\u1ed1\" \/>\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-7c72c3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c72c3e\" 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-71ae8e8\" data-id=\"71ae8e8\" 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-42637a9 elementor-widget elementor-widget-text-editor\" data-id=\"42637a9\" 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-bc449f36-7fff-81fb-00ad-d539e5e3f492\"><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;\">L\u00ed gi\u1ea3i c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m SUMPRODUCT c\u00f3 1 m\u1ea3ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u1edf tr\u00ean:<\/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-6424b2a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6424b2a\" 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-e4b2618\" data-id=\"e4b2618\" 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-de85ecb elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"de85ecb\" 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><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;\">Bi\u1ec3u th\u1ee9c (C4:C8&gt;140): th\u1ef1c hi\u1ec7n so s\u00e1nh t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng v\u1edbi 140.<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Sau khi so s\u00e1nh xong c\u00e1c ph\u1ea7n t\u1eed trong m\u1ea3ng, h\u00e0m SUMPRODUCT tr\u1edf th\u00e0nh:<\/span><\/span><br><span id=\"docs-internal-guid-bc317fde-7fff-359d-7311-8a89dbe63744\"><span style=\"font-size: 12pt; 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;\">SUMPRODUCT(- {FALSE, FALSE, TRUE, TRUE, FALSE})<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">D\u1ea5u \u00e2m \u201c - \u201d \u0111\u1eb7t tr\u01b0\u1edbc m\u1ea3ng \u0111\u1ec3 bi\u1ebfn c\u00e1c gi\u00e1 tr\u1ecb TRUE\/ FALSE v\u1ec1 d\u1ea1ng s\u1ed1 nguy\u00ean -1 v\u00e0 0 th\u00ec k\u1ebft qu\u1ea3 h\u00e0m SUMPRODUCT m\u1edbi tr\u1ea3 v\u1ec1 s\u1ed1 ch\u00ednh x\u00e1c, n\u1ebfu kh\u00f4ng h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 0.<\/span><\/span><br><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;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 2 d\u1ea5u \u201c-\u201d \u0111\u1ec3 tr\u1ea3 TRUE\/ FALSE v\u1ec1 1 v\u00e0 0.<\/span><\/span><br><\/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-657a93f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"657a93f\" 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-ba9203b\" data-id=\"ba9203b\" 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-e5c8927 elementor-widget elementor-widget-heading\" data-id=\"e5c8927\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-0c5b7e10-7fff-b2e5-d6f5-62152355ec42\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 4: \u0110\u1ebfm S\u1ed1 S\u1ea3n Ph\u1ea9m Khi So S\u00e1nh 2 M\u1ea3ng V\u1edbi Nhau<\/span><\/span><\/h4>\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-681da46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"681da46\" 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-198b892\" data-id=\"198b892\" 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-b328a58 elementor-widget elementor-widget-text-editor\" data-id=\"b328a58\" 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;\">Y\u00eau c\u1ea7u \u0111\u1ebfm s\u1ed1 s\u1ea3n ph\u1ea9m c\u00f3 doanh s\u1ed1 th\u1ef1c t\u1ebf l\u1edbn h\u01a1n k\u1ebf ho\u1ea1ch.<\/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\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u01a1n thu\u1ea7n \u0111\u1ec3 t\u00ednh to\u00e1n nh\u01b0 \u1edf v\u00ed d\u1ee5 2 n\u1eefa. \u0110\u1ec3 d\u00f9ng h\u00e0m COUNTIF, b\u1ea1n c\u1ea7n th\u00eam c\u1ed9t ph\u1ee5 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh th\u1ef1c t\u1ebf v\u00e0 k\u1ebf ho\u1ea1ch r\u1ed3i \u0111\u1ebfm s\u1ed1 k\u1ebft qu\u1ea3 TRUE.<\/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=\"color: #000000; font-family: Arial; font-size: 16px; white-space: pre-wrap;\">V\u1edbi c\u00f4ng th\u1ee9c SUMPRODUCT, <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng 1 c\u00e2u l\u1ec7nh duy nh\u1ea5t. V\u00ed d\u1ee5 n\u00e0y d\u1ea7n cho th\u1ea5y s\u1ef1 linh ho\u1ea1t c\u1ee7a h\u00e0m SUMPRODUCT khi th\u1ef1c hi\u1ec7n so s\u00e1nh 2 m\u1ea3ng m\u00e0 kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5:<\/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-0e29d1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e29d1b\" 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-8c70b41\" data-id=\"8c70b41\" 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-475e178 elementor-widget elementor-widget-image\" data-id=\"475e178\" 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\/vi-du-ham-sumproduct-co-dieu-kien-trong-excel.png\" title=\"vi-du-ham-sumproduct-co-dieu-kien-trong-excel\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT \u0110\u1ebfm S\u1ed1 S\u1ea3n Ph\u1ea9m Khi So S\u00e1nh 2 M\u1ea3ng V\u1edbi Nhau\" \/>\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-c539142 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c539142\" 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-4890eef\" data-id=\"4890eef\" 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-070c669 elementor-widget elementor-widget-text-editor\" data-id=\"070c669\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"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;\">Chi ti\u1ebft c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m SUMPRODUCT:<\/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-445e99d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"445e99d\" 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-69ab58a\" data-id=\"69ab58a\" 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-8313075 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8313075\" 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-bda2bdde-7fff-1459-a987-889da1bcdf1d\"><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;\">Bi\u1ec3u th\u1ee9c (C4:C8&gt;B4:B8): th\u1ef1c hi\u1ec7n so s\u00e1nh t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a 2 m\u1ea3ng v\u1edbi nhau: C4 v\u1edbi B4, C5 v\u1edbi B5\u2026<\/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-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-d6df576b-7fff-277b-63fa-aa8fc2e7c462\"><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;\">Sau khi so s\u00e1nh xong c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a 2 m\u1ea3ng, h\u00e0m SUMPRODUCT tr\u1edf th\u00e0nh:<\/span><\/span><br><span id=\"docs-internal-guid-fc17c8a0-7fff-4419-9934-e2b36f3637a7\"><span style=\"font-size: 12pt; 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;\">SUMPRODUCT(- {TRUE, FALSE, FALSE, FALSE, TRUE})<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">D\u1ea5u \u00e2m \u201c - \u201d \u0111\u01b0a h\u00e0m v\u1ec1 d\u1ea1ng <\/span><span style=\"font-size: 12pt; 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;\">SUMPRODUCT({-1, 0, 0, 0, -1}), <\/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;\">k\u1ebft qu\u1ea3 b\u1eb1ng -2.<\/span><\/span><br><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;\">Tr\u01b0\u1edbc h\u00e0m SUMPRODUCT c\u00f3 th\u00eam 1 d\u1ea5u \u00e2m n\u00ean k\u1ebft qu\u1ea3 \u0111\u1ebfm l\u00e0 2.<\/span><\/span><br><span id=\"docs-internal-guid-444e92a9-7fff-076f-d8e8-7fe2700c0485\"><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;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 2 d\u1ea5u \u00e2m li\u00ean ti\u1ebfp =SUMPRODUCT(--(C4:C8&gt;B4:B8)).<\/span><\/span><br><\/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-21bb217 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21bb217\" 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-32d4462\" data-id=\"32d4462\" 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-84b6e92 elementor-widget elementor-widget-heading\" data-id=\"84b6e92\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-fe52afef-7fff-135a-f6e3-fe368ac57966\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 5: S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n Thay Th\u1ebf H\u00e0m COUNTIFS<\/span><\/span><\/h4>\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-aa33b83 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aa33b83\" 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-8758655\" data-id=\"8758655\" 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-e578979 elementor-widget elementor-widget-text-editor\" data-id=\"e578979\" 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;\">Y\u00eau c\u1ea7u \u0111\u1ebfm s\u1ed1 s\u1ea3n ph\u1ea9m l\u00e0 \u201cT\u00e1o\u201d c\u00f3 s\u1ed1 l\u01b0\u1ee3ng tr\u00ean 99.<\/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;\">V\u00ed d\u1ee5 n\u00e0y c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01a1n gi\u1ea3n b\u1eb1ng h\u00e0m COUNTIFS, nh\u01b0ng v\u1eabn \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o \u0111\u1ec3 c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m SUMPRODUCT nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. T\u01b0\u01a1ng t\u1ef1 c\u00e1c h\u00e0m Excel kh\u00e1c, \u0111i\u1ec1u ki\u1ec7n l\u00e0 v\u0103n b\u1ea3n kh\u00f4ng ph\u00e2n bi\u1ec7t vi\u1ebft hoa vi\u1ebft th\u01b0\u1eddng:<\/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-1bd214f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1bd214f\" 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-1ba4b9c\" data-id=\"1ba4b9c\" 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-e7ace9c elementor-widget elementor-widget-image\" data-id=\"e7ace9c\" 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\/vi-du-ham-sumproduct-2-dieu-kien-trong-excel.png\" title=\"vi-du-ham-sumproduct-2-dieu-kien-trong-excel\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n Thay Th\u1ebf H\u00e0m COUNTIFS\" \/>\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-a956e1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a956e1d\" 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-e69e455\" data-id=\"e69e455\" 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-efb09b4 elementor-widget elementor-widget-text-editor\" data-id=\"efb09b4\" 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-606810f1-7fff-fe94-2a50-acef7e86ed70\"><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;\">Gi\u1ea3i th\u00edch logic s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<\/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-84d9131 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"84d9131\" 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-bd497da\" data-id=\"bd497da\" 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-3403801 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"3403801\" 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-acec728b-7fff-5ed6-e149-d6fea9a12cd7\"><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;\">Bi\u1ec3u th\u1ee9c (A4:A8=\"t\u00e1o\"): th\u1ef1c hi\u1ec7n ki\u1ec3m tra t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng c\u00f3 ph\u1ea3i l\u00e0 T\u00e1o hay kh\u00f4ng: k\u1ebft qu\u1ea3 <\/span><span style=\"font-size: 12pt; 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;\">{TRUE, TRUE, FALSE, FALSE, TRUE}<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Bi\u1ec3u th\u1ee9c (C4:C8&gt;99): th\u1ef1c hi\u1ec7n ki\u1ec3m tra t\u1eebng ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng c\u00f3 l\u1edbn h\u01a1n 99 hay kh\u00f4ng: k\u1ebft qu\u1ea3 <\/span><span style=\"font-size: 12pt; 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;\">{TRUE, TRUE, TRUE, TRUE, FALSE}<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">D\u1ea5u * trong h\u00e0m bi\u1ebfn TRUE\/ FALSE v\u1ec1 d\u1ea1ng s\u1ed1 1\/ 0<\/span><\/span><br><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;\">H\u00e0m SUMPRODUCT th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng c\u1ee7a n\u00f3 tr\u1ea3 v\u1ec1 s\u1ed1 s\u1ea3n ph\u1ea9m th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n (v\u00ec 1 nh\u00e2n 0 b\u1eb1ng 0 n\u00ean ch\u1ec9 khi c\u1ea3 2 ph\u1ea7n t\u1eed b\u1eb1ng 1 th\u00ec m\u1edbi \u0111\u01b0\u1ee3c c\u1ed9ng v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m).<\/span><\/span><br><\/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-f7a42ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f7a42ef\" 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-2abcfa3\" data-id=\"2abcfa3\" 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-c6e4183 elementor-widget elementor-widget-text-editor\" data-id=\"c6e4183\" 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: 13.999999999999998pt; font-family: Arial; color: #0b5394; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd quan tr\u1ecdng<\/span><span style=\"font-size: 13.999999999999998pt; font-family: Arial; color: #0b5394; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.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;\">V\u00ed d\u1ee5 3 v\u00e0 4 \u0111\u1ec1u s\u1eed d\u1ee5ng c\u00e1ch d\u00f9ng d\u1ea5u \u00e2m c\u00f2n v\u00ed d\u1ee5 5 s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n \u0111\u1ec3 bi\u1ebfn TRUE\/ FALSE v\u1ec1 d\u1ea1ng s\u1ed1.<\/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\u00e2y l\u00e0 ch\u00eca kh\u00f3a cho c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT nhi\u1ec1u \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-205e068 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"205e068\" 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-a89795b\" data-id=\"a89795b\" 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-11be493 elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"11be493\" 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-99510135-7fff-ad1a-1e39-8501e41eb563\"><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;\">N\u1ebfu m\u1ea3ng l\u00e0 bi\u1ec3u th\u1ee9c so s\u00e1nh l\u00f4 gic, th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE<\/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><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;\">B\u1ea1n lu\u00f4n ph\u1ea3i \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE n\u00e0y th\u00e0nh 1 v\u00e0 0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <u>m\u1ed9t<\/u> trong 3 c\u00e1ch sau, ho\u1eb7c k\u1ebft h\u1ee3p nhi\u1ec1u c\u00e1ch khi vi\u1ebft 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-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-ed7a3df8-7fff-eba9-661d-a209ceca5168\"><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;\">Ph\u00e9p tr\u1eeb\/ d\u1ea5u \u00e2m (\u2013) \u0111\u1eb7t tr\u01b0\u1edbc m\u1ea3ng, v\u00ed d\u1ee5 -(A4:A8=\"t\u00e1o\") ho\u1eb7c --(A4:A8=\"t\u00e1o\"). C\u1ea7n l\u01b0u \u00fd d\u1ea5u c\u1ee7a k\u1ebft qu\u1ea3, m\u1ed7i 1 d\u1ea5u \u00e2m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi\u1ebfn k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m \u0111\u01b0\u1ee3c nh\u00e2n -1 t\u01b0\u01a1ng \u1ee9ng;<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check-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-cf55ecbb-7fff-1eaf-eeb7-f8070867ee0b\"><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;\">Ph\u00e9p nh\u00e2n v\u1edbi s\u1ed1 1, nh\u01b0 1*(A4:A8=\"t\u00e1o\");<\/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-ed3d5990-7fff-4a37-3d24-cb5046651389\"><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;\">Ph\u00e9p nh\u00e2n gi\u1eefa c\u00e1c m\u1ea3ng v\u1edbi nhau n\u1ebfu c\u00f3 t\u1eeb 2 array trong h\u00e0m SUMPRODUCT, v\u00ed d\u1ee5 (A4:A8=\"t\u00e1o\")*(C4:C8&gt;99).<\/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-fc567bb4-7fff-9979-9b1d-56b5cc8f658f\"><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;\">M\u1ea3ng v\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u1ea3ng c\u1ea7n \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n.<\/span><\/span><br><\/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-83db592 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"83db592\" 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-f1b92da\" data-id=\"f1b92da\" 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-ea7d193 elementor-widget elementor-widget-heading\" data-id=\"ea7d193\" 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-a19f1a28-7fff-2b42-b704-a2679ba39b7f\"><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, S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng C\u00f3 \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-e58a39f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e58a39f\" 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-db82f7a\" data-id=\"db82f7a\" 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-2338063 elementor-widget elementor-widget-heading\" data-id=\"2338063\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-80655a75-7fff-ec4e-f46a-b1b338165055\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed d\u1ee5 6: H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng C\u00e1c M\u00e3 Gi\u1ed1ng Nhau Trong Excel<\/span><\/span><\/h4>\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-add8b7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"add8b7d\" 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-b18ba6c\" data-id=\"b18ba6c\" 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-a01a817 elementor-widget elementor-widget-text-editor\" data-id=\"a01a817\" 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><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;\">\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu s\u1ea3n ph\u1ea9m l\u00e0 T\u00e1o, b\u1ea1n ch\u1ec9 c\u1ea7n x\u1eed l\u00fd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 logic \u1edf c\u00e1c v\u00ed d\u1ee5 tr\u00ean, v\u00e0 th\u00eam m\u1ea3ng doanh thu v\u00e0o c\u00f4ng th\u1ee9c SUMPRODUCT:<\/span><\/span><br><\/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;white-space:pre-wrap;\">= SUMPRODUCT ((A4:A8=&#8221;t\u00e1o&#8221;)*C4:C8)<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><br><\/p>\n<p><span id=\"docs-internal-guid-84ee7116-7fff-7812-52c2-fe60b66a3f38\"><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;\">K\u1ebft qu\u1ea3 m\u1ea3ng: SUMPRODUCT (<\/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;\">{1, 1, 0, 0, 1} <\/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;\">* {100, 150, 220, 155, 80}<\/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;\">)<\/span><\/span><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;\"><br><\/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-65d37b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65d37b3\" 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-9ee04bb\" data-id=\"9ee04bb\" 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-d1e12a5 elementor-widget elementor-widget-image\" data-id=\"d1e12a5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-ham-sumproduct-tinh-tong-cac-ma-giong-nhau-trong-excel.png\" title=\"su-dung-ham-sumproduct-tinh-tong-cac-ma-giong-nhau-trong-excel\" alt=\"H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng C\u00e1c M\u00e3 Gi\u1ed1ng Nhau Trong Excel\" \/>\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-3e9c574 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e9c574\" 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-1901cbd\" data-id=\"1901cbd\" 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-6947a49 elementor-widget elementor-widget-heading\" data-id=\"6947a49\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-c9966721-7fff-02a6-0640-37e1a6ed3306\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed d\u1ee5 7: H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng Theo \u0110i\u1ec1u Ki\u1ec7n<\/span><\/span><\/h4>\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-766e6ec elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"766e6ec\" 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-145f735\" data-id=\"145f735\" 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-362a9ea elementor-widget elementor-widget-text-editor\" data-id=\"362a9ea\" 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-91d9ba59-7fff-ec3d-d956-395f8dd574fe\"><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;\">\u0110\u1ec3 t\u00ednh t\u1ed5ng doanh thu s\u1ea3n ph\u1ea9m l\u00e0 T\u00e1o b\u00e1n t\u1ea1i khu v\u1ef1c B, d\u00f9 2 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n hi\u1ec3u logic nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean, v\u00e0 th\u00eam m\u1ea3ng doanh thu v\u00e0o c\u00f4ng th\u1ee9c SUMPRODUCT:<\/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-c3a1e7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3a1e7d\" 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-6d6dd7a\" data-id=\"6d6dd7a\" 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-24e5c11 elementor-widget elementor-widget-image\" data-id=\"24e5c11\" 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\/vi-du-ham-sumproduct-2-dieu-kien-trong-excel-san-pham-Tao-Khu-vuc-B.png\" title=\"vi-du-ham-sumproduct-2-dieu-kien-trong-excel-san-pham-Tao-Khu-vuc-B\" alt=\"H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng Theo \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-a0f1941 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a0f1941\" 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-aef71ad\" data-id=\"aef71ad\" 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-88ca8f0 elementor-widget elementor-widget-heading\" data-id=\"88ca8f0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-af966d66-7fff-aef2-af96-184e94524506\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed d\u1ee5 8: H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng Theo \u0110i\u1ec1u Ki\u1ec7n C\u00f3 To\u00e1n T\u1eed OR (Ho\u1eb7c)<\/span><\/span><\/h4>\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-384caa3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"384caa3\" 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-3cbedd1\" data-id=\"3cbedd1\" 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-726af6e elementor-widget elementor-widget-text-editor\" data-id=\"726af6e\" 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;\">C\u00e1c v\u00ed d\u1ee5 \u0111\u00e3 n\u00eau v\u1ec1 h\u00e0m SUMPRODUCT \u1edf tr\u00ean ch\u1ee7 y\u1ebfu l\u00e0 \u0111i\u1ec1u ki\u1ec7n AND (k\u1ebft h\u1ee3p th\u1ecfa m\u00e3n nhi\u1ec1u \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;\">H\u00e0m SUMPRODUCT c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m OR nh\u01b0 c\u00e1c h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n kh\u00e1c:<\/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-f7b6d17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f7b6d17\" 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-96c7322\" data-id=\"96c7322\" 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-df228d7 elementor-widget elementor-widget-image\" data-id=\"df228d7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-ham-sumproduct-tinh-tong-co-dieu-kien-ham-or.png\" title=\"su-dung-ham-sumproduct-tinh-tong-co-dieu-kien-ham-or\" alt=\"H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng Theo \u0110i\u1ec1u Ki\u1ec7n C\u00f3 To\u00e1n T\u1eed OR (Ho\u1eb7c)\" \/>\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-b1e43fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b1e43fd\" 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-7bf901c\" data-id=\"7bf901c\" 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-33d5f5f elementor-widget elementor-widget-text-editor\" data-id=\"33d5f5f\" 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;\">Di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c<\/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;\">=SUMPRODUCT((OR(A4:A9=&#8221;t\u00e1o&#8221;,A4:A9=&#8221;\u1ed5i&#8221;)*(B4:B9=&#8221;B&#8221;)*C4: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-20c17ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"20c17ed\" 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-ae56057\" data-id=\"ae56057\" 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-465b679 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"465b679\" 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-3e27db67-7fff-4001-6cc2-70e53c73c1c5\"><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;\">(OR(A4:A9=\"t\u00e1o\",A4:A9=\"\u1ed5i\") ki\u1ec3m tra S\u1ea3n ph\u1ea9m c\u00f3 ph\u1ea3i l\u00e0 T\u00e1o ho\u1eb7c \u1ed4i kh\u00f4ng, tr\u1ea3 v\u1ec1 {<\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">, <\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">,<\/span><span style=\"font-size: 12pt; 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;\"> TRUE<\/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;\">, <\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">, FALSE, <\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">}<\/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-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-62dfe21f-7fff-66b7-2e00-638982f64ef3\"><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;\">(B4:B9=\"B\") tr\u1ea3 v\u1ec1 {FALSE, <\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">,<\/span><span style=\"font-size: 12pt; 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;\"> TRUE<\/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;\">, FALSE, FALSE, <\/span><span style=\"font-size: 12pt; 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;\">TRUE<\/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;\">}<\/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-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-957ff92b-7fff-94ea-be31-f3da6e65e104\"><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;\">C4:C9 l\u00e0 c\u00e1c ph\u1ea7n t\u1eed c\u1ed9t Doanh thu<\/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-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: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Ph\u00e9p nh\u00e2n gi\u1eefa 3 m\u1ea3ng tr\u00ean tr\u1edf th\u00e0nh:<\/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-bd9b370 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bd9b370\" 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-4ee7f9d\" data-id=\"4ee7f9d\" 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-45a7936 elementor-widget elementor-widget-image\" data-id=\"45a7936\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-ham-sumproduct-dien-giai-khi-ket-hop-OR.png\" title=\"su-dung-ham-sumproduct-dien-giai-khi-ket-hop-OR\" alt=\"H\u00e0m SUMPRODUCT T\u00ednh T\u1ed5ng Theo \u0110i\u1ec1u Ki\u1ec7n C\u00f3 To\u00e1n T\u1eed OR (Ho\u1eb7c)- c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m sumproduct\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9a30325 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a30325\" 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-7d037d0\" data-id=\"7d037d0\" 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-6229130 elementor-widget elementor-widget-heading\" data-id=\"6229130\" 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-95bb8e70-7fff-1110-2f30-744e74f53c6f\"><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.3, H\u00e0m SUMPRODUCT K\u1ebft H\u1ee3p H\u00e0m Excel T\u1ea1o C\u00f4ng Th\u1ee9c M\u1ea3ng<\/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-b7c9675 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7c9675\" 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-a246fae\" data-id=\"a246fae\" 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-7593fec elementor-widget elementor-widget-text-editor\" data-id=\"7593fec\" 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;\">M\u1ed9t s\u1ed1 h\u00e0m khi trong c\u00f4ng th\u1ee9c c\u00f3 \u0111\u1ed1i s\u1ed1 l\u00e0 m\u1ed9t d\u1ea3i \u00f4 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng gi\u1ed1ng y\u00eau c\u1ea7u c\u1ee7a ng\u01b0\u1eddi vi\u1ebft do ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c m\u1ea3ng.<\/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;\">V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong d\u1ea3i \u00f4 A3:A5, s\u1eed d\u1ee5ng Ctrl + Shift + Enter \u0111\u1ec3 ch\u1ea1y c\u00f4ng th\u1ee9c m\u1ea3ng, k\u1ebft qu\u1ea3 m\u1ea3ng b\u1eb1ng 6 kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm:<\/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-3f112bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3f112bd\" 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-f5f86f7\" data-id=\"f5f86f7\" 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-884fce8 elementor-widget elementor-widget-image\" data-id=\"884fce8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/su-dung-cong-thuc-mang-khong-ra-ket-qua-chinh-xac-can-thay-the-bang-ham-sumproduct.png\" title=\"su-dung-cong-thuc-mang-khong-ra-ket-qua-chinh-xac-can-thay-the-bang-ham-sumproduct\" alt=\"s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong d\u1ea3i \u00f4 A3:A5, s\u1eed d\u1ee5ng Ctrl + Shift + Enter \u0111\u1ec3 ch\u1ea1y c\u00f4ng th\u1ee9c m\u1ea3ng, k\u1ebft qu\u1ea3 m\u1ea3ng b\u1eb1ng 6 kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm\" \/>\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-58078b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58078b3\" 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-74de65b\" data-id=\"74de65b\" 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-e124e39 elementor-widget elementor-widget-text-editor\" data-id=\"e124e39\" 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-faa47630-7fff-1c65-5921-958244117602\"><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\u00ec h\u00e0m SUMPRODUCT \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c m\u1ea3ng n\u00ean n\u00f3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh tr\u1ef1c ti\u1ebfp tr\u00ean c\u00e1c m\u1ea3ng gi\u00fap ti\u1ebft ki\u1ec7m dung l\u01b0\u1ee3ng trong trang t\u00ednh Excel b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u1ed9t ph\u1ee5.<\/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-b4020e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b4020e4\" 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-2b3286f\" data-id=\"2b3286f\" 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-a07a9a7 elementor-widget elementor-widget-heading\" data-id=\"a07a9a7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-d3d218d0-7fff-51b6-b15f-802bf04edb69\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed D\u1ee5 9: K\u1ebft H\u1ee3p H\u00e0m SUMPRODUCT V\u1edbi H\u00e0m Len<\/span><\/span><\/h4>\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-0c6573c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c6573c\" 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-9b44c06\" data-id=\"9b44c06\" 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-ae593c7 elementor-widget elementor-widget-text-editor\" data-id=\"ae593c7\" 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-330dc79d-7fff-81dd-dc07-0eee0a592281\"><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;\">Ti\u1ebfp t\u1ee5c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c m\u1ea3ng \u1edf tr\u00ean, \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i \u00f4 th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh (h\u00e0m LEN) tr\u1ef1c k\u1ebft l\u00ean m\u1ea3ng nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-546154c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"546154c\" 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-4025677\" data-id=\"4025677\" 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-60d234e elementor-widget elementor-widget-image\" data-id=\"60d234e\" 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\/vi-du-ham-sumproduct-ket-hop-ham-len-de-tinh-toan-cong-thuc-mang-trong-excel.png\" title=\"vi-du-ham-sumproduct-ket-hop-ham-len-de-tinh-toan-cong-thuc-mang-trong-excel\" alt=\"K\u1ebft H\u1ee3p H\u00e0m SUMPRODUCT V\u1edbi H\u00e0m Len\" \/>\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-12333f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12333f3\" 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-a9256f2\" data-id=\"a9256f2\" 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-7879138 elementor-widget elementor-widget-heading\" data-id=\"7879138\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-b40ca353-7fff-31e1-5cbc-0218d4cdecf7\"><span style=\"font-size: 14pt; font-family: Arial; color: rgb(11, 83, 148); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">V\u00ed d\u1ee5 10: \u0110\u1ebfm Lo\u1ea1i B\u1ecf C\u00e1c Gi\u00e1 Tr\u1ecb Gi\u1ed1ng Nhau B\u1eb1ng C\u00e1ch K\u1ebft H\u1ee3p H\u00e0m COUNTIF v\u00e0 SUMPRODUCT<\/span><\/span><\/h4>\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-d6f3620 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d6f3620\" 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-c7f65cd\" data-id=\"c7f65cd\" 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-2ffaea7 elementor-widget elementor-widget-text-editor\" data-id=\"2ffaea7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"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;\">Nh\u01b0 \u0111\u00e3 n\u00eau trong b\u00e0i vi\u1ebft <\/span><a href=\"https:\/\/hoctin.vn\/ham-countif-nang-cao\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m COUNTIF N\u00e2ng Cao<\/a><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;\">, hoctin.vn s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u1ea3 tr\u01b0\u1eddng h\u1ee3p \u0111\u1ebfm \u00f4 tr\u1ed1ng l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 kh\u00f4ng \u0111\u1ebfm \u00f4 tr\u1ed1ng:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4f5e4dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f5e4dc\" 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-203d776\" data-id=\"203d776\" 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-2321549 elementor-widget elementor-widget-image\" data-id=\"2321549\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/ham-countif-ket-hop-sumproduct-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi-1.png\" title=\"ham-countif-ket-hop-sumproduct-dem-cac-gia-tri-duy-nhat-trong-cung-mot-pham-vi\" alt=\"\u0110\u1ebfm Lo\u1ea1i B\u1ecf C\u00e1c Gi\u00e1 Tr\u1ecb Gi\u1ed1ng Nhau B\u1eb1ng C\u00e1ch K\u1ebft H\u1ee3p H\u00e0m COUNTIF v\u00e0 SUMPRODUCT\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2da516f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2da516f\" 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-8a92232\" data-id=\"8a92232\" 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-1e165f7 elementor-widget elementor-widget-text-editor\" data-id=\"1e165f7\" 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;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 v\u00e0 \u1ee9ng d\u1ee5ng hay c\u1ee7a h\u00e0m SUMPRODUCT t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn&nbsp;n\u00e2ng cao trong Excel. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.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;\">&nbsp;<\/span><\/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;\">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.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\">\n<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" 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; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMIF<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m IF<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cac-cach-tinh-tong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">6 C\u00e1ch T\u00ednh T\u1ed5ng Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/pivot-table-nang-cao\/\" target=\"_blank\">Pivot Table N\u00e2ng Cao<\/a><br><\/p>\n<div>&nbsp;<\/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>Khi t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, ch\u1eafc nhi\u1ec1u b\u1ea1n hay s\u1eed d\u1ee5ng h\u00e0m t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n SUMIF ho\u1eb7c SUMIFS. Tuy nhi\u00ean \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c m\u1ea3ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT hi\u1ec7u qu\u1ea3 h\u01a1n nhi\u1ec1u. \u00a0 B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed &#8230; <a title=\"H\u00e0m SUMPRODUCT T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao &#038; C\u00e1c V\u00ed D\u1ee5 Chi Ti\u1ebft\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-sumproduct-trong-excel\/\">Read more <span class=\"screen-reader-text\">H\u00e0m SUMPRODUCT T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao &#038; C\u00e1c V\u00ed D\u1ee5 Chi Ti\u1ebft<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1367,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[34,54,53,9,10,12,52],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1325"}],"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=1325"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1367"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}