{"id":3361,"date":"2023-07-17T21:48:09","date_gmt":"2023-07-17T21:48:09","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/"},"modified":"2023-07-17T21:48:09","modified_gmt":"2023-07-17T21:48:09","slug":"rata-rata-excel-dalam-beberapa-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/","title":{"rendered":"Excel: cara menggunakan averageif dengan banyak rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di Excel, tidak mungkin menggunakan fungsi <strong>AVERAGEIF()<\/strong> untuk menghitung nilai rata-rata menggunakan beberapa rentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda bisa menggunakan rumus berikut sebagai solusinya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>=(SUM(SUMIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> , <span style=\"color: #800080;\">B2:B11<\/span> ),SUMIF( <span style=\"color: #008000;\">D2:D11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> , <span style=\"color: #993300;\">E2:E11<\/span> ))\/SUM(COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> ),COUNTIF( <span style=\"color: #008000;\">D2:D11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> ) ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan rata-rata nilai dalam rentang <strong>B2:B11<\/strong> dan <strong>E2:E11<\/strong> di mana nilai terkait dalam rentang <strong>A2:A11<\/strong> dan <strong>D2:D11<\/strong> sama dengan nilai di sel <strong>G2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <strong>Contoh: Menggunakan AVERAGEIF dengan Beberapa Range di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki data berikut di Excel yang memperlihatkan penjualan berbagai buah-buahan pada hari yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28238 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne1-1.jpg\" alt=\"\" width=\"453\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menghitung rata-rata penjualan <strong>mangga<\/strong> harian.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>=(SUM(SUMIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> , <span style=\"color: #800080;\">B2:B11<\/span> ),SUMIF( <span style=\"color: #008000;\">D2:D11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> , <span style=\"color: #993300;\">E2:E11<\/span> ))\/SUM(COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> ),COUNTIF( <span style=\"color: #008000;\">D2:D11<\/span> , <span style=\"color: #ff0000;\">G2<\/span> ) ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita ketik rumus ini di sel <strong>H2<\/strong> lalu tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28239\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne2-1.jpg\" alt=\"Excel AVERAGEIFS dengan beberapa rentang\" width=\"623\" height=\"539\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat rata-rata penjualan mangga harian adalah <strong>6,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan mengambil rata-rata semua nilai penjualan secara manual jika produk yang bersangkutan adalah mangga:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata penjualan mangga: (8+6+5+4+8+8) \/ 6 = <strong>6,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini cocok dengan nilai yang kami hitung menggunakan rumus kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kita menghitung rata-rata menggunakan dua rentang sel, namun kita dapat menggunakan sintaks serupa untuk memasukkan rentang sel sebanyak yang kita inginkan.<\/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 Excel:<\/span><\/p>\n<p> Excel: cara rata-rata jika tidak kosong<br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-tidak-termasuk-outlier\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung rata-rata tidak termasuk outlier<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung rata-rata berdasarkan kelompok<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di Excel, tidak mungkin menggunakan fungsi AVERAGEIF() untuk menghitung nilai rata-rata menggunakan beberapa rentang. Namun, Anda bisa menggunakan rumus berikut sebagai solusinya: =(SUM(SUMIF( A2:A11 , G2 , B2:B11 ),SUMIF( D2:D11 , G2 , E2:E11 ))\/SUM(COUNTIF( A2:A11 , G2 ),COUNTIF( D2:D11 , G2 ) )) Rumus khusus ini menemukan rata-rata nilai dalam rentang B2:B11 dan E2:E11 [&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>Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.\" \/>\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\/rata-rata-excel-dalam-beberapa-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T21:48:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne1-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\/rata-rata-excel-dalam-beberapa-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/\",\"name\":\"Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T21:48:09+00:00\",\"dateModified\":\"2023-07-17T21:48:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan averageif dengan banyak 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":"Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.","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\/rata-rata-excel-dalam-beberapa-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-17T21:48:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyenne1-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\/rata-rata-excel-dalam-beberapa-rentang\/","url":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/","name":"Excel: Cara menggunakan AVERAGEIF dengan beberapa rentang \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T21:48:09+00:00","dateModified":"2023-07-17T21:48:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIF di Excel dengan beberapa rentang, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan averageif dengan banyak 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\/3361"}],"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=3361"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3361\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}