{"id":2714,"date":"2023-07-21T01:27:53","date_gmt":"2023-07-21T01:27:53","guid":{"rendered":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/"},"modified":"2023-07-21T01:27:53","modified_gmt":"2023-07-21T01:27:53","slug":"menghitung-karakter-di-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/","title":{"rendered":"Cara menghitung karakter di google sheets (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan tiga metode berikut untuk menghitung karakter di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung jumlah karakter dalam sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN( <span style=\"color: #ff6600;\">A2<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hitung jumlah karakter dalam kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUMPRODUCT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Hitung karakter tertentu dalam sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">-LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUBSTITUTE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">UPPER<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">R<\/span> \u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">\u201c<\/span> <span class=\" string \" dir=\"auto\">\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23899 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar1.jpg\" alt=\"\" width=\"472\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung jumlah karakter dalam sel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah karakter di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN( <span style=\"color: #ff6600;\">A2<\/span> )<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom A untuk menghitung jumlah total karakter di setiap sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23900\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar2.jpg\" alt=\"menghitung karakter di Google Spreadsheet\" width=\"547\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tim \u201cMavericks\u201d berisi total <strong>9<\/strong> karakter<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim \u201cWarriors\u201d berisi total <strong>8<\/strong> karakter<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim \u201cHeat\u201d berisi total <strong>4<\/strong> karakter<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>LEN()<\/strong> juga akan menghitung semua ruang kosong di sel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung jumlah karakter dalam kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah total karakter dalam cell range <strong>A2:A11<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUMPRODUCT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23901 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar3.jpg\" alt=\"\" width=\"516\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya terlihat total ada <strong>63<\/strong> karakter di kolom A.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Hitung karakter tertentu dalam sel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung jumlah total karakter yang sama dengan \u201cR\u201d di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">-LEN<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUBSTITUTE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">UPPER<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">R<\/span> \u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">\u201c<\/span> <span class=\" string \" dir=\"auto\">\u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom A untuk menghitung jumlah total karakter yang sama dengan &#8220;R&#8221; di setiap sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23902\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar4.jpg\" alt=\"menghitung karakter tertentu di R\" width=\"552\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada <strong>1<\/strong> karakter \u201cR\u201d di sel A2.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>3<\/strong> karakter \u201cR\u201d di sel A3.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>0<\/strong> karakter \u201cR\u201d di sel A4.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan COUNTIF dengan banyak rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-countifs-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menggunakan COUNTIFS dengan rentang tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan tiga metode berikut untuk menghitung karakter di Google Spreadsheet: Metode 1: Hitung jumlah karakter dalam sel = LEN( A2 ) Metode 2: Hitung jumlah karakter dalam kolom = SUMPRODUCT ( LEN ( A2:A11 ) ) Metode 3: Hitung karakter tertentu dalam sel = LEN ( A2 ) -LEN ( SUBSTITUTE ( UPPER [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T01:27:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/\",\"name\":\"Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T01:27:53+00:00\",\"dateModified\":\"2023-07-21T01:27:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung karakter di google sheets (3 contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-21T01:27:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptechar1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/","url":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/","name":"Cara menghitung karakter di Google Sheets (3 contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T01:27:53+00:00","dateModified":"2023-07-21T01:27:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung karakter di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menghitung-karakter-di-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung karakter di google sheets (3 contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2714"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2714"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2714\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}