{"id":1690,"date":"2023-11-11T12:06:18","date_gmt":"2023-11-11T12:06:18","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/"},"modified":"2023-12-06T06:18:27","modified_gmt":"2023-12-06T06:18:27","slug":"jumlah-tidak-langsung-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/","title":{"rendered":"Bagaimana cara menggunakan indirect dengan sum di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3670169609\"><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>Saat Anda menggabungkan INDIRECT dengan fungsi SUM, Anda bisa membuat rumus penjumlahan dinamis. Dan rumus ini memungkinkan Anda mereferensikan sel di mana Anda memiliki rentang (dalam bentuk teks) yang ingin Anda jumlahkan. Artinya, Anda tidak perlu berulang kali mengubah referensi rumus itu sendiri. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80191\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-tidak langsung-dengan-jumlah\" width=\"458\" height=\"421\"><\/figure><\/div><p class=\"grey-note\"> INDIRECT memungkinkan Anda membuat referensi sel atau rentang dengan memasukkan teks ke dalamnya.<\/p><h2 class=\"wp-block-heading\"> Gabungkan TIDAK LANGSUNG dengan SUM<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ul><li> Pertama, di dalam sel, masukkan rentang yang ingin Anda rujuk.<\/li><li> Setelah itu, di sel lain, masukkan fungsi SUM.<\/li><li> Selanjutnya, masukkan fungsi INDIRECT, dan pada argumen pertama INDIRECT, rujuk ke sel dengan alamat rentang.<\/li><li> Sekarang tutup kedua fungsi dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80192\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-combiner-indirect-et-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggabungkan-tidak langsung-dan-jumlah\" width=\"522\" height=\"394\"><\/figure><\/div><p> Saat Anda menekan Enter, ini mengembalikan jumlah nilai dalam rentang A2:A7. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80193\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah nilai\" width=\"405\" height=\"305\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan INDIRECT untuk merujuk ke sheet lain di SUM<\/h2><p> Katakanlah Anda memiliki rentang yang ada di lembar berbeda, dalam hal ini Anda juga dapat menggunakan INDIRECT dan SUM. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80194\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-indirect-pour-renvoyer-une-autre-feuille-a-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"tidak langsung-untuk-merujuk-lembar-lain-untuk-menambahkan\" width=\"672\" height=\"280\"><\/figure><\/div><p> Pada contoh di atas, kita memasukkan rumus di \u201cSheet2\u201d dan mereferensikan rentang pada sheet \u201cData\u201d. Dan di dalam rumusnya ada dua sel berbeda dengan nilai yang dijadikan acuan. Di sel pertama Anda memiliki nama lembar dan di sel kedua rentangnya sendiri.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(INDIRECT(A1&amp;\"!\"&amp;B1))<\/code><\/pre><h2 class=\"wp-block-heading\"> Gunakan INDIRECT untuk SUM dengan beberapa lembar<\/h2><p> Jika Anda memiliki beberapa lembar dan ingin menjumlahkan nilai rentang semua lembar tersebut, Anda perlu menggunakan rumus seperti di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80195\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-indirects-pour-additionner-plusieurs-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"tidak langsung-ke-jumlah-banyak-daun\" width=\"713\" height=\"220\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(SUMIF(INDIRECT(\"'\"&amp;A2:A4&amp;\"'!\"&amp;B2),\"&gt;0\"))<\/code><\/pre><p> Dalam rumus ini, kami menggunakan SUMPRODUK dan SUMIF, bukan SUM. Pada INDIRECT terdapat referensi nama sheet dan rangenya. Ini menciptakan <a href=\"https:\/\/exceladvisor.org\/id\/referensi-3d\/\">rentang 3D<\/a> untuk rentang A2:A7 di ketiga lembar (Data1, Data2, dan Data3). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80196\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sumproduit-cumule-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-produk-gabungan-sumsi\" width=\"638\" height=\"304\"><\/figure><\/div><p> Setelah itu, SUMIF menggunakan rentang ini dan mengembalikan jumlah individual dari ketiga rentang tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80197\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-utilise-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-menggunakan-rentang\" width=\"676\" height=\"270\"><\/figure><\/div><p> Pada akhirnya, SUMPRODUK menggunakan nilai-nilai ini dan mengembalikan nilai jumlah tunggal dalam sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80198\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumproduct-renvoie-une-seule-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah produk-pengembalian-jumlah-tunggal\" width=\"591\" height=\"242\"><\/figure><\/div><p> Anda dapat mempelajari lebih lanjut tentang penggunaan <a href=\"https:\/\/exceladvisor.org\/id\/kondisi-dalam-jumlah-produk\/\">SUMPRODUK IF<\/a> dari sini dan mendapatkan kejelasan yang lebih baik mengenai penggunaannya di sini. <\/p><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-indirecte.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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\/tambahkan-seluruh-kolom\/\">Tambahkan seluruh kolom atau baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\">Jumlahkan hanya sel yang terlihat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-sel-acak\/\">Jumlah sel acak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-keseluruhan\/\">Tambahkan baris total di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\">Gunakan AutoSum di Excel dengan cepat<\/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-1690","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 menggunakan INDIRECT dengan SUM di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026\" \/>\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-tidak-langsung-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan INDIRECT dengan SUM di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.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-tidak-langsung-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan INDIRECT dengan SUM di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\",\"datePublished\":\"2023-11-11T12:06:18+00:00\",\"dateModified\":\"2023-12-06T06:18:27+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan indirect dengan sum di excel?\"}]},{\"@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 menggunakan INDIRECT dengan SUM di Excel?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026","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-tidak-langsung-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan INDIRECT dengan SUM di Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.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-tidak-langsung-2\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/","name":"\u25b7 Bagaimana cara menggunakan INDIRECT dengan SUM di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png","datePublished":"2023-11-11T12:06:18+00:00","dateModified":"2023-12-06T06:18:27+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menggabungkan fungsi INDIRECT dengan SUM. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-tidak-langsung-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan indirect dengan sum di excel?"}]},{"@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\/1690","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=1690"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1690\/revisions"}],"predecessor-version":[{"id":2725,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1690\/revisions\/2725"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}