{"id":2772,"date":"2023-07-20T18:46:55","date_gmt":"2023-07-20T18:46:55","guid":{"rendered":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/"},"modified":"2023-07-20T18:46:55","modified_gmt":"2023-07-20T18:46:55","slug":"sumproduct-excel-pada-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/","title":{"rendered":"Excel: cara menggunakan sumproduk pada beberapa lembar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <strong>SUMPRODUK<\/strong> di Excel mengembalikan jumlah produk dari dua tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan fungsi <strong>SUMPRODUK<\/strong> pada beberapa lembar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUM(SUMPRODUCT(Sheet1!A2:A11, Sheet1!B2:B11),\n     SUMPRODUCT(Sheet2!A2:A6, Sheet2!B2:B6),\n     SUMPRODUCT(Sheet3!A2:A9, Sheet3!B2:B9))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini melakukan penghitungan <strong>SUMPRODUK<\/strong> pada rentang tertentu dalam sheet bernama <strong>Sheet1<\/strong> , <strong>Sheet2<\/strong> , dan <strong>Sheet3<\/strong> , lalu mengambil jumlah dari ketiga nilai tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Cara menggunakan SUMPRODUK pada beberapa lembar<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki tiga lembar berikut dalam buku kerja Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Lembar 1:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24346 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod11.jpg\" alt=\"\" width=\"437\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Lembar 2:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24347 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod12.jpg\" alt=\"\" width=\"437\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Lembar 3:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24348 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod13.jpg\" alt=\"\" width=\"439\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung <strong>SUMPRODUK<\/strong> antara kolom A dan B setiap lembar satu per satu, lalu menjumlahkan ketiga nilai tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUM(SUMPRODUCT(Sheet1!A2:A11, Sheet1!B2:B11),\n     SUMPRODUCT(Sheet2!A2:A6, Sheet2!B2:B6),\n     SUMPRODUCT(Sheet3!A2:A9, Sheet3!B2:B9))<\/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=\"aligncenter wp-image-24349\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod14.jpg\" alt=\"Excel SUMPRODUK pada beberapa lembar\" width=\"645\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai <strong>SUMPRODUK<\/strong> pada ketiga lembar tersebut ternyata <strong>355<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda menggunakan <strong>SUMPRODUK<\/strong> di setiap lembar satu per satu, Anda akan mendapatkan nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Lembar 1<\/strong> SUMPRODUK kolom A dan B : 184<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Lembar 2<\/strong> JUMLAH PRODUK kolom A dan B : 25<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Lembar 3<\/strong> SUMPRODUK kolom A dan B : 146<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jumlah ketiga nilai tersebut adalah: 184 + 25 + 146 = <strong>355<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini adalah nilai yang kami hitung menggunakan rumus.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>SUMPRODUK<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sumproduct-excel-jika-lebih-besar-dari-nol\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMPRODUK dengan nilai lebih besar dari nol di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-pada-beberapa-lembar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/baris-filter-jumlah-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris yang difilter di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi SUMPRODUK di Excel mengembalikan jumlah produk dari dua tabel. Anda dapat menggunakan sintaks dasar berikut untuk menggunakan fungsi SUMPRODUK pada beberapa lembar: =SUM(SUMPRODUCT(Sheet1!A2:A11, Sheet1!B2:B11), SUMPRODUCT(Sheet2!A2:A6, Sheet2!B2:B6), SUMPRODUCT(Sheet3!A2:A9, Sheet3!B2:B9)) Rumus ini melakukan penghitungan SUMPRODUK pada rentang tertentu dalam sheet bernama Sheet1 , Sheet2 , dan Sheet3 , lalu mengambil jumlah dari ketiga nilai tersebut. Contoh [&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 SUMPRODUK pada beberapa lembar - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, 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\/sumproduct-excel-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 SUMPRODUK pada beberapa lembar - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T18:46:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod11.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\/sumproduct-excel-pada-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/\",\"name\":\"Excel: Cara menggunakan SUMPRODUK pada beberapa lembar - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T18:46:55+00:00\",\"dateModified\":\"2023-07-20T18:46:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan sumproduk pada beberapa 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 SUMPRODUK pada beberapa lembar - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, 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\/sumproduct-excel-pada-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan SUMPRODUK pada beberapa lembar - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-20T18:46:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod11.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\/sumproduct-excel-pada-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/","name":"Excel: Cara menggunakan SUMPRODUK pada beberapa lembar - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T18:46:55+00:00","dateModified":"2023-07-20T18:46:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SUMPRODUK pada beberapa lembar di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sumproduct-excel-pada-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan sumproduk pada beberapa 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\/2772"}],"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=2772"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2772\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}