{"id":1777,"date":"2023-11-05T12:35:01","date_gmt":"2023-11-05T12:35:01","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/"},"modified":"2023-12-06T06:20:06","modified_gmt":"2023-12-06T06:20:06","slug":"hasil-akhir-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/","title":{"rendered":"Fungsi excel: sumproduk"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2758716254\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Fungsi SUMPRODUK dapat digunakan untuk mengembalikan nilai setelah penjumlahan dan mengalikan nilai dalam rentang atau array. Sederhananya, ini pertama-tama mengalikan sel yang cocok dari rentang dan kemudian merangkum semua nilainya. Ini adalah salah satu fungsi paling berguna dan kuat di Excel yang dapat digunakan untuk analisis data. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66787\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumproduct-fungsi-intro\" width=\"409\" height=\"243\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p class=\"formula\"> <em>SUMPRODUK(array1, [array2], [array3], \u2026)<\/em><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> array1: Array pertama yang ingin Anda kalikan lalu tambahkan.<\/li><li> [array2]: Array kedua yang ingin Anda kalikan lalu tambahkan.<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Pada contoh di bawah ini, kita menggunakan SUMPRODUK untuk mengalikan dan menjumlahkan nilai pada kolom D dan kolom F. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66784\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-sumproduct-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh-fungsi-produk-1\" width=\"680\" height=\"335\"><\/figure><\/div><p> Di sini kita telah menentukan rentang A1:A8 di tabel pertama dan di tabel kedua kita telah menentukan rentang C1:C8.<\/p><p> Sekarang yang terjadi adalah kelipatan nilai dari dua rentang satu sama lain (A1xC1, A2xC2, dll).<\/p><p> Dan setelah mengalikan semua nilai, ia menjumlahkannya dan menunjukkan nilai tersebut pada hasilnya.<\/p><p> Seperti namanya, fungsi SUMPRODUK pertama-tama menghitung produk dari semua nilai, lalu menjumlahkannya untuk mendapatkannya dalam satu sel.<\/p><p> Untuk membuat Anda memahami betapa hebatnya SUMPRODUK, dalam contoh berikut kita mencapai hasil yang sama dengan kolom pembantu dan fungsi SUM. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66785\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-sommeproduit-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh-fungsi-produk-2\" width=\"632\" height=\"254\"><\/figure><\/div><p> Itu sebabnya saya mengatakan bahwa SUMPRODUK adalah salah satu fungsi paling kuat yang kami miliki di Excel untuk menganalisis data dan melakukan penghitungan kompleks. Dan lebih jauh lagi, kita menggunakan SUMPRODUK untuk mencari nilai dalam tabel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66786\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-sumproduct-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh-fungsi-produk-3\" width=\"531\" height=\"294\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/produit-somme-2.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><em>contoh-file.xlsx<\/em><\/a><\/p><h2 class=\"wp-block-heading\"> Poin penting<\/h2><ul><li> Jika Anda tidak menentukan array2, SUMPRODUK hanya akan menjumlahkan array1.<\/li><li> Ukuran maksimum setiap array harus sama. Jika array1 memiliki lima sel, maka sel array2 harus berjumlah 5.<\/li><li> Teks dan masukan non-numerik lainnya akan diperlakukan sebagai 0.<\/li><\/ul><p> \u21e0 <strong>Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-excel\/\">fungsi Excel<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1777","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SUMPRODUK (Fungsi Excel dengan contoh + file contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMPRODUK (Fungsi Excel dengan contoh + file contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\",\"name\":\"SUMPRODUK (Fungsi Excel dengan contoh + file contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png\",\"datePublished\":\"2023-11-05T12:35:01+00:00\",\"dateModified\":\"2023-12-06T06:20:06+00:00\",\"description\":\"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fungsi excel: sumproduk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SUMPRODUK (Fungsi Excel dengan contoh + file contoh)","description":"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.","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:\/\/exceladvisor.org\/id\/hasil-akhir-2\/","og_locale":"id_ID","og_type":"article","og_title":"SUMPRODUK (Fungsi Excel dengan contoh + file contoh)","og_description":"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/","url":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/","name":"SUMPRODUK (Fungsi Excel dengan contoh + file contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png","datePublished":"2023-11-05T12:35:01+00:00","dateModified":"2023-12-06T06:20:06+00:00","description":"Tutorial cepat dan mudah untuk mempelajari cara menggunakan fungsi SUMPRODUK di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/introduction-a-la-fonction-sumproduct.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Fungsi excel: sumproduk"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1777"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1777\/revisions"}],"predecessor-version":[{"id":2897,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1777\/revisions\/2897"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}