{"id":559,"date":"2020-07-20T22:48:38","date_gmt":"2020-07-20T15:48:38","guid":{"rendered":"https:\/\/hoctin.vn\/?p=559"},"modified":"2020-08-24T03:33:12","modified_gmt":"2020-08-23T20:33:12","slug":"ham-sumif-trong-excel-nang-cao","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-sumif-trong-excel-nang-cao\/","title":{"rendered":"C\u00e1c V\u00ed D\u1ee5 H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel N\u00e2ng Cao V\u1edbi C\u00f4ng Th\u1ee9c M\u1ea3ng"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"559\" class=\"elementor elementor-559\">\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-b23a476 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b23a476\" 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-917faaf\" data-id=\"917faaf\" 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-5d7790f elementor-widget elementor-widget-text-editor\" data-id=\"5d7790f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">h\u00e0m SUMIF<\/a> \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft nh\u1ea5t t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng c\u00f9ng c\u00e1c l\u01b0u \u00fd quan tr\u1ecdng khi \u00e1p d\u1ee5ng h\u00e0m t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u1ede b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd ti\u1ebfp t\u1ee5c gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1c v\u00ed d\u1ee5 n\u00e2ng cao c\u1ee7a h\u00e0m SUMIF trong Excel v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, k\u1ebft h\u1ee3p h\u00e0m logic v\u00e0 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n th\u1eddi.<\/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-b2a1847 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b2a1847\" 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-e6b98b6\" data-id=\"e6b98b6\" 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-a8daddf elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"a8daddf\" 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-913a96b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"913a96b\" 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-3dd285e\" data-id=\"3dd285e\" 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-a5c6f21 elementor-widget elementor-widget-heading\" data-id=\"a5c6f21\" 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-46e851c7-7fff-ad76-e138-1e7625710e2b\"><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, S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel R\u00fat G\u1ecdn C\u00f4ng Th\u1ee9c T\u00ednh T\u1ed5ng C\u00f3 Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n K\u1ebft H\u1ee3p H\u00e0m OR<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5a20038 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5a20038\" 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-32021d9\" data-id=\"32021d9\" 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-2934028 elementor-widget elementor-widget-text-editor\" data-id=\"2934028\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c m\u00e1y trong c\u1ed9t A, gi\u00e1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a t\u1eebng lo\u1ea1i m\u00e1y v\u1edbi c\u00f4ng th\u1ee9c =SUMIF(A:A,\u201cT\u00ean m\u00e1y\u201d,B:B).\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Tuy nhi\u00ean n\u1ebfu s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIF \u0111\u01a1n gi\u1ea3n tr\u00ean, khi c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t danh s\u00e1ch g\u1ed3m nhi\u1ec1u lo\u1ea1i m\u00e1y kh\u00e1c nhau trong c\u1ed9t A th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i g\u00f5 \u0111i g\u00f5 l\u1ea1i c\u00f4ng th\u1ee9c nhi\u1ec1u l\u1ea7n, v\u00ed d\u1ee5 \u0111\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb M\u00e1y h\u00e0n v\u00e0 M\u00e1y \u00e9p:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=SUMIF(A3:A7,&#8221;M\u00e1y h\u00e0n&#8221;,B3:B7)+SUMIF(A3:A7,&#8221;M\u00e1y \u00e9p&#8221;,B3:B7)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">V\u1edbi m\u1ed9t danh s\u00e1ch v\u00e0i tr\u0103m lo\u1ea1i m\u00e1y th\u00ec \u0111i\u1ec1u n\u00e0y t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c. R\u1ea5t may l\u00e0 Excel c\u00f3 c\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=SUMPRODUCT(SUMIF(A3:A7,D3:D4,B3:B7))<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Criteria c\u1ee7a h\u00e0m SUMIF l\u00fac n\u00e0y d\u1ea1ng d\u00e3y D3:D4 ch\u1ee9a 2 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m ti\u00eau ch\u00ed. Ph\u1ea1m vi n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng \u0111\u1ec3 bao g\u1ed3m c\u00e1c ti\u00eau ch\u00ed b\u1ed5 sung khi c\u1ea7n thi\u1ebft.<\/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-d777cb9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d777cb9\" 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-5da0fd4\" data-id=\"5da0fd4\" 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-d15e96b elementor-widget elementor-widget-image\" data-id=\"d15e96b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-la-mang.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-la-mang\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel R\u00fat G\u1ecdn C\u00f4ng Th\u1ee9c T\u00ednh T\u1ed5ng C\u00f3 Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n K\u1ebft H\u1ee3p H\u00e0m OR\" \/>\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-f98a383 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f98a383\" 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-03b0396\" data-id=\"03b0396\" 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-73ca551 elementor-widget elementor-widget-heading\" data-id=\"73ca551\" 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-356ea946-7fff-eb8d-c44c-06529ac16ac2\"><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<\/span><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">, <\/span><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;\">S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c M\u1ea3ng \u0110\u1ec3 T\u00ednh \u0110i\u1ec1u Ki\u1ec7n Ho\u1eb7c (OR) Trong Tr\u01b0\u1eddng H\u1ee3p H\u00e0m SUMIF Kh\u00f4ng Ho\u1ea1t \u0110\u1ed9ng Ch\u00ednh X\u00e1c Khi K\u1ebft H\u1ee3p H\u00e0m Logic<\/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-7b31901 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7b31901\" 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-fa3087e\" data-id=\"fa3087e\" 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-9cadd63 elementor-widget elementor-widget-text-editor\" data-id=\"9cadd63\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u00ednh t\u1ed5ng c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean x\u1ea3y ra c\u00f9ng l\u00fac th\u00ec r\u1ea5t \u0111\u01a1n gi\u1ea3n, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m SUMIFS.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c lo\u1ea1i hoa qu\u1ea3 trong c\u1ed9t A, h\u00e3ng t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B v\u00e0 Doanh thu (Sales) t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t C.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng doanh thu c\u1ee7a \u0111\u00e1p \u1ee9ng 2 \u0111i\u1ec1u ki\u1ec7n: l\u00e0 T\u00e1o v\u00e0 H\u00e3ng Zespri v\u1edbi c\u00f4ng th\u1ee9c =SUMIFS(C3:C7,A3:A7,&#8221;t\u00e1o&#8221;,B3:B7,&#8221;zespri&#8221;) nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/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-4eef325 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4eef325\" 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-bb13acd\" data-id=\"bb13acd\" 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-f983341 elementor-widget elementor-widget-image\" data-id=\"f983341\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/ham-sumifs-tinh-tong-nhieu-dieu-kien.png\" title=\"ham-sumifs-tinh-tong-nhieu-dieu-kien\" alt=\"h\u00e0m sumifs t\u00ednh t\u1ed5ng t\u1eeb 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean\" \/>\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-6070aa2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6070aa2\" 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-1ec1155\" data-id=\"1ec1155\" 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-d5d7655 elementor-widget elementor-widget-text-editor\" data-id=\"d5d7655\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u01b0ng tr\u01b0\u1eddng h\u1ee3p t\u00ednh t\u1ed5ng n\u1ebfu th\u1ecfa m\u00e3n 1 trong 2 \u0111i\u1ec1u ki\u1ec7n th\u00ec sao?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">N\u1ebfu \u00e1p d\u1ee5ng \u0111\u01a1n thu\u1ea7n h\u00e0m SUMIF k\u1ebft h\u1ee3p h\u00e0m OR c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u1ee7a bi\u1ec3u th\u1ee9c sai v\u00ec c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c c\u1ed9ng hai l\u1ea7n nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">B\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">=SUM(IF((A3:A7=&#8221;T\u00e1o&#8221;)+(B3:B7=&#8221;zespri&#8221;),1,0)*C3:C7)<\/span><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-737ee17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"737ee17\" 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-1ba9c17\" data-id=\"1ba9c17\" 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-d52ad77 elementor-widget elementor-widget-image\" data-id=\"d52ad77\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-hoac-su-dung-mang.png\" title=\"su-dung-ham-sumif-trong-excel-de-tinh-tong-co-dieu-kien-hoac-su-dung-mang\" alt=\"S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c M\u1ea3ng \u0110\u1ec3 T\u00ednh \u0110i\u1ec1u Ki\u1ec7n Ho\u1eb7c (OR) Trong Tr\u01b0\u1eddng H\u1ee3p H\u00e0m SUMIF Kh\u00f4ng Ho\u1ea1t \u0110\u1ed9ng Ch\u00ednh X\u00e1c Khi K\u1ebft H\u1ee3p H\u00e0m Logic\" \/>\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-1d92c2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d92c2f\" 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-008c466\" data-id=\"008c466\" 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-6c50eee elementor-widget elementor-widget-text-editor\" data-id=\"6c50eee\" 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-331c95ab-7fff-0425-6cb9-6676127a82a1\"><span style=\"font-size: 11pt; 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: \u1ea4n Ctrl + Shift+ Enter \u0111\u1ec3 c\u00f4ng th\u1ee9c m\u1ea3ng ho\u1ea1t \u0111\u1ed9ng.<\/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-b50dc1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b50dc1b\" 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-afdc74e\" data-id=\"afdc74e\" 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-d54cd99 elementor-widget elementor-widget-heading\" data-id=\"d54cd99\" 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-f50c78c1-7fff-3561-d93e-26ac8ca9842f\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, D\u00f9ng H\u00e0m SUMIF T\u00ednh T\u1ed5ng C\u00e1c Gi\u00e1 Tr\u1ecb Ph\u00e1t Sinh Trong M\u1ed9t Kho\u1ea3ng Th\u1eddi Gian Nh\u1ea5t \u0110\u1ecbnh<\/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-5e369e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e369e4\" 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-2cb4614\" data-id=\"2cb4614\" 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-696c743 elementor-widget elementor-widget-text-editor\" data-id=\"696c743\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u1ee9ng ph\u00e1t sinh gi\u1eefa hai ng\u00e0y?<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS cho phi\u00ean b\u1ea3n Excel t\u1eeb 2007 tr\u1edf \u0111i.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">N\u1ebfu phi\u00ean b\u1ea3n Excel c\u1ee7a b\u1ea1n kh\u00f4ng h\u1ed7 tr\u1ee3 c\u00f4ng th\u1ee9c SUMIFS, h\u00e3y s\u1eed d\u1ee5ng hai c\u00f4ng th\u1ee9c SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb ph\u00e1t sinh gi\u1eefa ng\u00e0y T v\u00e0 ng\u00e0y T+n nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; font-weight: bold; white-space: pre-wrap;\">=SUMIF(range,\u201c&gt;=T\u201d,[sum_range])-SUMIF(range,\u201c&gt;=T+n\u201d,[sum_range])<\/span><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a598cbc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a598cbc\" 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-32f9e7f\" data-id=\"32f9e7f\" 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-7e0dc75 elementor-widget elementor-widget-image\" data-id=\"7e0dc75\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/ham-sumif-tinh-tong-co-dieu-kien-phat-sinh-trong-mot-khoang-thoi-gian.png\" title=\"ham-sumif-tinh-tong-co-dieu-kien-phat-sinh-trong-mot-khoang-thoi-gian\" alt=\"H\u00e0m SUMIF T\u00ednh T\u1ed5ng C\u00e1c Gi\u00e1 Tr\u1ecb Ph\u00e1t Sinh Trong M\u1ed9t Kho\u1ea3ng Th\u1eddi Gian Nh\u1ea5t \u0110\u1ecbnh\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d1dc170 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d1dc170\" 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-494b702\" data-id=\"494b702\" 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-8fdefe2 elementor-widget elementor-widget-heading\" data-id=\"8fdefe2\" 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-d39bc7ff-7fff-6658-a307-e6d41171b87e\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4, S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel \u0110\u1ec3 T\u00ednh T\u1ed5ng Gi\u00e1 Tr\u1ecb H\u00f3a \u0110\u01a1n D\u1ef1a Tr\u00ean Ng\u00e0y Hi\u1ec7n T\u1ea1i<\/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-6e045b5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e045b5\" 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-0c205fd\" data-id=\"0c205fd\" 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-1926e4f elementor-widget elementor-widget-text-editor\" data-id=\"1926e4f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">M\u1ed9t v\u00ed d\u1ee5 hay g\u1eb7p \u0111\u1ed1i v\u1edbi c\u00e1c b\u1ea1n k\u1ebf to\u00e1n, \u0111\u00f3 l\u00e0 t\u00ednh gi\u00e1 tr\u1ecb c\u00e1c h\u00f3a \u0111\u01a1n ph\u00e1t sinh trong m\u1ed9t s\u1ed1 ng\u00e0y g\u1ea7n nh\u1ea5t ho\u1eb7c ki\u1ec3m tra gi\u00e1 tr\u1ecb h\u00f3a \u0111\u01a1n \u0111\u1ebfn h\u1ea1n thanh to\u00e1n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c h\u00f3a \u0111\u01a1n trong c\u1ed9t A, ng\u00e0y h\u00f3a \u0111\u01a1n t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B v\u00e0 S\u1ed1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t C.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u00e1c h\u00f3a \u0111\u01a1n ph\u00e1t sinh trong 30 ng\u00e0y g\u1ea7n nh\u1ea5t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF k\u1ebft h\u1ee3p h\u00e0m TODAY() nh\u01b0 v\u00ed d\u1ee5 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0d9adc3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d9adc3\" 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-a8d2b37\" data-id=\"a8d2b37\" 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-b573b62 elementor-widget elementor-widget-image\" data-id=\"b573b62\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/ham-sumif-ket-hop-today-tinh-tong-co-dieu-kien.png\" title=\"ham-sumif-ket-hop-today-tinh-tong-co-dieu-kien\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel \u0110\u1ec3 T\u00ednh T\u1ed5ng Gi\u00e1 Tr\u1ecb H\u00f3a \u0110\u01a1n D\u1ef1a Tr\u00ean Ng\u00e0y Hi\u1ec7n T\u1ea1i H\u00e0m TODAY\" \/>\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-4565ac6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4565ac6\" 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-31a3ce9\" data-id=\"31a3ce9\" 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-15e698c elementor-widget elementor-widget-text-editor\" data-id=\"15e698c\" 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-5553a1b1-7fff-e914-5cf8-48083bc507f6\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Ho\u1eb7c c\u00f3 th\u1ec3 th\u00eam tr\u01b0\u1eddng Tu\u1ed5i n\u1ee3 b\u1eb1ng c\u00e1ch l\u1ea5y M\u1ed1c ng\u00e0y c\u1ea7n t\u00ednh (cu\u1ed1i ni\u00ean \u0111\u1ed9 k\u1ebf to\u00e1n, cu\u1ed1i th\u00e1ng ho\u1eb7c ng\u00e0y h\u00f4m nay b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TODAY) tr\u1eeb \u0111i ng\u00e0y h\u00f3a \u0111\u01a1n v\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUMIF nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/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-b64fc1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b64fc1d\" 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-176b767\" data-id=\"176b767\" 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-6dbf959 elementor-widget elementor-widget-image\" data-id=\"6dbf959\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/ham-sumif-tinh-tong-co-dieu-kien-cach-2-tinh-tuoi-tho-hoa-don.png\" title=\"ham-sumif-tinh-tong-co-dieu-kien-cach-2-tinh-tuoi-tho-hoa-don\" alt=\"S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel \u0110\u1ec3 T\u00ednh T\u1ed5ng Gi\u00e1 Tr\u1ecb H\u00f3a \u0110\u01a1n D\u1ef1a Tr\u00ean Ng\u00e0y Hi\u1ec7n T\u1ea1i H\u00e0m TODAY\" \/>\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-9014276 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9014276\" 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-19d5473\" data-id=\"19d5473\" 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-ce87388 elementor-widget elementor-widget-text-editor\" data-id=\"ce87388\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 hay v\u1ec1 h\u00e0m SUMIF 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 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng n\u00e2ng cao c\u1ee7a h\u00e0m SUMIF.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">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><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H<\/span><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cac-cach-tinh-tong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u00e0m SUM v\u00e0 c\u00e1c c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMIF t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft nh\u1ea5t t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao cho d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng c\u00f9ng c\u00e1c l\u01b0u \u00fd quan tr\u1ecdng khi \u00e1p d\u1ee5ng h\u00e0m t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. \u1ede b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd ti\u1ebfp t\u1ee5c gi\u1edbi &#8230; <a title=\"C\u00e1c V\u00ed D\u1ee5 H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel N\u00e2ng Cao V\u1edbi C\u00f4ng Th\u1ee9c M\u1ea3ng\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel-nang-cao\/\">Read more <span class=\"screen-reader-text\">C\u00e1c V\u00ed D\u1ee5 H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng H\u00e0m SUMIF Trong Excel N\u00e2ng Cao V\u1edbi C\u00f4ng Th\u1ee9c M\u1ea3ng<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":571,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[10,12],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/559"}],"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=559"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/559\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/571"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}