{"id":1560,"date":"2023-11-17T06:37:57","date_gmt":"2023-11-17T06:37:57","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/"},"modified":"2023-12-06T06:15:37","modified_gmt":"2023-12-06T06:15:37","slug":"jumlah-jika-lebih-besar-dari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/","title":{"rendered":"Bagaimana cara menambahkan nilai yang lebih besar daripada melalui sumif?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2364844989\"><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, Anda bisa menggunakan SUMIF untuk menambahkan nilai yang lebih besar dari nilai tertentu (yang Anda tentukan). Dalam tutorial, kita akan melihat berbagai contoh untuk dipahami.<\/p><h2 class=\"wp-block-heading\"> SUMIF lebih besar dari<\/h2><p> Dalam contoh berikut, kita memiliki daftar nilai yang perlu kita jumlahkan nilai yang lebih besar dari 25. Mari kita lihat cara menulis rumus untuk ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-lebih besar-dari\" width=\"156\" height=\"281\"><\/figure><\/div><p> Ikuti langkah ini:<\/p><ol type=\"1\"><li> Pertama, masukkan \u201c=SUMIF(\u201d di sel C1 untuk menjalankan fungsinya.<\/li><li> Setelah itu, lihat rentang yang ingin Anda periksa kondisinya.<\/li><li> Sekarang masukkan kriteria dengan tanda lebih besar dan sama dengan.<\/li><li> Kemudian pilih kembali rentang A2:A13 untuk mendapatkan nilai yang akan ditambahkan. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-2-sumif-avec-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-sumif-dengan-rentang\" width=\"446\" height=\"333\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">= <a href=\"https:\/\/exceladvisor.org\/somme-4\/\">SUMIF<\/a> (A2:A13,\"&gt;=25\",A2:A13)<\/code><\/pre><p> Anda bisa memasukkan rumus di atas di sel C1 untuk mendapatkan jumlah nilai yang lebih besar dari 25.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Karena rentang jumlah dan rentang kriteria Anda sama, Anda tidak dapat menentukan rentang jumlah. Dan itu akan selalu mengembalikan Anda jumlah semua nilai yang lebih besar dari dan sama dengan 25. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-3-sumif-avec-des-criteres-specifies.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-jumlah-dengan-kriteria-yang ditentukan\" width=\"368\" height=\"327\"><\/figure><\/div><p> Anda juga bisa menggunakan referensi sel untuk menentukan kriteria dalam fungsi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66830\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Reference-de-4-cellules-pour-specifier-les-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"kriteria referensi sel untuk menentukan\" width=\"430\" height=\"327\"><\/figure><\/div><p> Pada contoh di atas, kami menggunakan kriteria yang sama, namun kami mengacu pada sel yang memiliki nomor dan kami ingin membuat kriteria yang lebih besar dengan nomor tersebut.<\/p><p> Jadi di dalam sel kita memiliki angka ini, dan dalam argumen_kriteria kita telah menggabungkan angka ini dengan operator yang lebih besar dan sama dengan.<\/p><p> Anda tahu bagian terbaik menggunakan metode ini adalah Anda dapat mengubah jumlah sel dan tidak perlu mengubah rumus sebenarnya.<\/p><p> Ada satu hal lagi yang dapat Anda ubah dalam rumusnya, yaitu Anda dapat menggunakan referensi absolut dalam referensi rentang kriteria.<\/p><p> Untuk melakukannya, cukup tambahkan tanda dolar sebelum referensi sel, seperti yang kita lakukan pada contoh berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66831\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-5-sumif-avec-reference-absolue.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-jumlah-dengan-referensi-mutlak\" width=\"403\" height=\"326\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-si-superieure-a-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><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\/sumitif-tidak-sama\/\">Jumlah nilai yang tidak sama (SUMIFS) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-sumif-atau-logika\/\">SUMIF\/SUMIFS dengan logika OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-dengan-wildcard\/\">SUMIF dengan wildcard di Excel<\/a><\/li><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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1560","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>\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif 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\/jumlah-jika-lebih-besar-dari\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-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\/jumlah-jika-lebih-besar-dari\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png\",\"datePublished\":\"2023-11-17T06:37:57+00:00\",\"dateModified\":\"2023-12-06T06:15:37+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan nilai yang lebih besar daripada melalui 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":"\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif 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\/jumlah-jika-lebih-besar-dari\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-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\/jumlah-jika-lebih-besar-dari\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/","name":"\u25b7 Bagaimana cara menambahkan nilai yang lebih besar daripada melalui SUMIF?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png","datePublished":"2023-11-17T06:37:57+00:00","dateModified":"2023-12-06T06:15:37+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara untuk menambahkan nilai yang lebih besar menggunakan fungsi sumif di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-superieur-a.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan nilai yang lebih besar daripada melalui 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\/1560","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=1560"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1560\/revisions"}],"predecessor-version":[{"id":2432,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1560\/revisions\/2432"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}