{"id":3602,"date":"2023-07-16T14:42:33","date_gmt":"2023-07-16T14:42:33","guid":{"rendered":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/"},"modified":"2023-07-16T14:42:33","modified_gmt":"2023-07-16T14:42:33","slug":"menghitung-nama-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/","title":{"rendered":"Cara menghitung kata benda di excel (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut untuk menghitung nama di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung sel dengan nama persisnya<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"Bob Johnson\")<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hitung sel dengan nama parsial<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Johnson*\")<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Hitung sel dengan satu nama di antara beberapa<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Johnson*\") + COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Smith*\")<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29681 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes1.jpg\" alt=\"\" width=\"472\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung sel dengan nama persisnya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom A yang berisi nama persis &#8220;Bob Johnson&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"Bob Johnson\")<\/strong><\/span><\/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-29682\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes2.jpg\" alt=\"menghitung nama di Excel\" width=\"518\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat ada <strong>2<\/strong> sel yang berisi &#8220;Bob Johnson&#8221; sebagai nama yang benar.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung sel dengan nama sebagian<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom A yang berisi &#8220;Johnson&#8221; di mana pun dalam namanya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Johnson*\")<\/strong><\/span><\/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-29683 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes3.jpg\" alt=\"\" width=\"509\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa ada <strong>4<\/strong> sel yang mengandung &#8220;Johnson&#8221; di suatu tempat di namanya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hitung sel dengan satu nama di antara beberapa<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel di kolom A yang berisi &#8220;Johnson&#8221; atau &#8220;Smith&#8221; di suatu tempat di namanya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Johnson*\") + COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"*Smith*\")<\/strong><\/span><\/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-29684 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes4.jpg\" alt=\"\" width=\"669\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa ada <strong>6<\/strong> sel yang berisi &#8220;Johnson&#8221; atau &#8220;Smith&#8221; di suatu tempat di namanya.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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-menghitung-kata-kata-tertentu\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung kata tertentu di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai unik berdasarkan grup di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan banyak rentang di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan metode berikut untuk menghitung nama di Excel: Metode 1: Hitung sel dengan nama persisnya =COUNTIF( A2:A11 , &#8220;Bob Johnson&#8221;) Metode 2: Hitung sel dengan nama parsial =COUNTIF( A2:A11 , &#8220;*Johnson*&#8221;) Metode 3: Hitung sel dengan satu nama di antara beberapa =COUNTIF( A2:A11 , &#8220;*Johnson*&#8221;) + COUNTIF( A2:A11 , &#8220;*Smith*&#8221;) Contoh berikut memperlihatkan [&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 benda di Excel (3 contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kata benda 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\/menghitung-nama-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung kata benda di Excel (3 contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kata benda di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T14:42:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes1.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-nama-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/\",\"name\":\"Cara menghitung kata benda di Excel (3 contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T14:42:33+00:00\",\"dateModified\":\"2023-07-16T14:42:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kata benda di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kata benda di excel (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 kata benda di Excel (3 contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung kata benda 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\/menghitung-nama-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung kata benda di Excel (3 contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung kata benda di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-16T14:42:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/noms-de-comptes1.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-nama-di-excel\/","url":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/","name":"Cara menghitung kata benda di Excel (3 contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T14:42:33+00:00","dateModified":"2023-07-16T14:42:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kata benda di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menghitung-nama-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kata benda di excel (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\/3602"}],"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=3602"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3602\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}