{"id":2151,"date":"2023-07-23T11:49:55","date_gmt":"2023-07-23T11:49:55","guid":{"rendered":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/"},"modified":"2023-07-23T11:49:55","modified_gmt":"2023-07-23T11:49:55","slug":"countif-dari-spreadsheet-google-sheets-lainnya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/","title":{"rendered":"Google spreadsheet: cara menggunakan countif dari sheet lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan <strong>COUNTIF<\/strong> dari sheet lain di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #ff6600;\">Sheet1!A1:B20<\/span> , \" <span style=\"color: #008000;\">&gt;10<\/span> \")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: COUNTIF dari sheet lain<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki sheet berikut bernama <strong>Sheet1<\/strong> di Google Sheets yang berisi data pemain bola basket:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19920 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother1.png\" alt=\"\" width=\"445\" height=\"429\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuka <strong>Sheet2<\/strong> dan menghitung jumlah total pemain dengan lebih dari 30 poin.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #ff6600;\">Sheet1!B2:B9<\/span> , \" <span style=\"color: #008000;\">&gt;30<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menerapkan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19921 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother2.png\" alt=\"\" width=\"470\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami melihat bahwa <strong>2<\/strong> pemain memiliki lebih dari 30 poin.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: COUNTIFS dari sheet lain<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai lembar berikut yang berisi data tentang pemain bola basket:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19922 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother3.png\" alt=\"\" width=\"433\" height=\"417\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin membuka lembar 2 dan menghitung jumlah total pemain yang ada di tim A <em>dan<\/em> memiliki lebih dari 30 poin.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan fungsi <strong>COUNTIFS<\/strong> untuk melakukan ini karena kita menggunakan beberapa kriteria saat menghitung:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIFS( <span style=\"color: #ff6600;\">Sheet1!A2:A9<\/span> , \" <span style=\"color: #008000;\">A<\/span> \", <span style=\"color: #800080;\">Sheet1!B2:B9<\/span> , \" <span style=\"color: #008000;\">&gt;30<\/span> \")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menerapkan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19923 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother4.png\" alt=\"\" width=\"576\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami melihat ada <strong>3<\/strong> pemain yang tergabung dalam tim A <em>dan<\/em> memiliki lebih dari 30 poin.<\/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\/google-sheet-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan banyak rentang di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/countif-atau-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan OR di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-countifs-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIFS dengan rentang tanggal di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan COUNTIF dari sheet lain di Google Spreadsheet: =COUNTIF( Sheet1!A1:B20 , &#8221; &gt;10 &#8220;) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: COUNTIF dari sheet lain Katakanlah kita memiliki sheet berikut bernama Sheet1 di Google Sheets yang berisi data pemain bola basket: Sekarang katakanlah kita [&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 Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta 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\/countif-dari-spreadsheet-google-sheets-lainnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T11:49:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother1.png\" \/>\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\/countif-dari-spreadsheet-google-sheets-lainnya\/\",\"url\":\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\",\"name\":\"Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T11:49:55+00:00\",\"dateModified\":\"2023-07-23T11:49:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menggunakan countif dari sheet lain\"}]},{\"@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 Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta 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\/countif-dari-spreadsheet-google-sheets-lainnya\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/","og_site_name":"Statorials","article_published_time":"2023-07-23T11:49:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/countifanother1.png"}],"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\/countif-dari-spreadsheet-google-sheets-lainnya\/","url":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/","name":"Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T11:49:55+00:00","dateModified":"2023-07-23T11:49:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi COUNTIF dari sheet lain di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menggunakan countif dari sheet lain"}]},{"@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\/2151"}],"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=2151"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2151\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}