{"id":1588,"date":"2024-12-02T05:27:09","date_gmt":"2024-12-02T05:27:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel\/"},"modified":"2024-12-02T05:27:09","modified_gmt":"2024-12-02T05:27:09","slug":"huong-dan-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m s\u1eed d\u1ee5ng cho m\u1ee5c \u0111\u00edch th\u1ed1ng k\u00ea, b\u1edfi vi\u1ec7c th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ch\u1ee7 y\u1ebfu th\u00f4ng qua c\u00f4ng c\u1ee5 Excel. Trong b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> ch\u00fang ta s\u1ebd c\u00f9ng nhau t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel. C\u00e1c h\u00e0m \u0111\u00f3 l\u00e0 nh\u1eefng h\u00e0m n\u00e0o? C\u00f4ng d\u1ee5ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng ra sao? C\u00e1c b\u1ea1n s\u1ebd c\u00f3 c\u00e2u tr\u1ea3 l\u1eddi sau khi t\u00ecm hi\u1ec3u b\u00e0i vi\u1ebft n\u00e0y.<\/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-674d452c69422\" 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-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel.html#Tinh_trung_binh_co_dieu_kien\" title=\"T\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n\">T\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/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-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel.html#Ham_dem_theo_dieu_kien\" title=\"H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n\">H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/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-cach-su-dung-cac-ham-thong-ke-co-dieu-kien-trong-excel.html#Ham_tim_gia_tri_lon_nhat_nho_nhat_theo_dieu_kien\" title=\"H\u00e0m t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n\">H\u00e0m t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_trung_binh_co_dieu_kien\"><\/span>T\u00ednh trung b\u00ecnh c\u00f3 \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u1eafc t\u1edbi t\u00ednh trung b\u00ecnh, ch\u00fang ta ngh\u0129 ngay t\u1edbi nh\u00f3m h\u00e0m AVERAGE. V\u00e0 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u00ednh trung b\u00ecnh theo \u0111i\u1ec1u ki\u1ec7n th\u00ec Excel cung c\u1ea5p cho ch\u00fang ta 2 h\u00e0m l\u00e0:<\/p>\n<ul>\n<li><strong>AVERAGEIF<\/strong>(range,criteria,average_range): T\u00ednh trung b\u00ecnh theo 1 \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li><strong>AVERAGEIFS<\/strong>(average_range,criteria_range1,criteria1,[criteria_range2, criteria2],\u2026): T\u00ednh trung b\u00ecnh theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<\/ul>\n<p>V\u1ec1 c\u1ea5u tr\u00fac v\u00e0 c\u00e1ch vi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m th\u00ec hai h\u00e0m n\u00e0y kh\u00e1 gi\u1ed1ng v\u1edbi <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIF<\/a> v\u00e0 SUMIFS<\/strong>, nh\u01b0ng thay v\u00ec t\u00ednh t\u1ed5ng th\u00ec s\u1ebd t\u00ednh trung b\u00ecnh c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<p>\u0110\u1ec3 gi\u1ea3i th\u00edch r\u00f5 h\u01a1n v\u1ec1 2 h\u00e0m n\u00e0y ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau<\/p>\n<figure id=\"attachment_20167\" aria-describedby=\"caption-attachment-20167\" style=\"width: 766px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20167 size-full\" title=\"1 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/averageif-de-bai.png\" alt=\"1 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"766\" height=\"343\"><figcaption id=\"caption-attachment-20167\" class=\"wp-caption-text\">1 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p><strong>V\u1edbi y\u00eau c\u1ea7u 1: T\u00ednh m\u1ee9c l\u01b0\u01a1ng trung b\u00ecnh b\u1ed9 ph\u1eadn kinh doanh<\/strong><\/p>\n<p>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u:<\/p>\n<ul>\n<li>V\u00f9ng t\u00ednh trung b\u00ecnh: c\u1ed9t M\u1ee9c l\u01b0\u01a1ng<\/li>\n<li>V\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n: c\u1ed9t B\u1ed9 ph\u1eadn<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n: Kinh doanh<\/li>\n<\/ul>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u1ea3 2 h\u00e0m \u0111\u1ec3 t\u00ednh trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1edfi y\u00eau c\u1ea7u n\u00e0y ch\u1ec9 c\u00f3 1 \u0111i\u1ec1u ki\u1ec7n.<\/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-114.gif\" title=\"ex101_92019-nho-114\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">E12=AVERAGEIF(C2:C9,\u201dKinh doanh\u201d,D2:D9)<\/p>\n<p style=\"padding-left: 30px\">F12=AVERAGEIFS(D2:D9,C2:C9,\u201dKinh doanh\u201d)<\/p>\n<figure id=\"attachment_20168\" aria-describedby=\"caption-attachment-20168\" style=\"width: 767px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20168 size-full\" title=\"2 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/averageif-1-dieu-kien.png\" alt=\"2 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"767\" height=\"345\"><figcaption id=\"caption-attachment-20168\" class=\"wp-caption-text\">2 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p>C\u1ea3 2 h\u00e0m \u0111\u1ec1u ra k\u1ebft qu\u1ea3 gi\u1ed1ng nhau. Tuy nhi\u00ean khi vi\u1ebft h\u00e0m c\u1ea7n ch\u00fa \u00fd: C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m AVERAGEIFS kh\u00e1c so v\u1edbi h\u00e0m AVERAGEIF khi v\u00f9ng t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh \u0111\u01b0\u1ee3c vi\u1ebft tr\u01b0\u1edbc, t\u1ea1i th\u00e0nh ph\u1ea7n \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0m, trong khi h\u00e0m AverageIF th\u00ec th\u00e0nh ph\u1ea7n \u0111\u00f3 \u0111\u1eb7t \u1edf v\u1ecb tr\u00ed th\u1ee9 3. \u0110i\u1ec1u n\u00e0y r\u1ea5t gi\u1ed1ng v\u1edbi nh\u00f3m h\u00e0m SUMIF \/ SUMIFS<\/p>\n<p><strong>V\u1edbi y\u00eau c\u1ea7u 2: T\u00ednh m\u1ee9c l\u01b0\u01a1ng trung b\u00ecnh b\u1ed9 ph\u1eadn kinh doanh trong th\u00e1ng 2<\/strong><\/p>\n<p>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u:<\/p>\n<ul>\n<li>V\u00f9ng t\u00ednh trung b\u00ecnh: c\u1ed9t M\u1ee9c l\u01b0\u01a1ng<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1: c\u1ed9t B\u1ed9 ph\u1eadn<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: Kinh doanh<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2: c\u1ed9t Th\u00e1ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2: 2 (th\u00e1ng 2)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady trong y\u00eau c\u1ea7u n\u00e0y c\u00f3 t\u1edbi 2 \u0111i\u1ec1u ki\u1ec7n. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y kh\u00f4ng d\u00f9ng \u0111\u01b0\u1ee3c h\u00e0m AverageIF m\u00e0 ch\u1ec9 d\u00f9ng \u0111\u01b0\u1ee3c h\u00e0m\u00a0AverageIFS<\/p>\n<p>C\u00e1ch vi\u1ebft h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">F13=AVERAGEIFS(D2:D9,C2:C9,\u201dKinh doanh\u201d,A2:A9,2)<\/p>\n<figure id=\"attachment_20169\" aria-describedby=\"caption-attachment-20169\" style=\"width: 765px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20169 size-full\" title=\"3 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/averageif-nhieu-dieu-kien.png\" alt=\"3 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"765\" height=\"343\"><figcaption id=\"caption-attachment-20169\" class=\"wp-caption-text\">3 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p>Nh\u01b0 v\u1eady h\u00e0m AverageIFS l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t hi\u1ec7u qu\u1ea3, ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 thay th\u1ebf cho h\u00e0m AverageIF trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p c\u1ea7n t\u00ednh trung b\u00ecnh theo \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-trung-binh-dong-trong-excel.html\">C\u00e1ch t\u00ednh trung b\u00ecnh \u0111\u1ed9ng trong Excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_dem_theo_dieu_kien\"><\/span>H\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong y\u00eau c\u1ea7u \u0111\u1ebfm th\u00ec ch\u00fang ta c\u00f3 nh\u00f3m h\u00e0m COUNT. Vi\u1ec7c \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n\u00a0c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm theo 1 \u0111i\u1ec1u ki\u1ec7n, h\u00e0m COUNTIFS \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>C\u00e1c b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 c\u00f3 s\u1eb5n kh\u00e1 nhi\u1ec1u tr\u00ean blog.hocexcel.online. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\">C\u00e1ch d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\"><strong>h\u00e0m COUNTIFS<\/strong><\/a> v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_tim_gia_tri_lon_nhat_nho_nhat_theo_dieu_kien\"><\/span>H\u00e0m t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb phi\u00ean b\u1ea3n OFFICE 2016, OFFICE 365 tr\u1edf \u0111i ch\u00fang ta c\u00f3 th\u00eam h\u00e0m gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n. C\u1ee5 th\u1ec3 l\u00e0<\/p>\n<ul>\n<li><strong>MAXIFS<\/strong>(max_range,criteria_range1,criteria1,[criteria_range2,criteria2],\u2026) T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t theo 1 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li><strong>MINIFS<\/strong>(max_range,criteria_range1,criteria1,[criteria_range2,criteria2],\u2026) T\u00ecm gi\u00e1 tr\u1ecb\u00a0nh\u1ecf\u00a0nh\u1ea5t theo 1 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 v\u1ec1 2 h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<figure id=\"attachment_20170\" aria-describedby=\"caption-attachment-20170\" style=\"width: 654px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20170 size-full\" title=\"4 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/maxifs-minifs-de-bai.png\" alt=\"4 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"654\" height=\"345\"><figcaption id=\"caption-attachment-20170\" class=\"wp-caption-text\">4 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p><strong>Y\u00eau c\u1ea7u 1: T\u00ecm gi\u00e1 tr\u1ecb m\u1ee9c l\u01b0\u01a1ng l\u1edbn nh\u1ea5t b\u1ed9 ph\u1eadn Kinh doanh trong th\u00e1ng 2<\/strong><\/p>\n<p>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u:<\/p>\n<ul>\n<li>V\u00f9ng x\u00e9t gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t: c\u1ed9t M\u1ee9c l\u01b0\u01a1ng<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1: c\u1ed9t B\u1ed9 ph\u1eadn<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: Kinh doanh<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2: c\u1ed9t Th\u00e1ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2: 2 (th\u00e1ng 2)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u1ea7n d\u00f9ng t\u1edbi 2 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. C\u00e1ch vi\u1ebft h\u00e0m MAXIFS nh\u01b0 sau:<\/p>\n<p>E12=MAXIFS(D2:D9,C2:C9,\u201dKinh doanh\u201d,A2:A9,2)<\/p>\n<figure id=\"attachment_20171\" aria-describedby=\"caption-attachment-20171\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20171 size-full\" title=\"5 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/maxifs-minifs-ket-qua-maxifs.png\" alt=\"5 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"653\" height=\"344\"><figcaption id=\"caption-attachment-20171\" class=\"wp-caption-text\">5 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p>C\u00e1ch vi\u1ebft v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, \u0111i\u1ec1u ki\u1ec7n gi\u1ed1ng nh\u01b0 khi ch\u00fang ta vi\u1ebft v\u1edbi c\u00e1c h\u00e0m Averageifs, countifs, sumifs<\/p>\n<p><strong>Y\u00eau c\u1ea7u 2: t\u00ecm m\u1ee9c l\u01b0\u01a1ng nh\u1ecf nh\u1ea5t trong th\u00e1ng 2<\/strong><\/p>\n<p>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u:<\/p>\n<ul>\n<li>V\u00f9ng\u00a0x\u00e9t gi\u00e1 tr\u1ecb\u00a0nh\u1ecf\u00a0nh\u1ea5t: c\u1ed9t M\u1ee9c l\u01b0\u01a1ng<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1: c\u1ed9t Th\u00e1ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: gi\u00e1 tr\u1ecb l\u00e0 2 (th\u00e1ng 2)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u1ec9 c\u1ea7n d\u00f9ng 1 \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean h\u00e0m t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 c\u00f3 h\u00e0m MINIFS n\u00ean ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<p>E13=MINIFS(D2:D9,A2:A9,2)<\/p>\n<figure id=\"attachment_20172\" aria-describedby=\"caption-attachment-20172\" style=\"width: 657px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20172 size-full\" title=\"6 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/maxifs-minifs-ket-qua-minifs.png\" alt=\"6 - c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"657\" height=\"344\"><figcaption id=\"caption-attachment-20172\" class=\"wp-caption-text\">6 \u2013 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-1.html\">C\u00e1ch x\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n<\/a>\u00a0(b\u00e0i vi\u1ebft c\u00f3 3 ph\u1ea7n)<\/p>\n<p>Nh\u01b0 v\u1eady th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c nh\u1eefng h\u00e0m gi\u00fap th\u1ed1ng k\u00ea theo \u0111i\u1ec1u ki\u1ec7n trong Excel. Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2m8t7Ts\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online<\/a>. Ngo\u00e0i ra kh\u00f3a h\u1ecdc c\u00f2n cung c\u1ea5p cho b\u1ea1n nhi\u1ec1u ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch kh\u00e1c n\u1eefa, gi\u00fap b\u1ea1n \u1ee9ng d\u1ee5ng t\u1ed1t h\u01a1n Excel trong c\u00f4ng vi\u1ec7c.\u00a0H\u00e3y tham gia ngay kh\u00f3a h\u1ecdc b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y:<\/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-114.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1589,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1588","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\/1588","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=1588"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1589"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}