{"id":348015,"date":"2024-05-22T14:51:07","date_gmt":"2024-05-22T07:51:07","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=348015"},"modified":"2024-05-22T14:51:43","modified_gmt":"2024-05-22T07:51:43","slug":"ham-counta","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea, \u0111\u00f4i khi b\u1ea1n s\u1ebd c\u1ea7n \u0111\u1ebfm t\u1ed5ng c\u1ee7a m\u1ed9t s\u1ed1 th\u00e0nh ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh. Thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y. H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111\u1ebfn v\u1edbi h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm COUNTA chi ti\u1ebft nh\u1ea5t.<\/span><\/p>\n<h2><b>H\u00e0m COUNTA trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, COUNTA l\u00e0 h\u00e0m \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a\u00a0 t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a th\u00f4ng tin c\u1ee5 th\u1ec3, bao g\u1ed3m c\u1ea3 nh\u1eefng th\u00f4ng tin d\u1ea1ng l\u1ed7i ho\u1eb7c \u00f4 tr\u1ed1ng (\u201c\u201d).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTA s\u1ebd l\u00e0:<\/span><\/p>\n<p><strong>=COUNTA(gi\u00e1 tr\u1ecb 1, [gi\u00e1 tr\u1ecb 2], [gi\u00e1 tr\u1ecb 3],&#8230;)<\/strong><\/p>\n<figure id=\"attachment_348017\" aria-describedby=\"caption-attachment-348017\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-348017 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-1.jpg\" alt=\"ham-counta-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-348017\" class=\"wp-caption-text\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTA<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb 1: \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 trong c\u00f4ng th\u1ee9c, \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb 2, Gi\u00e1 tr\u1ecb 3: L\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn v\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3. Trong m\u1ed9t c\u00f4ng th\u1ee9c ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e9p th\u00eam v\u00e0o t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTA c\u00f3 th\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c d\u1ea1ng th\u00f4ng tin, bao g\u1ed3m c\u1ea3 nh\u1eefng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u1ed7i ho\u1eb7c \u00f4 tr\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0ng COUNT.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi nh\u1eefng ai c\u1ea7n \u0111\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a th\u00f4ng tin \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 xem x\u00e9t s\u1eed d\u1ee5ng COUNTIF ho\u1eb7c COUNTIFS.\u00a0<\/span><\/li>\n<\/ul>\n<h2><b>V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m COUNTA trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e3y \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb (t\u1ee9c l\u00e0 kh\u00f4ng b\u1ecb b\u1ecf tr\u1ed1ng) trong b\u1ea3ng d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c COUNTA v\u00e0o \u00f4 tham chi\u1ebfu b\u00ean d\u01b0\u1edbi v\u1edbi n\u1ed9i dung sau: =COUNTA(B4:B10), sau \u0111\u00f3 b\u1ea5m OK s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 7.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-348018 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-2.jpg\" alt=\"ham-counta-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-348019 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-3.jpg\" alt=\"ham-counta-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: H\u01b0\u1edbng d\u1eabn chia s\u1ebb trong b\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows 10 v\u1edbi Excel phi\u00ean b\u1ea3n 2013. \u0110\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel v\u00e0 h\u1ec7 \u0111i\u1ec1u h\u00e0nh kh\u00e1c, giao di\u1ec7n c\u00f3 th\u1ec3 c\u00f3 ch\u00fat kh\u00e1c bi\u1ec7t, nh\u01b0ng c\u00e1c b\u01b0\u1edbc g\u1ea7n nh\u01b0 l\u00e0 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng.\u00a0<\/span><\/p>\n<h2><b>M\u1ed9t s\u1ed1 h\u00e0m th\u00f4ng d\u1ee5ng kh\u00e1c trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i h\u00e0m COUNTA, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 h\u00e0m th\u00f4ng d\u1ee5ng kh\u00e1c \u0111\u1ec3 s\u1eed d\u1ee5ng cho qu\u00e1 tr\u00ecnh th\u1ed1ng k\u00ea v\u00e0 t\u00ednh to\u00e1n c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n<h3><b>Ham SUM<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00e1c v\u1edbi h\u00e0m COUNTA t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3, h\u00e0m SUM s\u1ebd t\u00ednh t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c con s\u1ed1 c\u00f3 trong v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUM s\u1ebd l\u00e0:\u00a0\u00a0<\/span><\/p>\n<p style=\"text-align: center;\"><strong>=SUM(Number1, Number2,\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n v\u1edbi c\u00f4ng th\u1ee9c =SUM(20,30,50), h\u00e0m s\u1ebd c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 l\u1ea1i \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng l\u00e0 100.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ho\u1eb7c, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 y\u00eau c\u1ea7u h\u00e0m t\u00ednh to\u00e1n t\u1ed5ng c\u1ee7a m\u1ed9t d\u00e3y d\u1eef li\u1ec7u, ch\u1eb3ng h\u1ea1n nh\u01b0 c\u00f4ng th\u1ee9c =SUM(B1:B5) \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 n\u1eb1m trong d\u00e3y t\u1eeb B1 &#8211; B5, t\u1ee9c l\u00e0 \u00f4 B1, B2, B3, B4 v\u00e0 B5.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-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-348020 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-4.jpg\" alt=\"ham-counta-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><b><\/b><\/span><\/p>\n<h3><span style=\"font-weight: 400;\"><b>H\u00e0m MIN\/MAX<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m MIN v\u00e0 h\u00e0m MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t ho\u1eb7c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t n\u1eb1m trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u cho tr\u01b0\u1edbc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m MIN l\u00e0:<\/span><\/p>\n<p><strong>=MIN(Number1, Number2,&#8230;)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m MAX s\u1ebd t\u01b0\u01a1ng t\u1ef1:<\/span><\/p>\n<p><strong>=MAX(Number1, Number2,&#8230;)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 c\u00fa ph\u00e1p = MIN(A2:C5) s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 5 v\u00ec \u0111\u00e2y l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t n\u1eb1m trong ph\u1ea1m vi m\u00e0 b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh. T\u01b0\u01a1ng t\u1ef1, c\u00f4ng th\u1ee9c =MAX(A2:C5) s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 100 v\u00ec \u0111\u00e2y l\u00e0 con s\u1ed1 l\u1edbn nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-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-348021 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-5.jpg\" alt=\"ham-counta-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m COUNT<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Thay v\u00ec \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh nh\u01b0 COUNTA, h\u00e0m COUNT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a s\u1ed1 trong v\u00f9ng d\u1eef li\u1ec7u cho tr\u01b0\u1edbc.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNT s\u1ebd l\u00e0\u00a0<\/span><\/p>\n<p><strong>=COUNT(Value1,\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c =COUNT (B2 &#8211; C5), sau khi nh\u1ea5n Enter s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 5, t\u1ee9c l\u00e0 c\u00f3 5 \u00f4 trong v\u00f9ng d\u1eef li\u1ec7u tr\u00ean ch\u1ee9a s\u1ed1.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n sang d\u00f9ng h\u00e0m COUNTA nh\u01b0 h\u01b0\u1edbng d\u1eabn \u0111\u00e3 chia s\u1ebb \u1edf b\u00ean tr\u00ean.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-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-348022 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-6.jpg\" alt=\"ham-counta-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m AVERAGE<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m AVERAGE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh s\u1ed1 trung b\u00ecnh c\u1ed9ng c\u1ee7a c\u00e1c \u00f4 n\u1eb1m trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=AVERAGE(Number1, Number2,\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0, b\u1ea1n mu\u1ed1n t\u00ednh l\u01b0\u01a1ng trung b\u00ecnh c\u1ed9ng trong 4 th\u00e1ng, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c sau: =AVERAGE(C2:C5), sau \u0111\u00f3 nh\u1ea5n Enter l\u00e0 s\u1ebd ra k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-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-348023 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-7.jpg\" alt=\"ham-counta-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m COUNTIF<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, n\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 \u00f4 trong khu v\u1ef1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh trong c\u00f4ng th\u1ee9c, nh\u01b0ng l\u1ea1i ph\u1ea3i \u0111\u1ea3m b\u1ea3o \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng COUNTIF thay v\u00ec h\u00e0m COUNTA.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m COUNTIF:<\/span><\/p>\n<p><strong>=COUNTIF(Range, Criteria)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, Range l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm, c\u00f2n Criteria l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m. Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng t\u1ed3n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng t\u1eeb 120 s\u1ea3n ph\u1ea9m tr\u1edf l\u00ean.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-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-348024 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-8.jpg\" alt=\"ham-counta-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m COUNTBLANK<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">COUNTBLANK l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c \u00f4 r\u1ed7ng n\u1eb1m trong v\u00f9ng d\u1eef li\u1ec7u cho tr\u01b0\u1edbc, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=COUNTBLANK(Range)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, Range l\u00e0 khu v\u1ef1c d\u1eef li\u1ec7u m\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng b\u00ean trong.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n c\u1ea7n t\u00ednh s\u1ed1 \u00f4 tr\u1ed1ng nh\u01b0 trong h\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=COUNTBLANK(C2:C9)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348025 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-9.jpg\" alt=\"ham-counta-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m IF<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m quen thu\u1ed9c ti\u1ebfp theo th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel l\u00e0 h\u00e0m IF. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra v\u00e0 cho ra c\u00e1c k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ebd l\u00e0:<\/span><\/p>\n<p><strong>=IF(Logical test, Value if true, Value if false)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p 2 \u0111i\u1ec1u ki\u1ec7n l\u00e0 <strong>value if true<\/strong> v\u00e0 <strong>value if false<\/strong> b\u1ecb b\u1ecf tr\u1ed1ng, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 0 n\u1ebfu nh\u01b0 th\u1ecfa m\u00e3n \u0111\u00fang v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc, ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u0111i\u1ec3m s\u1ed1 t\u1eeb 5 tr\u1edf l\u00ean s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 \u0110\u1ea1t, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 kh\u00f4ng \u0110\u1ea1t. Ta c\u00f3 c\u00f4ng th\u1ee9c =IF(B2&gt;5, \u201c\u0110\u1ea1t\u201d, \u201cKh\u00f4ng \u0111\u1ea1t\u201d).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348026 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-10.jpg\" alt=\"ham-counta-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m SUMIF<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUMIF l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. Trong \u0111\u00f3, c\u00fa ph\u00e1p h\u00e0m SUMIF s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=SUMIF(range,criteria,[sum_range])<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Range \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 so s\u00e1nh v\u1edbi \u0111i\u1ec1u ki\u1ec7n, criteria l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n th\u1ecfa m\u00e3n v\u00e0 [sum_range] l\u00e0 v\u00f9ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed5ng s\u1ed1 m\u00e0u xanh n\u1eb1m trong c\u1ed9t B c\u00f3 s\u1ed1 l\u01b0\u1ee3ng bao nhi\u00eau t\u1ea1i c\u1ed9t C, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau: =SUMIF(B1:B8,\u201dxanh\u201d,C1:C8).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348027 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11.jpg\" alt=\"ham-counta-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m RIGHT\/LEFT\/MID<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng gi\u1ed1ng v\u1edbi h\u00e0m COUNTA th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong qu\u00e1 tr\u00ecnh th\u1ed1ng k\u00ea d\u1eef li\u1ec7u, c\u00e1c h\u00e0m LEFT, RIGHT v\u00e0 MID s\u1ebd gi\u00fap b\u1ea1n t\u00e1ch c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n cho tr\u01b0\u1edbc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, h\u00e0m LEFT cho ph\u00e9p t\u00e1ch k\u00fd t\u1ef1 b\u00ean tr\u00e1i v\u1edbi c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>=LEFT(text,[num_chars])<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ng\u01b0\u1ee3c l\u1ea1i, h\u00e0m RIGHT cho ph\u00e9p t\u00e1ch k\u00fd t\u1ef1 b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=RIGHT(text,[num_chars])<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, text l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n, c\u00f2n [num_chars] l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n l\u1ea5y khi t\u00e1ch t\u1eeb b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i sang (t\u00f9y c\u00f4ng th\u1ee9c).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n l\u1ea5y m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 n\u1eb1m \u1edf gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m MID v\u1edbi c\u00fa ph\u00e1p sau:\u00a0\u00a0<\/span><\/p>\n<p><strong>=MID(text,start_num,[num_chars])<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, text l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n b\u1ea1n c\u1ea7n t\u00e1ch k\u00fd t\u1ef1, start_num l\u00e0 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a k\u00fd t\u1ef1 v\u00e0 num_chars l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n c\u1ea7n l\u1ea5y.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348027 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11.jpg\" alt=\"ham-counta-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m CONCAT<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00e1c v\u1edbi h\u00e0m COUNTA d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm, th\u00ec h\u00e0m CONCAT c\u00f3 ch\u1ee9c n\u0103ng gh\u00e9p n\u1ed1i 2 ho\u1eb7c nhi\u1ec1u v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n h\u1ee3p nh\u1ea5t. Trong c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn v\u1edbi c\u00e1i t\u00ean l\u00e0 CONCATENATE. C\u00fa ph\u00e1p c\u1ee5 th\u1ec3 s\u1ebd l\u00e0:\u00a0\u00a0<\/span><\/p>\n<p><strong>=CONCAT(text1, [text2],\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n mu\u1ed1n t\u1ea1o n\u00ean d\u00f2ng ch\u1eef \u201cHo\u00e0ng H\u00e0 Mobile c\u1ea3m \u01a1n qu\u00fd kh\u00e1ch\u201d, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m CONCAT v\u1edbi c\u00f4ng th\u1ee9c sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=CONCAT(\u201cHo\u00e0ng\u201d,\u201d \u201c,\u201dH\u00e0\u201d,\u201d \u201c,\u201dMobile\u201d,\u201d \u201c,\u201dc\u1ea3m\u201d,\u201d \u201c,\u201d\u01a1n\u201d,\u201d \u201c,\u201dqu\u00fd\u201d,\u201d \u201c, \u201ckh\u00e1ch.\u201d)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348028 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-12.jpg\" alt=\"ham-counta-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m NOW<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m NOW th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u1eddi gian \u1edf th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i. Ngo\u00e0i ra, h\u00e0m n\u00e0y c\u00f2n xu\u1ea5t hi\u1ec7n trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u00ednh to\u00e1n ho\u1eb7c c\u1eadp nh\u1eadt l\u1ea1i gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean ng\u00e0y gi\u1edd th\u1ef1c t\u1ebf. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=NOW()<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Khi nh\u1eadp h\u00e0m NOW v\u00e0o m\u1ed9t \u00f4 tr\u00ean Excel, b\u1ea1n s\u1ebd nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng. \u0110\u1ed1i v\u1edbi c\u00e1c c\u00fa ph\u00e1p =NOW()+12, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 ng\u00e0y gi\u1edd c\u1ee7a 10 ng\u00e0y ti\u1ebfp theo.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348029 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-13.jpg\" alt=\"ham-counta-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m DATE<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m COUNTA c\u00f9ng nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u b\u00ean tr\u00ean, h\u00e0m DATE c\u0169ng l\u00e0 m\u1ed9t h\u00e0m kh\u00e1 quen thu\u1ed9c trong Excel. Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 ng\u00e0y c\u1ee5 th\u1ec3. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=DATE(Year,Month,Day)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, Year l\u00e0 s\u1ed1 n\u0103m, Month l\u00e0 s\u1ed1 th\u00e1ng v\u00e0 Day l\u00e0 th\u00f4ng tin v\u1ec1 ng\u00e0y. Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n nh\u1eadp c\u00fa ph\u00e1p =DATE(2024,7,3), k\u1ebft qu\u1ea3 s\u1ebd cho ra 3\/7\/2024.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348030 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-14.jpg\" alt=\"ham-counta-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m VLOOKUP<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">VLOOKUP th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p t\u00ednh \u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i d\u00f2 t\u00ecm v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u theo h\u00e0ng d\u1ecdc sao cho ph\u00f9 h\u1ee3p. C\u00fa ph\u00e1p c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>=VLOOKUP(Lookup_value, Table_array, Col_index_ num, Range_lookup)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3,\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Lookup_value: \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Table_array: Khu v\u1ef1c ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n d\u00f2 t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Col_index_num: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t trong khu v\u1ef1c c\u1ea7n d\u00f2 t\u00ecm, \u0111\u01b0\u1ee3c t\u00ednh l\u1ea7n l\u01b0\u1ee3t t\u1eeb tr\u00e1i sang ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range_lookup: X\u00e1c \u0111\u1ecbnh ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm, s\u1ed1 1 l\u00e0 t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i, s\u1ed1 0 l\u00e0 t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c kho\u1ea3ng ti\u1ec1n tr\u1ee3 c\u1ea5p c\u1ea7n ph\u1ea3i chi tr\u1ea3 cho nh\u00e2n vi\u00ean c\u1ee7a m\u00ecnh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348031 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-15.jpg\" alt=\"ham-counta-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>H\u00e0m HLOOKUP<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m HLOOKUP c\u00f3 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng kh\u00e1 gi\u1ed1ng v\u1edbi h\u00e0m VLOOKUP, nh\u01b0ng h\u00e0m n\u00e0y s\u1ebd tham chi\u1ebfu v\u00e0 d\u00f2 t\u00ecm d\u1ef1a tr\u00ean c\u00e1c d\u00f2ng c\u1ee7a b\u1ea3ng t\u00ednh, t\u1eeb \u0111\u00f3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t v\u1edbi y\u00eau c\u1ea7u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=HLOOKUP(Lookup_value, Table_ array, Row_index_Num, Range_lookup)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c \u0111\u1ed1i s\u1ed1 b\u00ean trong \u0111\u1ec1u t\u01b0\u01a1ng t\u1ef1 v\u1edbi VLOOKUP, nh\u01b0ng thay v\u00ec x\u00e1c \u0111\u1ecbnh qua c\u1ed9t, \u1edf c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd ch\u1ec9 \u0111\u1ecbnh b\u1eb1ng d\u00f2ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u1ea1o b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh \u1edf b\u1ea3ng 1 b\u1eb1ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111i\u1ec1n trong b\u1ea3ng 2. C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 s\u1ebd gi\u1ed1ng v\u1edbi h\u00ecnh sau:\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/05\/ham-counta-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348032 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-16.jpg\" alt=\"ham-counta-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean tr\u00ean l\u00e0 c\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc b\u1eb1ng h\u00e0m COUNTA chi ti\u1ebft v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Ngo\u00e0i ra, b\u00e0i vi\u1ebft c\u0169ng cung c\u1ea5p m\u1ed9t s\u1ed1 h\u00e0m quen thu\u1ed9c th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, qu\u1ea3n l\u00fd v\u00e0 th\u1ed1ng k\u00ea s\u1ed1 li\u1ec7u tr\u00ean Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. N\u1ebfu n\u1ed9i dung tr\u00ean h\u1eefu \u00edch, \u0111\u1eebng qu\u00ean chia s\u1ebb \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi c\u00f9ng \u00e1p d\u1ee5ng v\u00e0 \u0111\u00f3n \u0111\u1ecdc, b\u1ea1n nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 n\u1ed9i dung li\u00ean quan m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumproduct\/\">H\u00e0m SUMPRODUCT trong Excel: C\u00e1ch t\u00ednh t\u1ed5ng t\u00edch \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\">H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea, \u0111\u00f4i khi b\u1ea1n s\u1ebd c\u1ea7n \u0111\u1ebfm t\u1ed5ng c\u1ee7a m\u1ed9t s\u1ed1 th\u00e0nh ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh. Thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y. H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile [&hellip;]<\/p>\n","protected":false},"author":97,"featured_media":348016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-348015","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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 h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft<\/title>\n<meta name=\"description\" content=\"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.\" \/>\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\/ham-counta\/\" \/>\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 h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\" \/>\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:published_time\" content=\"2024-05-22T07:51:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-22T07:51:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.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 Th\u1ecb M\u1ef9 Li\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 Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 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\/ham-counta\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bd62b9b9f8624b34df49eb671db6853a\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft\",\"datePublished\":\"2024-05-22T07:51:07+00:00\",\"dateModified\":\"2024-05-22T07:51:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\"},\"wordCount\":2947,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg\",\"datePublished\":\"2024-05-22T07:51:07+00:00\",\"dateModified\":\"2024-05-22T07:51:43+00:00\",\"description\":\"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-counta\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft\"}]},{\"@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\/bd62b9b9f8624b34df49eb671db6853a\",\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft","description":"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.","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\/ham-counta\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft","og_description":"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-05-22T07:51:07+00:00","article_modified_time":"2024-05-22T07:51:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bd62b9b9f8624b34df49eb671db6853a"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft","datePublished":"2024-05-22T07:51:07+00:00","dateModified":"2024-05-22T07:51:43+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/"},"wordCount":2947,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg","datePublished":"2024-05-22T07:51:07+00:00","dateModified":"2024-05-22T07:51:43+00:00","description":"Trong Excel, thay v\u00ec t\u00ecm v\u00e0 \u0111\u1ebfm th\u1ee7 c\u00f4ng r\u1ea5t m\u1ea5t th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m h\u1ed7 tr\u1ee3 nh\u01b0 h\u00e0m COUNTA \u0111\u1ec3 t\u1ed1i \u01b0u qu\u00e1 tr\u00ecnh n\u00e0y.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/05\/ham-counta.jpg","width":1200,"height":628,"caption":"ham-counta"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft"}]},{"@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\/bd62b9b9f8624b34df49eb671db6853a","name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/348015","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\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=348015"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/348015\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/348016"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=348015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=348015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=348015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}