{"id":10665,"date":"2025-01-14T22:50:40","date_gmt":"2025-01-14T22:50:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs\/"},"modified":"2025-01-14T22:50:40","modified_gmt":"2025-01-14T22:50:40","slug":"cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs\/","title":{"rendered":"C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo t\u1eebng th\u00e1ng v\u1edbi h\u00e0m SUMIFS"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>SUMIFS l\u00e0 1 h\u00e0m r\u1ea5t quen thu\u1ed9c v\u00e0 h\u1eefu\u00a0\u00edch khi ch\u00fang ta mu\u1ed1n t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. H\u00e0m n\u00e0y th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p v\u1edbi c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n li\u00ean quan t\u1edbi th\u1eddi gian, t\u1edbi nhi\u1ec1u\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f9ng l\u00fac. V\u1ec1 c\u1ea5u tr\u00fac v\u00e0 c\u00e1ch s\u1eed\u00a0 d\u1ee5ng h\u00e0m SUMIFS c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem t\u1ea1i \u0111\u00e2y:<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\">h\u00e0m Sumifs<\/a> trong Excel qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/strong><\/p>\n<p>Tuy nhi\u00ean c\u00f3 1 h\u1ea1n ch\u1ebf l\u00e0 c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m SUMIFS ph\u1ea3i c\u00f3 c\u1ea5u tr\u00fac ho\u1eb7c n\u1ed9i dung t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u00f3. T\u1ee9c l\u00e0:<\/p>\n<ul>\n<li>N\u1ebfu criteria_range l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng\u00a0dd\/mm\/yyyy th\u00ec criteria trong\u00a0\u0111\u00f3 ph\u1ea3i l\u00e0 d\u1ea1ng\u00a0dd\/mm\/yyyy<\/li>\n<\/ul>\n<p>V\u1eady n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta l\u00e0 d\u1ea1ng\u00a0dd\/mm\/yyyy m\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh c\u1ee7a ch\u00fang ta l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Th\u00e1ng th\u00ec sao? L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m SUMIFS theo t\u1eebng th\u00e1ng trong t\u1eebng n\u0103m? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14508\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-sumifs-bcth-01.png\" width=\"1289\" height=\"478\" title=\"heo-sumifs-bcth-01\"><\/p>\n<p><strong>Y\u00eau c\u1ea7u<\/strong>:<\/p>\n<p>L\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p doanh s\u1ed1 b\u00e1n h\u00e0ng theo t\u1eebng th\u00e1ng trong c\u00e1c n\u0103m theo:<\/p>\n<ul>\n<li>Nh\u00e2n vi\u00ean<\/li>\n<li>S\u1ea3n ph\u1ea9m<\/li>\n<\/ul>\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<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-7.gif\" title=\"vba101_92019-nho-7\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-207.gif\" title=\"ex101_92019-nho-207\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><label for=\"ez-toc-cssicon-toggle-item-6786ea3fa63e6\" 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\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html#Phan_tich_yeu_cau\" title=\"Ph\u00e2n t\u00edch y\u00eau c\u1ea7u\">Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<\/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\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html#Xay_dung_cong_thuc_tinh\" title=\"X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Phan_tich_yeu_cau\"><\/span><strong>Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><em>D\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u<\/em><\/strong>: b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m c\u00e1c c\u1ed9t: Ng\u00e0y \/ S\u1ea3n ph\u1ea9m \/ Nh\u00e2n vi\u00ean \/ S\u1ed1 ti\u1ec1n; trong\u00a0\u0111\u00f3 c\u1ed9t Ng\u00e0y\u00a0\u1edf d\u1ea1ng\u00a0dd\/mm\/yyyy<\/p>\n<p><strong><em>Y\u00eau c\u1ea7u c\u1ea7n th\u1ef1c\u00a0 \u00a0hi\u1ec7n<\/em><\/strong>: B\u00e1o c\u00e1o theo doanh thu (c\u1ed9t s\u1ed1 ti\u1ec1n) c\u1ee7a\u00a0Nh\u00e2n vi\u00ean (c\u1ed9t C) theo t\u1eebng th\u00e1ng, t\u1eebng n\u0103m (c\u1ed9t A).\u00a0\u1ede\u00a0\u0111\u00e2y\u00a0\u0111\u1ec3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c c\u1ea7n th\u00f4ng qua 2\u00a0\u0111i\u1ec1u ki\u1ec7n: t\u00ean nh\u00e2n vi\u00ean v\u00e0 th\u1eddi gian (l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi S\u1ea3n ph\u1ea9m (c\u1ed9t B)) =&gt; Do\u00a0\u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_cong_thuc_tinh\"><\/span>X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u00e1c\u00a0\u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m SUMIFS nh\u01b0 sau (\u00e1p d\u1ee5ng t\u1ea1i\u00a0\u00f4 G4, gi\u1ea3 s\u1eed b\u1ea3ng d\u1eef li\u1ec7u t\u1edbi\u00a0 d\u00f2ng 31):<\/p>\n<ul>\n<li><strong>sum_range<\/strong>: v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng, l\u00e0 c\u1ed9t S\u1ed1 ti\u1ec1n (c\u1ed9t D), t\u1eeb d\u00f2ng 4 t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u\u00a0 =<strong>\u00a0D4:D31<\/strong><\/li>\n<li><strong>criteria_range1<\/strong>: v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1, l\u00e0 c\u1ed9t Nh\u00e2n vi\u00ean (c\u1ed9t C), t\u1eeb\u00a0d\u00f2ng 4 t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. L\u01b0u\u00a0\u00fd\u00a0\u0111\u1ed9ng r\u1ed9ng c\u1ee7a c\u00e1c Range l\u00e0 b\u1eb1ng nhau (c\u00f3 c\u00f9ng s\u1ed1 d\u00f2ng) =\u00a0<strong>C4:C31<\/strong><\/li>\n<li><strong>criteria1<\/strong>:\u00a0\u0111i\u1ec1u\u00a0ki\u1ec7n th\u1ee9\u00a0 1 n\u1eb1m trong v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1, c\u1ee5 th\u1ec3\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 nh\u00e2n vi\u00ean\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o (t\u1ea1i\u00a0\u00f4 H2)\u00a0 =\u00a0<strong>H2<\/strong><\/li>\n<\/ul>\n<p><strong>X\u00e9t\u00a0\u0111i\u1ec1u\u00a0 ki\u1ec7n th\u1ee9 2 l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1eddi gian<\/strong><\/p>\n<p>V\u00ec kh\u00f4ng c\u00f3 c\u1ed9t Th\u00e1ng v\u00e0 c\u1ed9t N\u0103m trong b\u1ea3ng d\u1eef li\u1ec7u, do\u00a0\u0111\u00f3 ph\u1ea3i d\u1ef1a v\u00e0o nguy\u00ean t\u1eafc: tr\u00f2n th\u00e1ng s\u1ebd t\u00ednh t\u1eeb ng\u00e0y b\u1eaft \u0111\u1ea7u c\u1ee7a th\u00e1ng t\u1edbi ng\u00e0y cu\u1ed1i c\u1ee7a th\u00e1ng\u00a0\u0111\u00f3.<\/p>\n<p>=&gt; Th\u00e1ng 1 n\u0103m 2012 s\u1ebd t\u00ednh t\u1eeb 01\/01\/2012\u00a0\u0111\u1ebfn 31\/01\/2012 =&gt;\u00a0\u1ede\u00a0\u0111\u00e2y t\u00e1ch\u00a0\u0111i\u1ec1u ki\u1ec7n ng\u00e0y ra th\u00e0nh 2\u00a0\u0111i\u1ec1u ki\u1ec7n<\/p>\n<ul>\n<li><strong>criteria_range2<\/strong>: v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2, l\u00e0 c\u1ed9t Ng\u00e0y (c\u1ed9t A),\u00a0t\u1eeb d\u00f2ng 4 t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u\u00a0 =\u00a0<strong>A4:A31<\/strong><\/li>\n<li><strong>criteria2<\/strong>:\u00a0\u0111i\u1ec1u ki\u1ec1n th\u1ee9 2, t\u00ednh b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb ng\u00e0y 01\/01\/2012. Do\u00a0\u0111\u00f3 ph\u1ea3i th\u00eam to\u00e1n t\u1eed \u201c&gt;=\u201d \u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh \u201ct\u1eeb ng\u00e0y\u201d, k\u1ebft h\u1ee3p v\u1edbi h\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y d\u1ef1a theo 2 y\u1ebfu t\u1ed1\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh l\u00e0 n\u0103m (\u00f4 G3) v\u00e0 th\u00e1ng (\u00f4 F4) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DATE =\u00a0<strong>\u201c&gt;=\u201d&amp;DATE(G3,F4,1)<\/strong><\/li>\n<li><strong>criteria_range3<\/strong>: v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 3, l\u00e0 c\u1ed9t Ng\u00e0y\u00a0(c\u1ed9t A),\u00a0t\u1eeb d\u00f2ng 4 t\u1edbi d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u, gi\u1ed1ng criteria_range2\u00a0\u00a0=\u00a0<strong>A4:A31<\/strong><\/li>\n<li><strong>criteria3<\/strong>:\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 3, t\u00ednh\u00a0\u0111\u1ebfn ng\u00e0y cu\u1ed1i th\u00e1ng 1 n\u0103m 2012. Do\u00a0\u0111\u00f3 ph\u1ea3i th\u00eam to\u00e1n t\u1eed \u201c&lt;=\u201d\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh \u201c\u0111\u1ebfn ng\u00e0y\u201d, k\u1ebft h\u1ee3p v\u1edbi h\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y cu\u1ed1i th\u00e1ng l\u00e0 h\u00e0m EOMONTH, x\u00e9t cho th\u00e1ng 1 n\u0103m 2012 (x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m Date trong criteria2) =\u00a0<strong>\u201c&lt;=\u201d&amp;EOMONTH(DATE(G3,F4,1),0)<\/strong><\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng nh\u01b0 sau<\/p>\n<p>G4 =SUMIFS(D4:D31,C4:C31,H2,A4:A31,\u201d&gt;=\u201d&amp;DATE(G3,F4,1),A4:A31,\u201d&lt;=\u201d&amp;EOMONTH(DATE(G3,F4,1),0))<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3\u00a0\u00a0\u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ea1i G4 t\u01b0\u01a1ng t\u1ef1 cho\u00a0 c\u00e1c th\u00e1ng kh\u00e1c, n\u0103m kh\u00e1c th\u00ec l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1ea5t c\u1ea3 c\u00e1c Range (g\u1ed3m Sum_range, Criteria_range)\u00a0\u0111\u1ec1u ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh khi sao ch\u00e9p c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 kh\u00f4ng l\u00e0m thay\u00a0\u0111\u1ed5i t\u1ecda\u00a0\u0111\u1ed9 tham chi\u1ebfu t\u1edbi c\u00e1c v\u00f9ng d\u1eef li\u1ec7u n\u00e0y:\u00a0$D$4:$D$31 ,\u00a0$C$4:$C$31,\u00a0$A$4:$A$31<\/li>\n<li>Tham chi\u1ebfu t\u1edbi t\u00ean Nh\u00e2n vi\u00ean (H2) ph\u1ea3i c\u1ed1\u00a0\u0111\u1ecbnh =&gt; H2\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh l\u00e0 $H$2<\/li>\n<li>Tham chi\u1ebfu t\u1edbi c\u00e1c gi\u00e1 tr\u1ecb n\u0103m (d\u00f2ng 3) s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh =&gt; G3\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh d\u00f2ng l\u00e0 G$3\u00a0\u0111\u1ec3 khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang ph\u1ea3i th\u00ec tham chi\u1ebfu t\u1edbi c\u00e1c c\u1ed9t N\u0103m t\u01b0\u01a1ng\u00a0\u1ee9ng s\u1ebd thay\u00a0\u0111\u1ed5i theo, sao ch\u00e9p xu\u1ed1ng c\u00e1c th\u00e1ng b\u00ean d\u01b0\u1edbi th\u00ec kh\u00f4ng thay\u00a0\u0111\u1ed5i trong n\u0103m\u00a0\u0111\u00f3.<\/li>\n<li>Tham chi\u1ebfu t\u1edbi c\u00e1c gi\u00e1 tr\u1ecb th\u00e1ng (c\u1ed9t F) s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh =&gt; F4\u00a0\u0111\u01b0\u1ee3c c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t l\u00e0 $F4\u00a0\u0111\u1ec3 khi sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c th\u00e1ng b\u00ean d\u01b0\u1edbi th\u00ec thay\u00a0\u0111\u1ed5i theo d\u00f2ng t\u01b0\u01a1ng\u00a0\u1ee9ng c\u00e1c th\u00e1ng\u00a0\u0111\u00f3, khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang ph\u1ea3i th\u00ec gi\u1eef nguy\u00ean c\u1ed9t Th\u00e1ng trong c\u00e1c n\u0103m t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh l\u00e0:<\/p>\n<p>G4=SUMIFS($D$4:$D$31,$C$4:$C$31,$H$2,$A$4:$A$31,\u201d&gt;=\u201d&amp;DATE(G$3,$F4,1),$A$4:$A$31,\u201d&lt;=\u201d&amp;EOMONTH(DATE(G$3,$F4,1),0))<\/p>\n<p>=&gt; Sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb G4 sang ph\u1ea3i cho c\u00e1c\u00a0\u00f4 H4, I4 (fillright)<\/p>\n<p>=&gt; Sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb G4 xu\u1ed1ng d\u01b0\u1edbi cho c\u00e1c th\u00e1ng t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1edbi G15, H15, I15 (filldown)<\/p>\n<p>=&gt; Ho\u00e0n th\u00e0nh b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo nh\u00e2n vi\u00ean.<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi b\u1ea3ng b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo s\u1ea3n ph\u1ea9m.<\/p>\n<p>T\u1ea3i v\u1ec1 t\u00e0i li\u1ec7u tham kh\u1ea3o:\u00a0<a href=\"https:\/\/drive.google.com\/open?id=1i6qJezLzp05kw_PyhriHDPuWc1FqZPu2\">https:\/\/drive.google.com\/open?id=1i6qJezLzp05kw_PyhriHDPuWc1FqZPu2<\/a><\/p>\n<p>Video h\u01b0\u1edbng d\u1eabn:<\/p>\n<iframe loading=\"lazy\" title=\"L\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo th\u00e1ng v\u1edbi h\u00e0m SUMIFS\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KlznZC6k1EQ?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <strong>H\u1ecdc\u00a0Excel Online<\/strong>!<\/p>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-excel-su-dung-trong-ke-toan-luong-nhan-su-ham-sumif.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ph\u00ed l\u01b0\u01a1ng theo b\u1ed9 ph\u1eadn v\u00e0 theo th\u00e1ng v\u1edbi h\u00e0m SUMIFS tr\u00ean Excel\u00a0<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-chi-phi-luong-theo-bo-phan-va-theo-thang-voi-ham-sumifs-tren-excel.html\">H\u00e0m, c\u00f4ng th\u1ee9c Excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: H\u00e0m SUMIF<\/a><\/strong><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-7.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10666,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10665","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\/10665","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=10665"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10665\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10666"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}