{"id":12338,"date":"2025-01-15T08:11:40","date_gmt":"2025-01-15T08:11:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-gia-tri-trung-binh-voi-dieu-kien-cho-truoc-voi-ham-daverage\/"},"modified":"2025-01-15T08:11:40","modified_gmt":"2025-01-15T08:11:40","slug":"tinh-gia-tri-trung-binh-voi-dieu-kien-cho-truoc-voi-ham-daverage","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-gia-tri-trung-binh-voi-dieu-kien-cho-truoc-voi-ham-daverage\/","title":{"rendered":"T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc v\u1edbi h\u00e0m DAVERAGE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>B\u00ecnh th\u01b0\u1eddng, \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 li\u1ec7u, ta th\u01b0\u1eddng d\u00f9ng h\u00e0m AVERAGE. Nh\u01b0ng \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh v\u1edbi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc n\u00e0o \u0111\u00f3 th\u00ec b\u1ea1n l\u1ea1i kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AVERAGE m\u00e0 n\u00ean d\u00f9ng h\u00e0m\u00a0AVERAGE k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF. Tuy nhi\u00ean, \u0111\u1ec5 x\u1eed l\u00fd nhanh h\u01a1n, b\u1ea1n n\u00ean d\u00f9ng h\u00e0m DAVERAGE.\u00a0<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m <strong>DAVERAGE\u00a0<\/strong>trong Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67876db9647b2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tinh-gia-tri-trung-binh-voi-dieu-kien-cho-truoc-voi-ham-daverage.html#Cu_Phap\" title=\"C\u00fa Ph\u00e1p\">C\u00fa Ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tinh-gia-tri-trung-binh-voi-dieu-kien-cho-truoc-voi-ham-daverage.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Cu_Phap\"><\/span><strong>C\u00fa Ph\u00e1p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>=DAVERAGE(database, field, criteral)<\/strong><\/p>\n<p><em>Trong \u0111\u00f3<\/em><\/p>\n<p><strong>\u2013 <em>database<\/em>: <\/strong>Danh s\u00e1ch c\u01a1 s\u1edf d\u1eef li\u1ec7u bao g\u1ed3m c\u1ea3 c\u1ed9t ti\u00eau \u0111\u1ec1. Tham s\u1ed1 b\u1eaft bu\u1ed9c<br \/>\n<strong>\u2013<em> field<\/em>: <\/strong>\u0110\u1ecba ch\u1ec9 c\u1ee7a tr\u01b0\u1eddng d\u1eef li\u1ec7u. Tham s\u1ed1 b\u1eaft bu\u1ed9c.<br \/>\n<strong>\u2013 <em>criterial<\/em>: <\/strong>\u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh. Tham s\u1ed1 b\u1eaft bu\u1ed9c.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>T\u00ecm tu\u1ed5i trung b\u00ecnh c\u1ee7a nh\u1eefng nh\u00e2n vi\u00ean trong c\u00f4ng ty v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 t\u1ed1t nghi\u1ec7p \u0110\u1ea1i h\u1ecdc r\u1ed3i, \u00a0ta d\u00f9ng c\u00f4ng th\u1ee9c: <strong>=DAVERAGE(B2:D8;C2;D11:E12)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3416 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-daverage.png\" width=\"600\" height=\"418\" title=\"ham-daverage\"><\/p>\n<p>=&gt; K\u1ebft qu\u1ea3:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-385.gif\" title=\"ex101_92019-nho-385\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3419 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-daverage-2.png\" alt=\"ham-daverage\" width=\"600\" height=\"433\" title=\"ham-daverage-2\"><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-385.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12339,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12338","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12338"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12338\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12339"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}