{"id":3380,"date":"2023-07-17T19:22:41","date_gmt":"2023-07-17T19:22:41","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/"},"modified":"2023-07-17T19:22:41","modified_gmt":"2023-07-17T19:22:41","slug":"excel-menghitung-kata-kata-tertentu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/","title":{"rendered":"Cara menghitung kata tertentu di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung kemunculan kata tertentu di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung kemunculan kata 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> , <span style=\"color: #000000;\">\"word\",\"\")))\/LEN(\"word\")\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung berapa kali &#8220;kata&#8221; muncul di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hitung kemunculan kata tertentu dalam rentang tersebut<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT((LEN( <span style=\"color: #3366ff;\">A2:A8<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2:A8<\/span> ,\"word\",\"\")))\/LEN(\"word\"))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung berapa kali &#8220;kata&#8221; muncul dalam rentang sel <strong>A2:A8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kolom teks berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28355 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique0.jpg\" alt=\"\" width=\"505\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung kemunculan kata tertentu dalam sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel B2 untuk menghitung berapa kali kata &#8220;Tiga&#8221; muncul di sel A2:<\/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> , <span style=\"color: #000000;\">\"Three\",\"\")))\/LEN(\"Three\")\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28356 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique1.jpg\" alt=\"\" width=\"565\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menunjukkan berapa kali kata &#8220;Tiga&#8221; muncul di sel yang sesuai di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Rumus ini peka huruf besar-kecil. Misalnya kata \u201ctiga\u201d tidak akan dihitung.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung kemunculan kata tertentu dalam rentang tersebut<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel B10 untuk menghitung berapa kali kata &#8220;Tiga&#8221; muncul di rentang sel A2:A8:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT((LEN( <span style=\"color: #3366ff;\">A2:A8<\/span> )-LEN(SUBSTITUTE( <span style=\"color: #3366ff;\">A2:A8<\/span> ,\"Three\",\"\")))\/LEN(\"Three\"))<\/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-28357 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique2.jpg\" alt=\"\" width=\"595\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa kata &#8220;Tiga&#8221; muncul sebanyak <strong>6<\/strong> kali dalam rentang sel <strong>A2:A8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk membuat rumus case-insensitive, kita bisa menggunakan fungsi <strong>UPPER<\/strong> di Excel sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT((LEN( <span style=\"color: #3366ff;\">A2:A8<\/span> )-LEN(SUBSTITUTE(UPPER( <span style=\"color: #3366ff;\">A2:A8<\/span> ),UPPER(\"Three\"),\"\")))\/LEN(\"Three\"))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel B10 untuk menghitung berapa kali &#8220;Tiga&#8221; (apa pun kasusnya) muncul di rentang sel A2:A8.<br \/><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28359 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique3.jpg\" alt=\"\" width=\"652\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa kata &#8220;Tiga&#8221; (apa pun hurufnya) muncul sebanyak <strong>8<\/strong> kali dalam rentang sel <strong>A2:A8<\/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> <a href=\"https:\/\/statorials.org\/id\/excel-countif-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung jika sel berisi teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan COUNTIF dengan banyak rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung nilai unik berdasarkan beberapa kriteria<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung kemunculan kata tertentu di Excel: Metode 1: Hitung kemunculan kata tertentu dalam sel =(LEN( A2 )-LEN(SUBSTITUTE( A2 , &#8220;word&#8221;,&#8221;&#8221;)))\/LEN(&#8220;word&#8221;) Rumus khusus ini menghitung berapa kali &#8220;kata&#8221; muncul di sel A2 . Metode 2: Hitung kemunculan kata tertentu dalam rentang tersebut =SUMPRODUCT((LEN( A2:A8 )-LEN(SUBSTITUTE( A2:A8 ,&#8221;word&#8221;,&#8221;&#8221;)))\/LEN(&#8220;word&#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>Cara Menghitung Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, 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\/excel-menghitung-kata-kata-tertentu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T19:22:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique0.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=\"2 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-kata-kata-tertentu\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/\",\"name\":\"Cara Menghitung Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T19:22:41+00:00\",\"dateModified\":\"2023-07-17T19:22:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kata tertentu di excel: dengan 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 Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, 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\/excel-menghitung-kata-kata-tertentu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/","og_site_name":"Statorials","article_published_time":"2023-07-17T19:22:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-specifique0.jpg"}],"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\/excel-menghitung-kata-kata-tertentu\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/","name":"Cara Menghitung Kata Tertentu di Excel (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T19:22:41+00:00","dateModified":"2023-07-17T19:22:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kata tertentu di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-kata-kata-tertentu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kata tertentu di excel: dengan 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\/3380"}],"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=3380"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3380\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}