{"id":24204,"date":"2021-05-08T09:40:04","date_gmt":"2021-05-08T02:40:04","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24204"},"modified":"2021-05-08T09:40:04","modified_gmt":"2021-05-08T02:40:04","slug":"ham-average-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-average-trong-excel\/","title":{"rendered":"C\u00fa ph\u00e1p h\u00e0m Average trong Excel v\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"<p><strong>H\u00e0m Average trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 trong b\u1ea3ng t\u00ednh. So v\u1edbi h\u00e0m Averageif, h\u00e0m t\u00ednh trung b\u00ecnh c\u1ed9ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, <strong>h\u00e0m Average trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng h\u01a1n nhi\u1ec1u.<\/p>\n<p>Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u chi ti\u1ebft cho b\u1ea1n v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Average trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<h2><strong>H\u00e0m Average trong Excel<\/strong><\/h2>\n<p><strong>H\u00e0m Average trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng d\u00e3y s\u1ed1 trong b\u1ea3ng t\u00ednh. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu s\u1ed1 ph\u1ea7n t\u1eed t\u00ednh trung b\u00ecnh c\u1ed9ng d\u00e0i ho\u1eb7c l\u1edbn, qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian n\u1ebfu ch\u00fang ta th\u1ef1c hi\u1ec7n thao t\u00e1c b\u1eb1ng tay. Thay v\u00e0o \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Average \u0111\u1ec3 t\u00ednh to\u00e1n nhanh h\u01a1n v\u00e0 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n<figure id=\"attachment_24205\" aria-describedby=\"caption-attachment-24205\" style=\"width: 821px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"821\" height=\"460\" class=\"wp-image-24205 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-average-trong-excel.png\" alt=\"H\u00e0m Average trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-average-trong-excel.png 821w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-average-trong-excel-300x168.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-average-trong-excel-768x430.png 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-average-trong-excel-750x420.png 750w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><figcaption id=\"caption-attachment-24205\" class=\"wp-caption-text\">H\u00e0m Average trong Excel<\/figcaption><\/figure>\n<h2><strong>H\u00e0m Average trong Excel v\u00e0 c\u00fa ph\u00e1p<\/strong><\/h2>\n<p><strong>H\u00e0m Average trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=AVERAGE(number1, [number2], \u2026)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>\u2013 Number1<\/strong>\u00a0l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 s\u1ed1, tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi ch\u1ee9a s\u1ed1 m\u00e0 ch\u00fang ta mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng.<\/p>\n<p><strong>\u2013 Number 2, number 3, .. number n<\/strong>\u00a0l\u00e0 tham s\u1ed1 t\u00f9y ch\u1ecdn, c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi ch\u1ee9a s\u1ed1 b\u1ed5 sung m\u00e0 c\u00e1c ch\u00fang ta mu\u1ed1n t\u00ednh trung b\u00ecnh.<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>C\u00e1c tham s\u1ed1 <strong>h\u00e0m Average trong Excel<\/strong> c\u00f3 th\u1ec3 s\u1ed1, tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi ch\u1ee9a s\u1ed1. H\u00e0m Average c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1.<\/li>\n<li>H\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a ph\u1ea1m vi, d\u1ea3i \u00f4 ch\u1ee9a s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p.<\/li>\n<li><strong>H\u00e0m Average<\/strong> s\u1ebd b\u1ecf qua c\u00e1c \u00f4 c\u00f3 tham chi\u1ebfu \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb logic, v\u0103n b\u1ea3n ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng.<\/li>\n<li>N\u1ebfu c\u00e1c tham s\u1ed1 trong \u00f4 kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1, h\u00e0m Average Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!. N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c tham s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #DIV\/0!.<\/li>\n<\/ul>\n<h2><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Average trong Excel<\/strong><\/h2>\n<p>Tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Average Excel<\/strong>:<\/p>\n<h3><strong>V\u00ed d\u1ee5 1<\/strong><\/h3>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"672\" height=\"338\" class=\"aligncenter wp-image-17478 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-30.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-30-300x151.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-30-360x180.jpg 360w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-30.jpg 672w\" alt=\"1 30 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Y\u00eau c\u1ea7u l\u00e0 t\u00ecm 3 s\u1ed1 \u0111i\u1ec3m cao nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean, v\u00ec v\u1eady c\u00f4ng th\u1ee9c <strong>h\u00e0m Average<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"373\" class=\"aligncenter wp-image-17479 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-28.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-28-300x139.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-28-768x355.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-28-750x347.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-28.jpg 806w\" alt=\"2 28 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"324\" class=\"aligncenter wp-image-17480 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-17.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-17-300x144.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-17.jpg 677w\" alt=\"3 17 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, h\u00e0m Large l\u1ea5y gi\u00e1 tr\u1ecb th\u1ee9 n t\u1eeb t\u1eadp h\u1ee3p gi\u00e1 tr\u1ecb. <strong>H\u00e0m Average<\/strong> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<h3><strong>V\u00ed d\u1ee5 2<\/strong><\/h3>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"269\" class=\"aligncenter wp-image-17481 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-14.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-14-300x171.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-14.jpg 473w\" alt=\"4 14 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p><strong>C\u00f4ng th\u1ee9c h\u00e0m Average<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"335\" class=\"aligncenter wp-image-17482 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-9.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-9-300x166.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-9.jpg 607w\" alt=\"5 9 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"337\" class=\"aligncenter wp-image-17483 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-7.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-7-300x145.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-7.jpg 698w\" alt=\"6 7 - H\u00e0m Average trong Excel, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Average Excel<\/strong><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng <strong>h\u00e0m Average Excel<\/strong> \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng d\u00e3y s\u1ed1 trong b\u1ea3ng t\u00ednh.<\/p>\n<ul>\n<li><strong>H\u00e0m Average Excel<\/strong> b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb.<\/li>\n<li>N\u1ebfu tham s\u1ed1 l\u00e0 m\u1ed9t \u00f4 ho\u1eb7c tham chi\u1ebfu \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, c\u00e1c gi\u00e1 tr\u1ecb logic ho\u1eb7c \u00f4 tr\u1ed1ng th\u00ec nh\u1eefng tham s\u1ed1 n\u00e0y s\u1ebd b\u1ecb b\u1ecf qua. <strong>H\u00e0m Average<\/strong> ch\u1ea5p nh\u1eadn gi\u00e1 tr\u1ecb l\u00e0 0.<\/li>\n<li>C\u00e1c tham s\u1ed1 <strong>h\u00e0m Average<\/strong> l\u00e0 gi\u00e1 tr\u1ecb l\u1ed7i ho\u1eb7c v\u0103n b\u1ea3n kh\u00f4ng th\u1ec3 chuy\u1ec3n sang ch\u1eef s\u1ed1 th\u00ec h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i.<\/li>\n<li><strong>H\u00e0m Average<\/strong> ch\u1ec9 ch\u1ee9a t\u1ed1i \u0111a 256 tham s\u1ed1. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, t\u00ean, ph\u1ea1m vi ho\u1eb7c tham chi\u1ebfu \u00f4 c\u00f3 ch\u1ee9a s\u1ed1.<\/li>\n<li>M\u1ed9t \u0111\u1ed1i s\u1ed1 tham chi\u1ebfu \u00f4 ho\u1eb7c ph\u1ea1m vi c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb logic, v\u0103n b\u1ea3n hay \u00f4 tr\u1ed1ng th\u00ec b\u1ecb b\u1ecf qua, tr\u1eeb gi\u00e1 tr\u1ecb 0 ho\u1eb7c \u0111\u01b0\u1ee3c nh\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o danh s\u00e1ch \u0111\u1ed1i s\u1ed1.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 <strong>h\u00e0m Average trong Excel<\/strong>, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o. C\u00f9ng v\u1edbi \u0111\u00f3, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c trong Excel nh\u00e9.<\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-right-trong-excel\/\">H\u00e0m Right trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-index-va-match\/\">H\u00e0m Index v\u00e0 match<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-tach-ten-trong-excel\/\">H\u00e0m t\u00e1ch t\u00ean trong Excel<\/a><\/li>\n<\/ul>\n<p>Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 chia s\u1ebb \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Average trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 trong b\u1ea3ng t\u00ednh. So v\u1edbi h\u00e0m Averageif, h\u00e0m t\u00ednh trung b\u00ecnh c\u1ed9ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, h\u00e0m Average trong Excel c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng h\u01a1n nhi\u1ec1u. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24205,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24204"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24205"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}