{"id":1845,"date":"2020-12-22T01:42:32","date_gmt":"2020-12-21T18:42:32","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1845"},"modified":"2020-12-22T01:42:35","modified_gmt":"2020-12-21T18:42:35","slug":"ham-trung-binh-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-trung-binh-trong-excel\/","title":{"rendered":"C\u00e1c H\u00e0m Trung B\u00ecnh N\u00e2ng Cao Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1845\" class=\"elementor elementor-1845\">\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-5636766 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5636766\" 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-a138d7f\" data-id=\"a138d7f\" 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-2b9bdfb elementor-widget elementor-widget-text-editor\" data-id=\"2b9bdfb\" 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-6241de0f-7fff-6aab-d59f-cacc151b382a\"><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 \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft v\u1ec1 <\/span><a href=\"https:\/\/hoctin.vn\/ham-average-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><i><b>h\u00e0m AVERAGE<\/b><\/i><\/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;\"> \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng trong Excel.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3796d97 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3796d97\" 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-1f01300\" data-id=\"1f01300\" 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-ebb37b8 elementor-widget elementor-widget-text-editor\" data-id=\"ebb37b8\" 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;\">Tuy nhi\u00ean, khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u Excel, ngo\u00e0i c\u00f4ng th\u1ee9c t\u00ednh trung b\u00ecnh c\u1ed9ng \u0111\u01a1n gi\u1ea3n, nhi\u1ec1u l\u00fac ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n, t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a n gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t hay t\u00ednh b\u00ecnh qu\u00e2n gia quy\u1ec1n c\u00f3 tr\u1ecdng s\u1ed1.<\/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;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u1ec7c tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m c\u00e1c h\u00e0m trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n AVERAGEIF, AVERAGEIFS v\u00e0 c\u00e1c h\u00e0m SUM, SUMPRODUCT k\u1ebft h\u1ee3p c\u00e1c h\u00e0m 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-f5b0580 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5b0580\" 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-7f58a6c\" data-id=\"7f58a6c\" 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-9988262 elementor-widget elementor-widget-text-editor\" data-id=\"9988262\" 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;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m trung b\u00ecnh trong Excel 2007, 2010, 2013, 2016 v\u00e0 2019.<\/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-7211b67 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7211b67\" 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-6be31bd\" data-id=\"6be31bd\" 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-62162af elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"62162af\" 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-e7c88a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e7c88a0\" 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-fb5a290\" data-id=\"fb5a290\" 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-0cd4742 elementor-widget elementor-widget-heading\" data-id=\"0cd4742\" 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-680960b8-7fff-52e7-3320-64fde2daafa5\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00e1c C\u00f4ng Th\u1ee9c T\u00ednh Trung B\u00ecnh C\u1ed9ng Trong Excel Kh\u00f4ng D\u00f9ng H\u00e0m Trung B\u00ecnh AVERAGE<\/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-a527b0a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a527b0a\" 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-a880fc0\" data-id=\"a880fc0\" 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-2ab7f84 elementor-widget elementor-widget-text-editor\" data-id=\"2ab7f84\" 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-9fc97628-7fff-94a9-38d1-9d86c2b8221c\"><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 trung b\u00ecnh c\u1ed9ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc, ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m AVERAGE, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 chia cho s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh trung b\u00ecnh.<\/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-32f8b36 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32f8b36\" 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-2e40946\" data-id=\"2e40946\" 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-1d96080 elementor-widget elementor-widget-text-editor\" data-id=\"1d96080\" 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 \u00e1p d\u1ee5ng khi s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh trung b\u00ecnh c\u1ed9ng \u0111\u00e3 \u0111\u01b0\u1ee3c bi\u1ebft tr\u01b0\u1edbc v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh (n\u1ebfu c\u00f3 \u00f4 tr\u1ed1ng th\u00ec gi\u00e1 tr\u1ecb trung b\u00ecnh v\u1eabn chia \u0111\u1ec1u cho c\u1ea3 \u00f4 tr\u1ed1ng)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=SUM(C3:E3)\/3<\/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-2627d62 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2627d62\" 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-c75675f\" data-id=\"c75675f\" 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-a5156e8 elementor-widget elementor-widget-image\" data-id=\"a5156e8\" 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\/12\/su-dung-ham-sum-de-tinh-diem-trung-binh-trong-excel.png\" title=\"su-dung-ham-sum-de-tinh-diem-trung-binh-trong-excel\" alt=\"C\u00f4ng Th\u1ee9c T\u00ednh Trung B\u00ecnh C\u1ed9ng Trong Excel \u00c1p D\u1ee5ng H\u00e0m SUM Chia Cho S\u1ed1 Gi\u00e1 Tr\u1ecb C\u1ea7n 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-5c12ca6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c12ca6\" 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-e1ec77b\" data-id=\"e1ec77b\" 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-14ad4d5 elementor-widget elementor-widget-text-editor\" data-id=\"14ad4d5\" 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 b\u1ea1n mu\u1ed1n b\u1ecf qua \u00f4 tr\u1ed1ng, h\u00e3y k\u1ebft h\u1ee3p h\u00e0m SUM t\u00ednh t\u1ed5ng c\u00e1c \u00f4 v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e9p chia cho h\u00e0m COUNT \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 ch\u1ee9a c\u00e1c 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; font-weight: bold; white-space: pre-wrap;\">=SUM(B4:E4)\/COUNT(B4:E4)<\/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-32370b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32370b8\" 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-2b96f61\" data-id=\"2b96f61\" 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-2402947 elementor-widget elementor-widget-image\" data-id=\"2402947\" 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\/12\/su-dung-ham-sum-ket-hop-count-de-tinh-trung-binh-cong-trong-excel.png\" title=\"su-dung-ham-sum-ket-hop-count-de-tinh-trung-binh-cong-trong-excel\" alt=\"T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m SUM t\u00ednh t\u1ed5ng c\u00e1c \u00f4 v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e9p chia cho h\u00e0m COUNT \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 ch\u1ee9a c\u00e1c 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-61a6fbf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"61a6fbf\" 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-36159ca\" data-id=\"36159ca\" 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-c67e4f2 elementor-widget elementor-widget-heading\" data-id=\"c67e4f2\" 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-e86b1df2-7fff-acef-5525-0dd329061707\"><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, H\u00e0m Trung B\u00ecnh C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Trong Excel: AVERAGEIF v\u00e0 AVERAGEIFS<\/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-10dede6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"10dede6\" 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-983bb0c\" data-id=\"983bb0c\" 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-d0a610b elementor-widget elementor-widget-heading\" data-id=\"d0a610b\" 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-eabcf65d-7fff-d52a-5cd1-0dd44fc8d6db\"><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, H\u00e0m Trung B\u00ecnh AVERAGEIF T\u00ednh Trung B\u00ecnh V\u1edbi 1 Ti\u00eau Ch\u00ed Duy 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-6eb60d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6eb60d3\" 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-f4eaaab\" data-id=\"f4eaaab\" 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-9bda000 elementor-widget elementor-widget-text-editor\" data-id=\"9bda000\" 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\u00e1ch ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 <\/span><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\"><b><i>h\u00e0m COUNTIF<\/i><\/b><\/a><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\u00e0 <\/span><a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b><i>SUMIF<\/i><\/b><\/a><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 AVERAGEIF tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t pha\u0323m vi \u0111\u00e1p \u1ee9ng ti\u00eau ch\u00ed \u0111\u01b0a ra:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=AVERAGEIF(range, criteria, [average_range])<\/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-75d28a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"75d28a3\" 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-f008da3\" data-id=\"f008da3\" 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-42614f8 elementor-widget elementor-widget-text-editor\" data-id=\"42614f8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Range: ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 m\u00e0 theo \u0111\u00f3 c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n, m\u1ea3ng ho\u1eb7c tham chi\u1ebfu c\u00f3 ch\u1ee9a s\u1ed1.<\/span><\/p><\/li><\/ul><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Criteria: Ti\u00eau ch\u00ed \u1edf d\u1ea1ng s\u1ed1, bi\u1ec3u th\u1ee9c, bi\u1ec3u th\u1ee9c logic, tham chi\u1ebfu \u00f4 ho\u1eb7c v\u0103n b\u1ea3n. V\u00ed d\u1ee5, c\u00e1c ti\u00eau ch\u00ed c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb d\u01b0\u1edbi d\u1ea1ng nh\u01b0 10, A1*10, &#8220;&gt;10&#8221;, B2 ho\u1eb7c &#8220;nh\u00f3m A&#8221;.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Average_range: c\u00e1c \u00f4 c\u1ea7n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c23a7ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c23a7ae\" 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-468c213\" data-id=\"468c213\" 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-b355abd elementor-widget elementor-widget-text-editor\" data-id=\"b355abd\" 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-bf26506b-7fff-7ddc-111a-3b6f657285d5\"><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 d\u01b0\u1edbi \u0111\u00e2y t\u00ednh \u0111i\u1ec3m trung b\u00ecnh c\u1ed9ng c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m thu\u1ed9c nh\u00f3m Alpha v\u00e0 nh\u00f3m Beta theo c\u00f4ng th\u1ee9c h\u00e0m trung b\u00ecnh c\u00f3 \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-49acdb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49acdb7\" 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-795a7f0\" data-id=\"795a7f0\" 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-56466cc elementor-widget elementor-widget-image\" data-id=\"56466cc\" 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\/12\/ham-trung-binh-ham-averageif-tinh-trung-binh-trong-excel-co-dieu-kien.png\" title=\"ham-trung-binh-ham-averageif-tinh-trung-binh-trong-excel-co-dieu-kien\" alt=\"h\u00e0m AVERAGEIF tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t pha\u0323m vi \u0111\u00e1p \u1ee9ng ti\u00eau ch\u00ed \u0111\u01b0a ra\" \/>\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-25200ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"25200ed\" 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-334e7d8\" data-id=\"334e7d8\" 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-a186bf6 elementor-widget elementor-widget-heading\" data-id=\"a186bf6\" 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-4bcab75b-7fff-417f-69fb-faf0e8edca09\"><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, H\u00e0m Trung B\u00ecnh AVERAGEIFS T\u00ednh Trung B\u00ecnh V\u1edbi Nhi\u1ec1u \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-309da3f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"309da3f\" 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-f2a4046\" data-id=\"f2a4046\" 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-42dee90 elementor-widget elementor-widget-text-editor\" data-id=\"42dee90\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u00ednh s\u1ed1 trung b\u00ecnh d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AVERAGEIFS:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=AVERAGEIFS(average_range, range1, criteria1, range2, criteria2,\u2026)<\/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-68dee9f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"68dee9f\" 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-56c1c13\" data-id=\"56c1c13\" 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-47b5aaf elementor-widget elementor-widget-text-editor\" data-id=\"47b5aaf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u00f4 G5 t\u00ednh doanh s\u1ed1 trung b\u00ecnh c\u1ee7a <\/span><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;\">S\u1ea3n ph\u1ea9m <\/span><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;\">SP1 \u1edf <\/span><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;\">Khu v\u1ef1c<\/span><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\u00e0 N\u1ed9i. Nh\u01b0 v\u1eady, c\u00f3 2 ti\u00eau ch\u00ed c\u1ea7n x\u00e1c \u0111\u1ecbnh l\u00e0 S\u1ea3n ph\u1ea9m v\u00e0 Khu v\u1ef1c. C\u00f4ng th\u1ee9c trong \u00f4 G5 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i nh\u01b0 sau:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Average_range: <\/span><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;\">d\u1ea3i \u00f4 $B$5:$B$13 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh trung b\u00ecnh c\u1ed9ng.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Range1<\/span><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;\">: d\u1ea3i \u00f4 $A$5:$A$13 t\u01b0\u01a1ng \u1ee9ng ti\u00eau ch\u00ed 1 v\u1ec1 T\u00ean s\u1ea3n ph\u1ea9m.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Criteria1<\/span><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;\">: \u00f4 E5 (\u201cSP1\u201d) l\u00e0 ti\u00eau ch\u00ed 1.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">Range2<\/span><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;\">: d\u1ea3i \u00f4 C$5:C$13 t\u01b0\u01a1ng \u1ee9ng ti\u00eau ch\u00ed 2 v\u1ec1 Khu v\u1ef1c.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Criteria2<\/span><span style=\"background-color: transparent; font-size: 12pt; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">: \u00f4 F5 (\u201cH\u00e0 N\u1ed9i\u201d) l\u00e0 ti\u00eau ch\u00ed 2.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e29c61e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e29c61e\" 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-abf9641\" data-id=\"abf9641\" 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-68c0ea4 elementor-widget elementor-widget-image\" data-id=\"68c0ea4\" 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\/12\/ham-trung-binh-ham-averageifs-tinh-trung-binh-trong-excel-nhieu-dieu-kien.png\" title=\"ham-trung-binh-ham-averageifs-tinh-trung-binh-trong-excel-nhieu-dieu-kien\" alt=\"H\u00e0m Trung B\u00ecnh AVERAGEIFS T\u00ednh Trung B\u00ecnh V\u1edbi Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8542462 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8542462\" 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-93635f2\" data-id=\"93635f2\" 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-a277236 elementor-widget elementor-widget-heading\" data-id=\"a277236\" 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-5cb01438-7fff-9ff8-7550-79b013331156\"><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, T\u00ednh Trung B\u00ecnh Top N Gi\u00e1 Tr\u1ecb L\u1edbn Nh\u1ea5t\/ Nh\u1ecf Nh\u1ea5t<\/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-2cd1503 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2cd1503\" 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-2bef594\" data-id=\"2bef594\" 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-b42b016 elementor-widget elementor-widget-heading\" data-id=\"b42b016\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.1, H\u00e0m Trung B\u00ecnh AVERAGE K\u1ebft H\u1ee3p H\u00e0m LARGE T\u00ednh Trung B\u00ecnh Top N Gi\u00e1 Tr\u1ecb L\u1edbn 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-6eeea9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6eeea9e\" 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-df241a0\" data-id=\"df241a0\" 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-122c474 elementor-widget elementor-widget-text-editor\" data-id=\"122c474\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u00ednh trung b\u00ecnh c\u1ee7a n gi\u00e1 tr\u1ecb h\u00e0ng \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m AVERAGE v\u1edbi h\u00e0m LARGE.<\/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 <b>LARGE(array,k)<\/b> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u1ee9 k t\u1eeb tr\u00ean xu\u1ed1ng c\u1ee7a m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c 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-093bb38 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"093bb38\" 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-5f917a8\" data-id=\"5f917a8\" 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-65dd966 elementor-widget elementor-widget-text-editor\" data-id=\"65dd966\" 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<div style=\"text-align: justify;\"><span style=\"color: #000000; font-family: Arial;\"><span style=\"font-size: 16px; white-space: pre-wrap;\">V\u00ed d\u1ee5:<\/span><\/span><\/div><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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 LARGE (array, 5) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb cao th\u1ee9 5.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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 LARGE(array, {1,2,3}) tr\u1ea3 v\u1ec1 3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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;\">T\u01b0\u01a1ng t\u1ef1, v\u1edbi top 5 l\u1edbn nh\u1ea5t, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c LARGE(array, {1,2,3,4,5})<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5cda00c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5cda00c\" 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-503780d\" data-id=\"503780d\" 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-772792f elementor-widget elementor-widget-text-editor\" data-id=\"772792f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c trong c\u1ed9t I t\u00ednh trung b\u00ecnh c\u1ee7a top 3 \u0111i\u1ec3m h\u00e0ng \u0111\u1ea7u trong m\u1ed7i h\u00e0ng:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=AVERAGE(LARGE(ph\u1ea1m vi c\u1ea7n ch\u1ecdn top 3 t\u00ednh trung b\u00ecnh, {1,2,3}))<\/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-e474018 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e474018\" 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-9013760\" data-id=\"9013760\" 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-4a7f2a7 elementor-widget elementor-widget-image\" data-id=\"4a7f2a7\" 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\/12\/ham-trung-binh-de-tinh-diem-trung-binh-top-3-trong-excel-bang-cach-ket-hop-ham-average-va-large.png\" title=\"ham-trung-binh-de-tinh-diem-trung-binh-top-3-trong-excel-bang-cach-ket-hop-ham-average-va-large\" alt=\"H\u00e0m Trung B\u00ecnh AVERAGE K\u1ebft H\u1ee3p H\u00e0m LARGE T\u00ednh Trung B\u00ecnh Top N Gi\u00e1 Tr\u1ecb L\u1edbn Nh\u1ea5t\" \/>\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-a29dc2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a29dc2e\" 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-c511be9\" data-id=\"c511be9\" 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-cb43195 elementor-widget elementor-widget-heading\" data-id=\"cb43195\" 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-e90003e1-7fff-1307-07d0-c41d4e95098d\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.2, H\u00e0m Trung B\u00ecnh AVERAGE V\u00e0 H\u00e0m SMALL T\u00ednh Trung B\u00ecnh Top N Gi\u00e1 Tr\u1ecb Nh\u1ecf 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-5bd038a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5bd038a\" 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-2543cb6\" data-id=\"2543cb6\" 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-d6106f5 elementor-widget elementor-widget-text-editor\" data-id=\"d6106f5\" 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;\">Ng\u01b0\u1ee3c l\u1ea1i v\u1edbi h\u00e0m LARGE, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m SMALL v\u1edbi h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ee7a n gi\u00e1 tr\u1ecb cu\u1ed1i v\u1edbi c\u00fa ph\u00e1p t\u01b0\u01a1ng t\u1ef1.<\/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;\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh trung b\u00ecnh top 5 nh\u1ecf nh\u1ea5t, c\u00f4ng th\u1ee9c h\u00e0m trung b\u00ecnh k\u1ebft h\u1ee3p nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=AVERAGE(SMALL(ph\u1ea1m vi c\u1ea7n ch\u1ecdn top 5 t\u00ednh trung b\u00ecnh, {1,2,3,4,5}))<\/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-870b78e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"870b78e\" 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-a7ba93e\" data-id=\"a7ba93e\" 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-e35e3d8 elementor-widget elementor-widget-heading\" data-id=\"e35e3d8\" 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-dac28bc6-7fff-8e6a-6cd2-22686bc6075f\"><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 SUMPRODUCT \u0110\u1ec3 T\u00ednh To\u00e1n Trung B\u00ecnh C\u00f3 Tr\u1ecdng S\u1ed1<\/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-88fde99 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"88fde99\" 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-25e8449\" data-id=\"25e8449\" 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-a742d21 elementor-widget elementor-widget-text-editor\" data-id=\"a742d21\" 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\u00f4ng th\u1ee9c t\u00ednh b\u00ecnh qu\u00e2n gia quy\u1ec1n:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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 tr\u1ecdng s\u1ed1 \u1edf \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m: <\/span><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=SUMPRODUCT(m\u1ea3ng gi\u00e1 tr\u1ecb, m\u1ea3ng tr\u1ecdng s\u1ed1)<\/span><\/p><\/li><\/ul><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; 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;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><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 tr\u1ecdng s\u1ed1 kh\u00f4ng \u1edf \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m m\u00e0 l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 th\u00ec l\u1ec7nh t\u00ednh trung b\u00ecnh c\u1ed9ng l\u00e0 <\/span><span style=\"background-color: transparent; font-size: 12pt; font-weight: bold; white-space: pre-wrap;\">=SUMPRODUCT(m\u1ea3ng gi\u00e1 tr\u1ecb, m\u1ea3ng tr\u1ecdng s\u1ed1)\/ SUM(tr\u1ecdng s\u1ed1)<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a3c30a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a3c30a\" 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-ac145c3\" data-id=\"ac145c3\" 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-d22822c elementor-widget elementor-widget-text-editor\" data-id=\"d22822c\" 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-variant-numeric: normal; font-variant-east-asian: normal; text-align: justify; background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-style: italic; vertical-align: baseline; white-space: pre-wrap;\">Chi ti\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u1edf b\u00e0i vi\u1ebft:<\/span><i style=\"text-align: justify;\"><span style=\"font-weight: bold;\">\u00a0<\/span><\/i><i style=\"background-color: #ffffff; text-align: justify;\"><span style=\"font-weight: bold;\"><a style=\"background-color: #ffffff; text-align: justify;\" href=\"https:\/\/hoctin.vn\/ham-sumproduct-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m SUMPRODUCT trong Excel<\/a>.<\/span><\/i><\/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-4eaed18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4eaed18\" 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-e436162\" data-id=\"e436162\" 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-a8cc940 elementor-widget elementor-widget-text-editor\" data-id=\"a8cc940\" 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-daa4326c-7fff-b7a8-d7b0-811733108ebf\"><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 d\u01b0\u1edbi \u0111\u00e2y t\u00ednh \u0111i\u1ec3m t\u1ed5ng k\u1ebft h\u1ecdc ph\u1ea7n khi c\u00f3 c\u00e1c \u0111i\u1ec3m th\u00e0nh ph\u1ea7n m\u00f4n h\u1ecdc v\u00e0 tr\u1ecdng s\u1ed1 \u0111i\u1ec3m t\u01b0\u01a1ng \u1ee9ng:<\/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-17dfc6d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"17dfc6d\" 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-51b9d52\" data-id=\"51b9d52\" 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-9faaa9b elementor-widget elementor-widget-image\" data-id=\"9faaa9b\" 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\/12\/cach-tinh-trung-binh-cong-co-trong-so-trong-excel-bang-ham-sumproduct.png\" title=\"cach-tinh-trung-binh-cong-co-trong-so-trong-excel-bang-ham-sumproduct\" alt=\"V\u00ed D\u1ee5 S\u1eed D\u1ee5ng H\u00e0m SUMPRODUCT \u0110\u1ec3 T\u00ednh To\u00e1n Trung B\u00ecnh C\u00f3 Tr\u1ecdng 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-c3be23a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3be23a\" 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-24628ad\" data-id=\"24628ad\" 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-497d2f5 elementor-widget elementor-widget-text-editor\" data-id=\"497d2f5\" 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\u1ec1 c\u00e1c h\u00e0m trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n, h\u00e0m trung b\u00ecnh c\u00f3 tr\u1ecdng s\u1ed1 trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">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\u00e1c h\u00e0m trung b\u00ecnh trong Excel.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d649437 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d649437\" 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-31c0cf5\" data-id=\"31c0cf5\" 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-c532224 elementor-widget elementor-widget-text-editor\" data-id=\"c532224\" 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;\">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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b><i><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m IF<\/a><br \/><\/i><\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b><i><a href=\"https:\/\/hoctin.vn\/tinh-can-bac-2-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u0103n B\u1eadc 2 Trong Excel<\/a><br \/><\/i><\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-dem-co-dieu-kien\/\" target=\"_blank\" rel=\"noopener\"><b><i>H\u00e0m \u0110\u1ebfm C\u00f3 \u0110i\u1ec1u Ki\u1ec7n<\/i><\/b><\/a><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng trong Excel. Tuy nhi\u00ean, khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u Excel, ngo\u00e0i c\u00f4ng th\u1ee9c t\u00ednh trung b\u00ecnh c\u1ed9ng \u0111\u01a1n gi\u1ea3n, nhi\u1ec1u l\u00fac ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n, t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a n gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t &#8230; <a title=\"C\u00e1c H\u00e0m Trung B\u00ecnh N\u00e2ng Cao Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-trung-binh-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1c H\u00e0m Trung B\u00ecnh N\u00e2ng Cao Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[71,73,74,75,76,52],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1845"}],"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=1845"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1845\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1858"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}