{"id":484403,"date":"2025-08-24T10:15:42","date_gmt":"2025-08-24T03:15:42","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=484403"},"modified":"2025-08-24T10:15:42","modified_gmt":"2025-08-24T03:15:42","slug":"count","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, c\u00e1c h\u00e0m \u0111\u1ebfm nh\u01b0 COUNT, COUNTA, COUNTIF, COUNTIFS l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Nh\u1edd nh\u1eefng h\u00e0m n\u00e0y, vi\u1ec7c th\u1ed1ng k\u00ea, ph\u00e2n t\u00edch hay l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng t\u1eebng h\u00e0m, k\u00e8m theo v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ec3 b\u1ea1n d\u1ec5 \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i sao c\u1ea7n n\u1eafm v\u1eefng h\u00e0m COUNT trong Excel?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm d\u1eef li\u1ec7u trong Excel l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng, \u0111\u1eb7c bi\u1ec7t trong b\u1ed1i c\u1ea3nh c\u00f4ng vi\u1ec7c ng\u00e0y c\u00e0ng g\u1eafn li\u1ec1n v\u1edbi s\u1ed1 li\u1ec7u. K\u1ef9 n\u0103ng n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian x\u1eed l\u00fd m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c cao, t\u1eeb \u0111\u00f3 h\u1ed7 tr\u1ee3 hi\u1ec7u qu\u1ea3 cho c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 qu\u1ea3n l\u00fd.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u1ee3i \u00edch c\u1ee5 th\u1ec3 khi bi\u1ebft c\u00e1ch \u0111\u1ebfm s\u1ed1 li\u1ec7u trong Excel bao g\u1ed3m:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ed1ng k\u00ea nhanh ch\u00f3ng: D\u1ec5 d\u00e0ng x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng kh\u00e1ch h\u00e0ng, \u0111\u01a1n h\u00e0ng, s\u1ea3n ph\u1ea9m hay b\u1ea5t k\u1ef3 th\u00f4ng tin n\u00e0o trong b\u1ea3ng t\u00ednh \u0111\u1ec3 c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u: Gi\u00fap nh\u1eadn di\u1ec7n xu h\u01b0\u1edbng, t\u00ednh to\u00e1n x\u00e1c su\u1ea5t ho\u1eb7c t\u00ecm ra gi\u00e1 tr\u1ecb n\u1ed5i b\u1eadt, t\u1eeb \u0111\u00f3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh h\u1ee3p l\u00fd.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u1ee5c v\u1ee5 b\u00e1o c\u00e1o: Cho ph\u00e9p t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u nhanh v\u00e0 ch\u00ednh x\u00e1c, t\u1ea1o n\u1ec1n t\u1ea3ng \u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c b\u00e1o c\u00e1o ph\u1ee5c v\u1ee5 h\u1ecdp ho\u1eb7c thuy\u1ebft tr\u00ecnh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh hi\u1ec7u qu\u1ea3: Theo d\u00f5i s\u1ed1 giao d\u1ecbch, ki\u1ec3m so\u00e1t kho\u1ea3n chi ti\u00eau, g\u00f3p ph\u1ea7n c\u1ea3i thi\u1ec7n kh\u1ea3 n\u0103ng qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh c\u00e1 nh\u00e2n ho\u1eb7c doanh nghi\u1ec7p.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_484412\" aria-describedby=\"caption-attachment-484412\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-484412 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-1.jpg\" alt=\"count-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484412\" class=\"wp-caption-text\">T\u1ea1i sao c\u1ea7n n\u1eafm v\u1eefng h\u00e0m \u0111\u1ebfm trong Excel?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm trong Excel l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh. C\u00e1c \u00f4 tr\u1ed1ng, \u00f4 ch\u1ee9a ch\u1eef, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c gi\u00e1 tr\u1ecb logic s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh, ch\u1ec9 nh\u1eefng \u00f4 c\u00f3 s\u1ed1 m\u1edbi \u0111\u01b0\u1ee3c ghi nh\u1eadn.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: n\u1ebfu trong m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u c\u00f3 5 \u00f4 l\u1ea7n l\u01b0\u1ee3t l\u00e0 5, 8, \u201cABC\u201d, 12 v\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng th\u00ec khi d\u00f9ng h\u00e0m \u0111\u1ebfm, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 3, v\u00ec ch\u1ec9 c\u00f3 ba \u00f4 ch\u1ee9a s\u1ed1.<\/span><\/p>\n<figure id=\"attachment_484413\" aria-describedby=\"caption-attachment-484413\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-484413 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-2.jpg\" alt=\"count-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484413\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm trong Excel l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u00e2n bi\u1ec7t c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel c\u00f3 nhi\u1ec1u h\u00e0m h\u1ed7 tr\u1ee3 \u0111\u1ebfm d\u1eef li\u1ec7u, m\u1ed7i lo\u1ea1i \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho m\u1ed9t m\u1ee5c \u0111\u00edch ri\u00eang. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c h\u00e0m th\u01b0\u1eddng g\u1eb7p:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNT: Ch\u1ec9 t\u00ednh c\u00e1c \u00f4 c\u00f3 ch\u1ee9a s\u1ed1, kh\u00f4ng t\u00ednh v\u0103n b\u1ea3n, logic, ng\u00e0y th\u00e1ng ho\u1eb7c \u00f4 tr\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTA: \u0110\u1ebfm to\u00e0n b\u1ed9 \u00f4 c\u00f3 d\u1eef li\u1ec7u, b\u1ea5t k\u1ec3 \u0111\u00f3 l\u00e0 s\u1ed1, ch\u1eef, k\u00fd t\u1ef1 logic, ng\u00e0y th\u00e1ng hay l\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTBLANK: X\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f2n tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTIF: \u0110\u1ebfm s\u1ed1 \u00f4 \u0111\u00e1p \u1ee9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 (v\u00ed d\u1ee5: gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 10).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTIFS: \u0110\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5: l\u1edbn h\u01a1n 10 v\u00e0 nh\u1ecf h\u01a1n 20).<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00e2y l\u00e0 b\u1ea3ng so s\u00e1nh c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel \u0111\u1ec3 b\u1ea1n tham kh\u1ea3o:<\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">H\u00e0m<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c \u0111\u1ebfm<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110i\u1ec3m n\u1ed5i b\u1eadt<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Ch\u1ec9 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">B\u1ecf qua v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, logic, \u00f4 tr\u1ed1ng<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTA<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ebfm m\u1ecdi \u00f4 c\u00f3 d\u1eef li\u1ec7u<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Bao g\u1ed3m s\u1ed1, ch\u1eef, ng\u00e0y th\u00e1ng, logic, l\u1ed7i<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTBLANK<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng trong ph\u1ea1m vi<\/span><\/td>\n<td><span style=\"font-weight: 400;\">H\u1eefu \u00edch khi ki\u1ec3m tra d\u1eef li\u1ec7u b\u1ecb b\u1ecf s\u00f3t<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTIF<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ebfm \u00f4 th\u1ecfa m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Th\u01b0\u1eddng d\u00f9ng trong l\u1ecdc d\u1eef li\u1ec7u theo quy t\u1eafc<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTIFS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ebfm \u00f4 th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng trong th\u1ed1ng k\u00ea ph\u1ee9c t\u1ea1p<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c lo\u1ea1i h\u00e0m COUNT trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o qua:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh s\u1ed1 \u00f4 c\u00f3 d\u1eef li\u1ec7u l\u00e0 s\u1ed1 trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ecdn, \u0111\u1ed3ng th\u1eddi b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, \u00f4 ch\u1ee9a ch\u1eef ho\u1eb7c k\u00fd t\u1ef1 logic.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p: COUNT(value1, [value2], \u2026)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng: H\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ed1ng k\u00ea nhanh s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb s\u1ed1 trong b\u1ea3ng t\u00ednh, h\u1ed7 tr\u1ee3 t\u1ed1t cho vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u ho\u1eb7c l\u1eadp b\u00e1o c\u00e1o.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed d\u00e3y \u00f4 t\u1eeb A1 \u0111\u1ebfn A10 g\u1ed3m c\u1ea3 s\u1ed1 v\u00e0 v\u0103n b\u1ea3n, khi \u00e1p d\u1ee5ng h\u00e0m \u0111\u1ebfm, k\u1ebft qu\u1ea3 s\u1ebd cho bi\u1ebft c\u00f3 bao nhi\u00eau \u00f4 th\u1ef1c s\u1ef1 ch\u1ee9a s\u1ed1 li\u1ec7u.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_484414\" aria-describedby=\"caption-attachment-484414\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-484414 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-3.jpg\" alt=\"count-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484414\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u01a1 b\u1ea3n trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng &#8211; COUNTA<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTA \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng \u00f4 kh\u00f4ng r\u1ed7ng trong m\u1ed9t ph\u1ea1m vi, bao g\u1ed3m c\u1ea3 \u00f4 ch\u1ee9a s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, gi\u00e1 tr\u1ecb logic ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. Nh\u1eefng \u00f4 tr\u1ed1ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o k\u1ebft qu\u1ea3.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m COUNTA: COUNTA(value1, value2, \u2026). Trong \u0111\u00f3:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">value1, value2,\u2026 c\u00f3 th\u1ec3 l\u00e0 \u00f4 ri\u00eang l\u1ebb ho\u1eb7c c\u1ea3 m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 l\u01b0\u1ee3ng \u0111\u1ed1i s\u1ed1 t\u1ed1i \u0111a: 255 \u00f4\/v\u00f9ng \u0111\u1ed1i v\u1edbi Excel 2007 tr\u1edf l\u00ean v\u00e0 30 \u00f4\/v\u00f9ng \u0111\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda: Gi\u1ea3 s\u1eed c\u00f3 m\u1ed9t b\u1ea3ng danh s\u00e1ch theo d\u00f5i vi\u1ec7c n\u1ed9p b\u00e0i t\u1eadp c\u1ee7a sinh vi\u00ean. B\u1ea1n mu\u1ed1n bi\u1ebft bao nhi\u00eau sinh vi\u00ean \u0111\u00e3 n\u1ed9p (t\u1ee9c l\u00e0 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a link b\u00e0i t\u1eadp). Khi nh\u1eadp h\u00e0m COUNTA cho v\u00f9ng C2:C15, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 6, t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 sinh vi\u00ean \u0111\u00e3 n\u1ed9p b\u00e0i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484415 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-4.jpg\" alt=\"count-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm 1 \u0111i\u1ec1u ki\u1ec7n &#8211; COUNTIF<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u00e1p \u1ee9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u theo quy t\u1eafc ri\u00eang, ch\u1eb3ng h\u1ea1n \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n m\u1ed9t m\u1ee9c cho tr\u01b0\u1edbc ho\u1eb7c \u0111\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m COUNTIF: COUNTIF(range, criteria). Trong \u0111\u00f3:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">range: V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u00e1p d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria: \u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 so s\u00e1nh, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c bi\u1ec3u th\u1ee9c logic (v\u00ed d\u1ee5: \u201c&gt;70\u201d, \u201cABC\u201d, 120\u2026).<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda: Gi\u1ea3 s\u1eed c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m. N\u1ebfu mu\u1ed1n bi\u1ebft bao nhi\u00eau m\u1eb7t h\u00e0ng c\u00f3 s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 150, b\u1ea1n nh\u1eadp COUNTIF(C2:C11, \u201c&gt;150\u201d). K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb cho th\u1ea5y c\u00f3 8 s\u1ea3n ph\u1ea9m th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n n\u00e0y.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n: d\u1ea5u * thay cho nhi\u1ec1u k\u00fd t\u1ef1 b\u1ea5t k\u1ef3, d\u1ea5u ? thay cho m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n t\u00ecm ch\u00ednh x\u00e1c k\u00fd t\u1ef1 \u201c\u201d ho\u1eb7c \u201c?\u201d, c\u1ea7n th\u00eam k\u00fd t\u1ef1 \u201c\u201d ph\u00eda tr\u01b0\u1edbc (v\u00ed d\u1ee5: \u201c\u201d, \u201c~?\u201d).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTIF th\u01b0\u1eddng kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng hay ch\u1eef hoa.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484416 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-5.jpg\" alt=\"count-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm v\u1edbi 2 \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean &#8211; COUNTIFS<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT n\u00e0y cho ph\u00e9p \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t ho\u1eb7c nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u, khi t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t ra \u0111\u1ec1u th\u1ecfa m\u00e3n. \u0110\u00e2y l\u00e0 phi\u00ean b\u1ea3n m\u1edf r\u1ed9ng c\u1ee7a COUNTIF, th\u00edch h\u1ee3p khi c\u1ea7n th\u1ed1ng k\u00ea d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed \u0111\u1ed3ng th\u1eddi.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m COUNTIFS: COUNTIFS(range1, criteria1, range2, criteria2, \u2026). Trong \u0111\u00f3:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">range1, range2,\u2026: C\u00e1c v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u00e1p d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n, t\u1ed1i \u0111a 127 v\u00f9ng. C\u00e1c v\u00f9ng n\u00e0y c\u00f3 th\u1ec3 ch\u1ee9a s\u1ed1, ch\u1eef, t\u00ean ho\u1eb7c m\u1ea3ng. C\u00e1c \u00f4 tr\u1ed1ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria1, criteria2,\u2026: L\u00e0 \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng v\u00f9ng, t\u1ed1i \u0111a 127 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ed9t \u00f4 ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o k\u1ebft qu\u1ea3 khi th\u1ecfa m\u00e3n to\u00e0n b\u1ed9 c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda: Gi\u1ea3 s\u1eed c\u00f3 b\u1ea3ng theo d\u00f5i s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho t\u1ea1i nhi\u1ec1u chi nh\u00e1nh. N\u1ebfu mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau m\u1eb7t h\u00e0ng \u1edf kho 1 c\u00f2n t\u1ed3n tr\u00ean 150 s\u1ea3n ph\u1ea9m, b\u1ea1n nh\u1eadp COUNTIFS(C2:C11, \u201c&gt;150\u201d, D2:D11, \u201c1\u201d). K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd hi\u1ec3n th\u1ecb 2 m\u1eb7t h\u00e0ng \u0111\u00e1p \u1ee9ng \u0111\u1ed3ng th\u1eddi c\u1ea3 hai ti\u00eau ch\u00ed.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484417 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-6.jpg\" alt=\"count-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTBLANK \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong Excel<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng \u00f4 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi c\u1ea7n ki\u1ec3m tra nh\u1eefng \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp th\u00f4ng tin.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m COUNTBLANK: COUNTBLANK(range). Trong \u0111\u00f3 range l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n th\u1ed1ng k\u00ea s\u1ed1 \u00f4 r\u1ed7ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng danh s\u00e1ch theo d\u00f5i vi\u1ec7c n\u1ed9p b\u00e0i t\u1eadp c\u1ee7a sinh vi\u00ean. \u0110\u1ec3 bi\u1ebft bao nhi\u00eau sinh vi\u00ean ch\u01b0a n\u1ed9p (\u00f4 ch\u01b0a ch\u1ee9a link b\u00e0i), b\u1ea1n d\u00f9ng COUNTBLANK cho v\u00f9ng C2:C15. K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 8 sinh vi\u00ean ch\u01b0a n\u1ed9p b\u00e0i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484418 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-7.jpg\" alt=\"count-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eefng l\u01b0u \u00fd khi d\u00f9ng c\u00e1c h\u00e0m COUNT trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm \u0111\u1ea1t hi\u1ec7u qu\u1ea3 v\u00e0 cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n quan t\u00e2m \u0111\u1ebfn m\u1ed9t s\u1ed1 y\u1ebfu t\u1ed1 quan tr\u1ecdng trong qu\u00e1 tr\u00ecnh thao t\u00e1c d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u chu\u1ea9n x\u00e1c<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c, c\u1ea7n ch\u1eafc ch\u1eafn ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00fang v\u00e0 kh\u00f4ng bao g\u1ed3m nh\u1eefng \u00f4 ngo\u00e0i \u00fd mu\u1ed1n. Vi\u1ec7c ch\u1ecdn sai v\u00f9ng d\u1eef li\u1ec7u c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 thi\u1ebfu ch\u00ednh x\u00e1c, \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484419 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-8.jpg\" alt=\"count-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n \u0111\u1ebfm, h\u00e3y r\u00e0 so\u00e1t l\u1ea1i ki\u1ec3u d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. M\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u00f4i khi l\u1ea1i \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n, khi\u1ebfn c\u00e1c h\u00e0m nh\u01b0 COUNT hay COUNTIF kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c. V\u00ec v\u1eady, b\u1ea1n c\u1ea7n \u0111\u1ecbnh d\u1ea1ng th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u (s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng) \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 \u0111\u00fang.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1edbi h\u1ea1n \u0111\u1ed1i s\u1ed1<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i, c\u00e1c h\u00e0m COUNT, COUNTA, COUNTIF\u2026 c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1edbi 255 ph\u1ea1m vi\/\u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean, trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n (Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc), gi\u1edbi h\u1ea1n ch\u1ec9 c\u00f2n 30.<\/span><\/p>\n<figure id=\"attachment_484420\" aria-describedby=\"caption-attachment-484420\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-484420 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-9.jpg\" alt=\"count-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484420\" class=\"wp-caption-text\">Gi\u1edbi h\u1ea1n \u0111\u1ed1i s\u1ed1 trong h\u00e0m \u0111\u1ebfm Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u00e2n bi\u1ec7t gi\u1eefa \u00f4 tr\u1ed1ng v\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i r\u1ed7ng<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 \u00f4 nh\u00ecn nh\u01b0 tr\u1ed1ng nh\u01b0ng th\u1ef1c t\u1ebf c\u00f3 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 r\u1ed7ng (\u201c\u201d). COUNTBLANK s\u1ebd kh\u00f4ng t\u00ednh c\u00e1c \u00f4 n\u00e0y l\u00e0 tr\u1ed1ng, do \u0111\u00f3 c\u1ea7n ki\u1ec3m tra k\u1ef9 \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn.<\/span><\/p>\n<figure id=\"attachment_484421\" aria-describedby=\"caption-attachment-484421\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-484421 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-10.jpg\" alt=\"count-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484421\" class=\"wp-caption-text\">Ph\u00e2n bi\u1ec7t gi\u1eefa \u00f4 tr\u1ed1ng v\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i r\u1ed7ng khi s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ea2nh h\u01b0\u1edfng c\u1ee7a k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0 d\u1ea5u c\u00e1ch<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 \u00f4 c\u00f3 th\u1ec3 ch\u1ee9a kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 \u1ea9n khi\u1ebfn h\u00e0m COUNTA nh\u1eadn di\u1ec7n l\u00e0 \u00f4 c\u00f3 d\u1eef li\u1ec7u. V\u00ec v\u1eady, b\u1ea1n n\u00ean l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m COUNT<\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT c\u00f3 \u0111\u1ebfm \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. Mi\u1ec5n gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng s\u1ed1 seri trong Excel th\u00ec h\u00e0m \u0111\u1ebfm s\u1ebd t\u00ednh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfn c\u00f3 ph\u00e2n bi\u1ec7t s\u1ed1 \u00e2m v\u00e0 s\u1ed1 d\u01b0\u01a1ng kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng. H\u00e0m \u0111\u1ebfm ch\u1ec9 c\u1ea7n \u00f4 \u0111\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 (d\u00f9 l\u00e0 \u00e2m hay d\u01b0\u01a1ng) th\u00ec \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u00ednh.<\/span><\/p>\n<figure id=\"attachment_484422\" aria-describedby=\"caption-attachment-484422\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/count-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-484422 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-11.jpg\" alt=\"count-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-484422\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfn c\u00f3 ph\u00e2n bi\u1ec7t s\u1ed1 \u00e2m v\u00e0 s\u1ed1 d\u01b0\u01a1ng kh\u00f4ng?<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm c\u00f3 \u0111\u1ebfm gi\u00e1 tr\u1ecb l\u1ed7i (#N\/A, #VALUE!) kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng, h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c \u00f4 ch\u1ee9a l\u1ed7i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm c\u00f3 \u0111\u1ebfm s\u1ed1 \u0111\u01b0\u1ee3c nh\u1eadp trong d\u1ea1ng v\u0103n b\u1ea3n kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng. V\u00ed d\u1ee5: &#8220;123&#8221; (d\u1ea1ng text) s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh, ch\u1ec9 123 (d\u1ea1ng s\u1ed1) m\u1edbi \u0111\u01b0\u1ee3c t\u00ednh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, n\u00e2ng cao hi\u1ec7u qu\u1ea3 ph\u00e2n t\u00edch v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u trong Excel. M\u1ed7i h\u00e0m c\u00f3 \u01b0u \u0111i\u1ec3m ri\u00eang, ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3, t\u1eeb \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1, \u00f4 c\u00f3 d\u1eef li\u1ec7u cho \u0111\u1ebfn \u0111\u1ebfm theo m\u1ed9t hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\">C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\">H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong Excel, c\u00e1c h\u00e0m \u0111\u1ebfm nh\u01b0 COUNT, COUNTA, COUNTIF, COUNTIFS l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. Nh\u1edd nh\u1eefng h\u00e0m n\u00e0y, vi\u1ec7c th\u1ed1ng k\u00ea, ph\u00e2n t\u00edch hay l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. B\u00e0i vi\u1ebft sau s\u1ebd h\u01b0\u1edbng d\u1eabn [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":484411,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-484403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m: COUNT, COUNTA, COUNTIF, COUNTIFS<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-24T03:15:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel\",\"datePublished\":\"2025-08-24T03:15:42+00:00\",\"dateModified\":\"2025-08-24T03:15:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\"},\"wordCount\":2978,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m: COUNT, COUNTA, COUNTIF, COUNTIFS\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg\",\"datePublished\":\"2025-08-24T03:15:42+00:00\",\"dateModified\":\"2025-08-24T03:15:42+00:00\",\"description\":\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg\",\"width\":1200,\"height\":628,\"caption\":\"count\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m: COUNT, COUNTA, COUNTIF, COUNTIFS","description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel","og_description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-08-24T03:15:42+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel","datePublished":"2025-08-24T03:15:42+00:00","dateModified":"2025-08-24T03:15:42+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/"},"wordCount":2978,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/","name":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m: COUNT, COUNTA, COUNTIF, COUNTIFS","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg","datePublished":"2025-08-24T03:15:42+00:00","dateModified":"2025-08-24T03:15:42+00:00","description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel v\u1edbi v\u00ed d\u1ee5 chi ti\u1ebft, d\u1ec5 hi\u1ec3u.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/count\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/count.jpg","width":1200,"height":628,"caption":"count"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/count\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/484403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=484403"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/484403\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/484411"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=484403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=484403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=484403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}