{"id":1617,"date":"2023-11-15T10:25:02","date_gmt":"2023-11-15T10:25:02","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-4\/"},"modified":"2023-12-06T06:20:05","modified_gmt":"2023-12-06T06:20:05","slug":"jumlah-4","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-4\/","title":{"rendered":"Fungsi excel: sumif"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2341780831\"><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> <div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"0-intro-sumif-function\" class=\"wp-block-heading\"> Pendahuluan: Fungsi SUMIF<\/h2><p> Di Excel, saat Anda menggunakan fungsi SUMIF, ia mengembalikan jumlah nilai yang memenuhi kondisi yang Anda tentukan. Anda harus menentukan rentang sel yang akan diperiksa kondisinya, lalu nilai yang akan diperiksa sebagai kondisi, dan pada akhirnya rentang untuk menjumlahkan nilainya. Oleh karena itu ada tiga argumen untuk ditentukan. <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"1-syntax\" class=\"wp-block-heading\"> Sintaksis<\/h2><p> SUMIF(rentang, kriteria, [jumlah_rentang]) <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"2-arguments\" class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>range<\/strong> : Rentang sel yang ingin Anda periksa kriterianya.<\/li><li> <strong>kriteria<\/strong> : kriteria yang dapat berupa angka, teks, ekspresi, referensi sel, atau fungsi.<\/li><li> <strong>[sum_range]<\/strong> : Rentang sel yang berisi nilai yang ingin Anda jumlahkan. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"3-example\" class=\"wp-block-heading\"> Contoh<\/h2><p> Pada contoh di bawah ini, kita telah menetapkan A1:A9 sebagai rentang kriteria dan B1:B9 sebagai rentang jumlah dan setelah itu kita telah menentukan kriteria di A12 yang memiliki nilai C. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-jumlah-fungsi-contoh-1\" width=\"416\" height=\"469\"><\/figure><\/div><p> Anda juga dapat memasukkan kriteria secara langsung ke dalam fungsi. Pada contoh di bawah, kami menggunakan wildcard tanda bintang untuk menentukan kriteria yang memiliki alfabet &#8220;S&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-jumlah-fungsi-contoh-2\" width=\"457\" height=\"488\"><\/figure><\/div><p> Dan, jika Anda mengabaikan rentang jumlah, ini akan memberi Anda jumlah rentang kriteria. Namun hal ini hanya mungkin terjadi jika rentang kriteria memiliki nilai numerik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-jumlah-fungsi-contoh-3\" width=\"449\" height=\"450\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Contoh berkas<\/h2><p> <em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-2.xlsx\">Unduh file contoh<\/a><\/em> <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 id=\"4-related\" class=\"wp-block-heading\"> Tutorial lainnya<\/h2><ul><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/id\/sumif-dengan-wildcard\/\">SUMIF dengan wildcard di Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/id\/jumlah-nilai-antara-dua-tanggal\/\">Jumlah nilai antara dua tanggal di Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/id\/sumif-sumif-atau-logika\/\">SUMIF\/SUMIFS dengan logika OR di Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/id\/sumitif-tidak-sama\/\">Jumlah nilai yang tidak sama (SUMIFS) di Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/id\/jumlah-jika-lebih-besar-dari\/\">Jumlahkan nilai yang lebih besar menggunakan SUMIF di Excel<\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> Fungsi terkait<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/sumif-2\/\">Fungsi SUM Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hasil-akhir-2\/\">Fungsi Excel SUMPRODUK<\/a><\/li><\/ul><\/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-1617","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>Fungsi SUMIF di Excel (Tutorial Singkat Excel)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.\" \/>\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-4\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fungsi SUMIF di Excel (Tutorial Singkat Excel)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/jumlah-4\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/\",\"name\":\"Fungsi SUMIF di Excel (Tutorial Singkat Excel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"datePublished\":\"2023-11-15T10:25:02+00:00\",\"dateModified\":\"2023-12-06T06:20:05+00:00\",\"description\":\"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fungsi 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":"Fungsi SUMIF di Excel (Tutorial Singkat Excel)","description":"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.","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-4\/","og_locale":"id_ID","og_type":"article","og_title":"Fungsi SUMIF di Excel (Tutorial Singkat Excel)","og_description":"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-4\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/jumlah-4\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-4\/","name":"Fungsi SUMIF di Excel (Tutorial Singkat Excel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","datePublished":"2023-11-15T10:25:02+00:00","dateModified":"2023-12-06T06:20:05+00:00","description":"Tutorial ini menunjukkan cara menggunakan fungsi SUMIF Excel untuk menambahkan nilai menggunakan kriteria.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-4\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-4\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-4\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Fungsi 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\/1617","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=1617"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1617\/revisions"}],"predecessor-version":[{"id":2896,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1617\/revisions\/2896"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}