{"id":3418,"date":"2023-07-17T14:24:25","date_gmt":"2023-07-17T14:24:25","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/"},"modified":"2023-07-17T14:24:25","modified_gmt":"2023-07-17T14:24:25","slug":"excel-menghitung-baris-dengan-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/","title":{"rendered":"Cara menghitung baris dengan nilai di excel (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut untuk menghitung baris dengan nilai tertentu di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung baris dengan nilai apa pun<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , <span style=\"color: #000000;\">\"&lt;&gt;\")<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hitung baris tanpa nilai<\/strong><\/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;\"><strong>Metode 3: Hitung baris dengan nilai tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , <span style=\"color: #000000;\">\"50\")<\/span><\/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-28649 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-1.jpg\" alt=\"\" width=\"478\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung baris dengan nilai apa pun<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris dengan nilai <em>apa pun<\/em> di kolom B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , <span style=\"color: #000000;\">\"&lt;&gt;\")<\/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-28650 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-1.jpg\" alt=\"\" width=\"479\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat ada <strong>7<\/strong> baris dengan nilai berapa pun di kolom Poin.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung baris tanpa nilai<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris <i>yang tidak memiliki<\/i> nilai pada kolom B:<\/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-28651 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte3.jpg\" alt=\"\" width=\"483\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat ada <strong>3<\/strong> baris yang tidak memiliki nilai pada kolom Poin.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hitung baris dengan nilai tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah baris dengan nilai &#8220;8&#8221; pada kolom B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , <span style=\"color: #000000;\">\"8\")<\/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-28652 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte4.jpg\" alt=\"\" width=\"471\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat ada <strong>3<\/strong> baris dengan nilai \u201c8\u201d pada kolom Poin.<\/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 dengan nilai tertentu di Excel: Metode 1: Hitung baris dengan nilai apa pun =COUNTIF( B2:B11 , &#8220;&lt;&gt;&#8221;) Metode 2: Hitung baris tanpa nilai =COUNTBLANK( B2:B11 ) Metode 3: Hitung baris dengan nilai tertentu =COUNTIF( B2:B11 , &#8220;50&#8221;) Contoh berikut memperlihatkan cara menggunakan setiap metode dengan kumpulan data [&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 nilai di Excel (3 contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung baris dengan nilai 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-baris-dengan-nilai\/\" \/>\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 nilai di Excel (3 contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung baris dengan nilai tertentu di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T14:24:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-1.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\/excel-menghitung-baris-dengan-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/\",\"name\":\"Cara menghitung baris dengan nilai di Excel (3 contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T14:24:25+00:00\",\"dateModified\":\"2023-07-17T14:24:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung baris dengan nilai tertentu di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung baris dengan nilai 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 nilai di Excel (3 contoh) - Statorials","description":"Tutorial ini menjelaskan cara menghitung baris dengan nilai 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-baris-dengan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung baris dengan nilai di Excel (3 contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung baris dengan nilai tertentu di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-17T14:24:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-1.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\/excel-menghitung-baris-dengan-nilai\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/","name":"Cara menghitung baris dengan nilai di Excel (3 contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T14:24:25+00:00","dateModified":"2023-07-17T14:24:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung baris dengan nilai tertentu di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-baris-dengan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung baris dengan nilai 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\/3418"}],"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=3418"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3418\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}