{"id":263299,"date":"2023-10-05T20:58:34","date_gmt":"2023-10-05T13:58:34","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=263299"},"modified":"2023-10-05T20:58:34","modified_gmt":"2023-10-05T13:58:34","slug":"cach-dung-ham-countifs","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. Tuy nhi\u00ean, h\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi th\u01b0\u1eddng s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi m\u1edbi t\u1eadp l\u00e0m quen v\u1edbi h\u00e0m n\u00e0y. Th\u1ea5u hi\u1ec3u \u0111i\u1ec1u \u0111\u00f3, <\/span><span style=\"font-weight: 400;\">Ho\u00e0ng H\u00e0 Mobile<\/span><span style=\"font-weight: 400;\"> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS \u0111\u1ec3 \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u0111\u1ed3ng th\u1eddi gi\u1edbi thi\u1ec7u th\u00eam m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm kh\u00e1c trong Excel m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi b\u1ea1n c\u00f9ng tham kh\u1ea3o!<\/span><\/p>\n<h2><b>H\u00e0m COUNTIFS trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi \u0111\u1ebfn v\u1edbi c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u COUNTIFS l\u00e0 g\u00ec. COUNTIFS l\u00e0 m\u1ed9t h\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t ra trong c\u00e1c ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh c\u1ee7a b\u1ea3ng t\u00ednh.\u00a0<\/span><\/p>\n<figure id=\"attachment_265883\" aria-describedby=\"caption-attachment-265883\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-265883 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-1.jpg\" alt=\"cach-dung-ham-countifs-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265883\" class=\"wp-caption-text\">COUNTIFS l\u00e0 m\u1ed9t h\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c cho tr\u01b0\u1edbc<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 n\u00f3i r\u1eb1ng, COUNTIFS ch\u00ednh l\u00e0 m\u1ed9t h\u00e0m n\u00e2ng cao c\u1ee7a COUNTIFS. N\u1ebfu nh\u01b0 COUNTIF ch\u1ec9 \u0111\u1ebfm c\u00e1c \u00f4 trong ph\u1ea1m vi v\u1edbi 1 \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t, th\u00ec COUNTIFS l\u1ea1i c\u00f3 kh\u1ea3 n\u0103ng \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng c\u00f9ng l\u00fac nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00f9ng ph\u1ea1m vi ho\u1eb7c c\u00e1c ph\u1ea1m vi kh\u00e1c nhau cho tr\u01b0\u1edbc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong Excel, COUNTIFS \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ebfm c\u00e1c \u00f4 d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea1o ph\u00e9p t\u00ednh chuy\u00ean nghi\u1ec7p v\u00e0 nhanh ch\u00f3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cho ph\u00e9p k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c.\u00a0<\/span><\/li>\n<\/ul>\n<h2><b>C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIFS l\u00e0:\u00a0<\/span><\/p>\n<h3><b>C\u00fa ph\u00e1p h\u00e0m COUNTIFS<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIFS l\u00e0:<\/span><\/p>\n<p><strong>=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)<\/strong><\/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;\">criteria_range1: L\u00e0 th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm, trong \u0111\u00f3 c\u00f3 th\u1ec3 ch\u1ee9a s\u1ed1, m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c tham chi\u1ebfu ch\u1ee9a s\u1ed1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria1: L\u00e0 th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c trong h\u00e0m, \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 \u0111i\u1ec1u ki\u1ec7n m\u00e0 \u00f4 c\u1ea7n ph\u1ea3i \u0111\u00e1p \u1ee9ng c\u1ee7a criteria_range1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria_range2: \u0110\u00e2y l\u00e0 th\u00e0nh ph\u1ea7n kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 trong h\u00e0m, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm th\u1ee9 hai.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria2: T\u01b0\u01a1ng t\u1ef1, th\u00e0nh ph\u1ea7n n\u00e0y ch\u1ec9 c\u00f3 n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng criteria_range2 v\u00ec n\u00f3 l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 hai c\u1ea7n \u0111\u1ebfm \u00f4.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng COUNTIFS trong Excel, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i h\u1ecdc thu\u1ed9c l\u00f2ng c\u00fa ph\u00e1p tr\u00ean. B\u1edfi l\u1ebd, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb t\u1eebng \u0111\u1ed1i s\u1ed1 khi b\u1ea1n nh\u1eadp t\u00ean h\u00e0m.<\/span><\/p>\n<figure id=\"attachment_265884\" aria-describedby=\"caption-attachment-265884\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-265884 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-2.jpg\" alt=\"cach-dung-ham-countifs-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265884\" class=\"wp-caption-text\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIFS<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng COUNTIFS \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng 1 \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t trong 1 ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111i k\u00e8m v\u1edbi nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u. Trong tr\u01b0\u1eddng h\u1ee3p th\u1ee9 2, h\u00e0m s\u1ebd ch\u1ec9 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ed7i v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c b\u1ed5 sung c\u1ea7n c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 s\u1ed1 c\u1ed9t nh\u01b0 ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u1ea7u &#8211; t\u01b0\u01a1ng \u1ee9ng l\u00e0 \u0111\u1ed1i s\u1ed1 criteria_range1. Tuy nhi\u00ean, ch\u00fang kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i n\u1eb1m k\u1ebf ti\u1ebfp nhau.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTIFS \u0111\u1ebfm \u0111\u01b0\u1ee3c t\u1ed1i \u0111a 127 v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTIFS s\u1ebd t\u1ef1 \u0111\u1ed9ng x\u1eed l\u00fd v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 \u00f4 tr\u1ed1ng l\u00e0 1 gi\u00e1 tr\u1ecb b\u1eb1ng 0.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c wildcard character (k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n) l\u00e0 d\u1ea5u sao (*) v\u00e0 d\u1ea5u ch\u1ea5m h\u1ecfi (?).<\/span><\/li>\n<\/ul>\n<h3><b>C\u00e1ch d\u00f9ng h\u00e0m COUNTIFS<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 n\u1eafm r\u00f5 c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i v\u00ed d\u1ee5 sau:\u00a0<\/span><\/p>\n<h4><b>Tr\u01b0\u1eddng h\u1ee3p 1<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 c\u00f4ng ty b\u1ea1n \u0111ang s\u1ea3n xu\u1ea5t v\u00e0 ph\u00e2n ph\u1ed1i nhi\u1ec1u lo\u1ea1i m\u1eb7t h\u00e0ng kh\u00e1c nhau (\u00e1o, qu\u1ea7n) v\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 lo\u1ea1i \u00e1o \u0111\u01b0\u1ee3c xu\u1ea5t \u0111i v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 s\u1ed1 l\u01b0\u1ee3ng ph\u1ea3i tr\u00ean 40 c\u00e1i. <\/span><span style=\"font-weight: 400;\">Khi \u0111\u00f3, b\u1ea1n nh\u1eadp c\u00fa ph\u00e1p sau v\u00e0o \u00f4 tham chi\u1ebfu r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3:\u00a0<\/span><\/p>\n<p><strong>=COUNTIFS(B3:B8,&#8221;\u00c1o&#8221;,D3:D8,&#8221;&gt;40&#8243;)<\/strong><\/p>\n<figure id=\"attachment_265885\" aria-describedby=\"caption-attachment-265885\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-265885 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-3.jpg\" alt=\"cach-dung-ham-countifs-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265885\" class=\"wp-caption-text\">C\u00fa ph\u00e1p \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00e1o \u0111\u01b0\u1ee3c xu\u1ea5t v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 s\u1ed1 l\u01b0\u1ee3ng ph\u1ea3i h\u01a1n 40 c\u00e1i<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y c\u00f3 ngh\u0129a l\u00e0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 1: T\u1eeb \u00f4 B3 \u0111\u1ebfn \u00f4 B8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 1: C\u00f3 ch\u1eef \u201c\u00c1o\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 2: T\u1eeb \u00f4 D3 \u0111\u1ebfn \u00f4 D8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 2: &gt; 40.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_265886\" aria-describedby=\"caption-attachment-265886\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265886 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-4.jpg\" alt=\"cach-dung-ham-countifs-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265886\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">=&gt; Nh\u01b0 v\u1eady, \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ebd ph\u1ea3i \u0111\u00e1p \u1ee9ng \u0111\u1ed3ng th\u1eddi 2 \u0111i\u1ec1u ki\u1ec7n tr\u00ean. K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng s\u1ebd l\u00e0 2 (bao g\u1ed3m \u00c1o \u1edf khu v\u1ef1c mi\u1ec1n Nam v\u00e0 \u00c1o \u1edf khu v\u1ef1c mi\u1ec1n B\u1eafc).\u00a0<\/span><\/p>\n<h4><b>Tr\u01b0\u1eddng h\u1ee3p 2<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 lo\u1ea1i h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c xu\u1ea5t \u0111i sau th\u1eddi gian 20\/5\/2021 v\u1edbi gi\u00e1 tr\u00ean 5 tri\u1ec7u \u0111\u1ed3ng. C\u00fa ph\u00e1p \u0111\u1ebfm s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=COUNTIFS(E3:E8,&#8221;&gt;=5000000&#8243;,F3:F8,&#8221;&gt;20\/05\/2021&#8243;)<\/strong><\/p>\n<figure id=\"attachment_265887\" aria-describedby=\"caption-attachment-265887\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265887 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-5.jpg\" alt=\"cach-dung-ham-countifs-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265887\" class=\"wp-caption-text\">C\u00fa ph\u00e1p \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c xu\u1ea5t \u0111i t\u1eeb ng\u00e0y 20\/5\/2021 v\u1edbi chi ph\u00ed tr\u00ean 5 tri\u1ec7u \u0111\u1ed3ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y c\u00f3 ngh\u0129a l\u00e0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 1: T\u1eeb \u00f4 E3 \u0111\u1ebfn \u00f4 E8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 1: C\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5000000.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 2: T\u1eeb \u00f4 F3 \u0111\u1ebfn \u00f4 F8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 2: T\u1eeb ng\u00e0y 20\/05\/2021 tr\u1edf \u0111i<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_265888\" aria-describedby=\"caption-attachment-265888\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265888 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-6.jpg\" alt=\"cach-dung-ham-countifs-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265888\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">=&gt; Nh\u01b0 v\u1eady, \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ebd ph\u1ea3i \u0111\u00e1p \u1ee9ng \u0111\u1ed3ng th\u1eddi 2 \u0111i\u1ec1u ki\u1ec7n tr\u00ean. Sau khi b\u1ea1n nh\u1ea5n Enter, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 2 (bao g\u1ed3m: Qu\u1ea7n \u1edf mi\u1ec1n B\u1eafc v\u00e0 \u00c1o \u1edf mi\u1ec1n Nam).<\/span><\/p>\n<h4><b>Tr\u01b0\u1eddng h\u1ee3p 3<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e3y \u0111\u1ebfm lo\u1ea1i qu\u1ea7n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng n\u1eb1m trong kho\u1ea3ng t\u1eeb 40 &#8211; 80 c\u00e1i \u0111\u00e3 \u0111\u01b0\u1ee3c xu\u1ea5t tr\u01b0\u1edbc th\u1eddi gian 31\/5\/2021.\u00a0 <\/span><span style=\"font-weight: 400;\">V\u1edbi c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, b\u1ea1n g\u00f5 c\u00fa ph\u00e1p sau v\u00e0o \u00f4 tham chi\u1ebfu r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3:<\/span><\/p>\n<p><strong>=COUNTIFS(B3:B8,&#8221;Qu\u1ea7n&#8221;,D3:D8,&#8221;&gt;=40&#8243;,D3:D8,&#8221;&lt;=80&#8243;,F3:F8,&#8221;&lt;31\/05\/2021&#8243;)<\/strong><\/p>\n<figure id=\"attachment_265889\" aria-describedby=\"caption-attachment-265889\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265889 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-7.jpg\" alt=\"cach-dung-ham-countifs-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265889\" class=\"wp-caption-text\">C\u00fa ph\u00e1p \u0111\u1ebfm qu\u1ea7n c\u00f3 s\u1ed1 l\u01b0\u1ee3ng n\u1eb1m trong kho\u1ea3ng t\u1eeb 40 &#8211; 80 c\u00e1i \u0111\u00e3 xu\u1ea5t \u0111i tr\u01b0\u1edbc ng\u00e0y 31\/5\/2021<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y c\u00f3 ngh\u0129a l\u00e0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 1: T\u1eeb \u00f4 B3 \u0111\u1ebfn \u00f4 B8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 1: C\u00f3 ch\u1eef \u201cQu\u1ea7n\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 2: T\u1eeb \u00f4 D3 \u0111\u1ebfn \u00f4 D8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 2: N\u1eb1m trong kho\u1ea3ng 40 &#8211; 80.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00f9ng tham chi\u1ebfu 3: T\u1eeb \u00f4 F3 \u0111\u1ebfn \u00f4 F8.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng tham chi\u1ebfu 3: Tr\u01b0\u1edbc ng\u00e0y 31\/5\/2021.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_265890\" aria-describedby=\"caption-attachment-265890\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265890 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-8.jpg\" alt=\"cach-dung-ham-countifs-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265890\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng ph\u00e9p t\u00ednh<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ebd ph\u1ea3i \u0111\u00e1p \u1ee9ng \u0111\u1ed3ng th\u1eddi 3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean. Sau khi nh\u1ea5n Enter, k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng s\u1ebd l\u00e0 1 v\u00ec ch\u1ec9 c\u00f3 1 m\u1eb7t h\u00e0ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c, \u0111\u00f3 l\u00e0: \u00c1o \u1edf mi\u1ec1n B\u1eafc.<\/span><\/p>\n<h2><b>M\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm kh\u00e1c trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm kh\u00e1c trong Excel nh\u01b0 sau:\u00a0<\/span><\/p>\n<h3><b>C\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm trong Excel<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Trong Excel c\u00f3 5 lo\u1ea1i h\u00e0m \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau, c\u1ee5 th\u1ec3 l\u00e0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNT: H\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 trong b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a s\u1ed1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTIF: H\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 trong b\u1ea3ng t\u00ednh \u0111\u00e1p \u1ee9ng 1 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTIFS: Ch\u00fang ta \u0111\u00e3 n\u1eafm r\u00f5 c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua h\u01b0\u1edbng d\u1eabn tr\u00ean, \u0111\u00e2y l\u00e0 h\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTA: H\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong b\u1ea3ng t\u00ednh Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">COUNTBLANK: H\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng trong b\u1ea3ng t\u00ednh Excel.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_265891\" aria-describedby=\"caption-attachment-265891\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265891 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-9.jpg\" alt=\"cach-dung-ham-countifs-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265891\" class=\"wp-caption-text\">Trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m \u0111\u1ebfm kh\u00e1c nhau<\/figcaption><\/figure>\n<h3><b>H\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">COUNTIF v\u00e0 COUNTIFS l\u00e0 2 h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Trong \u0111\u00f3, h\u00e0m COUNTIFS l\u00e0 h\u00e0m n\u00e2ng cao c\u1ee7a COUNTIF. B\u1edfi l\u1ebd, h\u00e0m COUNTIF ch\u1ec9 \u0111\u1ebfm c\u00e1c \u00f4 \u0111\u00e1p \u1ee9ng \u0111\u00fang 1 \u0111i\u1ec1u ki\u1ec7n, c\u00f2n h\u00e0m COUNTIFS cho ph\u00e9p b\u1ea1n k\u1ebft h\u1ee3p gi\u1eefa nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ph\u1ea7n tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, n\u00ean ph\u1ea7n n\u00e0y ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m COUNTIF:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p: <strong>=COUNTIF(range, criteria)<\/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;\">Range: V\u00f9ng tham chi\u1ebfu c\u1ea7n \u0111\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria: \u0110i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u00e1p \u1ee9ng \u0111\u1ec3 \u0111\u1ebfm.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u1ea7n th\u1ed1ng k\u00ea xem c\u00f3 bao nhi\u00eau m\u1eb7t h\u00e0ng t\u1ed3n tr\u00ean 150 s\u1ea3n ph\u1ea9m trong b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y. Khi \u0111\u00f3, c\u00fa ph\u00e1p s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=COUNTIF(C2:C11,&#8221;&gt;150&#8243;)<\/span><\/p>\n<figure id=\"attachment_265892\" aria-describedby=\"caption-attachment-265892\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265892 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-10.jpg\" alt=\"cach-dung-ham-countifs-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265892\" class=\"wp-caption-text\">\u0110\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi h\u00e0m COUNTIF<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00f3 8 \u00f4 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n n\u00e0y n\u00ean k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 8.\u00a0<\/span><\/p>\n<p><strong>L\u01b0u \u00fd:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 d\u1ea5u ch\u1ea5m h\u1ecfi (?) s\u1ebd \u0111\u1ea1i di\u1ec7n cho 1 k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 c\u00f2n d\u1ea5u sao (*) \u0111\u1ea1i di\u1ec7n cho nhi\u1ec1u \u00fd t\u1ef1 b\u1ea5t k\u1ef3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u00e0 d\u1ea5u sao ho\u1eb7c d\u1ea5u ch\u1ea5m h\u1ecfi, b\u1ea1n th\u00eam v\u00e0o tr\u01b0\u1edbc \u0111\u00f3 d\u1ea5u ~ (Ch\u1eb3ng h\u1ea1n nh\u01b0 \u201c~?\u201d, \u201c~*\u201d).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTIF trong Excel kh\u00f4ng c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa v\u1edbi ch\u1eef th\u01b0\u1eddng.\u00a0<\/span><\/li>\n<\/ul>\n<h3><b>H\u00e0m \u0111\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng COUNTA<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng gi\u1ed1ng v\u1edbi c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS hay COUNTIF, h\u00e0m COUNTA \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 trong b\u1ea3ng t\u00ednh ch\u1ee9a chu\u1ed7i ho\u1eb7c s\u1ed1 &#8211; t\u1ee9c l\u00e0 c\u00e1c \u00f4 kh\u00f4ng b\u1ecb b\u1ecf tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh \u0111\u1ebfm.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><strong>=COUNTA(value1, value2,&#8230;)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, value1, value2 l\u00e0 c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng c\u1ea7n \u0111\u1ebfm. Trong h\u00e0m COUNTA, s\u1ed1 \u00f4 t\u1ed1i \u0111a c\u00f3 th\u1ec3 \u0111\u1ebfm t\u1eeb 255.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0: B\u1ea1n c\u1ea7n bi\u1ebft s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean \u0111\u00e3 l\u00e0m b\u00e0i t\u1eadp v\u00e0o trong b\u1ea3ng th\u1ed1ng k\u00ea d\u01b0\u1edbi \u0111\u00e2y. \u0110\u01b0\u1ee3c bi\u1ebft, c\u00e1c b\u1ea1n \u0111\u00e3 l\u00e0m v\u00e0 n\u1ed9p b\u00e0i \u0111\u1ea7y \u0111\u1ee7 l\u00e0 nh\u1eefng b\u1ea1n c\u00f3 g\u1eafn li\u00ean k\u1ebft b\u00e0i t\u1eadp \u1edf c\u1ed9t &#8220;Link b\u00e0i t\u1eadp \u0111\u00e3 n\u1ed9p&#8221;.<\/span><\/p>\n<figure id=\"attachment_265893\" aria-describedby=\"caption-attachment-265893\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265893 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-11.jpg\" alt=\"cach-dung-ham-countifs-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265893\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng COUNTA<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, b\u1ea1n nh\u1eadp: =COUNTA(C2:C15) t\u1ea1i \u00f4 F2 v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd cho th\u1ea5y c\u00f3 6\/14 b\u1ea1n \u0111\u00e3 n\u1ed9p b\u00e0i t\u1eadp.<\/span><\/p>\n<h3><b>\u0110\u1ebfm \u00f4 tr\u1ed1ng v\u1edbi h\u00e0m COUNTBLANK<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng gi\u1ed1ng v\u1edbi c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS, COUNTIF v\u00e0 th\u1eadm ch\u00ed ng\u01b0\u1ee3c l\u1ea1i v\u1edbi h\u00e0m COUNTA, COUNTBLANK l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u &#8211; t\u1ee9c l\u00e0 \u00f4 tr\u1ed1ng trong ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh t\u1eeb tr\u01b0\u1edbc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTBLANK l\u00e0: <\/span><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 c\u1ea7n \u0111\u1ebfm \u00f4 tr\u1ed1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0: C\u0169ng v\u1edbi b\u1ea3ng tr\u00ean, nh\u01b0ng b\u1ea1n c\u1ea7n bi\u1ebft s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean ch\u01b0a l\u00e0m b\u00e0i t\u1eadp &#8211; t\u1ee9c l\u00e0 nh\u1eefng b\u1ea1n ch\u01b0a \u0111i\u1ec1n \u0111\u01b0\u1eddng d\u1eabn v\u00e0o h\u00e0ng C, ch\u00fang ta s\u1ebd c\u00f3 c\u00fa ph\u00e1p: <\/span><span style=\"font-weight: 400;\">=COUNTBLANK(C2:C15).\u00a0<\/span><\/p>\n<figure id=\"attachment_265894\" aria-describedby=\"caption-attachment-265894\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265894 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-12.jpg\" alt=\"cach-dung-ham-countifs-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265894\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm \u00f4 tr\u1ed1ng COUNTBLANK<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, t\u1eeb k\u1ebft qu\u1ea3 \u0111\u1ebfm b\u00ean d\u01b0\u1edbi, c\u00f3 8\/14 b\u1ea1n ch\u01b0a n\u1ed9p b\u00e0i t\u1eadp.\u00a0<\/span><\/p>\n<h2><b>M\u1ed9t s\u1ed1 l\u01b0u \u00fd c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd b\u1ea1n c\u1ea7n quan t\u00e2m khi s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m COUNTIF kh\u00f4ng c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng \u0111\u1ed1i v\u1edbi v\u0103n b\u1ea3n. V\u00ed d\u1ee5 c\u00e1c \u00f4 \u201ch\u1ecdc\u201d, \u201cH\u1eccC\u201d hay \u201cH\u1ecdc\u201d \u0111\u1ec1u s\u1ebd kh\u1edbp v\u00e0 \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS v\u00e0 COUNTIF, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t l\u00e0 d\u1ea5u sao (*) v\u00e0 d\u1ea5u h\u1ecfi (?). Trong \u0111\u00f3, d\u1ea5u ch\u1ea5m h\u1ecfi (?) \u0111\u1ea1i di\u1ec7n cho k\u00fd t\u1ef1 \u0111\u01a1n l\u1ebb, c\u00f2n d\u1ea5u sao (*) \u0111\u1ea1i di\u1ec7n cho chu\u1ed7i k\u00fd t\u1ef1 b\u1ea5t k\u1ef3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n t\u00ecm ki\u1ebfm d\u1ea5u sao hay d\u1ea5u ch\u1ea5m h\u1ecfi, b\u1ea1n c\u1ea7n nh\u1eadp k\u00fd t\u1ef1 s\u00f3ng (~) \u1edf ph\u00eda tr\u01b0\u1edbc.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu \u0111\u1ebfm v\u0103n b\u1ea3n, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n nh\u1eadp kh\u00f4ng c\u00f3 c\u00e1c kho\u1ea3ng tr\u1eafng \u1edf tr\u01b0\u1edbc v\u00e0 \u1edf sau.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean cho m\u1ed9t v\u00f9ng\/ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u1edbi h\u00e0m COUNTIF. C\u00e1ch \u0111\u1eb7t t\u00ean s\u1ebd l\u00e0: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n \u0111\u1eb7t t\u00ean &gt; Click chu\u1ed9t ph\u1ea3i &gt; Ch\u1ecdn m\u1ee5c Define Nam &gt; Nh\u1eadp t\u00ean v\u00f9ng d\u1eef li\u1ec7u v\u00e0o \u00f4 Name &gt; Nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n t\u1ea5t. Ngo\u00e0i ra, b\u1ea1n c\u00f2n \u0111\u01b0\u1ee3c ph\u00e9p thay th\u1ebf ph\u1ea1m vi v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh t\u00ean c\u1ee7a ph\u1ea1m vi \u0111\u00e3 \u0111\u1eb7t b\u00ean trong c\u00fa ph\u00e1p.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u1ea1m vi t\u00ean c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong c\u00f9ng m\u1ed9t trang t\u00ednh ho\u1eb7c gi\u1eefa 2 trang t\u00ednh kh\u00e1c nhau, trong c\u00f9ng sheet l\u00e0m vi\u1ec7c ho\u1eb7c trong sheet l\u00e0m vi\u1ec7c kh\u00e1c v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu qua l\u1ea1i v\u1edbi nhau, mi\u1ec5n l\u00e0 c\u1ea3 2 s\u1ed5 l\u00e0m vi\u1ec7c c\u00f9ng \u0111\u01b0\u1ee3c m\u1edf.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_265895\" aria-describedby=\"caption-attachment-265895\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-dung-ham-countifs-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-265895 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-13.jpg\" alt=\"cach-dung-ham-countifs-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-265895\" class=\"wp-caption-text\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u1ea1m vi c\u00f3 t\u00ean v\u1edbi h\u00e0m COUNTIF<\/figcaption><\/figure>\n<h2><b>L\u1eddi k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Qua b\u00e0i vi\u1ebft tr\u00ean, ngo\u00e0i c\u00e1ch d\u00f9ng COUNTIFS, <\/span><span style=\"font-weight: 400;\">Ho\u00e0ng H\u00e0 Mobile<\/span><span style=\"font-weight: 400;\"> \u0111\u00e3 chia s\u1ebb th\u00eam m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm kh\u00e1c trong Excel \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 \u00e1p d\u1ee5ng trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p ri\u00eang bi\u1ec7t. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd h\u1eefu \u00edch v\u00e0 \u0111\u1eebng qu\u00ean chia s\u1ebb \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi c\u00f9ng \u0111\u00f3n \u0111\u1ecdc nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Xem th\u00eam<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tinh-tong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh t\u1ed5ng trong Excel nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-so-ngay-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m trong Excel<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. Tuy nhi\u00ean, h\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi th\u01b0\u1eddng s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n khi m\u1edbi t\u1eadp l\u00e0m quen v\u1edbi h\u00e0m n\u00e0y. Th\u1ea5u hi\u1ec3u \u0111i\u1ec1u \u0111\u00f3, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS \u0111\u1ec3 \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n, [&hellip;]<\/p>\n","protected":false},"author":97,"featured_media":265882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-263299","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 d\u00f9ng h\u00e0m COUNTIF trong Excel chi ti\u1ebft nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!\" \/>\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\/cach-dung-ham-countifs\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel\" \/>\n<meta property=\"og:description\" content=\"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\" \/>\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=\"2023-10-05T13:58:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.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\/cach-dung-ham-countifs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\"},\"headline\":\"C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel\",\"datePublished\":\"2023-10-05T13:58:34+00:00\",\"dateModified\":\"2023-10-05T13:58:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\"},\"wordCount\":3114,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\",\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m COUNTIF trong Excel chi ti\u1ebft nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg\",\"datePublished\":\"2023-10-05T13:58:34+00:00\",\"dateModified\":\"2023-10-05T13:58:34+00:00\",\"description\":\"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-dung-ham-countifs\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#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 d\u00f9ng h\u00e0m 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\/8bdc637e22d0dfe8143434576119c189\",\"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 d\u00f9ng h\u00e0m COUNTIF trong Excel chi ti\u1ebft nh\u1ea5t","description":"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!","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\/cach-dung-ham-countifs\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel","og_description":"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-05T13:58:34+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.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\/cach-dung-ham-countifs\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189"},"headline":"C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel","datePublished":"2023-10-05T13:58:34+00:00","dateModified":"2023-10-05T13:58:34+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/"},"wordCount":3114,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/","name":"C\u00e1ch d\u00f9ng h\u00e0m COUNTIF trong Excel chi ti\u1ebft nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg","datePublished":"2023-10-05T13:58:34+00:00","dateModified":"2023-10-05T13:58:34+00:00","description":"COUNTIFS l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng h\u00e0m COUNTIFS qua b\u00e0i vi\u1ebft sau!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-dung-ham-countifs.jpg","width":1200,"height":628,"caption":"cach-dung-ham-countifs"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-dung-ham-countifs\/#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 d\u00f9ng h\u00e0m 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\/8bdc637e22d0dfe8143434576119c189","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\/263299","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=263299"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/263299\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/265882"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=263299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=263299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=263299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}