{"id":2785,"date":"2023-07-20T17:23:42","date_gmt":"2023-07-20T17:23:42","guid":{"rendered":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/"},"modified":"2023-07-20T17:23:42","modified_gmt":"2023-07-20T17:23:42","slug":"sumif-atau-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/","title":{"rendered":"Cara menggunakan sumif dengan or di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Seringkali, Anda mungkin ingin menambahkan sel di Google Spreadsheet yang memenuhi salah satu dari beberapa kriteria.<\/span><\/p>\n

Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut:<\/span><\/p>\n

 =<\/span> SUMIFS<\/span> (<\/span> B2:B11<\/span> ,<\/span> A2:A11<\/span> ,<\/span> \" value1<\/span> \"<\/span> )<\/span> +<\/span> SUMIFS<\/span> (<\/span> B2:B11<\/span> ,<\/span> A2:A11<\/span> ,<\/span> \" value2<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini mengambil jumlah nilai dalam rentang B2:B11<\/strong> di mana nilai terkait dalam rentang A2:A11<\/strong> sama dengan “nilai1” atau “nilai2”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Gunakan SUMIF dengan OR 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 di kolom A yang memiliki nilai “Mavs” atau “Jazz”:<\/span><\/p>\n
 =<\/span> SUMIFS<\/span> (<\/span> B2:B11<\/span> ,<\/span> A2:A11<\/span> ,<\/span> \" Mavs<\/span> \"<\/span> )<\/span> +<\/span> SUMIFS<\/span> (<\/span> B2:B11<\/span> ,<\/span> A2:A11<\/span> ,<\/span> \" Jazz<\/span> \"<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Rumus<\/p>\n
 Kita melihat bahwa jumlah nilai pada kolom Poin<\/strong> dimana nilai yang sesuai pada kolom Tim<\/strong> adalah \u201cMavs\u201d atau \u201cJazz\u201d adalah 77<\/strong> .<\/span><\/p>\n
 Kami dapat memverifikasi kebenarannya secara manual dengan menjumlahkan poin untuk Mavs dan Jazz:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah poin: 23 + 13 + 19 + 22 = 77<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi SUMIFS<\/strong> di Google Spreadsheet di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi SUMIF()<\/strong> umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Sheets: Cara menggunakan SUMIFS dengan rentang tanggal<\/a>
 Google Spreadsheet: Cara menggunakan SUMIF dari sheet lain<\/a>
 Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali, Anda mungkin ingin menambahkan sel di Google Spreadsheet yang memenuhi salah satu dari beberapa kriteria. Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut: = SUMIFS ( B2:B11 , A2:A11 , ” value1 ” ) + SUMIFS ( B2:B11 , A2:A11 , ” value2 ” ) Rumus khusus ini mengambil jumlah nilai dalam rentang B2:B11 […]<\/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":"\nCara menggunakan SUMIF dengan OR di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR 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\/sumif-atau-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan SUMIF dengan OR di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T17:23:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumifor1.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\/sumif-atau-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/\",\"name\":\"Cara menggunakan SUMIF dengan OR di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T17:23:42+00:00\",\"dateModified\":\"2023-07-20T17:23:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan sumif dengan or di google sheets\"}]},{\"@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 SUMIF dengan OR di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR 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\/sumif-atau-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan SUMIF dengan OR di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T17:23:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumifor1.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\/sumif-atau-google-sheet\/","url":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/","name":"Cara menggunakan SUMIF dengan OR di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T17:23:42+00:00","dateModified":"2023-07-20T17:23:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMIF dengan OR di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan sumif dengan or di google sheets"}]},{"@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\/2785"}],"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=2785"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2785\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}