{"id":3155,"date":"2023-07-18T23:00:57","date_gmt":"2023-07-18T23:00:57","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/"},"modified":"2023-07-18T23:00:57","modified_gmt":"2023-07-18T23:00:57","slug":"lembar-hitungan-google-memfilter-baris","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/","title":{"rendered":"Cara menghitung baris yang difilter di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk menghitung jumlah baris yang difilter di Google Spreadsheet adalah dengan menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>SUBTOTAL( <span style=\"color: #0000ff;\">102<\/span> , <span style=\"color: #ff6600;\">A1:A10<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai 102 adalah <a href=\"https:\/\/support.google.com\/docs\/answer\/3093649?hl=en\" target=\"_blank\" rel=\"noopener\">jalan pintas<\/a> untuk menghitung rentang baris yang difilter.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Hitung baris yang difilter di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai spreadsheet berikut yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21153 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.png\" alt=\"\" width=\"457\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan filter pada data ini, kita bisa menyorot sel <strong>A1:B10<\/strong> , lalu klik tab <strong>Data<\/strong> , lalu klik <strong>Buat Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21154 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt2.png\" alt=\"\" width=\"504\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik ikon Filter di bagian atas kolom Poin dan hapus centang pada kotak di sebelah tiga nilai pertama 84, 89 dan 93:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt3.png\" alt=\"\" width=\"491\" height=\"642\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kami mengklik <strong>OK<\/strong> , data akan disaring untuk menghapus nilai-nilai ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mencoba menggunakan fungsi <strong>COUNT()<\/strong> untuk menghitung jumlah baris yang difilter, nilainya tidak akan benar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-feuilles-de-filtres1.jpg\" alt=\"\" width=\"473\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah baris yang difilter adalah 6, tetapi fungsi <strong>COUNT()<\/strong> menghasilkan 7.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebagai gantinya, kita perlu menggunakan fungsi <strong>SUBTOTAL()<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26813 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nombre-de-feuilles-de-filtres2.jpg\" alt=\"\" width=\"474\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini hanya menghitung jumlah garis yang terlihat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memverifikasi kebenarannya secara manual dengan mengamati ada 6 garis yang terlihat.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menjumlahkan-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan baris yang difilter di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-sel-dengan-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung sel dengan teks di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung sel antara dua nilai di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk menghitung jumlah baris yang difilter di Google Spreadsheet adalah dengan menggunakan sintaks berikut: SUBTOTAL( 102 , A1:A10 ) Perhatikan bahwa nilai 102 adalah jalan pintas untuk menghitung rentang baris yang difilter. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Hitung baris yang difilter di Google Spreadsheet Misalkan kita mempunyai spreadsheet [&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 yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, 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\/lembar-hitungan-google-memfilter-baris\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Baris yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T23:00:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.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\/lembar-hitungan-google-memfilter-baris\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/\",\"name\":\"Cara Menghitung Baris yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T23:00:57+00:00\",\"dateModified\":\"2023-07-18T23:00:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung baris yang difilter di google spreadsheet (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 Baris yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, 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\/lembar-hitungan-google-memfilter-baris\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Baris yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/","og_site_name":"Statorials","article_published_time":"2023-07-18T23:00:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.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\/lembar-hitungan-google-memfilter-baris\/","url":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/","name":"Cara Menghitung Baris yang Difilter di Google Spreadsheet (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T23:00:57+00:00","dateModified":"2023-07-18T23:00:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung baris yang difilter di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung baris yang difilter di google spreadsheet (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\/3155"}],"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=3155"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3155\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}