{"id":2333,"date":"2024-12-02T07:29:59","date_gmt":"2024-12-02T07:29:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2017-2010-2013-2016\/"},"modified":"2024-12-02T07:29:59","modified_gmt":"2024-12-02T07:29:59","slug":"huong-dan-3-cach-tinh-trung-binh-tren-excel-2017-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2017-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch t\u00ednh trung b\u00ecnh tr\u00ean excel 2017, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u00e0m-trung-b\u00ecnh\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html?ham-trung-binh\">\n<p style=\"text-align: justify\">T\u00ednh trung b\u00ecnh thu\u1ed9c nh\u1eefng ph\u00e9p t\u00ednh \u0111\u1eb7c tr\u01b0ng\u00a0s\u1eed d\u1ee5ng nhi\u1ec1u\u00a0trong th\u1ed1ng k\u00ea v\u00e0 tr\u00ean Excel. N\u1eafm v\u1eefng 3 c\u00e1ch sau \u0111\u1ec3 t\u00ednh trung b\u00ecnh \u0111\u01a1n gi\u1ea3n h\u01a1n.<\/p>\n<\/blockquote>\n<figure id=\"attachment_3234\" aria-describedby=\"caption-attachment-3234\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3234\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2.png\" width=\"600\" height=\"402\" title=\"2-2\"><figcaption id=\"caption-attachment-3234\" class=\"wp-caption-text\">T\u00ednh trung b\u00ecnh doanh thu c\u1eeda h\u00e0ng<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><span data-sheets-value='{\"1\":2,\"2\":\"h\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n\"}' data-sheets-userformat='{\"2\":513,\"3\":[null,0],\"12\":0}'>h\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n<\/span><\/a><\/p>\n<\/blockquote>\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-674d61f64fd96\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html#Cach_1\" title=\"C\u00e1ch 1\">C\u00e1ch 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html#Cach_2\" title=\"C\u00e1ch 2\">C\u00e1ch 2<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-trung-binh-tren-excel-2010.html#Cach_3\" title=\"C\u00e1ch 3\">C\u00e1ch 3<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1\"><\/span>C\u00e1ch 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">T\u00ednh doanh thu trung b\u00ecnh c\u1eeda h\u00e0ng l\u00e0m v\u00ed d\u1ee5. <strong>C\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ea7u ti\u00ean,<\/strong> c\u0169ng l\u00e0 c\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u01a1n gi\u1ea3n nh\u1ea5t: c\u1ed9ng t\u1eebng gi\u00e1 tr\u1ecb, r\u1ed3i l\u1ea5y t\u1ed5ng \u0111\u00f3 \u00a0chia cho s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb, c\u00e1ch \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau =\u00a0<strong>(C6+D6+E6+F6+G6)\/5<\/strong><\/p>\n<figure id=\"attachment_3233\" aria-describedby=\"caption-attachment-3233\" style=\"width: 467px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3233\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/a1.gif\" width=\"467\" height=\"224\" title=\"a1\"><figcaption id=\"caption-attachment-3233\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 1<\/figcaption><\/figure>\n<figure id=\"attachment_3235\" aria-describedby=\"caption-attachment-3235\" style=\"width: 526px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3235\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/a2.gif\" width=\"526\" height=\"298\" title=\"a2\"><figcaption id=\"caption-attachment-3235\" class=\"wp-caption-text\">K\u00e9o \u0111\u1ec3 copy c\u00e1ch t\u00ednh trung b\u00ecnh xu\u1ed1ng c\u00e1c c\u1eeda h\u00e0ng c\u00f2n l\u1ea1i<\/figcaption><\/figure>\n<p style=\"text-align: justify\">C\u00e1ch t\u00ednh trung b\u00ecnh n\u00e0y \u0111\u01a1n gi\u1ea3n nh\u1ea5t tuy v\u1eady s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb nhi\u1ec1u h\u01a1n.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">h\u1ecdc Excel 2020 c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2\"><\/span>C\u00e1ch 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1edbi <strong>c\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 2<\/strong>, ch\u00fang ta t\u00ednh t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 trong v\u00f9ng \u0111\u00e3 l\u1ef1a ch\u1ecdn, sau \u0111\u00f3 chia cho s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb. C\u00e1ch t\u00ednh n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau <em><strong>=(sum(C7:G7))\/5<\/strong><\/em><\/p>\n<figure id=\"attachment_3236\" aria-describedby=\"caption-attachment-3236\" style=\"width: 523px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3236\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b1.gif\" width=\"523\" height=\"284\" title=\"b1\"><figcaption id=\"caption-attachment-3236\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 2<\/figcaption><\/figure>\n<figure id=\"attachment_3237\" aria-describedby=\"caption-attachment-3237\" style=\"width: 527px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b2.gif\" width=\"527\" height=\"297\" title=\"b2\"><figcaption id=\"caption-attachment-3237\" class=\"wp-caption-text\">K\u00e9o sao ch\u00e9p c\u00e1ch t\u00ednh xu\u1ed1ng c\u00e1c c\u1eeda h\u00e0ng ph\u00eda sau<\/figcaption><\/figure>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch \u0111\u1ea7u ti\u00ean, tr\u1edf ng\u1ea1i c\u1ee7a c\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 2 n\u00e0y l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb nhi\u1ec1u h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_3\"><\/span>C\u00e1ch 3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 lo\u1ea1i b\u1ecf nh\u01b0\u1ee3c \u0111i\u1ec3m t\u1eeb hai c\u00e1ch tr\u00ean, ta c\u00f3 <strong>c\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 3<\/strong>: s\u1eed d\u1ee5ng h\u00e0m Average. Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m Average \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau<strong><em> =Average(C7:G7)<\/em><\/strong><\/p>\n<figure id=\"attachment_3238\" aria-describedby=\"caption-attachment-3238\" style=\"width: 526px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3238\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/c1.gif\" width=\"526\" height=\"282\" title=\"c1\"><figcaption id=\"caption-attachment-3238\" class=\"wp-caption-text\">C\u00e1ch t\u00ednh trung b\u00ecnh th\u1ee9 3 s\u1eed d\u1ee5ng h\u00e0m Average<\/figcaption><\/figure>\n<p style=\"text-align: justify\">T\u1eadn d\u1ee5ng h\u00e0m Average, t\u00ednh trung b\u00ecnh \u0111\u01b0\u1ee3c Excel t\u1ef1 \u0111\u1ed9ng c\u1ed9ng t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong kho\u1ea3ng \u0111\u01b0a ra trong ngo\u1eb7c, \u0111\u1ed3ng th\u1eddi t\u1ef1 \u0111\u1ed9ng \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb trong kho\u1ea3ng. Cu\u1ed1i c\u00f9ng l\u1ea5y t\u1ed5ng gi\u00e1 tr\u1ecb chia s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 ho\u00e0n th\u00e0nh ph\u00e9p t\u00ednh trung b\u00ecnh m\u1ed9t c\u00e1ch thu\u1eadn ti\u1ec7n.<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/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\/2024\/12\/ex101_92019-nho-180.gif\" title=\"ex101_92019-nho-180\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/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\/2024\/12\/ex101_92019-nho-180.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2334,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2333","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\/2333","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=2333"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2333\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2334"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}