{"id":10884,"date":"2025-01-15T00:27:51","date_gmt":"2025-01-15T00:27:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-countif\/"},"modified":"2025-01-15T00:27:51","modified_gmt":"2025-01-15T00:27:51","slug":"ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-countif","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-countif\/","title":{"rendered":"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: COUNTIF"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u1eefng h\u00e0m, c\u00f4ng th\u1ee9c Excel n\u00e0o th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1? N\u1ed9i dung n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p qua b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong.html\">H\u00e0m, c\u00f4ng th\u1ee9c\u00a0excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/a><\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u1ee5 th\u1ec3 c\u00e1ch\u00a0\u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m\u00a0\u0111\u00f3 v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p><strong>B\u00e0i 4: H\u00e0m COUNTIF(range, criteria)<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">H\u00e0m countif<\/a> th\u01b0\u1eddng s\u1eed d\u1ee5ng trong b\u1ea3ng ch\u1ea5m c\u00f4ng\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y c\u00f4ng. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11498 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic04-ham-countif-01.png\" width=\"666\" height=\"138\" title=\"pic04-ham-countif-01\"><\/p>\n<p>\u00c1p d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y c\u00f4ng (\u0111\u01b0\u1ee3c ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd t\u1ef1 X)<\/p>\n<ul>\n<li>range: v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 hay ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n\u00a0\u0111\u1ebfm.\u00a0\u1ede\u00a0\u0111\u00e2y l\u00e0 ph\u1ea7n t\u1eeb c\u1ed9t B t\u1edbi c\u1ed9t H<\/li>\n<li>criteria:\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n\u00a0\u0111\u1ebfm.\u00a0\u1ede\u00a0\u0111\u00e2y l\u00e0 k\u00fd t\u1ef1 \u201cX\u201d<\/li>\n<\/ul>\n<p>C\u00e1ch vi\u1ebft h\u00e0m COUNTIF nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11499 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic04-ham-countif-02.png\" width=\"711\" height=\"199\" title=\"pic04-ham-countif-02\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-234.gif\" title=\"ex101_92019-nho-234\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-29.gif\" title=\"vba101_92019-nho-29\"><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-234.gif\" title=\"ex101_92019-nho-234\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>I3 =COUNTIF($B3:$H3,\u201dX\u201d)<\/p>\n<p>I4 =COUNTIF($B4:$H4,\u201dX\u201d)<\/p>\n<\/blockquote>\n<p><strong><em>L\u01b0u\u00a0\u00fd:<\/em><\/strong><\/p>\n<ul>\n<li>Khi t\u00ednh cho nh\u00e2n vi\u00ean A (d\u00f2ng 3) th\u00ec ph\u1ea1m vi Range c\u1ee7a h\u00e0m COUNTIF c\u0169ng ch\u1ec9\u00a0\u00e1p d\u1ee5ng t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi d\u00f2ng 3<\/li>\n<li>D\u00f9ng khi ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>Excel \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n v\u00e0 h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1. Vi\u1ec7c s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel r\u00f5 r\u00e0ng l\u00e0 m\u1ed9t l\u1ee3i th\u1ebf l\u1edbn c\u1ee7a b\u1ea1n khi x\u1eed l\u00fd nh\u1eefng c\u00f4ng vi\u1ec7c n\u00e0y. H\u00e3y \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> c\u00f9ng b\u1ea1n l\u00e0m ch\u1ee7 Excel,\u00a0chinh ph\u1ee5c ngh\u1ec1 nghi\u1ec7p! B\u1ea1n tham kh\u1ea3o <a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a>! T\u1ea1i kh\u00f3a h\u1ecdc n\u00e0y, b\u1ea1n\u00a0s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m quen v\u00e0 b\u1ed5 sung nh\u1eefng\u00a0ki\u1ebfn th\u1ee9c Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. B\u1ea1n xem chi ti\u1ebft th\u00f4ng tin kh\u00f3a h\u1ecdc t\u1ea1i link sau:<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-234.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10885,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10884","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\/10884","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=10884"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10884\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10885"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}