{"id":2592,"date":"2024-12-02T08:10:35","date_gmt":"2024-12-02T08:10:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel\/"},"modified":"2024-12-02T08:10:35","modified_gmt":"2024-12-02T08:10:35","slug":"huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm theo \u0111\u1ed9 tu\u1ed5i trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c th\u1ed1ng k\u00ea s\u1ed1 ng\u01b0\u1eddi trong\u00a0\u0111\u1ed9 tu\u1ed5i l\u00e0 m\u1ed9t ch\u1ee7\u00a0\u0111\u1ec1\u00a0\u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u b\u1ea1n quan t\u00e2m.\u00a0D\u00f9ng h\u00e0m g\u00ec? Vi\u1ebft h\u00e0m nh\u01b0 th\u1ebf n\u00e0o? T\u1ea5t c\u1ea3 nh\u1eefng th\u1eafc m\u1eafc\u00a0\u0111\u00f3 s\u1ebd\u00a0\u0111\u01b0\u1ee3c <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> gi\u1ea3i\u00a0\u0111\u00e1p qua b\u00e0i vi\u1ebft n\u00e0y. CH\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u\u00a0<strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm theo \u0111\u1ed9 tu\u1ed5i trong Excel<\/strong> ngay n\u00e0o.<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n d\u1ec5 h\u00ecnh dung, ch\u00fang ta h\u00e3y xem v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb A1:C13 v\u1edbi n\u1ed9i dung sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23722\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-thong-ke-theo-do-tuoi.png\" width=\"556\" height=\"348\" title=\"de-bai-thong-ke-theo-do-tuoi\"><\/p>\n<p>Y\u00eau c\u1ea7u: Th\u1ed1ng k\u00ea (\u0111\u1ebfm) s\u1ed1\u00a0ng\u01b0\u1eddi trong\u00a0\u0111\u1ed9 tu\u1ed5i d\u01b0\u1edbi 30, t\u1eeb 30\u00a0\u0111\u1ebfn 40 tu\u1ed5i, t\u1eeb 41\u00a0\u0111\u1ebfn 50 tu\u1ed5i.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau<\/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-674d6b7ace552\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel.html#Dem_so_nguoi_co_do_tuoi_duoi_30_voi_ham_COUNTIF\" title=\"\u0110\u1ebfm s\u1ed1\u00a0ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i d\u01b0\u1edbi 30 v\u1edbi h\u00e0m COUNTIF\">\u0110\u1ebfm s\u1ed1\u00a0ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i d\u01b0\u1edbi 30 v\u1edbi h\u00e0m COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel.html#Dem_nguoi_co_do_tuoi_trong_khoang_tu_tuoi_den_tuoi\" title=\"\u0110\u1ebfm ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i trong kho\u1ea3ng t\u1eeb tu\u1ed5i\u00a0\u0111\u1ebfn tu\u1ed5i\">\u0110\u1ebfm ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i trong kho\u1ea3ng t\u1eeb tu\u1ed5i\u00a0\u0111\u1ebfn tu\u1ed5i<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel.html#Cach_1_Dem_theo_nhieu_dieu_kien\" title=\"C\u00e1ch 1:\u00a0\u0110\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\">C\u00e1ch 1:\u00a0\u0110\u1ebfm theo nhi\u1ec1u\u00a0\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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-dem-theo-do-tuoi-trong-excel.html#Cach_2_Dem_va_loai_tru\" title=\"C\u00e1ch 2:\u00a0\u0110\u1ebfm v\u00e0 lo\u1ea1i tr\u1eeb\">C\u00e1ch 2:\u00a0\u0110\u1ebfm v\u00e0 lo\u1ea1i tr\u1eeb<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dem_so_nguoi_co_do_tuoi_duoi_30_voi_ham_COUNTIF\"><\/span>\u0110\u1ebfm s\u1ed1\u00a0ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i d\u01b0\u1edbi 30 v\u1edbi h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta th\u1ea5y xu\u1ea5t hi\u1ec7n y\u00eau c\u1ea7u l\u00e0 th\u1ed1ng k\u00ea (\u0111\u1ebfm) v\u1edbi 1\u00a0\u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t, do\u00a0\u0111\u00f3:<\/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-200.gif\" title=\"ex101_92019-nho-200\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>H\u00e0m\u00a0\u0111\u1ec3 th\u1ed1ng k\u00ea,\u00a0\u0111\u1ebfm trong Excel l\u00e0 h\u00e0m COUNT<\/li>\n<li>Khi vi\u1ec7c\u00a0\u0111\u1ebfm c\u00f3 bao g\u1ed3m 1 \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\"><strong>h\u00e0m COUNTIF<\/strong><\/a><\/li>\n<\/ul>\n<p>C\u1ee5 th\u1ec3 l\u00e0:<\/p>\n<ul>\n<li>V\u00f9ng c\u1ea7n\u00a0\u0111\u1ebfm: C\u1ed9t tu\u1ed5i, t\u1eeb\u00a0\u00f4 C2\u00a0\u0111\u1ebfn C13<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n c\u1ea7n\u00a0\u0111\u1ebfm: Nh\u1ecf h\u01a1n 30<\/li>\n<\/ul>\n<p>H\u00e0m COUNTIF\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">F2=COUNTIF(C2:C13,\u201d&lt;30\u2033)<\/p>\n<p>\u0111\u00e2y l\u00e0 c\u00e1ch vi\u1ebft d\u1ea5u so s\u00e1nh v\u00e0 s\u1ed1 c\u1ea7n so s\u00e1nh n\u1eb1m trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p; ho\u1eb7c<\/p>\n<p style=\"padding-left: 30px\">F2=COUNTIF(C2:C13,\u201d&lt;\u201c&amp;30)<\/p>\n<p>\u0111\u00e2y l\u00e0 c\u00e1ch vi\u1ebft d\u1ea5u so s\u00e1nh ri\u00eang, s\u1ed1 c\u1ea7n so s\u00e1nh ri\u00eang v\u00e0 n\u1ed1i v\u1edbi nhau b\u1edfi d\u1ea5u &amp;<\/p>\n<p>Xem th\u00eam: <strong>h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\">h\u00e0m count<\/a> v\u00e0 couta \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 trong Excel\u00a0<\/strong><\/p>\n<p><em><strong>* Ch\u00fa\u00a0\u00fd:<\/strong><\/em><\/p>\n<p>T\u1ea1i sao vi\u1ebft &lt;30 l\u1ea1i ph\u1ea3i\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p?<\/p>\n<p>B\u1edfi v\u00ec d\u1ea5u\u00a0&lt; l\u00e0 d\u1ea5u to\u00e1n t\u1eed. Khi vi\u1ebft d\u1ea5u n\u00e0y ph\u1ea3i\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p (gi\u1ed1ng v\u1edbi vi\u1ec7c vi\u1ebft k\u00fd t\u1ef1 Text trong h\u00e0m). Khi gh\u00e9p d\u1ea5u to\u00e1n t\u1eed v\u1edbi 1 s\u1ed1 th\u00ec c\u00f3 2 c\u00e1ch vi\u1ebft l\u00e0 s\u1ed1\u00a0\u0111\u1ea1t ngay c\u1ea1nh d\u1ea5u to\u00e1n t\u1eed b\u00ean trong d\u1ea5u nh\u00e1y k\u00e9p, ho\u1eb7c\u00a0\u0111\u1eb7t ngo\u00e0i d\u1ea5u nh\u00e1y k\u00e9p th\u00ec ph\u1ea3i k\u1ebft h\u1ee3p v\u1edbi d\u1ea5u &amp;<\/p>\n<p>Khi\u00a0\u0111\u00f3 ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23741\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-countif-dem-nguoi-tuoi-duoi-30.png\" width=\"572\" height=\"387\" title=\"ket-qua-countif-dem-nguoi-tuoi-duoi-30\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dem_nguoi_co_do_tuoi_trong_khoang_tu_tuoi_den_tuoi\"><\/span>\u0110\u1ebfm ng\u01b0\u1eddi c\u00f3\u00a0\u0111\u1ed9 tu\u1ed5i trong kho\u1ea3ng t\u1eeb tu\u1ed5i\u00a0\u0111\u1ebfn tu\u1ed5i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede y\u00eau c\u1ea7u\u00a0\u0111\u1ebfm s\u1ed1\u00a0ng\u01b0\u1eddi\u00a0\u1edf\u00a0\u0111\u1ed9 tu\u1ed5i T\u1eeb 30\u00a0\u0111\u1ebfn 40, ch\u00fang ta c\u00f3 2 m\u1ee9c gi\u1edbi h\u1ea1n tu\u1ed5i. Do\u00a0\u0111\u00f3 c\u00f3 2 c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Dem_theo_nhieu_dieu_kien\"><\/span>C\u00e1ch 1:\u00a0\u0110\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Coi T\u1eeb tr\u00ean 30 tu\u1ed5i l\u00e0 1\u00a0\u0111i\u1ec1u ki\u1ec7n v\u00e0 T\u1eeb d\u01b0\u1edbi 40 tu\u1ed5i l\u00e0 1\u00a0\u0111i\u1ec1u ki\u1ec7n, nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y y\u00eau c\u1ea7u n\u00e0y c\u00f3 2\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>H\u00e0m\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 h\u00e0m COUNTIFS. C\u00e1ch vi\u1ebft h\u00e0m COUNTIFS gi\u1ed1ng v\u1edbi h\u00e0m COUNTIF, nh\u01b0ng t\u0103ng th\u00eam v\u1ec1\u00a0\u0111i\u1ec1u ki\u1ec7n. M\u1ed7i\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ea3i n\u1eb1m trong 1 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 F3 c\u00f3 th\u1ec3 vi\u1ebft l\u00e0:<\/p>\n<p>=COUNTIFS(C2:C13,\u201d&gt;=30\u2033,C2:C13,\u201d&lt;=40\u2033)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23742\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-countif-dem-nguoi-tuoi-30-40.png\" width=\"708\" height=\"389\" title=\"ket-qua-countif-dem-nguoi-tuoi-30-40\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Dem_va_loai_tru\"><\/span>C\u00e1ch 2:\u00a0\u0110\u1ebfm v\u00e0 lo\u1ea1i tr\u1eeb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n v\u1eabn mu\u1ed1n d\u00f9ng h\u00e0m COUNTIF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c, nh\u01b0ng\u00a0\u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3\u00a0\u0111\u00fang ph\u1ea3i bi\u1ebft s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i tr\u1eeb.<\/p>\n<p>V\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng n\u00e0y, ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23743\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tinh-loai-tru-countif.png\" width=\"624\" height=\"154\" title=\"cach-tinh-loai-tru-countif\"><\/p>\n<p>Trong s\u01a1\u00a0\u0111\u1ed3 tr\u00ean:<\/p>\n<p>Ph\u1ea7n A l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb &gt;=30,\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh b\u1eb1ng h\u00e0m COUNTIF(C2:C13,\u201d&gt;=30\u2033)<\/p>\n<p>Ph\u1ea7n B l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb &gt;40,\u00a0,\u00a0\u0111\u01b0\u1ee3c x\u00e1c\u00a0\u0111\u1ecbnh b\u1eb1ng h\u00e0m COUNTIF(C2:C13,\u201d&gt;40\u2033)<\/p>\n<p>B\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i tr\u1eeb, ta c\u00f3 k\u1ebft qu\u1ea3 s\u1ebd =A \u2013 B =COUNTIF(C2:C13,\u201d&gt;=30\u2033)-COUNTIF(C2:C13,\u201d&gt;40\u2033)<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23744\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-countif-dem-nguoi-tuoi-30-40-cach-2.png\" width=\"779\" height=\"389\" title=\"ket-qua-countif-dem-nguoi-tuoi-30-40-cach-2\"><\/p>\n<p><em><strong>* L\u01b0u\u00a0\u00fd:<\/strong><\/em><\/p>\n<p>Ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i tr\u1eeb n\u00e0y kh\u00f4ng gi\u1ed1ng v\u1edbi vi\u1ec7c vi\u1ebft\u00a0\u0111\u1ed3ng th\u1eddi AND(C2:C13&gt;=30,C2:C13&lt;=40)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi\u00a0\u0111\u1ed9 tu\u1ed5i t\u1eeb 41\u00a0\u0111\u1ebfn 50 ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">F4=COUNTIF(C2:C13,\u201d&gt;=41\u2033)-COUNTIF(C2:C13,\u201d&gt;50\u2033)<\/p>\n<p>ho\u1eb7c<\/p>\n<p style=\"padding-left: 30px\">F4=COUNTIFS(C2:C13,\u201d&gt;=41\u2033,C2:C13,\u201d&lt;=50\u2033)<\/p>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m\u00a0\u0111\u1ebfm,\u00a0\u0111\u1ebfm theo c\u00e1c gi\u1edbi h\u1ea1n trong 1 kho\u1ea3ng c\u00f3\u00a0\u0111i\u1ec3m\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec3m cu\u1ed1i,\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i tr\u1eeb khi\u00a0\u0111\u1ebfm theo kho\u1ea3ng.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft c\u00f3 c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1 nh\u01b0:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">C\u00e1ch d\u00f9ng h\u00e0m COUNTIFS v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-countifs.html\">4 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ho\u1eb7c \u2013 H\u00e0m COUNTIFS<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-sumproduct.html\">4 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ho\u1eb7c \u2013 H\u00e0m SUMPRODUCT<\/a><\/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-200.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2593,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2592","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\/2592","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=2592"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2592\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2593"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}