{"id":4360,"date":"2023-07-11T17:24:19","date_gmt":"2023-07-11T17:24:19","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-subtotal\/"},"modified":"2023-07-11T17:24:19","modified_gmt":"2023-07-11T17:24:19","slug":"vba-subtotal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-subtotal\/","title":{"rendered":"Cara menggunakan fungsi subtotal di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>SUBTOTAL<\/strong> di Excel untuk menghitung statistik keseluruhan hanya untuk sel yang terlihat pada lembar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut di VBA untuk menggunakan fungsi SUBTOTAL:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindSubtotal()\nRange(\" <span style=\"color: #ff0000;\">A16<\/span> \") = WorksheetFunction.Subtotal(9, Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung jumlah nilai dalam sel yang terlihat dalam rentang <strong>B2:B11<\/strong> dan menampilkan hasilnya di sel <strong>A16<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa argumen pertama pada metode <strong>Subtotal<\/strong> menentukan metode agregasi yang akan digunakan di mana:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> : SEDANG<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> : AKUN<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> : AKUN<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>4<\/strong> : MAKSIMUM<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>5<\/strong> : MINIMAL<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>6<\/strong> : PRODUK<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>7<\/strong> : STDEV<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>8<\/strong> : STDEVP<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>9<\/strong> : JUMLAH<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>10<\/strong> : VAR<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>11<\/strong> : VARP<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan metode <strong>Subtotal<\/strong> di VBA dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan subtotal di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34250 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub2.jpg\" alt=\"\" width=\"483\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita menerapkan filter untuk hanya menampilkan baris dengan tim yang sama dengan A atau C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34249 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub1.jpg\" alt=\"\" width=\"490\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk menghitung jumlah sel yang terlihat di kolom poin dan menampilkan hasilnya di sel <strong>A16<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindSubtotal()\nRange(\" <span style=\"color: #ff0000;\">A16<\/span> \") = WorksheetFunction.Subtotal(9, Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34251 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub3.jpg\" alt=\"\" width=\"457\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A16<\/b> berisi nilai <strong>168<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa jumlah sel yang terlihat di kolom poin adalah 168.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat mengubah nilai argumen pertama metode <strong>Subtotal<\/strong> untuk menghitung metrik yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa menggunakan nilai <strong>1<\/strong> untuk menghitung rata-rata sel yang terlihat di kolom poin:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindSubtotal()\nRange(\" <span style=\"color: #ff0000;\">A16<\/span> \") = WorksheetFunction.Subtotal(1, Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34252 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub4.jpg\" alt=\"\" width=\"476\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A16<\/b> berisi nilai <strong>24<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa rata-rata sel yang terlihat di kolom poin adalah 24.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <b>Subtotal<\/b> VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.subtotal\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rentang-jumlah-vba\/\">VBA: Cara menambahkan nilai dalam suatu rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai rata-rata rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi SUBTOTAL di Excel untuk menghitung statistik keseluruhan hanya untuk sel yang terlihat pada lembar. Anda dapat menggunakan sintaks dasar berikut di VBA untuk menggunakan fungsi SUBTOTAL: Sub FindSubtotal() Range(&#8221; A16 &#8220;) = WorksheetFunction.Subtotal(9, Range(&#8221; B2:B11 &#8220;)) End Sub Contoh khusus ini menghitung jumlah nilai dalam sel yang terlihat dalam rentang B2:B11 [&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 Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, 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\/vba-subtotal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-subtotal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T17:24:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub2.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-subtotal\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-subtotal\/\",\"name\":\"Cara Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T17:24:19+00:00\",\"dateModified\":\"2023-07-11T17:24:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-subtotal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-subtotal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-subtotal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi subtotal di vba (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 Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, 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\/vba-subtotal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-subtotal\/","og_site_name":"Statorials","article_published_time":"2023-07-11T17:24:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vsub2.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-subtotal\/","url":"https:\/\/statorials.org\/id\/vba-subtotal\/","name":"Cara Menggunakan Fungsi Subtotal di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T17:24:19+00:00","dateModified":"2023-07-11T17:24:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi subtotal di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-subtotal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-subtotal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-subtotal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi subtotal di vba (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\/4360"}],"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=4360"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4360\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}