{"id":24372,"date":"2021-05-11T11:28:09","date_gmt":"2021-05-11T04:28:09","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24372"},"modified":"2021-05-11T11:28:09","modified_gmt":"2021-05-11T04:28:09","slug":"ham-counta-tren-google-sheets","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-counta-tren-google-sheets\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA tr\u00ean Google Sheets"},"content":{"rendered":"<p><strong>H\u00e0m Counta<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01a1n gi\u1ea3n v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t tr\u00ean Google Sheets. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta tr\u00ean Google Sheets<\/strong>.<\/p>\n<figure id=\"attachment_24373\" aria-describedby=\"caption-attachment-24373\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" class=\"wp-image-24373 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-counta-tren-google-sheets.jpg\" alt=\"H\u00e0m Counta tr\u00ean Google Sheets\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-counta-tren-google-sheets.jpg 800w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-counta-tren-google-sheets-300x169.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-counta-tren-google-sheets-768x432.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-counta-tren-google-sheets-750x422.jpg 750w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption id=\"caption-attachment-24373\" class=\"wp-caption-text\">H\u00e0m Counta tr\u00ean Google Sheets<\/figcaption><\/figure>\n<h2><strong>C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c h\u00e0m Counta tr\u00ean Google Sheets<\/strong><\/h2>\n<p><strong>H\u00e0m Counta tr\u00ean Google Sheets<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 d\u1ea1ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=COUNTA(value1, [value2, \u2026])<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>\u2013 Value 1:<\/strong>\u00a0l\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi c\u00e1c \u00f4 c\u1ea7n \u0111\u1ebfm.<\/p>\n<p><strong>\u2013 Value 2, Value 3, \u2026<\/strong>. (tham s\u1ed1 t\u00f9y ch\u1ecdn, gi\u00e1 tr\u1ecb t\u1ed1i \u0111a l\u00e0 30): l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb b\u1ed5 sung.<\/p>\n<p>C\u00e1c gi\u00e1 tr\u1ecb tham s\u1ed1 c\u00f3 th\u1ec3 l\u00e0:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb.<\/li>\n<li>Tham chi\u1ebfu \u00f4.<\/li>\n<li>Ph\u1ea1m vi, d\u1ea3i c\u00e1c \u00f4.<\/li>\n<li>D\u1ea3i c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean.<\/li>\n<\/ul>\n<h2><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta tr\u00ean Google Sheets<\/strong><\/h2>\n<p>\u0110\u1ec3 d\u1ec5 h\u00ecnh dung <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta tr\u00ean Google Sheets<\/strong> 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<p>Cho b\u1ea3ng t\u00ednh d\u01b0\u1edbi \u0111\u00e2y ch\u1ee9a d\u1eef li\u1ec7u doanh s\u1ed1 b\u00e1n h\u00e0ng c\u00e1c lo\u1ea1i \u0111\u1ed3 u\u1ed1ng trong th\u00e1ng 8.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"155\" class=\"aligncenter wp-image-16603 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-6.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-6-300x74.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-6.jpg 632w\" alt=\"1 6 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA tr\u00ean Google Sheets - Ben Computer\" \/><\/p>\n<p>C\u1ed9t D ch\u1ee9a c\u00f4ng th\u1ee9c, h\u00e0m Counta \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 c\u1ed9t E ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 h\u00e0m Google Sheets t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p>C\u00f4ng th\u1ee9c h\u00e0m Counta m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y c\u00f3 d\u1ea1ng:<\/p>\n<p><strong>=COUNTA(5600,\u201dNot Available\u201d,7720,6070,3540,\u201dNot Available\u201d,8000)<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean h\u00e0m Counta \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb 5600, 7720, 6070,3540, 8000 v\u00e0 \u201cNot Available\u201d. H\u00e0m Choose \u0111\u1ebfm c\u1ea3 gi\u00e1 tr\u1ecb \u201cNot Available\u201d 2 l\u1ea7n, m\u1eb7c d\u00f9 gi\u00e1 tr\u1ecb n\u00e0y l\u00e0 gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 7.<\/p>\n<p>Ti\u1ebfp theo c\u00f4ng th\u1ee9c trong \u00f4 D2:<\/p>\n<p><strong>=COUNTA(5600,7720,6070,3540,8000)<\/strong><\/p>\n<p>\u1ede \u0111\u00e2y h\u00e0m Counta \u0111\u1ebfm c\u00e1c s\u1ed1 5600, 7720, 6070,3540, 8000 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 7.<\/p>\n<p>C\u00f4ng th\u1ee9c Google Sheets trong \u00f4 D4 l\u00e0:<\/p>\n<p><strong>=COUNTA(C2:C8)<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Counta \u0111\u1ebfm c\u1ea3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n t\u1eeb C2 \u0111\u1ebfn C8 v\u00e0 c\u0169ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 7.<\/p>\n<p>Ti\u1ebfp theo c\u00f4ng th\u1ee9c trong \u00f4 D5:<\/p>\n<p><strong>=COUNTA(B2:B8)<\/strong><\/p>\n<p>\u00d4 D5 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y trong ph\u1ea1m vi t\u1eeb \u00f4 B2 \u0111\u1ebfn B8. C\u1ed9t B \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 ng\u00e0y th\u00e1ng v\u00e0 h\u00e0m Counta th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, tr\u1ea3 v\u1ec1 t\u1ed5ng l\u00e0 7.<\/p>\n<p>Cu\u1ed1i c\u00f9ng, c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng trong \u00f4 D6 l\u00e0:<\/p>\n<p><strong>=COUNTA(A2:A8)<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb A2 \u0111\u1ebfn A8. C\u00e1c \u00f4 t\u1eeb A2 \u0111\u1ebfn A8 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, v\u00e0 ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta Google Sheets. K\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 l\u00e0 7.<\/p>\n<h2><strong>H\u00e0m Counta x\u1eed l\u00fd c\u00e1c \u00f4 tr\u1ed1ng trong b\u1ea3ng t\u00ednh<\/strong><\/h2>\n<p>Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda c\u00e1ch <strong>h\u00e0m Counta Google Sheets<\/strong> x\u1eed l\u00fd c\u00e1c \u00f4 b\u1ea3ng t\u00ednh tr\u1ed1ng, kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"232\" class=\"aligncenter wp-image-16604 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-6.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-6-300x110.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-6.jpg 632w\" alt=\"2 6 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA tr\u00ean Google Sheets - Ben Computer\" \/><\/p>\n<p>Trong b\u1ea3ng t\u00ednh ch\u1ee9a m\u1ed9t s\u1ed1 chu\u1ed7i tr\u1ed1ng (\u201d \u201c), d\u1ea5u nh\u00e1y \u0111\u01a1n (\u2018), d\u1ea5u nh\u00e1y k\u00e9p (\u201c) v\u00e0 gi\u00e1 tr\u1ecb tr\u1ed1ng trong c\u00e1c \u00f4 A2 \u0111\u1ebfn A9. C\u1ed9t B ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t A \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 b\u1eb1ng v\u0103n b\u1ea3n. C\u1ed9t C ch\u1ee9a c\u00e1c c\u00f4ng th\u1ee9c, h\u00e0m Counta Google Sheets \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 c\u1ed9t D l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1.<\/p>\n<p><strong>=COUNTA(A2:A9)<\/strong><\/p>\n<p>H\u00e0m Counta \u0111\u1ebfm c\u00e1c chu\u1ed7i tr\u1ed1ng (\u201d \u201c), d\u1ea5u ngo\u1eb7c k\u00e9p (\u201d \u201c) v\u00e0 nh\u00e1y \u0111\u01a1n (\u2018) t\u1eeb c\u00e1c \u00f4 A2 \u0111\u1ebfn A9 nh\u01b0ng b\u1ecf qua c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ed1ng bao g\u1ed3m A4 v\u00e0 A7. H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 6 trong \u00f4 D2.<\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng Counta tr\u00ean Google Sheets<\/strong><\/h2>\n<ul>\n<li><strong>H\u00e0m Counta trong Google Sheets<\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1, ng\u00e0y, c\u00f4ng th\u1ee9c, bi\u1ec3u th\u1ee9c logic, v\u0103n b\u1ea3n, l\u1ed7i, \u2026 .<\/li>\n<li>H\u00e0m Counta c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a d\u1ea5u nh\u00e1y \u0111\u01a1n (\u2018) m\u00e0 kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u n\u00e0o kh\u00e1c. Google coi v\u0103n b\u1ea3n theo sau d\u1ea5u (\u2018) l\u00e0 v\u0103n b\u1ea3n.<\/li>\n<li>Ngo\u00e0i ra h\u00e0m Google Sheets n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a c\u00e1c chu\u1ed7i (\u201d \u201c) tr\u1ed1ng.<\/li>\n<li>V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m Counta v\u00e0 h\u00e0m Count \u0111\u1ec1u gi\u1ed1ng nhau, ch\u1ec9 c\u00f3 \u0111i\u1ec1u h\u00e0m Counta c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n trong b\u1ea3ng t\u00ednh c\u00f2n h\u00e0m Count th\u00ec kh\u00f4ng.<\/li>\n<li>Khi ch\u00fang ta thay \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb, n\u1ed9i dung trong d\u1ea3i, ph\u1ea1m vi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m tham s\u1ed1 h\u00e0m Counta, Google Sheets s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 t\u00ednh to\u00e1n l\u1ea1i k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<p>Hy v\u1ecdng sau b\u00e0i vi\u1ebft m\u00e0 Ben Computer gi\u1edbi thi\u1ec7u tr\u00ean \u0111\u00e2y, b\u1ea1n \u0111\u1ecdc s\u1ebd bi\u1ebft <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta tr\u00ean Google Sheets<\/strong> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean trang \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-left-trong-excel-google-sheets\/\">h\u00e0m Left Google Sheets<\/a> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Counta l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01a1n gi\u1ea3n v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t tr\u00ean Google Sheets. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Counta tr\u00ean Google Sheets. C\u00fa [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24373,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24372","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\/24372","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=24372"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24373"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}