{"id":4324,"date":"2023-07-12T00:03:53","date_gmt":"2023-07-12T00:03:53","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/"},"modified":"2023-07-12T00:03:53","modified_gmt":"2023-07-12T00:03:53","slug":"vba-jarak-menengah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/","title":{"rendered":"Vba: cara menghitung nilai rata-rata rentang"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung nilai rata-rata suatu rentang di Excel menggunakan VBA:<\/span><\/p>\n

 SubAverageRange<\/span> ()\n    Range(\" E2<\/span> \") = WorksheetFunction.Average(Range(\" B1:B12<\/span> \"))\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini menghitung nilai rata-rata dalam rentang B2:B12<\/strong> dan menetapkan hasilnya ke sel E2<\/strong> .<\/span><\/p>\n
 Jika Anda ingin menampilkan nilai rata-rata dalam kotak pesan, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n
 SubAverageRange<\/span> ()\n    'Create variable to store average value<\/span>\n    Dim<\/span> avg As<\/span> Single\n    \n    'Calculate average value of range<\/span>\n    avg = WorksheetFunction.Average(Range(\" B1:B12<\/span> \"))\n    \n    'Display the result<\/span>\n    MsgBox \" Average Value in Range:<\/span> \" & avg\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan himpunan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Hitung rata-rata rentang menggunakan VBA dan tampilkan hasilnya di sel<\/strong><\/span><\/h2>\n
 Misalkan kita ingin menghitung nilai rata-rata di kolom poin dan menampilkan hasilnya di sel tertentu.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubAverageRange<\/span> ()\n    Range(\" E2<\/span> \") = WorksheetFunction.Average(Range(\" B1:B12<\/span> \"))\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa sel E2<\/strong> berisi nilai 21.27273<\/strong> .<\/span><\/p>\n
 Artinya nilai rata-rata pada kolom poin adalah 21.27273.<\/span><\/p>\n
 Contoh 2: Hitung rata-rata rentang menggunakan VBA dan tampilkan hasilnya di kotak pesan<\/strong><\/span><\/h2>\n
 Misalkan kita ingin<\/span> menghitung nilai rata-rata di kolom poin dan menampilkan hasilnya di kotak pesan.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubAverageRange<\/span> ()\n    'Create variable to store average value<\/span>\n    Dim<\/span> avg As<\/span> Single\n    \n    'Calculate average value of range<\/span>\n    avg = WorksheetFunction.Average(Range(\" B1:B12<\/span> \"))\n    \n    'Display the result<\/span>\n    MsgBox \" Average Value in Range:<\/span> \" & avg\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"Rata-rata<\/p>\n
 Kotak pesan memberitahu kita bahwa nilai rata-rata dalam rentang B2:B12<\/strong> adalah 21.27273<\/strong> .<\/span><\/p>\n
 Perhatikan bahwa dalam contoh ini kami menghitung nilai rata-rata dalam rentang B2:B12<\/strong> .<\/span><\/p>\n
 Namun, jika Anda ingin menghitung nilai rata-rata di seluruh kolom, Anda bisa mengetikkan B:B<\/strong> .<\/span><\/p>\n
 Ini akan menghitung nilai rata-rata untuk setiap sel di kolom B.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a>
 VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a>
 VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung nilai rata-rata suatu rentang di Excel menggunakan VBA: SubAverageRange () Range(” E2 “) = WorksheetFunction.Average(Range(” B1:B12 “)) End Sub Contoh khusus ini menghitung nilai rata-rata dalam rentang B2:B12 dan menetapkan hasilnya ke sel E2 . Jika Anda ingin menampilkan nilai rata-rata dalam kotak pesan, Anda dapat menggunakan […]<\/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":"\nVBA: Cara menghitung nilai rata-rata rentang - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, 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\/vba-jarak-menengah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghitung nilai rata-rata rentang - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T00:03:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif1.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-jarak-menengah\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\",\"name\":\"VBA: Cara menghitung nilai rata-rata rentang - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T00:03:53+00:00\",\"dateModified\":\"2023-07-12T00:03:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghitung nilai rata-rata rentang\"}]},{\"@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":"VBA: Cara menghitung nilai rata-rata rentang - Statorial","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, 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\/vba-jarak-menengah\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghitung nilai rata-rata rentang - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/","og_site_name":"Statorials","article_published_time":"2023-07-12T00:03:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vba_sumif1.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-jarak-menengah\/","url":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/","name":"VBA: Cara menghitung nilai rata-rata rentang - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T00:03:53+00:00","dateModified":"2023-07-12T00:03:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata dalam suatu rentang menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-jarak-menengah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-jarak-menengah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghitung nilai rata-rata rentang"}]},{"@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\/4324"}],"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=4324"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4324\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}