{"id":3389,"date":"2023-07-17T18:17:30","date_gmt":"2023-07-17T18:17:30","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/"},"modified":"2023-07-17T18:17:30","modified_gmt":"2023-07-17T18:17:30","slug":"jumlah-lembar-google-jika-lebih-besar-dari-nol","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/","title":{"rendered":"Google spreadsheet: countif lebih besar dari nol"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus dasar berikut untuk menghitung jumlah sel yang lebih besar dari nol di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=COUNTIF( <span style=\"color: #ff6600;\">B2:B11<\/span> , \u201c <span style=\"color: #008000;\">&gt;0<\/span> \u201d)\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah sel dalam rentang <strong>B2:B11<\/strong> yang memiliki nilai lebih besar dari nol.<\/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: COUNTIF lebih besar dari nol di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan jumlah penjualan yang dilakukan oleh berbagai karyawan suatu perusahaan pada bulan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28431 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plus-grand1.jpg\" alt=\"\" width=\"481\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung jumlah karyawan yang memiliki penjualan lebih besar dari nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=COUNTIF( <span style=\"color: #ff6600;\">B2:B11<\/span> , \u201c <span style=\"color: #008000;\">&gt;0<\/span> \u201d)<\/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=\" wp-image-28432 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plus-grand2.jpg\" alt=\"\" width=\"488\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita melihat bahwa <strong>6<\/strong> karyawan menghasilkan penjualan lebih besar dari nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi hal ini dengan mengidentifikasi setiap karyawan berikut secara manual:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28433 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plus-grand3.jpg\" alt=\"\" width=\"500\" height=\"433\" srcset=\"\" sizes=\"\"><br \/> <span style=\"color: #000000;\">Jika Anda ingin menghitung jumlah sel dalam rentang <strong>yang sama dengan atau lebih besar dari nol<\/strong> , cukup gunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=COUNTIF( <span style=\"color: #ff6600;\">B2:B11<\/span> , \" <span style=\"color: #008000;\">&gt;=0<\/span> \")<\/span><\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi <strong>COUNTIF()<\/strong> umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan COUNTIF dengan banyak rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-countifs-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Cara menggunakan COUNTIFS dengan rentang tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus dasar berikut untuk menghitung jumlah sel yang lebih besar dari nol di Google Spreadsheet: =COUNTIF( B2:B11 , \u201c &gt;0 \u201d) Rumus khusus ini menghitung jumlah sel dalam rentang B2:B11 yang memiliki nilai lebih besar dari nol. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: COUNTIF lebih besar dari nol [&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: COUNTIF lebih besar dari nol \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta 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\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: COUNTIF lebih besar dari nol \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T18:17:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plus-grand1.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\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/\",\"name\":\"Google Spreadsheet: COUNTIF lebih besar dari nol \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T18:17:30+00:00\",\"dateModified\":\"2023-07-17T18:17:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: countif lebih besar dari nol\"}]},{\"@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: COUNTIF lebih besar dari nol \u2013 Statorial","description":"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta 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\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: COUNTIF lebih besar dari nol \u2013 Statorial","og_description":"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/","og_site_name":"Statorials","article_published_time":"2023-07-17T18:17:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plus-grand1.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\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/","url":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/","name":"Google Spreadsheet: COUNTIF lebih besar dari nol \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T18:17:30+00:00","dateModified":"2023-07-17T18:17:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan bagaimana COUNTIF lebih besar dari nol di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-lembar-google-jika-lebih-besar-dari-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: countif lebih besar dari nol"}]},{"@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\/3389"}],"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=3389"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3389\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}