{"id":5065,"date":"2023-07-04T07:14:28","date_gmt":"2023-07-04T07:14:28","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/"},"modified":"2023-07-04T07:14:28","modified_gmt":"2023-07-04T07:14:28","slug":"excel-menghitung-karakter-tertentu-di-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/","title":{"rendered":"Excel: cara menghitung karakter tertentu dalam suatu kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk menghitung karakter tertentu dalam kolom:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Hitung karakter tertentu dalam sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEN( <span style=\"color: #3366ff;\">A2<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"r\",\"\"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah karakter yang sama dengan &#8220;r&#8221; di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Hitung karakter tertentu di seluruh rentang<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(LEN( <span style=\"color: #3366ff;\">A2:A11<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2:A11<\/span> ,\"r\",\"\")))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah karakter yang sama dengan &#8220;r&#8221; di seluruh rentang <strong>A2:A11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam latihan dengan daftar nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39481 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptespec1.png\" alt=\"\" width=\"480\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung karakter tertentu dalam sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung jumlah karakter yang sama dengan \u201cr\u201d di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEN( <span style=\"color: #3366ff;\">A2<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2<\/span> ,\"r\",\"\"))<\/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=\" wp-image-39482 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptespec2.png\" alt=\"\" width=\"519\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan jumlah karakter di sel terkait di kolom A yang sama dengan &#8220;r&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Mavs berisi <strong>0<\/strong> karakter yang sama dengan \u201cr\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Spurs berisi <strong>1<\/strong> karakter yang sama dengan \u201cr\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Roket berisi <strong>0<\/strong> karakter yang sama dengan \u201cr\u201d<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Rumus ini peka huruf besar-kecil.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung karakter tertentu di seluruh rentang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <b>D1<\/b> untuk menghitung jumlah karakter yang sama dengan &#8220;r&#8221; di seluruh rentang <strong>A2:A11<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(LEN( <span style=\"color: #3366ff;\">A2:A11<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2:A11<\/span> ,\"r\",\"\")))<\/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=\"aligncenter wp-image-39483\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptespec3.png\" alt=\"Excel menghitung karakter tertentu di kolom\" width=\"605\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya memberitahu kita bahwa ada total <strong>7<\/strong> karakter yang sama dengan &#8220;r&#8221; di antara semua sel dalam rentang <strong>A2:A11<\/strong> .<\/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 tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi teks di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah sel berisi teks daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi teks di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk menghitung karakter tertentu dalam kolom: Rumus 1: Hitung karakter tertentu dalam sel =LEN( A2 )-LEN(SUBSTITUTE( A2 ,&#8221;r&#8221;,&#8221;&#8221;)) Rumus khusus ini menghitung jumlah karakter yang sama dengan &#8220;r&#8221; di sel A2 . Rumus 2: Hitung karakter tertentu di seluruh rentang =SUMPRODUCT(LEN( A2:A11 )-LEN(SUBSTITUTE( A2:A11 ,&#8221;r&#8221;,&#8221;&#8221;))) Rumus khusus ini [&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>Excel: Cara menghitung karakter tertentu dalam kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah 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\/excel-menghitung-karakter-tertentu-di-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung karakter tertentu dalam kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T07:14:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptespec1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/\",\"name\":\"Excel: Cara menghitung karakter tertentu dalam kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T07:14:28+00:00\",\"dateModified\":\"2023-07-04T07:14:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung karakter tertentu dalam suatu kolom\"}]},{\"@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":"Excel: Cara menghitung karakter tertentu dalam kolom - Statologi","description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah 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\/excel-menghitung-karakter-tertentu-di-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung karakter tertentu dalam kolom - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-04T07:14:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptespec1.png"}],"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\/excel-menghitung-karakter-tertentu-di-kolom\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/","name":"Excel: Cara menghitung karakter tertentu dalam kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T07:14:28+00:00","dateModified":"2023-07-04T07:14:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung karakter tertentu dalam kolom di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-karakter-tertentu-di-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung karakter tertentu dalam suatu kolom"}]},{"@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\/5065"}],"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=5065"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5065\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}