{"id":19366,"date":"2023-12-05T13:22:48","date_gmt":"2023-12-05T13:22:48","guid":{"rendered":"https:\/\/masterskills.org\/blog\/so-tay-cach-dung-ham-countif-trong-excel-cho-nguoi-moi-chi-tiet.html"},"modified":"2023-12-22T04:49:43","modified_gmt":"2023-12-21T21:49:43","slug":"so-tay-cach-dung-ham-countif-trong-excel-cho-nguoi-moi-chi-tiet","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/so-tay-cach-dung-ham-countif-trong-excel-cho-nguoi-moi-chi-tiet.html","title":{"rendered":"S\u1ed5 Tay C\u00e1ch D\u00f9ng H\u00e0m Countif Trong Excel Cho Ng\u01b0\u1eddi M\u1edbi Chi Ti\u1ebft"},"content":{"rendered":"
\n

S\u1ed5 Tay C\u00e1ch D\u00f9ng H\u00e0m COUNTIF Trong Excel Cho Ng\u01b0\u1eddi M\u1edbi Chi Ti\u1ebft<\/strong><\/h1>\n

Vi\u1ec7c t\u00ecm hi\u1ec3u v\u00e0 thu\u1ed9c n\u1eb1m l\u00f2ng c\u00f4ng th\u1ee9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong Excel l\u00e0 \u0111i\u1ec1u c\u1ea7n thi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ph\u1ea7n m\u1ec1m n\u00e0y m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i c\u00e1c h\u00e0m t\u00ednh th\u00f4ng d\u1ee5ng, <\/span><\/em>COUNTIF <\/em><\/strong>c\u0169ng l\u00e0 t\u00ean h\u00e0m c\u1ea7n thi\u1ebft cho qu\u00e1 tr\u00ecnh \u0111\u1ebfm \u0111\u1ed1i t\u01b0\u1ee3ng, d\u1eef li\u1ec7u c\u00f3 trong b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y chia s\u1ebb chi ti\u1ebft th\u00f4ng tin v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, c\u00f9ng <\/span><\/em>Masterskills<\/span><\/em> kh\u00e1m ph\u00e1 ngay. <\/span><\/em><\/p>\n

\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m COUNTIF trong Excel<\/strong><\/h2>\n

H\u00e0m <\/span>COUNTIF<\/strong>, <\/span>h\u00e0m Count, h\u00e0m \u0111\u1ebfm trong Excel <\/strong>\u0111\u1ec1u l\u00e0 nh\u1eefng h\u00e0m n\u00ean ghi nh\u1edb b\u1edfi c\u00f4ng d\u1ee5ng m\u00e0 c\u00e1c lo\u1ea1i h\u00e0m tr\u00ean mang l\u1ea1i trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u l\u00e0 r\u1ea5t \u0111\u00e1ng k\u1ec3. <\/span><\/p>\n

C\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m \u0111\u1ebfm trong Excel<\/strong><\/h3>\n

H\u00e0m <\/span>COUNTIF<\/strong> trong Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. \u0110i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh nh\u01b0 “=”, “>”, “<“, “>=”, “<=”, “<>” ho\u1eb7c c\u00e1c bi\u1ec3u th\u1ee9c ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0 “*” ho\u1eb7c “?”. <\/span><\/p>\n

C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb nh\u01b0 sau:<\/span><\/p>\n

=COUNTIF(range;criteria)<\/em><\/strong><\/p>\n

Trong \u0111\u00f3: <\/span><\/p>\n

    \n<\/ul>\n

    : <\/span>C\u00e1ch l\u00e0m CV b\u1eb1ng Word 2010, 2016 \u0111\u01a1n gi\u1ea3n, chuy\u00ean nghi\u1ec7p<\/span><\/p>\n

    V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/strong><\/h3>\n

    V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 gi\u00e1 b\u00e1n l\u1edbn h\u01a1n 100 trong ph\u1ea1m vi D5:D12, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n

    \n

    V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 h\u00e0m COUNTIF (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    Th\u1ebf n\u00e0o l\u00e0 h\u00e0m \u0111\u1ebfm 1 \u0111i\u1ec1u ki\u1ec7n v\u00e0 h\u00e0m \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?<\/strong><\/h2>\n

    H\u00e0m Count, h\u00e0m \u0111\u1ebfm trong Excel <\/strong>hay <\/span>h\u00e0m COUNTIF<\/strong> \u0111\u1ec1u \u0111\u01b0\u1ee3c xem l\u00e0 h\u00e0m \u0111\u1ebfm trong Excel, b\u1ea1n c\u1ea7n t\u00ecm hi\u1ec3u v\u00e0 ph\u00e2n bi\u1ec7t r\u00f5 r\u00e0ng hai lo\u1ea1i h\u00e0m \u0111\u1ebfm sau: <\/span><\/p>\n

    H\u00e0m \u0111\u1ebfm 1 \u0111i\u1ec1u ki\u1ec7n – h\u00e0m COUNTIF<\/strong><\/h3>\n

    H\u00e0m COUNTIF<\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n s\u1ed1 l\u01b0\u1ee3ng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m tr\u00ean 8, \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m \u0111\u00e3 b\u00e1n \u0111\u01b0\u1ee3c trong th\u00e1ng n\u00e0y v\u00e0 nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c. <\/span><\/p>\n

    \u01afu \u0111i\u1ec3m c\u1ee7a h\u00e0m COUNTIF \u0111\u00f3 l\u00e0 t\u00ednh linh ho\u1ea1t v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng gi\u00fap ng\u01b0\u1eddi d\u00f9ng \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p.<\/span><\/p>\n

    : <\/span>H\u01b0\u1edbng D\u1eabn C\u00e1ch D\u00f9ng H\u00e0m Sumifs Chi Ti\u1ebft C\u1ef1c \u0110\u01a1n Gi\u1ea3n V\u00e0 D\u1ec5 Hi\u1ec3u<\/span><\/p>\n

    H\u00e0m \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n – h\u00e0m COUNTIFS<\/strong><\/h3>\n

    H\u00e0m COUNTIFS trong Excel l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COUNTIFS nh\u01b0 sau:<\/span><\/p>\n

    =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)<\/em><\/strong><\/p>\n

    Trong \u0111\u00f3:<\/span><\/p>\n

      \n<\/ul>\n

      V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c sau \u0111\u00e2y cho s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c h\u01a1n 5 n\u0103m trong b\u1ed9 ph\u1eadn t\u00e0i ch\u00ednh. \u0110\u1ec3 t\u00ecm s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean c\u00f3 th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c \u00edt h\u01a1n ho\u1eb7c b\u1eb1ng 6 n\u0103m trong b\u1ed9 ph\u1eadn t\u00e0i ch\u00ednh:<\/span><\/p>\n

      =COUNTIFS(B4:B15,”Finance”,C4:C15,”<=6″).<\/em><\/strong><\/p>\n

      H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong ph\u1ea1m vi B4:B15 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n “th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c h\u01a1n 5 n\u0103m” v\u00e0 \u0111\u1ed3ng th\u1eddi th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n “th\u00e2m ni\u00ean l\u00e0m vi\u1ec7c \u00edt h\u01a1n ho\u1eb7c b\u1eb1ng 6 n\u0103m” trong ph\u1ea1m vi C4:C15.<\/span><\/p>\n

      \u0110i\u1ec3m n\u1ed5i b\u1eadt c\u1ee7a h\u00e0m COUNTIFS l\u00e0 cho ph\u00e9p \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi th\u1ecfa m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau, t\u1eeb \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng linh ho\u1ea1t trong vi\u1ec7c \u0111\u1ebfm v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, t\u1ea1o ra n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c c\u00f3 hi\u1ec7u qu\u1ea3 cao h\u01a1n.<\/span><\/p>\n

      <\/span><\/p>\n

      V\u00ed d\u1ee5 v\u1ec1 h\u00e0m COUNITFS – h\u00e0m \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

      : <\/span>Nh\u1eefng \u0110i\u1ec1u B\u1ea1n N\u00ean Bi\u1ebft V\u1ec1 H\u00e0m Vlookup V\u00e0 C\u00e1ch S\u1eed D\u1ee5ng Chi Ti\u1ebft<\/span><\/p>\n

      M\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm th\u00f4ng d\u1ee5ng trong Excel<\/strong><\/h2>\n

      Ngo\u00e0i <\/span>h\u00e0m Count, h\u00e0m \u0111\u1ebfm trong Excel <\/strong>hay <\/span>h\u00e0m COUNTIF <\/strong>l\u00e0 c\u00e1c h\u00e0m \u0111\u1ebfn th\u01b0\u1eddng g\u1eb7p, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ebfm kh\u00e1c c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 \u0111\u1ec3 gi\u00fap cho vi\u1ec7c \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng, d\u1eef li\u1ec7u,… trong Excel nh\u01b0 sau:<\/span><\/p>\n

      H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng h\u00e0m \u0111\u1ebfm COUNTA<\/strong><\/h3>\n

      H\u00e0m COUNTA trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u. H\u00e0m COUNTA kh\u00f4ng \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng trong ph\u1ea1m vi. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTA nh\u01b0 sau:<\/span><\/p>\n

      =COUNTA(value1, [value2], …)<\/em><\/strong><\/p>\n

      Trong \u0111\u00f3:<\/span><\/p>\n

        \n<\/ul>\n

        =COUNTA(A1:A10)<\/em><\/strong><\/p>\n

        H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong ph\u1ea1m vi A1:A10 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u (bao g\u1ed3m c\u1ea3 d\u1eef li\u1ec7u v\u0103n b\u1ea3n, s\u1ed1, v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb logic TRUE\/FALSE)<\/span><\/p>\n

        N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong nhi\u1ec1u ph\u1ea1m vi kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1 value2, value3,… \u0111\u1ec3 th\u00eam c\u00e1c ph\u1ea1m vi kh\u00e1c v\u00e0o c\u00f4ng th\u1ee9c COUNTA nh\u01b0 sau:<\/span><\/p>\n

        =COUNTA(A1:A10, B1:B10, C1:C10).<\/em><\/strong><\/p>\n

        H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong c\u00e1c ph\u1ea1m vi A1:A10, B1:B10 v\u00e0 C1:C10.<\/span><\/p>\n

        <\/span><\/p>\n

        C\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5 v\u1ec1 h\u00e0m COUNTA (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

        \n\u00a0<\/p>\n

        H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng h\u00e0m \u0111\u1ebfm COUNTBLANK<\/strong><\/h3>\n

        H\u00e0m COUNTBLANK l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n trong Microsoft Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng (kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 gi\u00e1 tr\u1ecb r\u1ed7ng “”) trong m\u1ed9t ph\u1ea1m vi \u00f4. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTBLANK nh\u01b0 sau:<\/span><\/p>\n

        =COUNTBLANK(range)<\/em><\/strong><\/p>\n

        Trong \u0111\u00f3:<\/span><\/p>\n

          \n<\/ul>\n

          V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng trong ph\u1ea1m vi A1:A10, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n

          =COUNTBLANK(A1:A10).<\/em><\/strong><\/p>\n

          N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng trong nhi\u1ec1u ph\u1ea1m vi kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c ph\u1ea1m vi b\u1eb1ng to\u00e1n t\u1eed d\u1ea5u ph\u1ea9y “,” ho\u1eb7c to\u00e1n t\u1eed d\u1ea5u ch\u1ea5m ph\u1ea9y “;”.<\/span><\/p>\n

          \n

          V\u00ed d\u1ee5 v\u1ec1 h\u00e0m COUNTBLANK (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

          :<\/span><\/p>\n

          H\u01b0\u1edbng D\u1eabn C\u00e1ch T\u1ea1o Gmail M\u1edbi Tr\u00ean M\u00e1y T\u00ednh, \u0110i\u1ec7n Tho\u1ea1i D\u1ec5 D\u00e0ng<\/span><\/p>\n

          Email marketing l\u00e0 g\u00ec? C\u00e1ch email marketing hi\u1ec7u qu\u1ea3<\/span><\/p>\n

          H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng h\u00e0m COUNTIF trong c\u00e1c chu\u1ed7i \u00f4<\/strong><\/h2>\n

          Khi s\u1eed d\u1ee5ng <\/span>h\u00e0m COUNTIF<\/strong> trong c\u00e1c chu\u1ed7i \u00f4, b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm, c\u00f9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n m\u00e0 c\u00e1c \u00f4 \u0111\u00f3 ph\u1ea3i th\u1ecfa m\u00e3n, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n

            \n<\/ul>\n

            \n

            C\u00e1ch s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m COUNTIF (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

            Nh\u1eefng \u0111i\u1ec1u \u0111\u00e1ng l\u01b0u \u00fd khi d\u00f9ng h\u00e0m COUNTIF trong Excel<\/strong><\/h2>\n

            Vi\u1ec7c s\u1eed d\u1ee5ng <\/span>h\u00e0m COUNTIF <\/strong>trong Excel c\u0169ng c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u nh\u01b0 sau:<\/span><\/p>\n

              \n<\/ul>\n

              <\/span><\/p>\n

              C\u00e1c l\u01b0u \u00fd khi d\u00f9ng h\u00e0m COUNTIF trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

              Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c th\u00f4ng tin xoay quanh <\/span><\/em>h\u00e0m COUNTIF <\/em><\/strong>v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y chi ti\u1ebft. Hy v\u1ecdng sau khi \u0111\u1ecdc xong, b\u1ea1n s\u1ebd bi\u1ebft th\u00eam \u0111\u01b0\u1ee3c nhi\u1ec1u tips hay khi \u00e1p d\u1ee5ng nh\u1eefng h\u00e0m t\u00ednh trong Excel. \u0110\u1eebng qu\u00ean truy c\u1eadp <\/span><\/em>Masterskills<\/span><\/em> \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00f4ng tin v\u1ec1 c\u00e1c thao t\u00e1c v\u1edbi nh\u1eefng c\u00f4ng c\u1ee5 tr\u1ee3 gi\u00fap c\u00f4ng vi\u1ec7c kh\u00e1c. <\/span><\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

              S\u1ed5 Tay C\u00e1ch D\u00f9ng H\u00e0m COUNTIF Trong Excel Cho Ng\u01b0\u1eddi M\u1edbi Chi Ti\u1ebft Vi\u1ec7c t\u00ecm hi\u1ec3u v\u00e0 thu\u1ed9c n\u1eb1m l\u00f2ng c\u00f4ng th\u1ee9c c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong Excel l\u00e0 \u0111i\u1ec1u c\u1ea7n thi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ph\u1ea7n m\u1ec1m n\u00e0y m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i c\u00e1c h\u00e0m t\u00ednh th\u00f4ng d\u1ee5ng, COUNTIF c\u0169ng […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19366"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19366"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19366\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}