![\"tinh-trung-binh-trong-excel-1\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-1.jpg.webp)
<\/picture>B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m AVERAGE v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel nh\u01b0 VLOOKUP, HLOOKUP, IF hay IFS \u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c th\u00e0nh ph\u1ea7n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ecdn t\u1eebng \u00f4 d\u1eef li\u1ec7u.<\/p>\n
C\u00e1ch s\u1eed d\u1ee5ng AVERAGE \u0111\u1ec3 t\u00ednh trung b\u00ecnh trong Excel<\/h2>\n
D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng AVERAGE \u0111\u1ec3 t\u00ednh trung b\u00ecnh trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n
C\u00fa ph\u00e1p<\/h3>\n
H\u00e0m AVERAGE: =AVERAGE(number1;number2;)<\/p>\n Trong \u0111\u00f3, Number 1, number 2 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi ch\u1ee9a gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh s\u1ed1 trung b\u00ecnh trong Excel.<\/p>\n V\u00ed d\u1ee5: =AVERAGE(5, 10, 15, 20) s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 12.5<\/p>\n L\u01b0u \u00fd:<\/p>\n \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AVERAGE trong Excel, b\u1ea1n th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn sau:<\/p>\n B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u1edbi c\u00fa ph\u00e1p ch\u00ednh x\u00e1c v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. V\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh, \u0111\u1ec3 t\u00ednh \u0111i\u1ec3m trung b\u00ecnh cho Nguy\u1ec5n V\u0103n A, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd l\u00e0 =Average(C2,D2,E2). Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 qu\u00e9t c\u00e1c \u00f4 n\u1eb1m trong ph\u1ea1m vi ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u1ec9nh trung b\u00ecnh c\u1ed9ng, khi \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y ph\u00e9p t\u00ednh t\u1ef1 \u0111\u1ed9ng th\u00e0nh =AVERAGE(C2:E2).<\/p>\n B\u01b0\u1edbc 2: Nh\u1ea5n Enter, k\u1ebft qu\u1ea3 l\u1eadp t\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb t\u1ea1i \u00f4 b\u1ea1n \u0111\u00e3 nh\u1eadp h\u00e0m AVERAGE.<\/p>\n B\u01b0\u1edbc 3: \u0110\u1ec3 ti\u1ebfp t\u1ee5c t\u00ednh trung b\u00ecnh c\u1ed9ng cho c\u00e1c h\u1ecdc sinh kh\u00e1c, b\u1ea1n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 m\u00e0 m\u00ecnh \u0111\u00e3 nh\u1eadp h\u00e0m \u1edf tr\u00ean r\u1ed3i k\u00e9o h\u00ecnh vu\u00f4ng nh\u1ecf xu\u1ed1ng b\u00ean d\u01b0\u1edbi cho \u0111\u1ebfn khi bao g\u1ed3m \u0111\u1ea7y \u0111\u1ee7 nh\u1eefng \u00f4 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng ph\u00e9p t\u00ednh.<\/p>\n Sau khi t\u00ednh xong, k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb9p l\u1eafm n\u00ean b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ec3 b\u1ea3ng t\u00ednh tr\u00f4ng d\u1ec5 nh\u00ecn h\u01a1n v\u1edbi h\u00e0m ROUND.<\/p>\n C\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROUND c\u01a1 b\u1ea3n l\u00e0:<\/p>\n C\u00fa ph\u00e1p =ROUND(Number,N)<\/strong><\/p>\n Trong \u0111\u00f3: Number l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n, c\u00f2n N l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n gi\u1eef sau khi l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3. N c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 \u00e2m ho\u1eb7c s\u1ed1 d\u01b0\u01a1ng.<\/p>\n N\u1ebfu mu\u1ed1n k\u1ebft h\u1ee3p h\u00e0m ROUND v\u1edbi AVERAGE \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 v\u00e0 cho ra k\u1ebft qu\u1ea3 \u0111\u1eb9p nh\u1ea5t, b\u1ea1n g\u00f5 c\u00fa ph\u00e1p sau:<\/p>\n =ROUND(AVERAGE(range), decimal_places)<\/strong><\/p>\n Trong \u0111\u00f3: range l\u00e0 ph\u1ea1m vi ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh c\u1ed9ng, c\u00f2n decimal_places l\u00e0 s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n gi\u1eef sau khi l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3.<\/p>\n V\u00ed d\u1ee5: T\u00ednh \u0111i\u1ec3m trung b\u00ecnh c\u1ed9ng c\u1ee7a h\u1ecdc sinh Nguy\u1ec5n V\u0103n A v\u00e0 l\u00e0m tr\u00f2n \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, ta c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n =ROUND(AVERAGE(C2:E2),2)<\/p>\n #VALUE l\u00e0 m\u1ed9t l\u1ed7i kh\u00e1 quen thu\u1ed9c v\u00e0 th\u01b0\u1eddng x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng h\u00e0m AVERAGE \u0111\u1ec3 t\u00ednh trung b\u00ecnh trong Excel.<\/p>\n B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y l\u1ed7i #VALUE! hi\u1ec3n th\u1ecb nh\u01b0 trong h\u00ecnh (\u1edf \u00f4 E2 v\u00e0 \u00f4 F2). Ban \u0111\u1ea7u, nguy\u00ean nh\u00e2n xu\u1ea5t ph\u00e1t t\u1eeb \u00f4 E2, v\u00ec \u00f4 E2 g\u1eb7p l\u1ed7i n\u00ean \u1edf \u00f4 k\u1ebft qu\u1ea3 l\u00e0 F2 c\u0169ng b\u1ecb l\u1ed7i theo.<\/p>\n \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m AVERAGE v\u1edbi 2 h\u00e0m kh\u00e1c l\u00e0 IF v\u00e0 ISERROR. Trong \u0111\u00f3, h\u00e0m IF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p t\u00ednh ho\u1eb7c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc, c\u00f2n h\u00e0m ISERROR c\u00f3 nhi\u1ec7m v\u1ee5 ki\u1ec3m tra xem m\u1ed9t \u00f4 c\u00f3 ch\u1eefa l\u1ed7i hay kh\u00f4ng.<\/p>\n K\u1ebft h\u1ee3p h\u00e0m IF, ISERROR v\u00e0 AVERAGE s\u1ebd cho ph\u00e9p t\u00ednh sau: =AVERAGE(IF(ISERROR(C2:E2),””,C2:E2))<\/p>\n Gi\u1ea3i th\u00edch:<\/strong> C\u00fa ph\u00e1p tr\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh trung b\u00ecnh c\u00e1c s\u1ed1 n\u1eb1m trong v\u00f9ng C2 \u0111\u1ebfn E2. Trong \u0111\u00f3, n\u1ebfu c\u00f3 \u00f4 n\u00e0o b\u1ecb l\u1ed7i, \u00f4 \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng v\u00e0 ch\u1ec9 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n tr\u00ean nh\u1eefng \u00f4 kh\u00f4ng c\u00f3 l\u1ed7i.<\/p>\n L\u01b0u \u00fd:<\/p>\n Sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean, l\u1ed7i #VALUE \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 h\u01b0\u1edbng d\u1eabn b\u00ean tr\u00ean \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u1ea3 nh\u1eefng \u00f4 b\u00ean d\u01b0\u1edbi c\u1ee7a b\u1ea3ng t\u00ednh.<\/p>\n Ngo\u00e0i AVERAGE, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00e1ch t\u00ednh trung b\u00ecnh trong Excel kh\u00e1c. Nh\u1eefng c\u00e1ch t\u00ednh n\u00e0y s\u1ebd kh\u00e1 \u0111\u01a1n gi\u1ea3n, nh\u01b0ng n\u00f3 l\u1ea1i khi\u1ebfn b\u1ea1n m\u1ea5t th\u1eddi gian h\u01a1n so v\u1edbi AVERAGE.<\/p>\n C\u00e1ch t\u00ednh n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. Tuy nhi\u00ean, nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a n\u00f3 l\u00e0 khi\u1ebfn b\u1ea1n t\u1ed1n kh\u00e1 nhi\u1ec1u th\u1eddi gian.<\/p>\n C\u00e1ch t\u00ednh n\u00e0y t\u1ef1a nh\u01b0 vi\u1ec7c th\u1ef1c hi\u1ec7n 1 b\u00e0i to\u00e1n t\u00ednh trung b\u00ecnh c\u1ed9ng th\u00f4ng th\u01b0\u1eddng, t\u1ee9c l\u00e0 b\u1ea1n s\u1ebd c\u1ed9ng t\u1eebng gi\u00e1 tr\u1ecb l\u1ea1i v\u1edbi nhau th\u00e0nh 1 t\u1ed5ng, sau \u0111\u00f3 chia cho t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c c\u1ed9ng, v\u00ed d\u1ee5 nh\u01b0:<\/p>\n \u0110\u1ec3 t\u00ednh \u0111i\u1ec3m trung b\u00ecnh trong Excel c\u1ee7a Nguy\u1ec5n V\u0103n A, b\u1ea1n c\u1ea7n c\u1ed9ng 3 gi\u00e1 tr\u1ecb \u1edf 3 \u00f4 l\u00e0 C2, D2 v\u00e0 E2. C\u00e1ch th\u1ef1c hi\u1ec7n s\u1ebd l\u00e0: Nh\u1eadp c\u00fa ph\u00e1p =(C2+D2+E2)\/3, sau \u0111\u00f3 b\u1ea5m Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/p>\n Ti\u1ebfp theo, b\u1ea1n k\u00e9o con chu\u1ed9t t\u1eeb \u00f4 ch\u1ee9a c\u00fa ph\u00e1p xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ed3ng lo\u1ea1t ph\u00e9p t\u00ednh n\u00e0y. Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd l\u00e0 c\u00e1ch n\u00e0y ch\u1ec9 ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh \u0111\u01a1n gi\u1ea3n, \u00edt d\u1eef li\u1ec7u, c\u00f2n v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh c\u1ea7n t\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn, b\u1ea1n v\u1eabn n\u00ean s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c AVERAGE \u1edf tr\u00ean.<\/p>\n C\u00e1ch t\u00ednh n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 nhanh ch\u00f3ng, nh\u01b0ng n\u1ebfu so s\u00e1nh v\u1edbi AVERAGE, h\u00e0m AVERAGE v\u1eabn \u0111\u01b0\u1ee3c \u01b0u ti\u00ean h\u01a1n. \u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb thu\u1ed9c v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n C\u00fa ph\u00e1p s\u1ebd l\u00e0: =SUM(number 1, number 2\u2026)<\/strong><\/p>\n Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh chia cho s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u \u0111\u00e3 l\u1ea5y \u0111\u1ec3 t\u00ednh t\u1ed5ng th\u00ec m\u1edbi ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 trung b\u00ecnh c\u1ed9ng trong Excel.<\/p>\n V\u00ed d\u1ee5: \u0110\u1ec3 t\u00ednh \u0111i\u1ec3m s\u1ed1 trung b\u00ecnh c\u1ee7a Nguy\u1ec5n V\u0103n A, b\u1ea1n nh\u1eadp\u00a0 =(SUM(C2:E2))\/3, sau \u0111\u00f3 b\u1ea5m Enter \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3. L\u01b0u \u00fd l\u00e0 b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh t\u1ed5ng r\u1ed3i m\u1edbi chia \u0111\u1ec3 tu\u00e2n th\u1ee7 theo quy t\u1eafc \u201cNh\u00e2n chia tr\u01b0\u1edbc – C\u1ed9ng tr\u1eeb sau\u201d.<\/p>\n T\u01b0\u01a1ng t\u1ef1, b\u1ea1n \u0111\u1eb7t tr\u1ecf chu\u1ed9t \u1edf \u00f4 \u0111\u00e3 nh\u1eadp r\u1ed3i k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn.<\/p>\n N\u00f3i t\u00f3m l\u1ea1i, AVERAGE v\u1eabn s\u1ebd l\u00e0 ph\u01b0\u01a1ng ph\u00e1p t\u00ednh trung b\u00ecnh trong Excel t\u1ed1i \u01b0u, thu\u1eadn ti\u1ec7n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t. Tuy nhi\u00ean, \u0111\u1ec3 c\u00e1c ph\u00e9p t\u00ednh lu\u00f4n cho ra k\u1ebft qu\u1ea3 \u0111\u00fang v\u00e0 tr\u00e1nh g\u1eb7p l\u1ed7i, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u sau:<\/p>\n B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi \u0111\u1ed1i s\u1ed1 m\u00e0 b\u1ea1n cung c\u1ea5p trong h\u00e0m AVERAGE l\u00e0 h\u1ee3p l\u1ec7. B\u1edfi v\u00ec vi\u1ec7c b\u1ea1n c\u1ed1 g\u1eafng t\u00ednh trung b\u00ecnh c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1 (v\u0103n b\u1ea3n ch\u1eb3ng h\u1ea1n), k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!<\/p>\n AVERAGE s\u1ebd b\u1ecf qua c\u00e1c \u00f4 r\u1ed7ng ho\u1eb7c b\u1ecb l\u1ed7i v\u00e0 \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh l\u00e0m m\u1ea5t d\u1eef li\u1ec7u ho\u1eb7c nh\u1eadp sai d\u1eef li\u1ec7u n\u00e0o \u0111\u00f3. V\u1eady n\u00ean, h\u00e3y th\u1eadt s\u1ef1 c\u1ea9n tr\u1ecdng trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u \u0111\u1ec3 kh\u00f4ng x\u1ea3y ra sai s\u00f3t kh\u00f4ng \u0111\u00e1ng c\u00f3.<\/p>\n N\u1ebfu b\u1ea1n c\u1ea7n t\u00ednh trung b\u00ecnh t\u1ed5ng trong Excel nh\u01b0ng l\u1ea1i ph\u1ea3i d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 AVERAGEIF ho\u1eb7c AVERAGEIFS thay v\u00ec AVERAGE \u0111\u1ec3 ph\u00e9p t\u00ednh cho ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, nhanh ch\u00f3ng v\u00e0 t\u00ednh \u0111\u00fang ph\u1ea7n d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n.<\/p>\n C\u00fa ph\u00e1p c\u1ee7a b\u1ea1n c\u1ea7n ph\u1ea3i ch\u00ednh x\u00e1c v\u00e0 c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00e0nh ph\u1ea7n, n\u1ebfu kh\u00f4ng Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ed7i. Ngo\u00e0i ra, t\u1ed1t nh\u1ea5t l\u00e0 b\u1ea1n n\u00ean s\u1eed d\u1ee5ng c\u00e1c ph\u1ea1m vi r\u1ed9ng thay v\u00ec ch\u1ecdn t\u1eebng \u00f4 \u0111\u1ed1i v\u1edbi c\u00e1c t\u1eadp d\u1eef li\u1ec7u c\u1ea7n thay \u0111\u1ed5i th\u01b0\u1eddng xuy\u00ean \u0111\u1ec3 tr\u00e1nh s\u1eeda ch\u1eefa ho\u1eb7c sai s\u00f3t v\u1ec1 sau.<\/p>\n Cu\u1ed1i c\u00f9ng, \u0111\u1eebng qu\u00ean l\u00e0m tr\u00f2n s\u1ed1 n\u1ebfu k\u1ebft qu\u1ea3 cho ra s\u1ed1 l\u1ebb khi\u1ebfn b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n tr\u00f4ng th\u1eadt l\u1ed9n x\u1ed9n v\u00e0 kh\u00f3 nh\u00ecn v\u1edbi h\u00e0m ROUND, ROUNDUP ho\u1eb7c ROUNDDOWN.<\/p>\n B\u00ean tr\u00ean l\u00e0 nh\u1eefng th\u00f4ng tin c\u01a1 b\u1ea3n v\u1ec1 c\u00e1ch t\u00ednh trung b\u00ecnh trong Excel v\u1edbi h\u00e0m AVERAGE v\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch t\u00ednh kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd h\u1eefu \u00edch v\u00e0 \u0111\u1eebng qu\u00ean \u0111\u1ec3 l\u1ea1i comment b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 n\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc hay c\u00e2u h\u1ecfi n\u00e0o nh\u00e9!<\/p>\n Xem th\u00eam:<\/p>\n Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong c\u00e1c l\u0129nh v\u1ef1c, ng\u00e0nh ngh\u1ec1 kh\u00e1c nhau. Khi l\u00e0m quen v\u1edbi c\u00f4ng c\u1ee5 n\u00e0y, b\u1ea1n s\u1ebd bi\u1ebft \u0111\u1ebfn m\u1ed9t h\u00e0m c\u00f3 t\u00ean l\u00e0 AVERAGE – h\u00e0m trung b\u00ecnh c\u1ed9ng. H\u00e0m AVERAGE cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u00ednh trung b\u00ecnh c\u1ed9ng trong Excel m\u1ed9t […]<\/p>\n","protected":false},"author":97,"featured_media":264631,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-262654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"\n![\"tinh-trung-binh-trong-excel-2\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-2.jpg.webp)
<\/picture>\n
C\u00e1ch t\u00ednh trung b\u00ecnh c\u1ed9ng trong Excel v\u1edbi h\u00e0m AVERAGE<\/h3>\n
![\"tinh-trung-binh-trong-excel-3\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-3.jpg.webp)
<\/picture>![\"tinh-trung-binh-trong-excel-4\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-4.jpg.webp)
<\/picture>![\"tinh-trung-binh-trong-excel-5\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-5.jpg.webp)
<\/picture>K\u1ebft h\u1ee3p h\u00e0m AVERAGE v\u1edbi ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3<\/h3>\n
![\"tinh-trung-binh-trong-excel-7\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-7.jpg.webp)
<\/picture>\n
X\u1eed l\u00fd l\u1ed7i #VALUE trong h\u00e0m AVERAGE nh\u01b0 th\u1ebf n\u00e0o?<\/h2>\n
![\"tinh-trung-binh-trong-excel-8\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-8.jpg.webp)
<\/picture>![\"tinh-trung-binh-trong-excel-9\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-9.jpg.webp)
<\/picture>![\"tinh-trung-binh-trong-excel-10\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-10.jpg.webp)
<\/picture>\n
C\u00e1c ph\u00e9p t\u00ednh trung b\u00ecnh trong Excel kh\u00e1c<\/h2>\n
T\u00ednh trung b\u00ecnh trong Excel v\u1edbi t\u1eebng gi\u00e1 tr\u1ecb<\/h3>\n
![\"tinh-trung-binh-trong-excel-11\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-11.jpg.webp)
<\/picture>C\u00e1ch t\u00ednh trung b\u00ecnh c\u1ed9ng trong Excel b\u1eb1ng h\u00e0m SUM<\/h3>\n
![\"tinh-trung-binh-trong-excel-12\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-12.jpg.webp)
<\/picture>M\u1ed9t s\u1ed1 l\u01b0u \u00fd c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m trung b\u00ecnh trong Excel – AVERAGE<\/h2>\n
Ki\u1ec3m tra \u0111\u1ea7u v\u00e0o<\/h3>\n
![\"tinh-trung-binh-trong-excel-13\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-13.jpg.webp)
<\/picture>X\u1eed l\u00fd l\u1ed7i ho\u1eb7c gi\u00e1 tr\u1ecb r\u1ed7ng<\/h3>\n
![\"tinh-trung-binh-trong-excel-14\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-14.jpg.webp)
<\/picture>K\u1ebft h\u1ee3p c\u00e1c h\u00e0m AVERAGEIF v\u00e0 AVERAGEIFS trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n thi\u1ebft<\/h3>\n
![\"tinh-trung-binh-trong-excel-15\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/tinh-trung-binh-trong-excel-15.jpg.webp)
<\/picture>Ki\u1ec3m tra c\u00fa ph\u00e1p v\u00e0 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3 (n\u1ebfu c\u1ea7n)<\/h3>\n
<\/picture>\n