{"id":2787,"date":"2023-07-20T17:08:32","date_gmt":"2023-07-20T17:08:32","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/"},"modified":"2023-07-20T17:08:32","modified_gmt":"2023-07-20T17:08:32","slug":"google-sheet-menghitung-antara-dua-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/","title":{"rendered":"Google spreadsheet: cara menghitung sel di antara dua nilai"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah sel antara dua nilai di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> COUNTIFS<\/span> (<\/span> A:A<\/span> ,<\/span> \" >10<\/span> \"<\/span> ,<\/span> A:A<\/span> ,<\/span> \" <15<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini menghitung jumlah sel di kolom A<\/strong> lebih besar dari 10<\/strong> atau kurang dari 15<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Hitung sel antara dua nilai di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki data berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk menghitung jumlah sel pada kolom B<\/strong> yang mempunyai nilai lebih besar dari 10<\/strong> dan kurang dari 20<\/strong> :<\/span><\/p>\n
 =<\/span> COUNTIFS<\/span> (<\/span> B:B<\/span> ,<\/span> \" >10<\/span> \"<\/span> ,<\/span> B:B<\/span> ,<\/span> \" <20<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Ada 4<\/strong> nilai poin yang lebih besar dari 10 dan<\/em> kurang dari 20.<\/span><\/p>\n
 Kita dapat menghitung secara manual masing-masing dari empat nilai berikut di kolom B:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa kita juga dapat menggunakan >=<\/strong> dan <=<\/strong> dalam rumus untuk menghitung nilai antara 10 dan 20 inklusif<\/strong> :<\/span><\/p>\n
 =<\/span> COUNTIFS<\/span> (<\/span> B:B<\/span> ,<\/span> \" >=10<\/span> \"<\/span> ,<\/span> B:B<\/span> ,<\/span> \" <=20<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Ada 6<\/strong> nilai poin yang lebih besar atau sama dengan 10 dan<\/em> kurang dari atau sama dengan 20.<\/span><\/p>\n
 Kita dapat menghitung secara manual masing-masing dari enam nilai berikut di kolom B:<\/span> <\/p>\n
\"\"<\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi COUNTIFS<\/b> di Google Spreadsheet di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi COUNTIF()<\/strong> umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan COUNTIFS dengan rentang tanggal di Google Sheets<\/a>
 Cara menggunakan COUNTIF dengan OR di Google Sheets<\/a>
 Cara menggunakan COUNTIF dari sheet lain di Google Sheets<\/a>
 Cara menggunakan COUNTIF dengan banyak rentang di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah sel antara dua nilai di Google Spreadsheet: = COUNTIFS ( A:A , ” >10 ” , A:A , ” <15 ” ) Rumus khusus ini menghitung jumlah sel di kolom A lebih besar dari 10 atau kurang dari 15 . Contoh berikut menunjukkan cara menggunakan sintaksis […]<\/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":"\nGoogle Spreadsheet: Cara menghitung sel antara dua nilai - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai 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\/google-sheet-menghitung-antara-dua-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menghitung sel antara dua nilai - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T17:08:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compter-entre1.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-menghitung-antara-dua-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/\",\"name\":\"Google Spreadsheet: Cara menghitung sel antara dua nilai - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T17:08:32+00:00\",\"dateModified\":\"2023-07-20T17:08:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menghitung sel di antara dua nilai\"}]},{\"@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 menghitung sel antara dua nilai - Statorial","description":"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai 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\/google-sheet-menghitung-antara-dua-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menghitung sel antara dua nilai - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-20T17:08:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compter-entre1.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-menghitung-antara-dua-nilai\/","url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/","name":"Google Spreadsheet: Cara menghitung sel antara dua nilai - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T17:08:32+00:00","dateModified":"2023-07-20T17:08:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah sel antara dua nilai di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-antara-dua-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menghitung sel di antara dua nilai"}]},{"@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\/2787"}],"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=2787"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2787\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}