{"id":1723,"date":"2023-11-09T19:39:01","date_gmt":"2023-11-09T19:39:01","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/"},"modified":"2023-12-06T06:17:37","modified_gmt":"2023-12-06T06:17:37","slug":"menghitung-garis-yang-difilter","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/","title":{"rendered":"Bagaimana cara menghitung baris yang difilter di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2045201585\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk menghitung baris yang difilter di Excel, Anda bisa menggunakan fungsi SUBTOTAL yang memungkinkan Anda memilih fungsi penghitungannya di argumen pertama dan rentang dari mana Anda ingin menghitung baris yang difilter. Setelah menggunakan rumus ini, saat Anda menerapkan filter pada rentang ini dan memfilter sel, hanya baris yang terlihat yang akan dihitung.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(3,A2:A101) =SUBTOTAL(103,A2:A101)<\/code><\/pre><p> Pada contoh di atas, kita memiliki 100 sel dengan nilai di kolom A. Sekarang Anda perlu menghitung baris setelah Anda menerapkan sel filter. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77694\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah baris yang difilter\" width=\"384\" height=\"319\"><\/figure><\/div><h2 id=\"h-steps-to-count-filtered-rows\" class=\"wp-block-heading\"> Langkah-langkah untuk menghitung baris yang difilter<\/h2><ol type=\"1\"><li> Pertama, di sel B2, masukkan fungsi SUBTOTAL.<\/li><li> Sekarang di argumen pertama pilih function_num COUNTA atau masukkan 3.<\/li><li> Setelah itu, pada argumen kedua, lihat rentang A1:A101.<\/li><li> Kemudian masukkan tanda kurung tutup untuk menutup fungsi dan enter.<\/li><li> Pada akhirnya, filter kolom A untuk melihat bahwa rumus Anda memperlihatkan jumlah baris yang difilter dalam hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-la-fonction-de-sous-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan fungsi subtotal\" width=\"568\" height=\"235\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(3,A2:A101)<\/code><\/pre><p> Menggunakan fungsi SUBTOTAL ini juga membantu Anda dalam hal lain. Katakanlah Anda memiliki beberapa garis tersembunyi, dalam hal ini juga akan memberi Anda hitungan tanpa garis tersembunyi tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77697\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comptes-sans-lignes-cachees.png\" sizes=\"auto, \" srcset=\"\" alt=\"hitung tanpa garis tersembunyi\" width=\"510\" height=\"360\"><\/figure><\/div><p> Dalam contoh di atas kita memiliki empat baris tersembunyi dan hasilnya menghasilkan 96.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(103,A2:A101)<\/code><\/pre><p> Ingatlah bahwa ada dua cara berbeda untuk menghitung baris setelah Anda menerapkan filter.<\/p><ul><li> Menghitung dengan garis tersembunyi<\/li><li> Hitung tanpa garis tersembunyi <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77698\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-sous-total-avec-lignes-masquees-et-non-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotal-dengan-baris yang tersembunyi dan terbuka kedoknya\" width=\"328\" height=\"344\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/compter-les-lignes-filtrees-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-sel-dengan-teks\/\">Hitung sel dengan teks di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-karakter-tertentu\/\">Hitung karakter tertentu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-jumlah-sel-seluruhnya\/\">Hitung jumlah total sel dalam suatu rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-nilai-unik-1\/\">Hitung nilai unik di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-melawan-hitungan\/\">COUNT Vs.COUNTA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1723","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/\",\"name\":\"Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\",\"datePublished\":\"2023-11-09T19:39:01+00:00\",\"dateModified\":\"2023-12-06T06:17:37+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung baris yang difilter di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)","description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya","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:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)","og_description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/","name":"Bagaimana cara menghitung baris yang difilter di Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","datePublished":"2023-11-09T19:39:01+00:00","dateModified":"2023-12-06T06:17:37+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menghitung baris yang difilter di Excel. Anda dapat menggunakan fungsinya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghitung-garis-yang-difilter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung baris yang difilter di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1723"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1723\/revisions"}],"predecessor-version":[{"id":2621,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1723\/revisions\/2621"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}