{"id":2781,"date":"2023-07-20T17:50:35","date_gmt":"2023-07-20T17:50:35","guid":{"rendered":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/"},"modified":"2023-07-20T17:50:35","modified_gmt":"2023-07-20T17:50:35","slug":"sumproduct-jika-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/","title":{"rendered":"Cara menggunakan rumus sumproduk if di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan cara berikut untuk membuat rumus SUMPRODUK IF<\/strong> di Google Spreadsheet:<\/span><\/p>\n

Metode 1: SUMPRODUK IF dengan satu kriteria<\/strong><\/span><\/p>\n

 =<\/span> SUMPRODUCT<\/span> (<\/span> -<\/span> -<\/span> (<\/span> A2:A12<\/span> =<\/span> \" value<\/span> \"<\/span> )<\/span> ,<\/span> C2:C12<\/span> ,<\/span> D2:D12<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus ini menemukan jumlah hasil kali antara kolom C dan D hanya jika nilai kolom A sama dengan “nilai”.<\/span><\/p>\n
 Metode 2: SUMPRODUK IF dengan beberapa kriteria<\/strong><\/span><\/p>\n
 =SUMPRODUCT( -<\/span> -<\/span> ( A2:A12<\/span> =<\/span> \" value1<\/span> \"<\/span> ), -<\/span> -<\/span> ( B2:B12<\/span> =<\/span> \" value2<\/span> \"<\/span> ), C2:C12<\/span> , D2:D12<\/span> )\n<\/span><\/strong><\/pre>\n
 Rumus ini mencari jumlah hasil kali antara kolom C dan D hanya jika nilai kolom A sama dengan “nilai1” dan<\/em> nilai kolom B sama dengan “nilai2”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: SUMPRODUK IF dengan satu kriteria<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk menghitung jumlah produk antara kolom Kuantitas<\/strong> dan Harga<\/strong> hanya untuk baris yang kolom Tokonya<\/strong> sama dengan \u201cA\u201d:<\/span><\/p>\n
 =<\/span> SUMPRODUCT<\/span> (<\/span> -<\/span> -<\/span> (<\/span> A2:A12<\/span> =<\/span> \" A<\/span> \"<\/span> )<\/span> ,<\/span> C2:C12<\/span> ,<\/span> D2:D12<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah hasil kali antara Kuantitas<\/strong> dan Harga<\/strong> untuk toko<\/strong> A ternyata adalah 86<\/strong> .<\/span><\/span><\/p>\n
 Kami dapat memverifikasi kebenarannya secara manual dengan mengambil jumlah produk antara kuantitas dan harga hanya untuk toko A:<\/span><\/p>\n
 SUMPRODUK untuk toko A: 1*6 + 3*12 + 4*6 + 4*4 + 1*4 = 86<\/strong> .<\/span><\/p>\n
 Contoh 2: SUMPRODUK IF dengan beberapa kriteria<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk menghitung jumlah produk antara kolom Kuantitas<\/strong> dan Harga<\/strong> hanya untuk baris dengan kolom Toko<\/strong> sama dengan “A” dan kolom Produk<\/strong> sama dengan “Sarung Tangan”:<\/span><\/p>\n
 =SUMPRODUCT( -<\/span> -<\/span> ( A2:A12<\/span> =<\/span> \" A<\/span> \"<\/span> ), -<\/span> -<\/span> ( B2:B12<\/span> =<\/span> \" Gloves<\/span> \"<\/span> ), C2:C12<\/span> , D2:D12<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah hasil kali antara Kuantitas<\/strong> dan Harga<\/strong> \u201cSarung Tangan\u201d di toko A adalah 30<\/strong> .<\/span><\/p>\n
 Kami dapat memverifikasi kebenarannya secara manual dengan menjumlahkan produk antara kuantitas dan harga untuk “Sarung Tangan” di toko A saja:<\/span><\/p>\n
 SUMPRODUK untuk \u201cSarung Tangan\u201d di toko A: 1*6 + 4*6 = 30<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Cara mengalikan kolom dengan konstanta<\/a>
 Google Sheets: cara mengalikan kolom dengan persentase<\/a>
 Google Spreadsheet: cara mengurutkan item di beberapa kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan cara berikut untuk membuat rumus SUMPRODUK IF di Google Spreadsheet: Metode 1: SUMPRODUK IF dengan satu kriteria = SUMPRODUCT ( – – ( A2:A12 = ” value ” ) , C2:C12 , D2:D12 ) Rumus ini menemukan jumlah hasil kali antara kolom C dan D hanya jika nilai kolom A sama dengan […]<\/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 rumus SUMPRODUK IF di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa 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\/sumproduct-jika-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 rumus SUMPRODUK IF di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T17:50:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod_if1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/\",\"name\":\"Cara menggunakan rumus SUMPRODUK IF di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T17:50:35+00:00\",\"dateModified\":\"2023-07-20T17:50:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rumus sumproduk if 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 rumus SUMPRODUK IF di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa 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\/sumproduct-jika-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan rumus SUMPRODUK IF di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa contohnya.","og_url":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T17:50:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumprod_if1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/","url":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/","name":"Cara menggunakan rumus SUMPRODUK IF di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T17:50:35+00:00","dateModified":"2023-07-20T17:50:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus SUMPRODUK IF di Google Sheets, beserta beberapa contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sumproduct-jika-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rumus sumproduk if 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\/2781"}],"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=2781"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2781\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}