{"id":9280,"date":"2025-01-02T00:17:15","date_gmt":"2025-01-02T00:17:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-tinh-diem-trung-binh-mon-cho-hoc-sinh-va-sinh-vien-trong-excel\/"},"modified":"2025-01-02T00:17:15","modified_gmt":"2025-01-02T00:17:15","slug":"huong-dan-cach-tinh-diem-trung-binh-mon-cho-hoc-sinh-va-sinh-vien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-tinh-diem-trung-binh-mon-cho-hoc-sinh-va-sinh-vien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n cho h\u1ecdc sinh v\u00e0 sinh vi\u00ean trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n trong Excel th\u00f4ng qua 2 tr\u01b0\u1eddng h\u1ee3p: \u0110i\u1ec3m trung b\u00ecnh m\u00f4n cho h\u1ecdc sinh (b\u1eadc trung h\u1ecdc) v\u00e0 sinh vi\u00ean (b\u1eadc \u0111\u1ea1i h\u1ecdc).<\/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-6775db0a2ff36\" 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\/tinh-diem-trung-binh-mon-hoc-sinh-sinh-vien.html#Tinh_diem_trung_binh_mon_bac_trung_hoc\" title=\"T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n b\u1eadc trung h\u1ecdc\">T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n b\u1eadc trung h\u1ecdc<\/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\/tinh-diem-trung-binh-mon-hoc-sinh-sinh-vien.html#Tinh_diem_trung_binh_mon_dai_hoc\" title=\"T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n \u0111\u1ea1i h\u1ecdc\">T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n \u0111\u1ea1i h\u1ecdc<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tinh-diem-trung-binh-mon-hoc-sinh-sinh-vien.html#Cach_tinh\" title=\"C\u00e1ch t\u00ednh\">C\u00e1ch t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tinh-diem-trung-binh-mon-hoc-sinh-sinh-vien.html#Huong_dan_thiet_lap_cong_thuc_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c trong Excel\">H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_diem_trung_binh_mon_bac_trung_hoc\"><\/span>T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n b\u1eadc trung h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i v\u1edbi b\u1eadc trung h\u1ecdc, th\u00f4ng th\u01b0\u1eddng c\u00f4ng th\u1ee9c t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23816\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/so-diem-4.png\" width=\"556\" height=\"60\" title=\"so-diem-4\"><\/p>\n<p>V\u00ed d\u1ee5, m\u1ed9t h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m t\u01b0\u01a1ng \u1ee9ng 3 h\u1ec7 s\u1ed1 l\u00e0 9 9 | 8 8 | 7 s\u1ebd c\u00f3 \u0111i\u1ec3m trung b\u00ecnh l\u00e0<\/p>\n<p><em>[9+9+(8+8)*2+7*3]\/[2+2*2+1*3] ~ 7.9<\/em><\/p>\n<p>\u0110\u1ec3 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c n\u00e0y trong Excel, ta c\u1ea7n thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25030\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-1.png\" width=\"456\" height=\"99\" title=\"tinh-diem-trung-binh-mon-1\"><\/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-33.gif\" title=\"ex101_92019-nho-33\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea1i \u00f4 L2, c\u00f4ng th\u1ee9c c\u1ea7n nh\u1eadp c\u00f3 d\u1ea1ng:<\/p>\n<p><em><strong>=(SUM(A2:E2)+SUM(F2:J2)*2+K2*3)\/(COUNT(A2:E2)+COUNT(F2:J2)*2+3)<\/strong><\/em><\/p>\n<p>V\u1eady l\u00e0 xong, ta \u0111\u00e3 c\u00f3 c\u00f4ng th\u1ee9c t\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n cho b\u1eadc trung h\u1ecdc. Tuy nhi\u00ean, ta c\u1ea7n ph\u1ea3i x\u1eed l\u00fd t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u00e0 trong \u0111\u00f3 c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0:<\/p>\n<ul>\n<li>Ph\u1ea3i c\u00f3 \u0111i\u1ec3m l\u1edbn h\u01a1n 0 v\u00e0 nh\u1ecf h\u01a1n 9 (<strong>khi \u0111\u1ebfm b\u1eb1ng COUNTIF v\u1edbi \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 \u2013 VD: COUNTIF(A2:E2,\u201d&gt;=0\u2033) tr\u1ea3 k\u1ebft qu\u1ea3 =0 ph\u1ea3i \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n \u201cThi\u1ebfu \u0111i\u1ec3m\u201d).<\/strong><\/li>\n<li>Ph\u1ea3i c\u00f3 \u0111i\u1ec3m 3 h\u1ec7 s\u1ed1 (<strong>\u0111\u1ed3ng th\u1eddi 3 COUNTIF ph\u1ea3i l\u1edbn h\u01a1n 0, n\u1ebfu =0 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n \u201cThi\u1ebfu \u0111i\u1ec3m\u201d)<\/strong><\/li>\n<li>\u0110i\u1ec3m h\u1ecdc k\u00ec ph\u1ea3i l\u00e0 duy nh\u1ea5t (<strong>COUNT(K2)=1<\/strong>).<\/li>\n<li>\u0110i\u1ec3m ph\u1ea3i l\u00e0m tr\u00f2n l\u00ean 1 ch\u1eef s\u1ed1<\/li>\n<\/ul>\n<p>V\u00e2n v\u00e2n\u2026<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u tr\u00ean, h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/lap-so-diem-theo-lop-va-mon-trong-excel.html\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 x\u00e2y d\u1ef1ng s\u1ed5 \u0111i\u1ec3m theo l\u1edbp v\u00e0 m\u00f4n cho gi\u00e1o vi\u00ean t\u1eeb a-z<\/a><\/strong><\/p>\n<p>B\u00e0i vi\u1ebft tr\u00ean s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eeb l\u1eadp c\u00f4ng th\u1ee9c, cho t\u1edbi thi\u1ebft l\u1eadp b\u1ea3ng t\u00ednh sao cho ti\u1ec7n g\u1ecdn nh\u1ea5t!<\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_diem_trung_binh_mon_dai_hoc\"><\/span>T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n \u0111\u1ea1i h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi l\u00ean \u0111\u1ea1i h\u1ecdc, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta nh\u00ecn chung c\u00f3 thay \u0111\u1ed5i 1 ch\u00fat: Xu\u1ea5t hi\u1ec7n\u00a0<strong>\u0111i\u1ec3m ch\u1eef\u00a0<\/strong>v\u00e0\u00a0<strong>\u0111i\u1ec3m h\u1ec7 4.<\/strong><\/p>\n<figure id=\"attachment_25032\" aria-describedby=\"caption-attachment-25032\" style=\"width: 877px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25032 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-2.png\" width=\"877\" height=\"319\" title=\"tinh-diem-trung-binh-mon-2\"><figcaption id=\"caption-attachment-25032\" class=\"wp-caption-text\">X\u1ebfp h\u1ea1ng c\u1ee7a \u0111\u1ea1i h\u1ecdc giao th\u00f4ng v\u1eadn t\u1ea3i HCM<\/figcaption><\/figure>\n<p>Ch\u01b0a h\u1ebft, c\u00f2n c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a nh\u1eefng\u00a0<strong>m\u00f4n kh\u00f4ng t\u00ednh \u0111i\u1ec3m<\/strong> v\u00e0\u00a0<strong>m\u00f4n t\u1ef1 ch\u1ecdn c\u00f3 th\u1ec3 thay \u0111\u1ed5i\/h\u1ee7y \u0111i\u1ec3m<\/strong>.<\/p>\n<p>V\u1eady ta t\u00ednh nh\u01b0 n\u00e0o?<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_tinh\"><\/span>C\u00e1ch t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1ec1 nguy\u00ean t\u1eafc, v\u1edbi nh\u1eefng m\u00f4n kh\u00f4ng t\u00ednh \u0111i\u1ec3m, ta kh\u00f4ng \u0111\u01b0a v\u00e0o.<\/p>\n<p>\u0110i\u1ec3m nh\u1eadp v\u00e0o l\u00e0 \u0111i\u1ec3m h\u1ec7 10, t\u1eeb \u0111i\u1ec3m h\u1ec7 10 t\u00ednh \u0111i\u1ec3m trung b\u00ecnh, sau \u0111\u00f3 quy sang h\u1ec7 4, t\u1eeb h\u1ec7 4 quy ra \u0111i\u1ec3m ch\u1eef v\u00e0 t\u1eeb ch\u1eef x\u1ebfp lo\u1ea1i. M\u1ed9t s\u1ed1 tr\u01b0\u1eddng s\u1ebd c\u00f3 ki\u1ec3u quy \u0111\u1ed5i kh\u00e1c, VD <strong>\u0111\u1ea1i h\u1ecdc qu\u1ed1c gia H\u00e0 N\u1ed9i<\/strong> c\u00f3 th\u00eam <strong>B+ cho m\u1ee9c \u0111i\u1ec3m 3.5, A cho m\u1ee9c 3.7 v\u00e0 A+ cho 4.0.<\/strong><\/p>\n<p>\u0110i\u1ec3m trung b\u00ecnh theo h\u1ec7 10, t\u00f9y tr\u01b0\u1eddng quy \u0111\u1ecbnh. M\u1ed9t s\u1ed1 tr\u01b0\u1eddng c\u00f3 t\u1ef7 l\u1ec7 1-3-6 (0.1 h\u1ec7 s\u1ed1 chuy\u00ean c\u1ea7n, 0.3 gi\u1eefa k\u00ec v\u00e0 0.6 cu\u1ed1i k\u00ec).<\/p>\n<p><strong>V\u00ed d\u1ee5<\/strong> \u0111i\u1ec3m c\u1ee7a b\u1ea1n l\u00e0 9 8 10, \u0111i\u1ec3m trung b\u00ecnh c\u1ee7a b\u1ea1n l\u00e0 <em>9*0.1+8*0.3+10*0.6=9.3<\/em>, quy v\u1ec1 h\u1ec7 4 l\u00e0\u00a0<strong>4.0<\/strong>, v\u1ec1 \u0111i\u1ec3m l\u00e0\u00a0<strong>A<\/strong> (ho\u1eb7c\u00a0<strong>A+<\/strong>).<\/p>\n<p>\u0110\u00f3 l\u00e0 t\u00ednh trung b\u00ecnh\u00a0<strong>1 m\u00f4n<\/strong>, v\u1eady c\u00f2n nhi\u1ec1u m\u00f4n?<\/p>\n<p>V\u1edbi h\u1ec7 10, c\u1ee9 l\u1ea5y trung b\u00ecnh\u00a0<strong>nh\u01b0 h\u1ed3i c\u1ea5p 3 th\u00f4i<\/strong>. C\u00f2n h\u1ec7 4?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25034\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-3.png\" width=\"884\" height=\"443\" title=\"tinh-diem-trung-binh-mon-3\"><\/p>\n<p>\u1ede \u0111\u00e2y ta ph\u1ea3i nh\u1eafc \u0111\u1ebfn 1 kh\u00e1i ni\u1ec7m:\u00a0<strong>t\u00edn ch\u1ec9.<\/strong><\/p>\n<blockquote>\n<p><em><strong>T\u00edn ch\u1ec9<\/strong> l\u00e0 \u0111\u01a1n v\u1ecb d\u00f9ng \u0111\u1ec3 \u0111o l\u01b0\u1eddng kh\u1ed1i l\u01b0\u1ee3ng h\u1ecdc t\u1eadp. M\u1ed9t t\u00edn ch\u1ec9 \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh b\u1eb1ng <strong>15 ti\u1ebft h\u1ecdc l\u00fd thuy\u1ebft, 30 ti\u1ebft th\u1ef1c h\u00e0nh, th\u00ed nghi\u1ec7m ho\u1eb7c th\u1ea3o lu\u1eadn, b\u1eb1ng 60 gi\u1edd th\u1ef1c t\u1eadp t\u1ea1i c\u01a1 s\u1edf ho\u1eb7c b\u1eb1ng 45 gi\u1edd l\u00e0m ti\u1ec3u lu\u1eadn, b\u00e0i t\u1eadp l\u1edbn, \u0111\u1ed3 \u00e1n ho\u1eb7c kho\u00e1 lu\u1eadn t\u1ed1t nghi\u1ec7p.<\/strong><\/em><\/p>\n<\/blockquote>\n<p>C\u00e1ch t\u00ednh \u0111i\u1ec3m trung b\u00ecnh k\u00ec:<\/p>\n<p><strong>(\u0110i\u1ec3m h\u1ec7 4 m\u00f4n 1 * S\u1ed1 t\u00edn ch\u1ec9 m\u00f4n 1 + \u0110i\u1ec3m h\u1ec7 4 m\u00f4n 2 * S\u1ed1 t\u00edn m\u00f4n 2 + \u2026 + \u0110i\u1ec3m h\u1ec7 4 m\u00f4n n * S\u1ed1 t\u00edn m\u00f4n n)\/T\u1ed5ng s\u1ed1 t\u00edn trong k\u00ec.<\/strong><\/p>\n<p>\u0110i\u1ec3m trung b\u00ecnh to\u00e0n kh\u00f3a:<\/p>\n<p><strong>(\u0110i\u1ec3m h\u1ec7 4 m\u00f4n 1 * S\u1ed1 t\u00edn m\u00f4n 1 + \u0110i\u1ec3m h\u1ec7 4 m\u00f4n 2 * S\u1ed1 t\u00edn m\u00f4n 2 + \u2026 + \u0110i\u1ec3m h\u1ec7 4 m\u00f4n cu\u1ed1i * S\u1ed1 t\u00edn m\u00f4n cu\u1ed1i)\/T\u1ed5ng s\u1ed1 t\u00edn to\u00e0n kh\u00f3a.<\/strong><\/p>\n<p><span style=\"text-decoration: underline\">L\u01b0u \u00fd:<\/span> Kh\u00f4ng l\u1ea5y trung b\u00ecnh c\u00e1c k\u00ec c\u1ed9ng v\u00e0o chia ra.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Huong_dan_thiet_lap_cong_thuc_trong_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc ti\u00ean, ta ph\u1ea3i c\u00f3 m\u1ed9t b\u1ea3ng quy \u0111\u1ed5i nh\u01b0 sau:<\/p>\n<figure id=\"attachment_25040\" aria-describedby=\"caption-attachment-25040\" style=\"width: 259px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25040 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-4.png\" width=\"259\" height=\"218\" title=\"tinh-diem-trung-binh-mon-4\"><figcaption id=\"caption-attachment-25040\" class=\"wp-caption-text\">T\u00f9y tr\u01b0\u1eddng s\u1ebd c\u00f3 b\u1ea3ng tham chi\u1ebfu kh\u00e1c nhau<\/figcaption><\/figure>\n<p>Sau khi \u0111\u00e3 c\u00f3 b\u1ea3ng n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html\">VLOOKUP tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i<\/a>\u00a0<\/strong>\u0111\u1ec3 tham chi\u1ebfu \u0111i\u1ec3m. B\u1eaft \u0111\u1ea7u t\u1eeb \u0111i\u1ec3m trung b\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25041\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-5.png\" width=\"688\" height=\"265\" title=\"tinh-diem-trung-binh-mon-5\"><\/p>\n<p><strong><em>\u0110i\u1ec3m trung b\u00ecnh = T\u1ed5ng c\u00e1c \u0111i\u1ec3m th\u00e0nh ph\u1ea7n * H\u1ec7 s\u1ed1<\/em><\/strong><\/p>\n<p>Ch\u00fang ta ti\u1ebfn h\u00e0nh t\u00ecm \u0111i\u1ec3m h\u1ec7 4 t\u1eeb \u0111i\u1ec3m h\u1ec7 10 b\u1eb1ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tu-dau-den-cuoi-ve-cach-su-dung-ham-vlookup.html\">VLOOKUP<\/a>\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25042\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-6.png\" width=\"783\" height=\"267\" title=\"tinh-diem-trung-binh-mon-6\"><\/p>\n<p><strong>=VLOOKUP($F3,Sheet2!$A$1:$C$10,2,1)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>F3<\/strong> l\u00e0 \u00f4 tham chi\u1ebfu \u2013 l\u1ea5y t\u1eeb \u0111i\u1ec3m trung b\u00ecnh<\/p>\n<p><strong>Sheet2!$A$1:$C$10\u00a0<\/strong>l\u00e0 b\u1ea3ng tham chi\u1ebfu \u2013 s\u1eed d\u1ee5ng b\u1ea3ng quy \u0111\u1ed5i, c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 h\u00e0ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25043\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-7.png\" width=\"287\" height=\"242\" title=\"tinh-diem-trung-binh-mon-7\"><\/p>\n<p><strong>2<\/strong> l\u00e0 s\u1ed1 c\u1ed9t \u2013 \u1edf \u0111\u00e2y c\u1ea7n tham chi\u1ebfu sang c\u1ed9t\u00a0<strong>Thang 4<\/strong> (c\u1ed9t s\u1ed1 2)<\/p>\n<p><strong>1<\/strong> l\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm \u2013 t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i. K\u1ebft qu\u1ea3 tr\u1ea3 ra nh\u01b0 h\u00ecnh tr\u00ean.<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1, ta c\u0169ng s\u1eed d\u1ee5ng VLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm\u00a0<strong>\u0111i\u1ec3m ch\u1eef<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25044\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-8.png\" width=\"882\" height=\"287\" title=\"tinh-diem-trung-binh-mon-8\"><\/p>\n<p>\u00a0<\/p>\n<p>\u0110\u1ec3 t\u00ednh\u00a0<strong>trung b\u00ecnh k\u00ec<\/strong>, ta c\u1ea7n t\u00ecm\u00a0<strong>t\u1ed5ng s\u1ed1 t\u00edn,\u00a0<\/strong>sau \u0111\u00f3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>T\u1ed5ng s\u1ed1 t\u00edn\u00a0<\/strong>=<strong>SUM(s\u1ed1 t\u00edn ch\u1ec9).\u00a0<\/strong>C\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 <strong>SUM(B3:B10)<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25045\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-9.png\" width=\"864\" height=\"269\" title=\"tinh-diem-trung-binh-mon-9\"><\/p>\n<p><strong>Trung b\u00ecnh k\u00ec<\/strong> =\u00a0<strong>(S\u1ed1 t\u00edn t\u1eebng m\u00f4n * \u0110i\u1ec3m h\u1ec7 4 t\u1eebng m\u00f4n)\/T\u1ed5ng t\u00edn k\u00ec<\/strong><\/p>\n<p>\u0110\u1ec3 t\u00ednh ph\u1ea7n t\u1eed s\u1ed1, ta s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/bi-kip-vo-lam-sumproduct-than-chuong.html\">SUMPRODUCT<\/a>,\u00a0<\/strong>sau \u0111\u00f3 chia cho <strong>T\u1ed5ng t\u00edn k\u00ec<\/strong> v\u1eeba t\u00ednh \u1edf tr\u00ean:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25046\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-diem-trung-binh-mon-10-1024x251-1.png\" width=\"1024\" height=\"251\" title=\"tinh-diem-trung-binh-mon-10-1024x251-1\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 x\u00e2y d\u1ef1ng \u0111\u01b0\u1ee3c m\u1ed9t b\u1ea3ng t\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n \u0111\u01a1n gi\u1ea3n r\u1ed3i. Kh\u00f4ng kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/lap-so-diem-theo-lop-va-mon-trong-excel.html\"><strong>L\u1eadp s\u1ed5 \u0111i\u1ec3m theo m\u00f4n v\u00e0 l\u1edbp<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html\">D\u00f9ng COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 th\u00e0nh ph\u1ea7n<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/4-tuyet-chieu-tra-cuu-voi-vlookup-index-match-sumproduct-va-names-range-trong-excel.html\"><strong>Tra c\u1ee9u v\u1edbi VLOOKUP<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html\"><strong>SUMPRODUCT v\u00e0 SUMIFS<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-33.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9280","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\/9280","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=9280"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9281"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}