{"id":3267,"date":"2024-12-03T01:36:47","date_gmt":"2024-12-03T01:36:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat\/"},"modified":"2024-12-03T01:36:47","modified_gmt":"2024-12-03T01:36:47","slug":"huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean Excel hay nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"m\u1eabu-b\u1ea3ng-ch\u1ea5m-c\u00f4ng-theo-ca\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html?mau-bang-cham-cong-theo-ca\">\n<p>Trong nhi\u1ec1u c\u00f4ng ty l\u1edbn hi\u1ec7n nay th\u01b0\u1eddng y\u00eau c\u1ea7u b\u1ed9 ph\u1eadn k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1 ph\u1ea3i th\u1ef1c hi\u1ec7n ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd\u00a0tr\u00ean c\u00f9ng 1 b\u1ea3ng t\u00ednh\u00a0Excel. V\u1eady ch\u00fang ta c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c b\u1ea3ng t\u00ednh\u00a0Excel nh\u01b0 th\u1ebf n\u00e0o\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u n\u00e0y? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1eadp b\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean Excel\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c\u00a0\u00e1p d\u1ee5ng nhi\u1ec1u nh\u1ea5t nh\u00e9.<\/p>\n<\/blockquote>\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-674e60af0c60a\" 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-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html#Yeu_cau_cua_viec_cham_cong_theo_ca_va_lam_them_gio\" title=\"Y\u00eau c\u1ea7u c\u1ee7a vi\u1ec7c ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd\">Y\u00eau c\u1ea7u c\u1ee7a vi\u1ec7c ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd<\/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-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html#Bang_cham_cong_theo_ca_va_lam_them_gio_tren_Excel\" title=\"B\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean\u00a0Excel\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean\u00a0Excel<\/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-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html#Xay_dung_bo_cuc_bang_cham_cong\" title=\"X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u1ea3ng ch\u1ea5m c\u00f4ng\">X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u1ea3ng ch\u1ea5m c\u00f4ng<\/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-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html#Cach_cham_cong_vao_bang\" title=\"C\u00e1ch ch\u1ea5m c\u00f4ng v\u00e0o b\u1ea3ng\">C\u00e1ch ch\u1ea5m c\u00f4ng v\u00e0o b\u1ea3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-lap-bang-cham-cong-theo-ca-va-lam-them-gio-tren-excel-hay-nhat.html#Cach_tinh_cong_cuoi_thang\" title=\"C\u00e1ch t\u00ednh c\u00f4ng cu\u1ed1i th\u00e1ng\">C\u00e1ch t\u00ednh c\u00f4ng cu\u1ed1i th\u00e1ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau_cua_viec_cham_cong_theo_ca_va_lam_them_gio\"><\/span>Y\u00eau c\u1ea7u c\u1ee7a vi\u1ec7c ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc h\u1ebft ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u xem vi\u1ec7c ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd c\u1ee5 th\u1ec3 l\u00e0 l\u00e0m g\u00ec nh\u00e9.<\/p>\n<p>Nh\u1eefng doanh nghi\u1ec7p\u00a0\u00e1p d\u1ee5ng l\u00e0m vi\u1ec7c theo ca th\u01b0\u1eddng l\u00e0 doanh nghi\u1ec7p l\u00e0m trong ng\u00e0nh s\u1ea3n xu\u1ea5t, d\u1ecbch v\u1ee5.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m l\u00e0:<\/p>\n<ul>\n<li>Trong 1 ng\u00e0y c\u00f3 th\u1ec3 chia l\u00e0m 2 \u2013 3 ca l\u00e0m vi\u1ec7c. M\u1ed7i ca l\u00e0m 8 ti\u1ebfng.<\/li>\n<li>C\u00e1c nh\u00e2n vi\u00ean c\u00f3 th\u1ec3 lu\u00e2n chuy\u1ec3n c\u00e1c ca l\u00e0m tho\u1ea3i m\u00e1i\u00a0theo tu\u1ea7n, th\u00e1ng.<\/li>\n<li>Trong m\u1ed7i ca l\u1ea1i c\u00f3 th\u1ec3 l\u00e0m th\u00eam gi\u1edd ngay trong ca\u00a0\u0111\u00f3.<\/li>\n<li>M\u1ed9t ng\u00e0y ch\u1ec9 l\u00e0m ch\u00ednh th\u1ee9c 1 ca, c\u00f2n l\u1ea1i th\u1eddi gian v\u01b0\u1ee3t qu\u00e1 s\u1ebd t\u00ednh l\u00e0m th\u00eam gi\u1edd<\/li>\n<\/ul>\n<p>Do v\u1eady m\u1ed7i ng\u01b0\u1eddi trong b\u1ea3ng ch\u1ea5m c\u00f4ng s\u1ebd ph\u1ea3i ghi nh\u1eadn\u00a0\u0111\u01b0\u1ee3c:<\/p>\n<ul>\n<li>L\u00e0m vi\u1ec7c v\u00e0o ng\u00e0y n\u00e0o trong th\u00e1ng<\/li>\n<li>Trong ng\u00e0y\u00a0\u0111\u00f3 l\u00e0m ca n\u00e0o, l\u00e0m vi\u1ec7c bao nhi\u00eau gi\u1edd trong 1 ca<\/li>\n<li>Trong ca\u00a0\u0111\u00f3 l\u00e0m th\u00eam bao nhi\u00eau gi\u1edd<\/li>\n<li>T\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m vi\u1ec7c ch\u00ednh th\u1ee9c<\/li>\n<li>T\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m th\u00eam (t\u0103ng ca)<\/li>\n<li>Ngo\u00e0i y\u1ebfu t\u1ed1 gi\u1edd l\u00e0m, c\u00f2n ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c c\u00e1c y\u1ebfu t\u1ed1: ngh\u1ec9 ph\u00e9p, ngh\u1ec9 kh\u00f4ng ph\u00e9p, ngh\u1ec9 ch\u1ebf\u00a0\u0111\u1ed9\u2026<\/li>\n<\/ul>\n<p>D\u1ef1a tr\u00ean nh\u1eefng y\u00eau c\u1ea7u tr\u00ean ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch th\u1ef1c hi\u1ec7n b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean\u00a0Excel nh\u00e9.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bang_cham_cong_theo_ca_va_lam_them_gio_tren_Excel\"><\/span>B\u1ea3ng ch\u1ea5m c\u00f4ng theo ca v\u00e0 l\u00e0m th\u00eam gi\u1edd tr\u00ean\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_bo_cuc_bang_cham_cong\"><\/span>X\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u1ea3ng ch\u1ea5m c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng b\u1ed1 c\u1ee5c b\u1ea3ng ch\u1ea5m c\u00f4ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26199 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mau-bang-cham-cong-theo-ca-01.png\" width=\"1657\" height=\"492\" title=\"mau-bang-cham-cong-theo-ca-01\"><\/p>\n<p>M\u1ed7i nh\u00e2n vi\u00ean s\u1ebd c\u00f3 4 d\u00f2ng:<\/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-251.gif\" title=\"ex101_92019-nho-251\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>3 d\u00f2ng\u00a0\u1ee9ng v\u1edbi 3 ca l\u00e0m vi\u1ec7c\u00a0\u0111\u1ec3 theo d\u00f5i s\u1ed1 c\u00f4ng theo t\u1eebng ca<\/li>\n<li>1 d\u00f2ng\u00a0\u1ee9ng v\u1edbi th\u1eddi gian t\u0103ng ca (c\u00f3 th\u1ec3 k\u00fd hi\u1ec7u t\u1eaft l\u00e0 TC ho\u1eb7c OT)<\/li>\n<\/ul>\n<p>M\u1ed7i th\u00e1ng s\u1ebd g\u1ed3m 31 ng\u00e0y, t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi 31 c\u1ed9t,\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e1nh s\u1ed1 t\u1eeb 1 t\u1edbi 31<\/p>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y\u00a0\u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y, c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y t\u1ea1i d\u00f2ng 4: D\u00f9ng h\u00e0m Date d\u1ef1a theo N\u0103m l\u00e0 n\u0103m hi\u1ec7n t\u1ea1i, th\u00e1ng l\u00e0 s\u1ed1 t\u1ea1i \u00f4 B2, ng\u00e0y l\u00e0 s\u1ed1 t\u1ea1i \u00f4 D3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26200\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-xac-dinh-ngay.png\" width=\"514\" height=\"171\" title=\"cong-thuc-xac-dinh-ngay\"><\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng Ng\u00e0y v\u1ec1 d\u1ea1ng th\u1ee9 trong ti\u1ebfng anh: S\u1eed d\u1ee5ng Custome Format: T\u1ea1i d\u00f2ng 4, s\u1eed d\u1ee5ng Format cells &gt; Custome &gt; Nh\u1eadp v\u00e0o m\u1ee5c Type l\u00e0 ba ch\u1eef d vi\u1ebft li\u1ec1n (nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-26202\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-cells-ngay-viet-tat-trong-tieng-anh.png\" width=\"500\" height=\"445\" title=\"format-cells-ngay-viet-tat-trong-tieng-anh\"><\/p>\n<p>Nh\u01b0 v\u1eady ta s\u1ebd c\u00f3\u00a0k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb Ng\u00e0y t\u1ea1i d\u00f2ng 4, nh\u01b0ng\u00a0\u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng Th\u1ee9 trong ti\u1ebfng anh.<\/p>\n<p>Vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 trang tr\u00ed k\u1ebb khung, t\u00f4 m\u00e0u, c\u0103n ch\u1ec9nh\u00a0\u0111\u1ed9 r\u1ed9ng cho b\u1ea3ng ch\u1ea5m c\u00f4ng sao cho\u00a0\u0111\u1eb9p m\u1eaft v\u00e0 d\u1ec5 nh\u00ecn.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_cham_cong_vao_bang\"><\/span>C\u00e1ch ch\u1ea5m c\u00f4ng v\u00e0o b\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi ch\u1ea5m c\u00f4ng trong t\u1eebng ca, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ea5m c\u00f4ng theo k\u00fd hi\u1ec7u ho\u1eb7c theo s\u1ed1 gi\u1edd.<\/p>\n<p>V\u1edbi ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd, t\u0103ng ca, n\u00ean ch\u1ec9 ch\u1ea5m b\u1eb1ng s\u1ed1 gi\u1edd<\/p>\n<p>Khi ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd, l\u01b0u\u00a0\u00fd ch\u1ea5m\u00a0\u0111\u00fang theo ng\u00e0y\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c l\u00e0m th\u00eam gi\u1edd trong ca n\u00e0o<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26218\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-cham-cong-bcc-ca-1024x338-1.png\" width=\"1024\" height=\"338\" title=\"cach-cham-cong-bcc-ca-1024x338-1\"><\/p>\n<p>K\u00fd hi\u1ec7u X l\u00e0\u00a0\u0111i l\u00e0m trong ca<\/p>\n<p>K\u00fd hi\u1ec7u P l\u00e0 ngh\u1ec9 ph\u00e9p<\/p>\n<p>K\u00fd hi\u1ec7u K l\u00e0 ngh\u1ec9 kh\u00f4ng ph\u00e9p<\/p>\n<p>Trong 1 ng\u00e0y ch\u1ec9 c\u00f3 duy nh\u1ea5t 1 ca\u00a0\u0111\u01b0\u1ee3c ch\u1ea5m.<\/p>\n<p>S\u1ed1 gi\u1edd l\u00e0m t\u0103ng ca trong ng\u00e0y\u00a0\u0111\u01b0\u1ee3c ch\u1ea5m k\u00e8m theo ng\u00e0y\u00a0\u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>NV001 ng\u00e0y 04\/01\/2019\u00a0\u0111i l\u00e0m ca 1 v\u00e0 t\u0103ng ca 2 gi\u1edd<\/li>\n<li>NV001 ng\u00e0y 07\/01\/2019\u00a0\u0111i l\u00e0m ca\u00a02 v\u00e0 t\u0103ng ca\u00a03 gi\u1edd<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_cong_cuoi_thang\"><\/span>C\u00e1ch t\u00ednh c\u00f4ng cu\u1ed1i th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 c\u00f4ng trong c\u00e1c ca:<\/p>\n<ul>\n<li>S\u1ed1 ca\u00a0l\u00e0m (k\u00fd hi\u1ec7u X): =COUNTIF([V\u00f9ng ch\u1ea5m c\u00f4ng], \u201cX\u201d)<\/li>\n<li>S\u1ed1\u00a0ng\u00e0y ngh\u1ec9 ph\u00e9p (k\u00fd hi\u1ec7u P) =COUNTIF([V\u00f9ng ch\u1ea5m c\u00f4ng], \u201cP\u201d)<\/li>\n<li>S\u1ed1\u00a0ng\u00e0y ngh\u1ec9 kh\u00f4ng ph\u00e9p (k\u00fd hi\u1ec7u K) =COUNTIF([V\u00f9ng ch\u1ea5m c\u00f4ng], \u201cK\u201d)<\/li>\n<\/ul>\n<p>S\u1eed d\u1ee5ng h\u00e0m SUM\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1\u00a0gi\u1edd l\u00e0m th\u00eam: =SUM([V\u00f9ng ch\u1ea5m c\u00f4ng])<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26225\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-cong-1024x306-1.png\" width=\"1024\" height=\"306\" title=\"cong-thuc-tinh-cong-1024x306-1\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2VIn5bT\">http:\/\/bit.ly\/2VIn5bT<\/a><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u th\u00eam v\u1ec1 hai h\u00e0m tr\u00ean, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">H\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00e1ch t\u00ednh t\u1ed5ng trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF c\u01a1 b\u1ea3n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tinh-cong-khi-cham-cong-bang-xen-lan-ky-hieu.html\">T\u00ednh c\u00f4ng khi ch\u1ea5m c\u00f4ng b\u1eb1ng s\u1ed1 xen l\u1eabn k\u00fd hi\u1ec7u<\/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-251.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3268,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3267","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\/3267","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=3267"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3267\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3268"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}