{"id":4905,"date":"2023-07-06T14:38:12","date_gmt":"2023-07-06T14:38:12","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/"},"modified":"2023-07-06T14:38:12","modified_gmt":"2023-07-06T14:38:12","slug":"excel-sumif-pada-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/","title":{"rendered":"Excel: cara menggunakan sumif pada banyak lembar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan <strong>SUMIF<\/strong> di beberapa lembar di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=SUMIF(First!B2:B11, \"Guard\", First!C2:C11)+SUMIF(Second!B2:B8, \"Guard\", Second!C2:C8)\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan merangkum semua nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai dalam rentang <strong>C2:C11<\/strong> pada lembar berlabel <strong>Perdana<\/strong> hanya jika sel terkait dalam rentang <strong>B2:B11<\/strong> berisi &#8220;Penjaga&#8221;.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai dalam rentang <strong>C2:C8<\/strong> pada lembar berlabel <strong>Second<\/strong> only dengan sel terkait dalam rentang <strong>B2:B18<\/strong> berisi &#8220;Penjaga&#8221;.<\/span><\/li>\n<\/ul>\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: Cara menggunakan SUMIF pada beberapa lembar di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki lembar bernama <strong>Pertama<\/strong> yang berisi informasi tentang pemain bola basket profesional terbaik dari paruh pertama musim reguler:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38303 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smu1.png\" alt=\"\" width=\"499\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan misalkan kita memiliki lembar lain bernama <strong>Second<\/strong> yang berisi informasi tentang pemain bola basket profesional terbaik dari paruh kedua musim reguler:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38304 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smu2.png\" alt=\"\" width=\"498\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung penjumlahan poin pemain pada dua lembar yang mempunyai nilai &#8220;Penjaga&#8221; pada kolom <strong>Posisi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut pada lembar berjudul <strong>Ringkasan<\/strong> untuk menghitung jumlah ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=SUMIF(First!B2:B11, \"Guard\", First!C2:C11)+SUMIF(Second!B2:B8, \"Guard\", Second!C2:C8)\n<\/strong><\/span><\/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-38305 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smu3.png\" alt=\"\" width=\"559\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>176<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya, jumlah nilai pada kolom <strong>Poin<\/strong> untuk seluruh pemain yang memiliki nilai \u201cPenjaga\u201d pada kolom <strong>Posisi<\/strong> lembar <strong>pertama<\/strong> dan <strong>kedua<\/strong> adalah <strong>176<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pada contoh ini, kami menambahkan hasil dari dua fungsi <strong>SUMIF<\/strong> namun Anda dapat menambahkan hasil dari fungsi <strong>SUMIF<\/strong> sebanyak yang Anda inginkan tergantung pada jumlah sheet yang Anda gunakan.<\/span><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan SUMPRODUK pada beberapa lembar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-pada-beberapa-lembar-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan SUM pada beberapa lembar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-beberapa-lembar\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Membuat PivotTable dari Beberapa Lembar<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan SUMIF di beberapa lembar di Excel: =SUMIF(First!B2:B11, &#8220;Guard&#8221;, First!C2:C11)+SUMIF(Second!B2:B8, &#8220;Guard&#8221;, Second!C2:C8) Contoh khusus ini akan merangkum semua nilai berikut: Nilai dalam rentang C2:C11 pada lembar berlabel Perdana hanya jika sel terkait dalam rentang B2:B11 berisi &#8220;Penjaga&#8221;. Nilai dalam rentang C2:C8 pada lembar berlabel Second only dengan sel [&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>Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.\" \/>\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\/excel-sumif-pada-beberapa-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T14:38:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smu1.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\/excel-sumif-pada-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/\",\"name\":\"Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T14:38:12+00:00\",\"dateModified\":\"2023-07-06T14:38:12+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan sumif pada banyak lembar\"}]},{\"@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":"Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi","description":"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.","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\/excel-sumif-pada-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-06T14:38:12+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/smu1.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\/excel-sumif-pada-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/","name":"Excel: Cara menggunakan SUMIF pada banyak lembar - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T14:38:12+00:00","dateModified":"2023-07-06T14:38:12+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan SUMIF di beberapa sheet di Excel, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-sumif-pada-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan sumif pada banyak lembar"}]},{"@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\/4905"}],"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=4905"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4905\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}