{"id":9161,"date":"2025-01-01T19:47:24","date_gmt":"2025-01-01T19:47:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien\/"},"modified":"2025-01-01T19:47:24","modified_gmt":"2025-01-01T19:47:24","slug":"huong-dan-cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AVERAGEIF trong Excel \u0111\u1ec3 t\u00ednh trung b\u00ecnh theo \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap c\u00e1c b\u1ea1n bi\u1ebft l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00ednh trung b\u00ecnh theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3? N\u1ebfu nh\u01b0 ch\u1ec9 s\u1eed d\u1ee5ng h\u00e0m AVERAGE th\u00f4ng th\u01b0\u1eddng th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p th\u00eam v\u1edbi h\u00e0m IF. Trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AVERAGEIF <\/strong><\/a><\/em><\/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-67759bcb2fd7b\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien.html#Cach_tinh_trung_binh_co_dieu_kien_bang_ham_Average_ket_hop_ham_IF\" title=\"C\u00e1ch t\u00ednh trung b\u00ecnh c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m Average k\u1ebft h\u1ee3p h\u00e0m\u00a0IF\">C\u00e1ch t\u00ednh trung b\u00ecnh c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m Average k\u1ebft h\u1ee3p h\u00e0m\u00a0IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-ham-averageif-trong-excel-de-tinh-trung-binh-theo-dieu-kien.html#Cach_su_dung_ham_AVERAGEIF_tinh_trung_binh_cong_theo_dieu_kien\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AVERAGEIF t\u00ednh trung b\u00ecnh c\u1ed9ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AVERAGEIF t\u00ednh trung b\u00ecnh c\u1ed9ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_trung_binh_co_dieu_kien_bang_ham_Average_ket_hop_ham_IF\"><\/span>C\u00e1ch t\u00ednh trung b\u00ecnh c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m Average k\u1ebft h\u1ee3p h\u00e0m\u00a0IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta h\u00e3y c\u00f9ng x\u00e9t v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<figure id=\"attachment_25392\" aria-describedby=\"caption-attachment-25392\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25392\" title=\"1- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ham-averageif-01.png\" alt=\"1- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" width=\"600\" height=\"316\"><figcaption id=\"caption-attachment-25392\" class=\"wp-caption-text\">1- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel<\/figcaption><\/figure>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng b\u00e1n trung b\u00ecnh c\u1ee7a 1 m\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh nh\u1eefng m\u1eb7t h\u00e0ng l\u00e0 CAM v\u00e0 x\u00e9t ri\u00eang s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a nh\u1eefng m\u1eb7t h\u00e0ng n\u00e0y.<\/li>\n<li>T\u00ednh trung b\u00ecnh cho nh\u1eefng m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<figure id=\"attachment_25395\" aria-describedby=\"caption-attachment-25395\" style=\"width: 537px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25395 size-full\" title=\"2- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-tinh-trung-binh-theo-ham-if-01.png\" alt=\"2- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" width=\"537\" height=\"413\"><figcaption id=\"caption-attachment-25395\" class=\"wp-caption-text\">2- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel<\/figcaption><\/figure>\n<p>\u0110\u1ea7u ti\u00ean d\u00f9ng h\u00e0m\u00a0IF\u00a0\u0111\u1ec3 x\u00e9t xem m\u1eb7t h\u00e0ng c\u00f3 ph\u1ea3i l\u00e0 Cam\u00a0hay kh\u00f4ng, n\u1ebfu\u00a0\u0111\u00fang th\u00ec gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb S\u1ed1 l\u01b0\u1ee3ng, n\u1ebfu kh\u00f4ng\u00a0\u0111\u00fang th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p style=\"padding-left: 30px\">=IF(A2=\u201dCam\u201d,B2,\u201d\u201d)<\/p>\n<p>V\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n b\u1edfi h\u00e0m\u00a0IF, ch\u00fang ta s\u1ebd t\u00ednh trung b\u00ecnh b\u1eb1ng h\u00e0m Average:<\/p>\n<p style=\"padding-left: 30px\">=AVERAGE(C2:C11)<\/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-15.gif\" title=\"ex101_92019-nho-15\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 =(11+32+9+44)\/4 = 24<\/p>\n<p>Nh\u01b0ng v\u1edbi c\u00e1ch l\u00e0m n\u00e0y, ch\u00fang ta ph\u1ea3i s\u1eed d\u1ee5ng nhi\u1ec1u c\u00f4ng th\u1ee9c v\u00e0 th\u1eddi gian th\u1ef1c hi\u1ec7n kh\u00e1 l\u00e2u. Thay v\u00e0o\u00a0\u0111\u00f3 ch\u1ec9 c\u1ea7n d\u00f9ng h\u00e0m AVERAGEIF l\u00e0\u00a0\u0111\u01b0\u1ee3c.<br \/>\nN\u1ebfu c\u00e1c b\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 t\u00ednh trung b\u00ecnh v\u1edbi kh\u00f4ng ch\u1ec9 m\u1ed9t m\u00e0 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec hayz xem b\u00e0i vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-averageifs-trong-excel-de-tinh-trung-binh-theo-nhieu-dieu-kien.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageifs trong Excel<\/strong><\/a> n\u00e0y nh\u00e9!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_AVERAGEIF_tinh_trung_binh_cong_theo_dieu_kien\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AVERAGEIF t\u00ednh trung b\u00ecnh c\u1ed9ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_25396\" aria-describedby=\"caption-attachment-25396\" style=\"width: 907px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25396 size-full\" title=\"3- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-tinh-trung-binh-theo-ham-averageif.png\" alt=\"3- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel\" width=\"907\" height=\"460\"><figcaption id=\"caption-attachment-25396\" class=\"wp-caption-text\">3- C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m averageif trong excel<\/figcaption><\/figure>\n<p>Trong\u00a0\u00f4 G3, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Averageif nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=AVERAGEIF(A2:A11,\u201dCam\u201d,B2:B11)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>V\u00f9ng A2:A11 l\u00e0 v\u00f9ng t\u00ean c\u00e1c m\u1eb7t h\u00e0ng, l\u00e0 v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n t\u00ednh trung b\u00ecnh<\/li>\n<li>\u201cCam\u201d l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh trung b\u00ecnh, l\u00e0 m\u1eb7t h\u00e0ng Cam<\/li>\n<li>V\u00f9ng B2:B11 l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng, v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh trung b\u00ecnh<\/li>\n<\/ul>\n<p>V\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m l\u00e0 24, gi\u1ed1ng v\u1edbi c\u00e1ch d\u00f9ng h\u00e0m AVERAGE k\u1ebft h\u1ee3p h\u00e0m\u00a0IF nh\u01b0\u00a0\u1edf tr\u00ean.<\/p>\n<p>Nh\u01b0 v\u1eady AVERAGEIF l\u00e0 c\u00e1ch k\u1ebft h\u1ee3p gi\u1eefa <strong>h\u00e0m AVERAGE<\/strong> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">h\u00e0m\u00a0IF.<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><strong>H\u01b0\u1edbng D\u1eabn 3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html\">c\u00e1ch t\u00ednh trung b\u00ecnh trong Excel<\/a> 2010, 2013, 2016<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>H\u01b0\u1edbng d\u1eabn nh\u1eefng <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/a> c\u01a1 b\u1ea3n nh\u1ea5t khi b\u1eaft \u0111\u1ea7u l\u00e0m quen<\/strong><\/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-15.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9162,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9161","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\/9161","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=9161"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9161\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9162"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}