{"id":4667,"date":"2024-12-08T06:09:48","date_gmt":"2024-12-08T06:09:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel\/"},"modified":"2024-12-08T06:09:48","modified_gmt":"2024-12-08T06:09:48","slug":"huong-dan-cach-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Th\u00f4ng th\u01b0\u1eddng khi l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel ch\u00fang ta hay quan t\u00e2m t\u1edbi vi\u1ec7c d\u00f9ng h\u00e0m g\u00ec. Nh\u01b0ng h\u1ea7u h\u1ebft kh\u00f4ng nh\u1eadn ra r\u1eb1ng c\u1ea5u tr\u00fac b\u00e1o c\u00e1o nh\u01b0 th\u1ebf n\u00e0o m\u1edbi l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng. C\u1ea5u tr\u00fac khoa h\u1ecdc, h\u1ee3p l\u00fd s\u1ebd gi\u00fap ch\u00fang ta d\u1ec5 d\u00e0ng h\u01a1n trong vi\u1ec7c l\u1ef1a ch\u1ecdn h\u00e0m, s\u1eed d\u1ee5ng h\u00e0m. N\u1ebfu ch\u1ec9 t\u1eadp trung v\u00e0o ngh\u0129 d\u00f9ng h\u00e0m g\u00ec th\u00ec ch\u00fang ta s\u1ebd g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n v\u1edbi nh\u1eefng y\u00eau c\u1ea7u b\u00e1o c\u00e1o ph\u1ee9c t\u1ea1p, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u00ean Excel nh\u00e9:<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n d\u1ec5 h\u00ecnh dung 1 y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n th\u00ec ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20056\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-nhieu-dieu-kien-01.png\" width=\"873\" height=\"254\" title=\"bao-cao-nhieu-dieu-kien-01\"><\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh tr\u00ean (kho\u1ea3ng 60 d\u00f2ng d\u1eef li\u1ec7u). Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta l\u00e0 ph\u1ea3i l\u1eadp b\u00e1o c\u00e1o s\u1ed1 l\u01b0\u1ee3ng nh\u1eadp xu\u1ea5t c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng trong t\u1eebng kho, v\u00e0 ch\u1ec9 t\u00ednh cho th\u00e1ng 5<\/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-6755382b574d5\" 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-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel.html#Phan_tich_yeu_cau_lap_bao_cao\" title=\"Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o\">Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o<\/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-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel.html#Cach_to_chuc_bang_bao_cao_nhieu_dieu_kien\" title=\"C\u00e1ch t\u1ed5 ch\u1ee9c b\u1ea3ng b\u00e1o c\u00e1o nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">C\u00e1ch t\u1ed5 ch\u1ee9c b\u1ea3ng b\u00e1o c\u00e1o nhi\u1ec1u \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-lap-bao-cao-tong-hop-theo-nhieu-dieu-kien-tren-excel.html#Cach_viet_cong_thuc_tinh_ket_qua_bao_cao\" title=\"C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c t\u00ednh k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o\">C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c t\u00ednh k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Phan_tich_yeu_cau_lap_bao_cao\"><\/span>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u l\u1eadp b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nghe th\u1eadt ph\u1ee9c t\u1ea1p ph\u1ea3i kh\u00f4ng n\u00e0o. V\u1edbi y\u00eau c\u1ea7u n\u00e0y ch\u00fang ta c\u00f3 t\u1edbi 4 \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>\u0110i\u1ec1u ki\u1ec7n 1: T\u00ean m\u1eb7t h\u00e0ng<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2: Lo\u1ea1i nh\u1eadp \u2013 xu\u1ea5t<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 3: Theo t\u1eebng kho<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 4: T\u00ednh trong th\u00e1ng 5<\/li>\n<\/ul>\n<p>V\u1eady th\u00ec \u0111\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y, quan tr\u1ecdng nh\u1ea5t l\u00e0 ch\u00fang ta c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? 4 \u0111i\u1ec1u ki\u1ec7n s\u1ebd \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed tr\u00ean 1 b\u1ea3ng b\u00e1o c\u00e1o ra sao \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t?<\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html\">T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel<\/a><\/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-378.gif\" title=\"ex101_92019-nho-378\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_to_chuc_bang_bao_cao_nhieu_dieu_kien\"><\/span>C\u00e1ch t\u1ed5 ch\u1ee9c b\u1ea3ng b\u00e1o c\u00e1o nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 bi\u1ebft b\u00e1o c\u00e1o c\u00f3\u00a0t\u1ed1i \u0111a bao nhi\u00eau chi\u1ec1u kh\u00f4ng? C\u00e1ch b\u1ed1 tr\u00ed s\u1eafp x\u1ebfp c\u00e1c chi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 1 b\u1ea3ng b\u00e1o c\u00e1o c\u00f3 t\u1ed1i \u0111a l\u00e0 3 chi\u1ec1u. V\u1edbi s\u1ed1 \u0111i\u1ec1u ki\u1ec7n l\u1eadp b\u00e1o c\u00e1o l\u1edbn h\u01a1n 3 th\u00ec ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c v\u00e0o trong 3 chi\u1ec1u m\u00e0 th\u00f4i.\u00a0C\u00e1ch t\u1ed5 ch\u1ee9c nh\u01b0 sau:<\/p>\n<ul>\n<li>Row: \u0110i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c tr\u00ean nhi\u1ec1u d\u00f2ng, trong c\u00f9ng 1 c\u1ed9t, th\u01b0\u1eddng n\u1eb1m b\u00ean tr\u00e1i b\u1ea3ng b\u00e1o c\u00e1o. C\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng chi ti\u1ebft h\u01a1n c\u1ee7a \u0111i\u1ec1u ki\u1ec7n n\u00e0y th\u00ec s\u1ebd n\u1eb1m \u1edf c\u00e1c c\u1ed9t b\u00ean ph\u1ea3i\u00a0m\u1ed7i nh\u00f3m v\u00e0 \u1edf c\u00e1c d\u00f2ng\u00a0chi ti\u1ebft so v\u1edbi \u0111i\u1ec1u ki\u1ec7n nh\u00f3m.<\/li>\n<li>Column: \u0110i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c tr\u00ean nhi\u1ec1u c\u1ed9t, trong c\u00f9ng 1 d\u00f2ng, th\u01b0\u1eddng n\u1eb1m ph\u00eda tr\u00ean b\u1ea3ng b\u00e1o c\u00e1o. C\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng chi ti\u1ebft h\u01a1n c\u1ee7a \u0111i\u1ec1u ki\u1ec7n n\u00e0y th\u00ec s\u1ebd n\u1eb1m \u1edf c\u00e1c c\u1ed9t b\u00ean trong m\u1ed7i nh\u00f3m v\u00e0 \u1edf d\u00f2ng b\u00ean d\u01b0\u1edbi<\/li>\n<li>Filter: l\u00e0 nh\u1eefng \u0111i\u1ec1u ki\u1ec7n c\u00f3 t\u00e1c d\u1ee5ng l\u1ecdc, gi\u1edbi h\u1ea1n ph\u1ea1m vi t\u00ednh to\u00e1n c\u1ee7a b\u00e1o c\u00e1o m\u00e0 kh\u00f4ng ph\u1ea3i y\u1ebfu t\u1ed1 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea nh\u01b0 trong Row v\u00e0 Column.<\/li>\n<\/ul>\n<p>C\u1ee5 th\u1ec3 trong y\u00eau c\u1ea7u n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 b\u1ed1 c\u1ee5c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20057\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-nhieu-dieu-kien-02.png\" width=\"652\" height=\"219\" title=\"bao-cao-nhieu-dieu-kien-02\"><\/p>\n<ul>\n<li>Th\u00e1ng = 5: \u0111i\u1ec1u ki\u1ec7n c\u00f3 vai tr\u00f2 l\u1ecdc, gi\u1edbi h\u1ea1n ph\u1ea1m vi t\u00ednh to\u00e1n =&gt; V\u1ecb tr\u00ed Filter<\/li>\n<li>T\u00ean m\u1eb7t h\u00e0ng: n\u1eb1m \u1edf Row<\/li>\n<li>T\u00ean kho v\u00e0 chi ti\u1ebft Nh\u1eadp-xu\u1ea5t m\u1ed7i kho: n\u1eb1m \u1edf Column<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_cong_thuc_tinh_ket_qua_bao_cao\"><\/span>C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c t\u00ednh k\u1ebft qu\u1ea3 b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u00e1o c\u00e1o, ch\u00fang ta c\u00f2n c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh y\u00eau c\u1ea7u t\u00ednh to\u00e1n c\u1ee7a b\u00e1o c\u00e1o \u0111\u1ec3 l\u1ef1a ch\u1ecdn ra c\u00f4ng th\u1ee9c, h\u00e0m ph\u00f9 h\u1ee3p. Trong y\u00eau c\u1ea7u n\u00e0y ta c\u00f3:<\/p>\n<ul>\n<li>T\u00ednh theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (4 \u0111i\u1ec1u ki\u1ec7n)<\/li>\n<li>T\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng =&gt; T\u00ednh t\u1ed5ng, v\u00f9ng t\u00ednh t\u1ed5ng l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 h\u00e0m s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">h\u00e0m SUMIFS<\/a><\/p>\n<p>C\u00e1ch vi\u1ebft h\u00e0m SUMIFS trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau:<\/p>\n<ul>\n<li>Sum_range: C\u1ed9t E l\u00e0 c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng (v\u00ec b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 t\u1eeb d\u00f2ng 2 t\u1edbi d\u00f2ng 57 n\u00ean ta s\u1ebd t\u00ednh trong v\u00f9ng E2:E57<\/li>\n<li>Criteria_range1: V\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1 l\u00e0 T\u00ean m\u1eb7t h\u00e0ng (c\u1ed9t D), v\u00f9ng D2:D57<\/li>\n<li>Criteria1: \u0110i\u1ec1u ki\u1ec7n 1 n\u1eb1m trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1. \u0110\u00f3\u00a0l\u00e0 t\u00ean m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c l\u1ea5y theo ph\u1ea7n Row c\u1ee7a b\u00e1o c\u00e1o<\/li>\n<li>Criteria_range2: V\u00f9ng \u0111i\u1ec1u ki\u1ec7n\u00a02 l\u00e0 T\u00ean\u00a0kho (c\u1ed9t C), v\u00f9ng C2:C57<\/li>\n<li>Criteria2: \u0110i\u1ec1u ki\u1ec7n 2 n\u1eb1m trong c\u1ed9t T\u00ean Kho l\u00e0 Kho, t\u01b0\u01a1ng \u1ee9ng Kho A, Kho B, Kho C<\/li>\n<li>Criteria_range3: V\u00f9ng \u0111i\u1ec1u ki\u1ec7n\u00a03 l\u00e0\u00a0Lo\u1ea1i\u00a0(c\u1ed9t B), v\u00f9ng B2:B57<\/li>\n<li>Criteria3: \u0110i\u1ec1u ki\u1ec7n 3 n\u1eb1m trong c\u1ed9t Lo\u1ea1i l\u00e0 \u201cNh\u1eadp\u201d ho\u1eb7c \u201cXu\u1ea5t\u201d t\u01b0\u01a1ng \u1ee9ng theo c\u1ed9t<\/li>\n<li>Criteria_range4: V\u00f9ng \u0111i\u1ec1u ki\u1ec7n\u00a04 l\u00e0\u00a0th\u1eddi gian\u00a0(c\u1ed9t A), v\u00f9ng A2:A57<\/li>\n<li>Criteria4: \u1edf \u0111\u00e2y l\u00e0 gi\u1edbi h\u1ea1n trong th\u00e1ng 5. Trong khi d\u1eef li\u1ec7u l\u00e0 d\u1eef li\u1ec7u ng\u00e0y. V\u00ec v\u1eady ph\u1ea3i t\u00e1ch \u0111i\u1ec1u ki\u1ec7n n\u00e0y ra 2 \u0111i\u1ec1u ki\u1ec7n nh\u1ecf h\u01a1n l\u00e0 T\u1eeb ng\u00e0y v\u00e0 \u0111\u1ebfn ng\u00e0y. C\u1ee5\u00a0th\u1ec3 l\u00e0 t\u1eeb ng\u00e0y 01\/05 \u0111\u1ebfn ng\u00e0y 31\/05 (\u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n).<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20058\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-nhieu-dieu-kien-03.png\" width=\"1500\" height=\"294\" title=\"bao-cao-nhieu-dieu-kien-03\"><\/p>\n<p><strong>C\u00f4ng th\u1ee9c t\u1ea1i \u00f4\u00a0B4<\/strong><\/p>\n<p style=\"padding-left: 30px\">=SUMIFS(Sheet1!$G$2:$G$57,Sheet1!$D$2:$D$57,<strong>$A4<\/strong>,Sheet1!$C$2:$C$57,<strong>B$2<\/strong>,Sheet1!$B$2:$B$57,<strong>B$3<\/strong>,Sheet1!$A$2:$A$57,<strong>\u201c&gt;=\u201d&amp;DATE(2018,5,1)<\/strong>,Sheet1!$A$2:$A$57,<strong>\u201c&lt;=\u201d&amp;DATE(2018,5,31)<\/strong>)<\/p>\n<p><strong>C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C4<\/strong><\/p>\n<p style=\"padding-left: 30px\">=SUMIFS(Sheet1!$G$2:$G$57,Sheet1!$D$2:$D$57,<strong>$A4<\/strong>,Sheet1!$C$2:$C$57,<strong>B$2<\/strong>,Sheet1!$B$2:$B$57,<strong>C$3<\/strong>,Sheet1!$A$2:$A$57,<strong>\u201c&gt;=\u201d&amp;DATE(2018,5,1)<\/strong>,Sheet1!$A$2:$A$57,<strong>\u201c&lt;=\u201d&amp;DATE(2018,5,31)<\/strong>)<\/p>\n<p>Ch\u00fang ta th\u1ea5y c\u00f4ng th\u1ee9c kh\u00e1 d\u00e0i ph\u1ea3i kh\u00f4ng n\u00e0o? Nh\u01b0ng khi ph\u00e2n t\u00edch c\u1ee5 th\u1ec3 t\u1eebng \u0111i\u1ec1u ki\u1ec7n (ph\u1ea7n in \u0111\u1eadm trong c\u00f4ng th\u1ee9c) v\u00e0 t\u1eebng v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, v\u00f9ng t\u00ednh t\u1ed5ng th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng r\u1ed3i.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"http:\/\/bit.ly\/2zd3SbZ\">http:\/\/bit.ly\/2zd3SbZ<\/a><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-dieu-kien-ham-sumifs-de-dat-hieu-qua-tot-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n h\u00e0m SUMIFS \u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1t nh\u1ea5t<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng theo tu\u1ea7n, th\u00e1ng, n\u0103m<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2KOYz6T\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-378.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4667","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\/4667","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=4667"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4667\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4668"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}