{"id":5001,"date":"2023-07-05T07:34:25","date_gmt":"2023-07-05T07:34:25","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/"},"modified":"2023-07-05T07:34:25","modified_gmt":"2023-07-05T07:34:25","slug":"google-sheet-menghitung-karakter-tertentu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/","title":{"rendered":"Cara menghitung karakter tertentu di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung jumlah karakter tertentu di sel Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: menghitung karakter tertentu (peka huruf besar\/kecil)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=LEN( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">-<\/span> LEN(SUBSTITUTE( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">a<\/span> \"<\/span> , <span class=\" string \" dir=\"auto\">\"\"<\/span> )) \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung semua kemunculan karakter &#8220;a&#8221; di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini peka huruf besar-kecil, sehingga karakter &#8220;A&#8221; di sel <strong>A2<\/strong> tidak akan dihitung.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: menghitung karakter tertentu (tidak peka huruf besar-kecil)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=LEN( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">-<\/span> LEN(SUBSTITUTE(LOWER( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ), <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">a<\/span> \"<\/span> , <span class=\" string \" dir=\"auto\">\"\"<\/span> ))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung semua kemunculan karakter &#8220;a&#8221; di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini tidak peka terhadap huruf besar-kecil, jadi semua karakter &#8220;A&#8221; di sel <strong>A2<\/strong> juga akan dihitung.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan daftar nama berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39016 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptec1.png\" alt=\"\" width=\"500\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Menghitung karakter tertentu (peka huruf besar\/kecil)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung berapa kali karakter &#8220;a&#8221; muncul 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\">=LEN( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">-<\/span> LEN(SUBSTITUTE( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">a<\/span> \"<\/span> , <span class=\" string \" dir=\"auto\">\"\"<\/span> )) \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39017 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptec2.png\" alt=\"\" width=\"481\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan berapa kali karakter &#8220;a&#8221; muncul di setiap sel yang cocok di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus mengembalikan <strong>0<\/strong> untuk nama <strong>Andy<\/strong> karena rumus ini peka huruf besar-kecil, jadi &#8220;A&#8221; tidak dihitung.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Menghitung karakter tertentu (tidak peka huruf besar-kecil)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung berapa kali karakter &#8220;a&#8221; muncul 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\">=LEN( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> )-LEN(SUBSTITUTE(LOWER( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ), <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">a<\/span> \"<\/span> , <span class=\" string \" dir=\"auto\">\"\"<\/span> )) \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39018\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptec3.png\" alt=\"Google Spreadsheet menghitung karakter tertentu dalam sel\" width=\"478\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan berapa kali karakter &#8220;a&#8221; muncul di setiap sel yang cocok di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus mengembalikan <b>1<\/b> untuk nama <strong>Andy<\/strong> karena rumus ini tidak peka terhadap huruf besar-kecil, sehingga &#8220;A&#8221; dihitung.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak substring di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-string-terbalik\/\" target=\"_blank\" rel=\"noopener\">Cara membalikkan string teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengekstrak-nomor-saluran\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak angka dari string di Google Sheets<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghitung jumlah karakter tertentu di sel Google Spreadsheet: Rumus 1: menghitung karakter tertentu (peka huruf besar\/kecil) =LEN( A2 ) &#8211; LEN(SUBSTITUTE( A2 , &#8221; a &#8221; , &#8220;&#8221; )) Rumus khusus ini menghitung semua kemunculan karakter &#8220;a&#8221; di sel A2 . Rumus ini peka huruf besar-kecil, sehingga karakter &#8220;A&#8221; [&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 tertentu di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel 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\/google-sheet-menghitung-karakter-tertentu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung karakter tertentu di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T07:34:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptec1.png\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/\",\"name\":\"Cara menghitung karakter tertentu di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T07:34:25+00:00\",\"dateModified\":\"2023-07-05T07:34:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung karakter tertentu di google sheets\"}]},{\"@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 tertentu di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel 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\/google-sheet-menghitung-karakter-tertentu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung karakter tertentu di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/","og_site_name":"Statorials","article_published_time":"2023-07-05T07:34:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptec1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/","url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/","name":"Cara menghitung karakter tertentu di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T07:34:25+00:00","dateModified":"2023-07-05T07:34:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam sel di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-karakter-tertentu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung karakter tertentu di google sheets"}]},{"@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\/5001"}],"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=5001"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5001\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}