{"id":6632,"date":"2024-12-21T15:48:25","date_gmt":"2024-12-21T15:48:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-gia-tri-trung-binh-mot-day-du-lieu-tru-gia-tri-0-trong-excel\/"},"modified":"2024-12-21T15:48:25","modified_gmt":"2024-12-21T15:48:25","slug":"cach-tinh-gia-tri-trung-binh-mot-day-du-lieu-tru-gia-tri-0-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tinh-gia-tri-trung-binh-mot-day-du-lieu-tru-gia-tri-0-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh m\u1ed9t d\u00e3y d\u1eef li\u1ec7u tr\u1eeb gi\u00e1 tr\u1ecb 0 trong Excel"},"content":{"rendered":"
\n

Th\u00f4ng th\u01b0\u1eddng, h\u00e0m AVERAGE c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a d\u00e3y bao g\u1ed3m c\u1ea3 gi\u00e1 tr\u1ecb 0 trong Excel. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i tr\u1eeb c\u00e1c gi\u00e1 tr\u1ecb 0 ra kh\u1ecfi t\u00ednh to\u00e1n, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t v\u00e0i ph\u01b0\u01a1ng ph\u00e1p.<\/p>\n

T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh tr\u1eeb c\u1ee7a d\u1eef li\u1ec7u tr\u1eeb gi\u00e1 tr\u1ecb 0 b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><\/p>\n

N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Excel 2007<\/a>\/2010\/2013, h\u00e0m\u00a0AVERAGEIF\u00a0<\/strong><\/em>c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng.<\/p>\n

1. Nh\u1eadp c\u00f4ng th\u1ee9c =AVERAGEIF(B2:B13,\u201d<>0\u2033)\u00a0<\/strong><\/em>v\u00e0o \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n

\"doc-average-ignore-zero1\"<\/p>\n

Ch\u00fa \u00fd.\u00a0<\/strong>Trong c\u00f4ng th\u1ee9c tr\u00ean, B2:B13 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh bao g\u1ed3m c\u1ea3 gi\u00e1 tr\u1ecb 0, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i n\u1ebfu mu\u1ed1n N\u1ebfu c\u00f3 \u00f4 tr\u1ed1ng trong v\u00f9ng d\u1eef li\u1ec7u n\u00e0y, c\u00f4ng th\u1ee9c c\u0169ng s\u1ebd t\u00ednh trung b\u00ecnh d\u1eef li\u1ec7u bao g\u1ed3m c\u1ea3 \u00f4 tr\u1ed1ng.<\/p>\n

2. Nh\u1ea5n Enter. K\u1ebft qu\u1ea3 trung b\u00ecnh kh\u00f4ng bao g\u1ed3m gi\u00e1 tr\u1ecb 0 nh\u01b0 sau:<\/p>\n

\"doc-average-ignore-zero1\"<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

Ch\u00fa \u00fd.\u00a0<\/strong>C\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 hi\u1ec7u qu\u1ea3 trong Excel 2003. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n 2003, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p h\u00e0m\u00a0SUM\u00a0<\/strong><\/em>v\u00e0\u00a0COUNTIF\u00a0<\/strong><\/em>nh\u01b0 sau:<\/p>\n

=SUM(B2:B13)\/COUNTIF(B2:B13,\u201d>0\u2033)<\/strong><\/p>\n

\n

H\u1ecdc Excel v\u0103n ph\u00f2ng<\/a>\u00a0v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6633,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6632","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6632","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=6632"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6632\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6633"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}