{"id":2756,"date":"2024-12-02T08:38:14","date_gmt":"2024-12-02T08:38:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-sumifs-tinh-tong-theo-dieu-kien\/"},"modified":"2024-12-02T08:38:14","modified_gmt":"2024-12-02T08:38:14","slug":"ham-sumif-sumifs-tinh-tong-theo-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-sumif-sumifs-tinh-tong-theo-dieu-kien\/","title":{"rendered":"H\u00e0m SUMIF \/ SUMIFS T\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u1eafc h\u1eafn c\u00e1c b\u1ea1n \u0111\u00e3 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p c\u1ea7n ph\u1ea3i t\u00ednh t\u1ed5ng theo 1 hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n v\u00e0 SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/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-674d71f5b3239\" 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\/ham-sumif-tinh-tong-excel.html#Ham_SUMIF_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:\">H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/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\/ham-sumif-tinh-tong-excel.html#Ham_SUMIFS_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:\">H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/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\/ham-sumif-tinh-tong-excel.html#Download_tai_lieu_lien_quan\" title=\"Download t\u00e0i li\u1ec7u li\u00ean quan:\">Download t\u00e0i li\u1ec7u li\u00ean quan:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIF_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m SUMIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-sumif-trong-excel-vi-du-cong-thuc.html\"><strong>h\u00e0m SUMIF<\/strong><\/a>, c\u00e1c b\u1ea1n s\u1ebd t\u00ednh \u0111\u01b0\u1ee3c t\u1ed5ng d\u1ef1a tr\u00ean 1 \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t.<\/p>\n<p>C\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=SUMIF(&lt;v\u00f9ng d\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n&gt;, &lt;\u0111i\u1ec1u ki\u1ec7n&gt;, &lt;v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng&gt;)<\/p>\n<\/blockquote>\n<p><strong>Ch\u00fang ta c\u00f3 th\u1ec3 ngh\u0129 ra nh\u1eefng tr\u01b0\u1eddng h\u1ee3p s\u1ebd s\u1eed d\u1ee5ng \u0111\u1ebfn c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/strong><\/p>\n<ul style=\"list-style-type: disc\">\n<li>T\u00ednh t\u1ed5ng doanh thu trong th\u00e1ng 1 cho 1 c\u00f4ng ty<\/li>\n<li>T\u00ednh t\u1ed5ng doanh thu c\u1ee7a m\u1ed9t nh\u00e2n vi\u00ean A<\/li>\n<li>T\u00ednh t\u1ed5ng doanh thu c\u1ee7a n\u0103m 2016 tr\u1edf v\u1ec1 tr\u01b0\u1edbc<\/li>\n<li>T\u00ednh t\u1ed5ng [\u0111\u1ea1i l\u01b0\u1ee3ng c\u1ea7n t\u00ednh t\u1ed5ng] n\u1ebfu [\u0111i\u1ec1u ki\u1ec7n]<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-sumif.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-554 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-sumif.png\" alt=\"cong thuc sumif\" width=\"445\" height=\"199\" title=\"cong-thuc-sumif\"><\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh thu c\u1ee7a n\u0103m 2016 th\u00ec ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIF nh\u01b0 sau<\/p>\n<blockquote>\n<p>=SUMIF(A2:A6,2016,B2:B6)<\/p>\n<\/blockquote>\n<p>\u1ede \u0111\u00e2y, \u0111\u1ec3 thu\u1eadn ti\u1ec7n nh\u1ea5t cho vi\u1ec7c s\u1eed d\u1ee5ng <strong>SUMIF<\/strong> c\u0169ng nh\u01b0 chu\u1ea9n b\u1ecb cho nh\u1eefng v\u00ed d\u1ee5 ph\u1ee9c t\u1ea1p h\u01a1n, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft s\u1ed1 2016 v\u00e0o 1 \u00f4 tr\u00ean Excel, v\u00ed d\u1ee5 \u00f4 C1 ch\u1eb3ng h\u1ea1n. Nh\u01b0 v\u1eady khi ch\u00fang ta thay \u0111\u1ed5i \u00f4 \u0111i\u1ec1u ki\u1ec7n C1 th\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m <strong>SUMIF<\/strong> c\u0169ng s\u1ebd thay \u0111\u1ed5i theo m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00fang ta kh\u00f4ng c\u1ea7n s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c.<\/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-212.gif\" title=\"ex101_92019-nho-212\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>=SUMIF(A2:A6,C1,B2:B6)<\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUMIFS_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span>H\u00e0m SUMIFS \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m <strong>SUMIFS<\/strong> s\u1ebd gi\u00fap c\u00e1c b\u1ea1n t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. T\u1ea5t nhi\u00ean c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m n\u00e0y \u0111\u1ec3 t\u00ednh to\u00e1n n\u1ebfu c\u00e1c b\u1ea1n ch\u1ec9 c\u00f3 1 \u0111i\u1ec1u ki\u1ec7n, nh\u01b0 v\u1eady b\u1ea1n s\u1ebd ph\u1ea3i vi\u1ebft nhi\u1ec1u h\u01a1n 1 ch\u1eef s. C\u00fa ph\u00e1p nh\u01b0 sau<\/p>\n<blockquote>\n<p>=SUMIFS(&lt;v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng&gt;, &lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1&gt;, &lt; \u0111i\u1ec1u ki\u1ec7n 1&gt;, &lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2&gt;, &lt; \u0111i\u1ec1u ki\u1ec7n 2&gt;, \u2026)<\/p>\n<\/blockquote>\n<p>\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng nhau nh\u00ecn v\u00e0o v\u00ed d\u1ee5 minh ho\u1ea1 sau \u0111\u00e2y.<\/p>\n<figure id=\"attachment_555\" aria-describedby=\"caption-attachment-555\" style=\"width: 632px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-sumifs.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-555\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-sumifs.png\" alt=\"C\u00fa ph\u00e1p h\u00e0m SUMIFS\" width=\"632\" height=\"243\" title=\"cong-thuc-sumifs\"><\/a><figcaption id=\"caption-attachment-555\" class=\"wp-caption-text\">C\u00fa ph\u00e1p h\u00e0m SUMIFS<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n c\u1ea7n t\u00ednh xem nh\u00e2n vi\u00ean A trong n\u0103m 2015 c\u00f3 doanh s\u1ed1 b\u00e1n h\u00e0ng l\u00e0 bao nhi\u00eau<\/p>\n<ul style=\"list-style-type: disc\">\n<li><strong>&lt;v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng&gt;<\/strong> ch\u00ednh l\u00e0 c\u1ed9t B, c\u1ee5 th\u1ec3 h\u01a1n l\u00e0 v\u00f9ng <strong>B2:B6<\/strong><\/li>\n<li><strong>&lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1&gt;<\/strong> l\u00e0 n\u0103m, \u0111\u01b0\u1ee3c l\u01b0u t\u1ea1i <strong>A2:A6<\/strong><\/li>\n<li><strong>&lt;\u0111i\u1ec1u ki\u1eb9n 1&gt;<\/strong> ch\u00ednh l\u00e0 2015, ch\u00fang ta s\u1ebd l\u01b0u \u1edf \u00f4 <strong>E1<\/strong><\/li>\n<li><strong>&lt;v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 2&gt;<\/strong> l\u00e0 nh\u00e2n vi\u00ean, \u0111\u01b0\u1ee3c l\u01b0u t\u1ea1i <strong>C2:C6<\/strong><\/li>\n<li><strong>&lt;\u0111i\u1ec1u ki\u1eb9n 2&gt;<\/strong> l\u00e0 nh\u00e2n vi\u00ean A, \u0111\u01b0\u1ee3c l\u01b0u t\u1ea1i \u00f4 <strong>F1<\/strong><\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n n\u00e0y l\u00e0<\/p>\n<blockquote>\n<pre><code>=SUMIFS(B2:B6,A2:A6,E1,C2:C6,F1)<\/code><\/pre>\n<\/blockquote>\n<p>Vi\u1ec7c l\u01b0u \u0111i\u1ec1u ki\u1ec7n ra ngo\u00e0i, kh\u00f4ng vi\u1ebft v\u00e0o tr\u1ef1c ti\u1ebfp v\u00e0o trong c\u00f4ng th\u1ee9c s\u1ebd gi\u00fap ch\u00fang ta c\u00f3 1 c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, khi thay \u0111\u1ed5i \u0111i\u1ec1u ki\u1ec7n c\u0169ng d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 tr\u00e1nh \u0111\u01b0\u1ee3c l\u1ed7i khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p.<\/p>\n<p>N\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a c\u00e1c b\u1ea1n b\u00ean d\u01b0\u1edbi kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u n\u00e0o n\u1eefa, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c SUMIFS nh\u01b0 sau, s\u1ebd g\u1ecdn h\u01a1n r\u1ea5t nhi\u00e8u:<\/p>\n<blockquote>\n<p><code>=SUMIF(B:B,A:A,E1,C:C,F1)<\/code><\/p>\n<\/blockquote>\n<p>\u0110\u1ebfn \u0111\u00e2y, c\u00f3 th\u1ec3 c\u00e1c b\u1ea1n \u0111\u00e3 n\u0103m \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng 2 h\u00e0m SUMIF v\u00e0 SUMIFS m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n r\u1ed3i. Nh\u1eefng v\u00ed d\u1ee5 minh ho\u1ea1 v\u00e0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p n\u00e2ng cao c\u1ee7a 2 h\u00e0m n\u00e0y, v\u00ed d\u1ee5 nh\u01b0<br \/>\nT\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1eb9n s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 so s\u00e1nh l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng: <strong>&gt;<\/strong>, <strong>&lt;<\/strong>, <strong>&gt;=<\/strong>, <strong>&lt;=<\/strong>, <strong>&lt;&gt;<\/strong><br \/>\nT\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n, s\u1eed d\u1ee5ng c\u00e1c k\u00ed t\u1ef1 d\u1ea5u h\u1ecfi ch\u1ea5m, d\u1ea5u sao: <strong>?<\/strong>, <strong>*<\/strong><\/p>\n<p><strong>Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-sumifs-va-sumif-voi-nhieu-dieu-kien-mot-vi-du-cong-thuc.html\">l\u1ec7nh sumifs<\/a> cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/strong><\/p>\n<p>m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i 2 videos sau \u0111\u00e2y\u00a0v\u00e0 \u0111\u1eebng qu\u00ean download t\u00e0i li\u1ec7u k\u00e8m theo b\u00ean d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Z73YOrndkEQ\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Video n\u00e2ng cao v\u1ec1 2 h\u00e0m SUMIF v\u00e0 SUMIFS s\u1ebd gi\u00fap c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 d\u1ea5u sao v\u00e0 h\u1ecfi ch\u1ea5m \u0111\u1ec3 t\u00ednh t\u1ed5ng n\u00e2ng cao:<\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1E52jQ-KH0A?autoplay=1&amp;loop=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<h3 id=\"download-ti-liu-lin-quan\"><span class=\"ez-toc-section\" id=\"Download_tai_lieu_lien_quan\"><\/span>Download t\u00e0i li\u1ec7u li\u00ean quan:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><a href=\"https:\/\/drive.google.com\/open?id=0Bw_8Ozc4aKi9VnJndTJJcjc5emM\">Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video #1<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/drive.google.com\/open?id=0Bw_8Ozc4aKi9WHBTRGRFWXhsUG8\" target=\"_blank\" rel=\"noopener noreferrer\">Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video #2<\/a><\/strong><\/p>\n<p>\u2014\u2014\u2014<\/p>\n<p>Ngo\u00e0i h\u00e0m SumIf, SumIfS\u00a0gi\u00fap t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 SUMPRODUCT \u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y. Trong th\u1ef1c t\u1ebf th\u00ec y\u00eau c\u1ea7u t\u00ednh to\u00e1n v\u00e0 \u0111\u1eb7c \u0111i\u1ec3m d\u1eef li\u1ec7u s\u1ebd quy\u1ebft \u0111\u1ecbnh t\u1edbi vi\u1ec7c ch\u00fang ta s\u1ebd c\u1ea7n d\u00f9ng h\u00e0m n\u00e0o, d\u00f9ng nh\u01b0 th\u1ebf n\u00e0o. Do \u0111\u00f3 b\u1ea1n c\u1ea7n b\u1ed5 sung th\u00eam cho m\u00ecnh c\u00e0ng nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 h\u00e0m, v\u1ec1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u th\u00ec c\u00e0ng thu\u1eadn l\u1ee3i khi l\u00e0m vi\u1ec7c.<\/p>\n<p>Ti\u1ebfp \u0111\u00f3 l\u00e0 vi\u1ec7c c\u1ea7n ph\u1ea3i k\u1ebft h\u1ee3p c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel \u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c nh\u01b0: \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n, tr\u00edch l\u1ecdc, s\u1eafp x\u1ebfp, b\u00e1o c\u00e1o b\u1eb1ng Pivot Table, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">kh\u00f3a h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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-212.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2756","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\/2756","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=2756"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2756\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2757"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}