{"id":23874,"date":"2021-05-04T15:17:10","date_gmt":"2021-05-04T08:17:10","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23874"},"modified":"2021-05-04T15:17:10","modified_gmt":"2021-05-04T08:17:10","slug":"ham-countif-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-countif-trong-google-sheets\/","title":{"rendered":"M\u1ecdi \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 H\u00e0m Countif trong Google Sheets"},"content":{"rendered":"

H\u00e0m Countif trong Google Sheets<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m Countif l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m IF v\u00e0 h\u00e0m COUNT.
\nD\u01b0\u1edbi \u0111\u00e2y l\u00e0 chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Google Sheets<\/strong> nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m Countif trong Google Sheets<\/strong><\/h2>\n

H\u00e0m Countif trong Google Sheets<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=COUNTIF(range, criterion)<\/strong><\/p>\n

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

\u2013 Range<\/strong>: l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm \u00f4, gi\u00e1 tr\u1ecb.<\/p>\n

\u2013 criterion:<\/strong>\u00a0l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb trong d\u1ea3i, ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u00e3 cho. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0:<\/p>\n

    \n
  • Gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n
  • Chu\u1ed7i v\u0103n b\u1ea3n, ch\u1eb3ng h\u1ea1n nh\u01b0 \u201d Ben Computer\u201d.<\/li>\n
  • Tham chi\u1ebfu \u00f4 (ch\u1eb3ng h\u1ea1n nh\u01b0 A1 ho\u1eb7c B1).<\/li>\n
  • Bi\u1ec3u th\u1ee9c, ch\u1eb3ng h\u1ea1n nh\u01b0 \u201c=100\u201d ho\u1eb7c \u201c>100\u201d ho\u1eb7c \u201c<100\u201d. L\u01b0u \u00fd, trong tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea7u ti\u00ean hay tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb b\u1eb1ng, ch\u00fang ta kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u \u201c=\u201d v\u00e0 c\u00f3 th\u1ec3 \u0111\u1eb7t gi\u00e1 tr\u1ecb trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/li>\n<\/ul>\n

    \u2013 Tham s\u1ed1 range c\u00f3 th\u1ec3 l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

    + N\u1ebfu tham s\u1ed1 range ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 th\u00ec trong ph\u1ea7n ti\u00eau ch\u00ed ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh (>, <, =).<\/p>\n

    Cho v\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh \u0111\u1ea1t s\u1ed1 \u0111i\u1ec3m tr\u00ean 75 \u0111i\u1ec3m, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u201c>75\u201d l\u00e0m ti\u00eau ch\u00ed. H\u00e0m countif s\u1ebd ki\u1ec3m tra t\u1eebng gi\u00e1 tr\u1ecb trong ph\u1ea1m vi cho ti\u00eau ch\u00ed n\u00e0y. Ngo\u00e0i ra c\u1ea7n l\u01b0u \u00fd, khi s\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh v\u1edbi m\u1ed9t s\u1ed1, ch\u00fang ta ph\u1ea3i \u0111\u1eb7t c\u1ea3 to\u00e1n t\u1eed v\u00e0 gi\u00e1 tr\u1ecb n\u00e0y trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/p>\n

    + N\u1ebfu tham s\u1ed1 range ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n, ti\u00eau ch\u00ed c\u00f3 th\u1ec3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p ho\u1eb7c c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

    \"H\u00e0m
    H\u00e0m Countif trong Google Sheets<\/figcaption><\/figure>\n

    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Google Sheets<\/strong><\/h2>\n

    H\u00e0m Countif trong Google Sheets<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 duy nh\u1ea5t.<\/p>\n

    \u2013 Ph\u1ea7n If c\u1ee7a h\u00e0m cung c\u1ea5p c\u00e1c ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n c\u1ea7n th\u1ecfa m\u00e3n cho c\u00e1c \u00f4 ho\u1eb7c d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u1ebfm.<\/p>\n

    \u2013 Ph\u1ea7n Count \u0111\u1ebfm t\u1ed5ng s\u1ed1 \u00f4 \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, \u0111\u01b0a ra.<\/p>\n

    \u0110\u1ec3 h\u00ecnh dung c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Google Sheets nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    V\u00ed d\u1ee5 1<\/strong><\/h3>\n

    Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng danh s\u00e1ch \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh trong l\u1edbp h\u1ecdc. Y\u00eau c\u1ea7u \u0111\u01b0a ra \u1edf \u0111\u00e2y l\u00e0 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh \u0111\u1ea1t tr\u00ean 75 \u0111i\u1ec3m tr\u1edf l\u00ean.<\/p>\n

    \"1<\/p>\n

    C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c Countif m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 h\u1ecdc sinh \u0111\u1ea1t tr\u00ean 75 \u0111i\u1ec3m tr\u1edf l\u00ean c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    =COUNTIF($B$2:$B$14,\u201d>75\u2033)<\/strong><\/p>\n

    \"2<\/p>\n

    L\u01b0u \u00fd:<\/strong><\/p>\n

    \u2013 \u0110i\u1ec1u ki\u1ec7n c\u1ea7n ch\u00fang ta ph\u1ea3i \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/p>\n

    \u2013 Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ti\u00eau ch\u00ed trong m\u1ed9t \u00f4 v\u00e0 s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 \u0111\u00f3. Ch\u1eb3ng h\u1ea1n, n\u1ebfu ti\u00eau ch\u00ed l\u00e0 \u00f4 C2, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =COUNTIF($B$2:$B$14,\u201d>\u201d&C2)<\/strong>. C\u1ea7n l\u01b0u \u00fd, khi s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 ch\u00fang ta v\u1eabn ph\u1ea3i s\u1eed d\u1ee5ng to\u00e1n t\u1eed trong d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0 s\u1eed d\u1ee5ng & \u0111\u1ec3 n\u1ed1i v\u1edbi tham chi\u1ebfu \u00f4.<\/p>\n

    V\u00ed d\u1ee5 2<\/strong><\/h3>\n

    Cho b\u1ea3ng t\u00ednh Google Sheets nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y, y\u00eau c\u1ea7u l\u00e0 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi giao d\u1ecbch c\u1ee7a US.<\/p>\n

    \"3<\/p>\n

    C\u00f4ng th\u1ee9c h\u00e0m Countif<\/strong> ch\u00fang ta s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    \"4<\/p>\n

    L\u01b0u \u00fd:<\/strong><\/p>\n

    \u2013 V\u00ec tham s\u1ed1 criterion l\u00e0 v\u0103n b\u1ea3n n\u00ean ch\u00fang ta kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u b\u1eb1ng (=). Trong v\u00ed d\u1ee5 n\u00e0y, \u0111i\u1ec1u ki\u1ec7n l\u00e0 US n\u00ean ch\u00fang ta ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng \u201cUS\u201d.<\/p>\n

    \u2013 Ngo\u00e0i ra ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4. V\u00ed d\u1ee5, n\u1ebfu ti\u00eau ch\u00ed n\u1eb1m trong \u00f4 D2, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c l\u00e0: =COUNTIF($B$2:$B$13,D2)<\/strong>.<\/p>\n

    V\u00ed d\u1ee5 3<\/strong><\/h3>\n

    Cho b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y, nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng trong v\u00f9ng, ph\u1ea1m vi d\u1eef li\u1ec7u cho tr\u01b0\u1edbc.<\/p>\n

    \"5
    \nTrong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c h\u00e0m Countif trong Google Sheets<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    =COUNTIF($C$2:$C$13,\u201c\u201d)<\/strong><\/p>\n

    \"6<\/p>\n

    Trong v\u00ed d\u1ee5 tr\u00ean, ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0 d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u201d. Khi ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c k\u00e9p l\u00e0m ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n, h\u00e0m Countif ch\u1ec9 \u0111\u1ebfm nh\u1eefng \u00f4 tr\u1ed1ng trong b\u1ea3ng t\u00ednh.<\/p>\n

    C\u00f3 m\u1ed9t l\u01b0u \u00fd nh\u1ecf l\u00e0 h\u00e0m ch\u1ec9 \u0111\u1ebfm \u00f4 tr\u1ed1ng ch\u1ee9 kh\u00f4ng \u0111\u1ebfm nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng, d\u1ea5u c\u00e1ch.<\/p>\n

    V\u00ed d\u1ee5 4<\/strong><\/h3>\n

    L\u1ea5y c\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u trong v\u00ed d\u1ee5 3 \u1edf tr\u00ean, trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Countif<\/strong> \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb, kh\u00f4ng ph\u1ea3i l\u00e0 \u00f4 tr\u1ed1ng.<\/p>\n

    C\u00f4ng th\u1ee9c h\u00e0m Countif<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    =COUNTIF($C$2:$C$13,\u201c<>\u201d)<\/strong><\/p>\n

    \"7<\/p>\n

    Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta s\u1eed d\u1ee5ng ti\u00eau ch\u00ed \u201c<>\u201d (kh\u00f4ng ch\u1ee9a d\u1ea5u b\u1eb1ng). H\u00e0m Countif<\/strong> s\u1ebd hi\u1ec3u l\u00e0 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng ph\u1ea3i \u00f4 tr\u1ed1ng.<\/p>\n

    \u0110\u1ebfn \u0111\u00e2y ch\u1eafc b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Countif trong Google Sheets<\/strong>. Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 chia s\u1ebb \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh cho Ben Computer trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft.<\/p>\n","protected":false},"excerpt":{"rendered":"

    H\u00e0m Countif trong Google Sheets \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 \u0111\u00e1p \u1ee9ng c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m Countif l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m IF v\u00e0 h\u00e0m COUNT. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 chi ti\u1ebft c\u00fa ph\u00e1p, […]<\/p>\n","protected":false},"author":39,"featured_media":23876,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-23874","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=23874"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23874\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/23876"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=23874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=23874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=23874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}