{"id":2046,"date":"2023-10-23T00:54:26","date_gmt":"2023-10-23T00:54:26","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/"},"modified":"2023-12-06T06:18:44","modified_gmt":"2023-12-06T06:18:44","slug":"sumitif-tidak-sama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/","title":{"rendered":"Bagaimana cara menjumlahkan nilai yang tidak sama di excel? (sumif)"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3289455204\"><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>Di Excel, saat Anda perlu menambahkan nilai yang tidak sama dengan kriteria tertentu, Anda bisa menggunakan SUMIF atau SUMIFS. Kedua fungsi tersebut dapat digunakan tergantung pada data yang Anda miliki. Dalam tutorial ini, kita akan melihat kedua situasi tersebut.<\/p><h2 class=\"wp-block-heading\"> SUMIF tidak sama dengan<\/h2><p> Pada contoh berikut kita memiliki daftar nilai di mana kita memiliki tiga nilai yaitu 2000, tetapi kita perlu menjumlahkan semua nilai lainnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66848\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-tidak-sama-dengan\" width=\"251\" height=\"278\"><\/figure><\/div><p> Di sini kita akan menggunakan SUMIF untuk mendapatkan hasilnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A14,\"&lt;&gt;2000\",A2:A14)<\/code><\/pre><ol><li> Pertama, di C1, masukkan \u201c=SUMIF\u201d lalu masukkan tanda kurung awal. <br><img loading=\"lazy\" decoding=\"async\" title=\"rumus 2 jumlah\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-2-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-formula\" width=\"380\" height=\"299\"><\/li><li> Selanjutnya, pilih rentang di mana kita perlu memeriksa kriterianya (tidak sama dengan 2000). <br><img loading=\"lazy\" decoding=\"async\" title=\"Rumus 3-rentang-dalam-sumif\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-plage-dans-la-formule-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"range-within-sumif-formula\" width=\"392\" height=\"293\"><\/li><li> Setelah itu masukkan nilai yang ingin kita jadikan kriteria yaitu tidak sama dengan 2000, dan untuk itu kita harus menggunakan operator (tanda) tidak sama dan menempatkannya dalam tanda kutip ganda. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-masukkan-nilai-untuk-digunakan-sebagai-kriteria\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-les-valeurs-a-utiliser-comme-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-values-to-use-as-criteria\" width=\"397\" height=\"295\"><\/li><li> Dari sini Anda perlu menentukan rentang dari mana kita perlu menjumlahkan nilainya. Sekarang, karena kita hanya menggunakan satu rentang, dan rentang yang sama, kita perlu menggunakannya untuk mendapatkan jumlah nilainya. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 rentang untuk menambahkan nilai\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-plage-pour-additionner-les-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"range-to-sum-the-values\" width=\"430\" height=\"315\"><\/li><li> Terakhir, masukkan tanda kurung tutup dan tekan Enter. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-masukkan-tanda kurung penutup\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-les-parentheses-fermantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-closing-parentheses\" width=\"428\" height=\"316\"><\/li><\/ol><p> Seperti yang Anda lihat, kami memiliki hasil 16046 yang merupakan total semua nilai yang tidak sama dengan 2000.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> [sum_range] bersifat opsional, Anda dapat mengabaikan penentuannya dan hasilnya akan selalu mengembalikan total. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66854\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Plage-de-saut-de-la-formule-7-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang-lewati-rumus-sumif\" width=\"423\" height=\"363\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A14,\"&lt;&gt;2000\")<\/code><\/pre><h2 class=\"wp-block-heading\"> SUMIFS tidak sama dengan banyak nilai (teks)<\/h2><p> Katakanlah Anda perlu menambahkan nilai menggunakan beberapa nilai yang tidak sama. Dalam contoh berikut, kami memiliki daftar produk dengan kuantitas, dan Anda perlu menjumlahkan produk yang tidak sama dengan A dan C. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66855\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumifs-non-egaux-a-plusieurs-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumitif multi-nilai yang tidak sama\" width=\"351\" height=\"337\"><\/figure><\/div><p> Anda dapat menggunakan rumus berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(B2:B13,A2:A13,\"&lt;&gt;A\",A2:A13,\"&lt;&gt;C\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66856\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-sumifs-multiples-non-egaux-aux-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"multiple-sumif-tidak-sama-dengan-kriteria\" width=\"492\" height=\"402\"><\/figure><\/div><p> Dalam rumus di atas, kami telah menggunakan kriteria kelipatan yang tidak sama untuk mendapatkan jumlah nilai lainnya.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-nilai-antara-dua-tanggal\/\">Rentang tanggal SUMIFS (jumlah nilai antara dua array tanggal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-vlookup\/\">Gabungkan VLOOKUP dengan SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-berisi\/\">Jumlahkan JIKA sel berisi teks tertentu (SUMIF sebagian teks)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-tahun-2\/\">Jumlah nilai menurut tahun (SUMIF Tahun)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-berdasarkan-tanggal\/\">SUMIF berdasarkan tanggal (jumlah nilai berdasarkan tanggal)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","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-2046","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>Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)<\/title>\n<meta name=\"description\" content=\"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.\" \/>\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\/sumitif-tidak-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)\" \/>\n<meta property=\"og:description\" content=\"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\",\"name\":\"Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png\",\"datePublished\":\"2023-10-23T00:54:26+00:00\",\"dateModified\":\"2023-12-06T06:18:44+00:00\",\"description\":\"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menjumlahkan nilai yang tidak sama di excel? (sumif)\"}]},{\"@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":"Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)","description":"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.","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\/sumitif-tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)","og_description":"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/","url":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/","name":"Bagaimana cara menambahkan nilai yang tidak sama? (SUMIF)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png","datePublished":"2023-10-23T00:54:26+00:00","dateModified":"2023-12-06T06:18:44+00:00","description":"Pelajari berbagai cara untuk menambahkan nilai berbeda di Excel menggunakan rumus yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-pas-egal-a.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menjumlahkan nilai yang tidak sama di excel? (sumif)"}]},{"@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\/2046","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=2046"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2046\/revisions"}],"predecessor-version":[{"id":2762,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2046\/revisions\/2762"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}