{"id":2801,"date":"2023-07-20T15:42:09","date_gmt":"2023-07-20T15:42:09","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/"},"modified":"2023-07-20T15:42:09","modified_gmt":"2023-07-20T15:42:09","slug":"rata-rata-spreadsheet-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/","title":{"rendered":"Cara menggunakan averageifs di google sheets (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <b>AVERAGEIFS<\/b> di Google Sheets dapat digunakan untuk mencari nilai rata-rata dalam suatu rentang jika nilai terkait dalam rentang lain memenuhi kriteria tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>KETERANGAN(rentang_rata-rata, rentang_kriteria1, kriteria1, [rentang_kriteria2, kriteria2, \u2026])<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Average_range<\/strong> : Rentang untuk menghitung rata-rata<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kriteria_rentang1<\/strong> : Rentang pertama yang memeriksa kriteria tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kriteria1<\/strong> : Kriteria yang akan dianalisis pada rentang pertama<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam skenario berbeda dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24597 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes1.jpg\" alt=\"\" width=\"485\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: AVERAGEIFS dengan kolom satu karakter<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan &#8220;Mavs&#8221;:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">AVERAGEIFS<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">C2:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Mavs<\/span> \u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24598 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes2.jpg\" alt=\"\" width=\"548\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan &#8220;Mavs&#8221; adalah <strong>24.6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menghitung rata-rata poin pemain Mavs:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata: (22 + 28 + 25 + 30 + 18) \/ 5 = <strong>24,6<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: AVERAGEIFS dengan dua kolom karakter<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan &#8220;Mavs&#8221; dan kolom <strong>Posisi<\/strong> sama dengan &#8220;Guard&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGEIFS( <span dir=\"auto\" style=\"color: #ff6600;\">C2:C11<\/span> , <span dir=\"auto\" style=\"color: #800080;\">A2:A11<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Mavs<\/span> \u201d<\/span> , <span dir=\"auto\" style=\"color: #008080;\">B2:B11<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Guard<\/span> \u201d<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24599\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes3.jpg\" alt=\"KEUNGGULAN di Google Spreadsheet\" width=\"544\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Team<\/strong> sama dengan \u201cMavs\u201d dan kolom <strong>Position<\/strong> sama dengan \u201cGuard\u201d adalah <strong>29<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menghitung rata-rata poin pemain Mavs yang merupakan Penjaga:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata: (22 + 28) \/ 2 = <strong>25<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: AVERAGEIFS dengan kolom karakter dan numerik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan &#8220;Spurs&#8221; dan kolom <strong>Poin<\/strong> lebih besar dari 15:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGEIFS( <span dir=\"auto\" style=\"color: #ff6600;\">C2:C11<\/span> , <span dir=\"auto\" style=\"color: #800080;\">A2:A11<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">Spurs<\/span> \u201d<\/span> , <span dir=\"auto\" style=\"color: #ff6600;\">C2:C11<\/span> , <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">&gt;15<\/span> \u201d<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24600 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes4.jpg\" alt=\"\" width=\"569\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata pada kolom <strong>Poin<\/strong> dimana kolom <strong>Tim<\/strong> sama dengan \u201cSpurs\u201d dan kolom <b>Poin<\/b> lebih besar dari 15 adalah <strong>23.67<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menghitung rata-rata poin pemain Spurs yang mencetak lebih dari 15 poin:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata: (19 + 22 + 30) \/ 3 = <strong>23,67<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi online lengkap untuk fungsi <strong>AVERAGEIFS<\/strong> <a href=\"https:\/\/support.google.com\/docs\/answer\/3256534?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/berarti-mode-median-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara Menghitung Mean, Median, dan Mode<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menghitung rata-rata jika tidak kosong<\/a><br \/> Google Spreadsheet: Cara Menghitung Rata-Rata Pergerakan Eksponensial<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi AVERAGEIFS di Google Sheets dapat digunakan untuk mencari nilai rata-rata dalam suatu rentang jika nilai terkait dalam rentang lain memenuhi kriteria tertentu. Fungsi ini menggunakan sintaks dasar berikut: KETERANGAN(rentang_rata-rata, rentang_kriteria1, kriteria1, [rentang_kriteria2, kriteria2, \u2026]) Emas: Average_range : Rentang untuk menghitung rata-rata kriteria_rentang1 : Rentang pertama yang memeriksa kriteria tertentu kriteria1 : Kriteria yang akan [&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 AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, 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\/rata-rata-spreadsheet-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T15:42:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes1.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\/rata-rata-spreadsheet-google\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\",\"name\":\"Cara menggunakan AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T15:42:09+00:00\",\"dateModified\":\"2023-07-20T15:42:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan averageifs di google sheets (3 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 AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, 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\/rata-rata-spreadsheet-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/","og_site_name":"Statorials","article_published_time":"2023-07-20T15:42:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennes1.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\/rata-rata-spreadsheet-google\/","url":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/","name":"Cara menggunakan AVERAGEIFS di Google Sheets (3 contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T15:42:09+00:00","dateModified":"2023-07-20T15:42:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi AVERAGEIFS di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan averageifs di google sheets (3 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\/2801"}],"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=2801"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2801\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}