{"id":12782,"date":"2015-09-09T03:18:06","date_gmt":"2015-09-09T03:18:06","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=12782"},"modified":"2015-09-10T02:59:07","modified_gmt":"2015-09-10T02:59:07","slug":"cach-su-dung-ham-countif-trong-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=12782","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel"},"content":{"rendered":"<h2><img decoding=\"async\" loading=\"lazy\" class=\"alignright size-full wp-image-12810\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-COUNTIF-trong-Excel-5.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel - \u1ea3nh ch\u00ednh\" width=\"258\" height=\"195\" \/><\/h2>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">H\u00e0m COUNTIF l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean v\u1edbi c\u00e1c b\u1ea1n l\u00e0m k\u1ebf to\u00e1n n\u00f3i ri\u00eang v\u00e0 nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u00eac v\u1edbi\u00a0Excel n\u00f3i chung. T\u1ea1i b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"https:\/\/centax.dsoftware.vn\" target=\"_blank\">K\u1ebf to\u00e1n Centax<\/a><\/strong> xin h\u01b0\u1edbng d\u1eabn b\u1ea1n\u00a0\u0111\u1ecdc c\u00e1c s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong\u00a0Excel.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00f4ng d\u1ee5ng: H\u00e0m COUNTIF trong\u00a0Excel d\u00f9ng\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1\u00a0\u00f4 th\u1ecfa m\u00e3n\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0trong 1 ph\u1ea1m vi nh\u1ea5t\u00a0\u0111\u1ecbnh. H\u00e0m n\u00e0y\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong l\u0129nh v\u1ef1c th\u1ed1ng k\u00ea, t\u00ednh to\u00e1n, k\u1ebf to\u00e1n ..<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif; font-size: 14pt; color: #000000;\">1. H\u00e0m COUNTIF cho 1\u00a0\u0111i\u1ec1u ki\u1ec7n<\/span><\/h2>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00fa ph\u00e1p: COUNTIF( Ph\u1ea1m vi,\u00a0\u0111i\u1ec1u ki\u1ec7n)<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Trong\u00a0\u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Ph\u1ea1m vi: L\u00e0 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n m\u00e0 ta mu\u1ed1n\u00a0\u0111\u1ebfm, mu\u1ed1n th\u1ed1ng k\u00ea<\/span><\/li>\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u0110i\u1ec1u ki\u1ec7n: l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n m\u00e0 t mu\u1ed1n l\u1ea5y k\u1ebft qu\u1ea3<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u00ed d\u1ee5: T\u1eeb b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean h\u00e3y\u00a0\u0111\u1ebfm s\u1ed1 nh\u00e2n vi\u00ean c\u00f3 l\u01b0\u01a1ng t\u1eeb 5 tri\u1ec7u tr\u1edf l\u00ean<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-12795\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel - \u1ea3nh 1\" width=\"762\" height=\"358\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel.jpg 762w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-300x141.jpg 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u0110\u1ec3\u00a0\u0111\u1ebfm\u00a0\u0111\u01b0\u1ee3c s\u1ed1 nh\u00e2n vi\u00ean c\u00f3 l\u01b0\u01a1ng th\u00e1ng tr\u00ean 5 tri\u1ec7u, t\u1ea1i\u00a0\u00f4 E16 ta d\u00f9ng c\u00f4ng th\u1ee9c: E16=COUNTIF(H4:H13,&#8221;&gt;=5000000&#8243;)<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Trong\u00a0\u0111\u00f3, H4:H13 : L\u00e0 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8220;&gt;=5000000&#8221; :\u00a0\u0110i\u1ec1u ki\u1ec7n l\u00e0 m\u1ee9c l\u01b0\u01a1ng &gt;=5000000<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-12798\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-2.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel - \u1ea3nh 2\" width=\"764\" height=\"368\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-2.jpg 764w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-2-300x145.jpg 300w\" sizes=\"(max-width: 764px) 100vw, 764px\" \/><\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif; font-size: 14pt; color: #000000;\">2. H\u00e0m Counif cho nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n<\/span><\/h2>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Khi b\u1ea1n\u00a0\u0111\u1ecdc mu\u1ed1n\u00a0\u0111\u1ebfm s\u1ed1\u00a0\u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, ta c\u1ea7n thay th\u1ebf h\u00e0m &#8221; COUNTIF&#8221; b\u1eb1ng h\u00e0m &#8221; COUNTIFS&#8221;<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00fa ph\u00e1p nh\u01b0 sau: COUNTIFS(V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n 1, &#8220;\u0111i\u1ec1u ki\u1ec7n 1&#8243;, V\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n 2,&#8221;\u0111i\u1ec1u ki\u1ec7n 2&#8243;, v\u00f9ng\u00a0\u0111i\u1ec1u ki\u00ean 3, &#8221;\u00a0\u0111i\u1ec1u ki\u1ec7n 3&#8243;&#8230;)<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u1eabn v\u00ed d\u1ee5 nh\u01b0 tr\u00ean nh\u01b0ng ta\u00a0\u0111\u1ebfm xem s\u1ed1 nh\u00e2n vi\u00ean v\u1eeba c\u00f3 ph\u1ee5 c\u1ea5p chuy\u00ean c\u1ea7n v\u00e0 c\u00f3 l\u01b0\u01a1ng tr\u00ean 6 tri\u1ec7u\u00a0\u0111\u1ed3ng.\u00a0<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">T\u1ea1i\u00a0\u00f4 H17 ta\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c sau: H17=COUNTIFS(G4:G13,500000,H4:H13, &#8220;&gt;=5000000) . khi\u00a0\u0111\u00f3 ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-12806\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-3.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel - \u1ea3nh 3\" width=\"765\" height=\"415\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-3.jpg 765w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-Countif-trong-Excel-3-300x163.jpg 300w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Tr\u00ean\u00a0\u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong k\u1ebf to\u00e1n, K\u1ebf to\u00e1n Centax\u00a0ch\u00fac b\u1ea1n\u00a0\u0111\u1ecdc s\u1eed d\u1ee5ng th\u00e0nh c\u00f4ng!<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">M\u1eddi b\u1ea1n\u00a0\u0111\u1ecdc tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/phan-mem-ke-toan-excel\/\">Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/tong-hop-cac-ham-excel-hay-dung-trong-ke-toan\/\">T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/cap-nhap-phan-mem-htkk-3-3-3-moi-nhat\/\">C\u1eadp nh\u1eadt ph\u1ea7n m\u1ec1m HTKK 3.3.3 m\u1edbi nh\u1ea5t<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/mo-ta-cong-viec-cua-ke-toan-tong-hop\/\">M\u00f4 t\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/mau-bao-cao-tai-chinh-theo-thong-tu-2002014tt-btc\/\">M\u1eabu b\u00e1o c\u00e1o t\u00e0i ch\u00ednh theo Th\u00f4ng t\u01b0 200\/2014\/TT-BTC<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel, \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng trong Excel. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/p>\n","protected":false},"author":7,"featured_media":12907,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1593],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12782"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12782"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12782\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/12907"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12782"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}