{"id":3420,"date":"2023-07-17T14:13:06","date_gmt":"2023-07-17T14:13:06","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/"},"modified":"2023-07-17T14:13:06","modified_gmt":"2023-07-17T14:13:06","slug":"google-sheet-berarti-jika-sel-berisi-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/","title":{"rendered":"Google sheets: cara menghitung rata-rata jika sel berisi teks"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung rata-rata di Google Spreadsheet hanya untuk sel yang berisi teks tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #ff6600;\">A2:A13<\/span> ,\"*text*\", <span style=\"color: #800080;\">B2:B13<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menghitung rata-rata nilai dalam rentang <strong>B2:B13<\/strong> hanya untuk sel yang berisi &#8220;teks&#8221; dalam rentang <strong>A2:A13<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Tanda bintang adalah karakter pengganti yang memberitahu Google Spreadsheet untuk mengabaikan teks apa pun sebelum atau sesudah string tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: hitung rata-rata jika sel berisi teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh 12 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23558 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennecontient1.jpg\" alt=\"\" width=\"409\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata poin yang dicetak oleh pemain di tim mana pun dengan &#8220;avs&#8221; di nama tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AVERAGEIF( <span style=\"color: #ff6600;\">A2:A13<\/span> ,\"*avs*\", <span style=\"color: #800080;\">B2:B13<\/span> )<\/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-28665\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moycontain1.jpg\" alt=\"Rata-rata Google Spreadsheet jika sel berisi teks\" width=\"643\" height=\"508\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rata-rata poin yang dicetak pemain dalam tim yang namanya mengandung \u201cavs\u201d adalah <strong>22,75<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh khusus ini, ada dua nama tim dengan &#8220;avs&#8221; di namanya: Mavs dan Cavs.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat menghitung secara manual rata-rata poin yang dicetak oleh pemain di tim berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata poin yang dicetak = (31 + 23 + 21 +16) \/ 4 = <strong>22.75<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung dengan rumus kami.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <b>AVERAGEIF<\/b> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3256529?hl=en\" 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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan AVERAGEIFS di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika tidak kosong di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata baris yang difilter di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghitung rata-rata di Google Spreadsheet hanya untuk sel yang berisi teks tertentu: =AVERAGEIF( A2:A13 ,&#8221;*text*&#8221;, B2:B13 ) Rumus khusus ini akan menghitung rata-rata nilai dalam rentang B2:B13 hanya untuk sel yang berisi &#8220;teks&#8221; dalam rentang A2:A13 . Catatan : Tanda bintang adalah karakter pengganti yang memberitahu Google Spreadsheet untuk [&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>Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, 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\/google-sheet-berarti-jika-sel-berisi-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T14:13:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennecontient1.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\/google-sheet-berarti-jika-sel-berisi-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/\",\"name\":\"Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T14:13:06+00:00\",\"dateModified\":\"2023-07-17T14:13:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara menghitung rata-rata jika sel berisi teks\"}]},{\"@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":"Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, 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\/google-sheet-berarti-jika-sel-berisi-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-17T14:13:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/moyennecontient1.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\/google-sheet-berarti-jika-sel-berisi-teks\/","url":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/","name":"Google Sheets: Cara menghitung rata-rata jika sel berisi teks - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T14:13:06+00:00","dateModified":"2023-07-17T14:13:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata sel Google Sheets yang berisi teks tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-berarti-jika-sel-berisi-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara menghitung rata-rata jika sel berisi teks"}]},{"@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\/3420"}],"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=3420"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3420\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}