{"id":6617,"date":"2024-12-21T15:44:32","date_gmt":"2024-12-21T15:44:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dem-gia-tri-khac-biet-voi-ham-countif\/"},"modified":"2024-12-21T15:44:32","modified_gmt":"2024-12-21T15:44:32","slug":"dem-gia-tri-khac-biet-voi-ham-countif","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dem-gia-tri-khac-biet-voi-ham-countif\/","title":{"rendered":"\u0110\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u1edbi h\u00e0m COUNTIF"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/bi-kip-vo-lam-sumproduct-than-chuong.html\">h\u00e0m SUMPRODUCT<\/a><\/strong>, ta \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ea5y v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SUMPRODUCT k\u1ebft h\u1ee3p COUNTIF \u0111\u1ec3 \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t. D\u01b0\u1edbi \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch c\u00f9ng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 \u0111\u1ec3 hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\"><strong>COUNTIF<\/strong><\/a> trong tr\u01b0\u1eddng h\u1ee3p \u0111\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t nh\u01b0 v\u1eady.<\/em><\/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-6766e25f345e0\" 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\/dem-gia-tri-khac-biet-countif.html#Dem_gia_tri_khac_biet_voi_ham_COUNTIF\" title=\"\u0110\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u1edbi h\u00e0m COUNTIF\">\u0110\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u1edbi h\u00e0m COUNTIF<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dem-gia-tri-khac-biet-countif.html#Bai_toan_%E2%80%9Ccac_loai_bi%E2%80%9D\" title=\"B\u00e0i to\u00e1n \u201cc\u00e1c lo\u1ea1i bi\u201d\">B\u00e0i to\u00e1n \u201cc\u00e1c lo\u1ea1i bi\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dem-gia-tri-khac-biet-countif.html#Mo_rong_bai_toan_voi_COUNTIFS\" title=\"M\u1edf r\u1ed9ng b\u00e0i to\u00e1n v\u1edbi COUNTIFS\">M\u1edf r\u1ed9ng b\u00e0i to\u00e1n v\u1edbi COUNTIFS<\/a><\/li>\n<\/ul>\n<\/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\/dem-gia-tri-khac-biet-countif.html#Tham_khao_them\" title=\"Tham kh\u1ea3o th\u00eam\">Tham kh\u1ea3o th\u00eam<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/dem-gia-tri-khac-biet-countif.html#Mot_so_bai_viet_ve_COUNTIFCOUNTIFS\" title=\"M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft v\u1ec1 COUNTIF\/COUNTIFS:\">M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft v\u1ec1 COUNTIF\/COUNTIFS:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/dem-gia-tri-khac-biet-countif.html#Mot_so_cach_dem_gia_tri_khac_biet_khac\" title=\"M\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00e1c:\">M\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00e1c:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dem_gia_tri_khac_biet_voi_ham_COUNTIF\"><\/span>\u0110\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u1edbi h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Bai_toan_%E2%80%9Ccac_loai_bi%E2%80%9D\"><\/span>B\u00e0i to\u00e1n \u201cc\u00e1c lo\u1ea1i bi\u201d<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><em>\u201cTrong m\u1ed9t h\u1ed9p nh\u1ef1a c\u00f3 5 vi\u00ean bi v\u00e0ng, 3 vi\u00ean bi xanh, 4 vi\u00ean bi \u0111\u1ecf. H\u1ecfi c\u00f3 bao nhi\u00eau lo\u1ea1i bi?\u201d<\/em><\/p>\n<figure id=\"attachment_32070\" aria-describedby=\"caption-attachment-32070\" style=\"width: 289px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32070 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-countif-dem-duy-nhat-1.png\" alt=\"b\u00e0i to\u00e1n c\u00e1c lo\u1ea1i bi\" width=\"289\" height=\"422\" title=\"ham-countif-dem-duy-nhat-1\"><figcaption id=\"caption-attachment-32070\" class=\"wp-caption-text\">b\u00e0i to\u00e1n c\u00e1c lo\u1ea1i bi<\/figcaption><\/figure>\n<p>C\u00e2u tr\u1ea3 l\u1eddi \u1edf \u0111\u00e2y l\u00e0: 3 lo\u1ea1i bi\u00a0<strong>V\u00e0ng \u2013 \u0110\u1ecf \u2013 Xanh<\/strong>.<\/p>\n<p>Trong Excel, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 l\u1ecdc k\u1ebft h\u1ee3p x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng, \u0111\u1ebfm kh\u00f4ng tr\u00f9ng\u2026 \u0111\u1ec3 \u0111\u01b0a ra \u0111\u00e1p \u00e1n. B\u1edfi \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m COUNTIF, n\u00ean ta s\u1ebd ch\u1ec9 s\u1eed d\u1ee5ng COUNTIF\/COUNTIFS cho b\u00e0i to\u00e1n n\u00e0y m\u00e0 th\u00f4i.<\/p>\n<p>Nh\u01b0ng logic n\u00e0o \u0111\u1ec3 \u0111\u01b0a ra con s\u1ed1 3 trong Sheet v\u1edbi c\u00f4ng th\u1ee9c <strong>1\/COUNTIF?<\/strong><\/p>\n<p>C\u00f3 th\u1ec3 gi\u1ea3i th\u00edch nh\u01b0 sau:<\/p>\n<p><em>C\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u1ea5y r\u1eb1ng, c\u00f4ng th\u1ee9c\u00a0<strong>=COUNTIF(A2:A13,A2:A13) <\/strong><\/em><em>s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t m\u1ea3ng t\u01b0\u01a1ng \u1ee9ng nh\u01b0 sau: {4;3;4;5;3;3;5;4;4;5;5;5}. \u0110\u00f3 l\u00e0 s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a c\u00e1c lo\u1ea1i bi: bi v\u00e0ng 5 l\u1ea7n, bi xanh 3 l\u1ea7n, bi \u0111\u1ecf 4 l\u1ea7n.\u00a0<\/em><\/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-591.gif\" title=\"ex101_92019-nho-591\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_32072\" aria-describedby=\"caption-attachment-32072\" style=\"width: 347px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32072 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-countif-dem-duy-nhat-2.png\" alt=\"nh\u1eadp h\u00e0m countif x\u1eed l\u00fd b\u00e0i to\u00e1n\" width=\"347\" height=\"283\" title=\"ham-countif-dem-duy-nhat-2\"><figcaption id=\"caption-attachment-32072\" class=\"wp-caption-text\">nh\u1eadp h\u00e0m countif x\u1eed l\u00fd b\u00e0i to\u00e1n<\/figcaption><\/figure>\n<p><em>V\u1eady ta suy lu\u1eadn nh\u01b0 sau: N\u1ebfu bi v\u00e0ng xu\u1ea5t hi\u1ec7n 5 l\u1ea7n th\u00ec m\u1ed7i \u00f4 trong sheet s\u1ebd l\u00e0 1\/5 l\u1ea7n, v\u1edbi bi \u0111\u1ecf l\u00e0 1\/4 l\u1ea7n, bi xanh l\u00e0 1\/3 l\u1ea7n. C\u1ed9ng l\u1ea1i ta s\u1ebd c\u00f3 3 lo\u1ea1i bi ri\u00eang bi\u1ec7t.<\/em><\/p>\n<p>B\u1edfi v\u1eady, ta s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p chia:<\/p>\n<p><em><strong>=1\/COUNTIF(A2:A13,A2:A13&amp;\u201d\u201d)<\/strong><\/em><\/p>\n<p>C\u1ee5m <strong>&amp;\u201d\u201d <\/strong>\u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb r\u1ed7ng, k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 g\u1eb7p l\u1ed7i chia cho 0 (#DIV\/0).<\/p>\n<p>L\u00fac \u0111\u00f3, m\u1ea3ng nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0: <em>{1\/4;1\/3;1\/4;1\/5;1\/3;1\/3;1\/5;1\/4;1\/4;1\/5;1\/5;1\/5}<\/em><\/p>\n<figure id=\"attachment_32073\" aria-describedby=\"caption-attachment-32073\" style=\"width: 550px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32073 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-countif-dem-duy-nhat-3.png\" alt=\"t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb\" width=\"550\" height=\"344\" title=\"ham-countif-dem-duy-nhat-3\"><figcaption id=\"caption-attachment-32073\" class=\"wp-caption-text\">t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb<\/figcaption><\/figure>\n<p>V\u00e0 b\u01b0\u1edbc cu\u1ed1i c\u00f9ng, ta c\u1ea7n m\u1ed9t h\u00e0m c\u00f3 ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng c\u00e1c ph\u1ea7n t\u1eed trong m\u1ea3ng. L\u1ef1a ch\u1ecdn \u1edf \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 SUM v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, ho\u1eb7c SUMPRODUCT:<\/p>\n<figure id=\"attachment_32074\" aria-describedby=\"caption-attachment-32074\" style=\"width: 824px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32074 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-countif-dem-duy-nhat-4.png\" alt=\"Ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUMPRODUCT\" width=\"824\" height=\"330\" title=\"ham-countif-dem-duy-nhat-4\"><figcaption id=\"caption-attachment-32074\" class=\"wp-caption-text\">Ch\u1ee9c n\u0103ng t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUMPRODUCT<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Mo_rong_bai_toan_voi_COUNTIFS\"><\/span>M\u1edf r\u1ed9ng b\u00e0i to\u00e1n v\u1edbi COUNTIFS<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u01b0\u01a1ng t\u1ef1 COUNTIF, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng COUNTIFS \u0111\u1ec3 \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n h\u01a1n. V\u1edbi b\u00e0i to\u00e1n bi tr\u00ean, ta m\u1edf r\u1ed9ng ra nh\u01b0 sau:<\/p>\n<p><em>\u201cTrong m\u1ed9t h\u1ed9p nh\u1ef1a c\u00f3 5 vi\u00ean bi v\u00e0ng bao g\u1ed3m: 2 vi\u00ean v\u00e0ng nh\u1ea1t, 3 vi\u00ean v\u00e0ng \u0111\u1eadm, 3 vi\u00ean bi xanh \u0111\u1eadm, 4 vi\u00ean bi \u0111\u1ecf bao g\u1ed3m: 1 vi\u00ean \u0111\u1ecf nh\u1ea1t, 3 vi\u00ean \u0111\u1ecf \u0111\u1eadm. H\u1ecfi c\u00f3 bao nhi\u00eau lo\u1ea1i bi?<\/em><\/p>\n<p>C\u00e2u tr\u1ea3 l\u1eddi \u1edf \u0111\u00e2y l\u00e0 5: <em>v\u00e0ng nh\u1ea1t + v\u00e0ng \u0111\u1eadm + xanh \u0111\u1eadm + \u0111\u1ecf nh\u1ea1t + \u0111\u1ecf \u0111\u1eadm<\/em>. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 n\u00e0y trong sheet, ta h\u00e3y \u00e1p d\u1ee5ng COUNTIFS v\u00e0o thay cho COUNTIF nh\u00e9.<\/p>\n<figure id=\"attachment_32076\" aria-describedby=\"caption-attachment-32076\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32076 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-countif-dem-duy-nhat-5-1024x228-1.png\" alt=\"c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m countifs \u0111\u1ec3 thay th\u1ebf\" width=\"1024\" height=\"228\" title=\"ham-countif-dem-duy-nhat-5-1024x228-1\"><figcaption id=\"caption-attachment-32076\" class=\"wp-caption-text\">c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m countifs \u0111\u1ec3 thay th\u1ebf<\/figcaption><\/figure>\n<blockquote>\n<p>=SUMPRODUCT(1\/COUNTIFS(A2:A13,A2:A13&amp;\u201d\u201d,B2:B13,B2:B13&amp;\u201d\u201d))<\/p>\n<\/blockquote>\n<p><em><strong>Ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi 3, 4, 5,\u2026 n \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng COUNTIFS.\u00a0<\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_khao_them\"><\/span>Tham kh\u1ea3o th\u00eam<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Mot_so_bai_viet_ve_COUNTIFCOUNTIFS\"><\/span>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft v\u1ec1 COUNTIF\/COUNTIFS:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ol>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-countifs-co-ban-qua-3-vi-du.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng COUNTIFS c\u01a1 b\u1ea3n<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-countif-countifs-trong-excel.html\">S\u1eeda l\u1ed7i #VALUE! khi d\u00f9ng COUNTIF\/COUNTIFS<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-countif-nang-cao-excel.html\">9 b\u00ed k\u00edp s\u1eed d\u1ee5ng COUNTIF hi\u1ec7u qu\u1ea3<\/a><\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Mot_so_cach_dem_gia_tri_khac_biet_khac\"><\/span>M\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00e1c:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ol>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/loc-du-lieu-theo-dieu-kien-duy-nhat-ket-hop-ham-unique-filter.html\">K\u1ebft h\u1ee3p h\u00e0m l\u1ecdc duy nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-bo-gia-tri-trung-trong-vba.html\">L\u1ecdc b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng\u00a0 v\u1edbi VBA<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t<\/a><\/li>\n<\/ol>\n<p><em>C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft \u0111\u1ebfn \u0111\u00e2y. <strong>H\u1ecdc Excel Online<\/strong> lu\u00f4n mong mu\u1ed1n c\u00e1c b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch c\u00f9ng v\u01a1i ch\u00fang t\u00f4i. Tr\u00e2n tr\u1ecdng!<\/em><\/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-591.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6618,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6617","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\/6617","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=6617"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6617\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6618"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}