{"id":4641,"date":"2023-07-09T09:15:07","date_gmt":"2023-07-09T09:15:07","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/"},"modified":"2023-07-09T09:15:07","modified_gmt":"2023-07-09T09:15:07","slug":"excel-menghitung-baris-dengan-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/","title":{"rendered":"Cara menghitung baris dengan teks di excel (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut untuk menghitung baris yang berisi teks tertentu di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung baris dengan teks apa pun<\/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> , \"&lt;&gt;\")<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: menghitung baris tanpa teks<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTBLANK( <span style=\"color: #3366ff;\">A2:A11<\/span> )<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Hitung baris dengan teks tertentu<\/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> , \"Mavs\")<\/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-36220 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne1.png\" alt=\"\" width=\"456\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung baris dengan teks apa pun<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris yang berisi teks <em>apa pun<\/em> di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"&lt;&gt;\")<\/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-36221 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne2.png\" alt=\"\" width=\"493\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat ada <strong>8<\/strong> baris dengan teks apa saja di kolom Tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung baris tanpa<\/strong><\/span> <span style=\"color: #000000;\"><strong>teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris <i>tanpa<\/i> teks pada kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTBLANK( <span style=\"color: #3366ff;\">B2:B11<\/span> )<\/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-36222 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne3.png\" alt=\"\" width=\"494\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat ada <strong>2<\/strong> baris tanpa teks pada kolom Tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hitung baris dengan teks tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris dengan nilai &#8220;Mavs&#8221; di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"Mavs\")<\/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-36223 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne4.png\" alt=\"\" width=\"517\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat ada <strong>3<\/strong> baris dengan nilai \u201cMavs\u201d pada kolom Team.<\/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 baris yang berisi teks tertentu di Excel: Metode 1: Hitung baris dengan teks apa pun =COUNTIF( A2:A11 , &#8220;&lt;&gt;&#8221;) Metode 2: menghitung baris tanpa teks =COUNTBLANK( A2:A11 ) Metode 3: Hitung baris dengan teks tertentu =COUNTIF( A2:A11 , &#8220;Mavs&#8221;) Contoh berikut memperlihatkan cara menggunakan setiap metode dengan kumpulan [&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 baris dengan teks di Excel (3 contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung baris yang berisi teks 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-baris-dengan-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung baris dengan teks di Excel (3 contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung baris yang berisi teks di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T09:15:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne1.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-baris-dengan-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/\",\"name\":\"Cara menghitung baris dengan teks di Excel (3 contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T09:15:07+00:00\",\"dateModified\":\"2023-07-09T09:15:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung baris yang berisi teks di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung baris dengan teks 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 baris dengan teks di Excel (3 contoh) - Statorial","description":"Tutorial ini menjelaskan cara menghitung baris yang berisi teks 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-baris-dengan-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung baris dengan teks di Excel (3 contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung baris yang berisi teks di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-09T09:15:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/texte-de-ligne1.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-baris-dengan-teks\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/","name":"Cara menghitung baris dengan teks di Excel (3 contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T09:15:07+00:00","dateModified":"2023-07-09T09:15:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung baris yang berisi teks di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung baris dengan teks 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\/4641"}],"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=4641"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4641\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}