{"id":1683,"date":"2023-11-11T15:33:29","date_gmt":"2023-11-11T15:33:29","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/"},"modified":"2023-12-06T06:17:42","modified_gmt":"2023-12-06T06:17:42","slug":"jumlah-kumulatif-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/","title":{"rendered":"Bagaimana cara menghitung jumlah nilai kumulatif?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-523161819\"><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>Untuk menghitung jumlah kumulatif di Excel, Anda perlu menggunakan rumus SUM. Anda perlu merujuk ke nilai sebelumnya dan nilai saat ini dalam rumus, lalu menyeret rumus ini ke semua sel yang ingin Anda hitung total berjalannya (jumlah berjalan).<\/p><p> Dalam tutorial ini, kita akan mempelajari cara menulis rumus ini dan beberapa rumus lainnya untuk menghadapi berbagai situasi.<\/p><h2 class=\"wp-block-heading\"> Rumus untuk menghitung jumlah kumulatif<\/h2><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi penjumlahan di sel C2.<\/li><li> Kemudian lihat rentang B2:B3. Kisaran ini mencakup kuantitas untuk hari 1 dan hari 2.<\/li><li> Sekarang gunakan tanda dolar sebelum nomor baris referensi sel.<\/li><li> Kemudian masukkan fungsi untuk mendapatkan total berjalan selama dua hari (1 dan 2).<\/li><li> Pada akhirnya, seret rumus ke sel terakhir kolom untuk mendapatkan total berjalan sepanjang hari. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-untuk-jumlah-kumulatif\" width=\"520\" height=\"519\"><\/figure><\/div><p> Anda dapat melihat bahwa ketika Anda menggunakan tanda dolar, itu membekukan sel pertama dan di setiap sel menghitung jumlah kumulatif untuk semua hari sebelumnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-signe-pour-geler-la-valeur-precedente.png\" sizes=\"auto, \" srcset=\"\" alt=\"$-tanda-untuk-membekukan-nilai-sebelumnya\" width=\"470\" height=\"406\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Jumlah kumulatif berdasarkan tanggal<\/h2><p> Jika Anda memiliki data dengan tanggal seperti yang kami miliki di kolom A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79326\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-cumulee-par-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah kumulatif berdasarkan tanggal\" width=\"464\" height=\"501\"><\/figure><\/div><p> Untuk mendapatkan total running berdasarkan tanggal, Anda harus mengurutkan data terlebih dahulu dari yang lama ke yang baru. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79327\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-trier-la-date-de-lancien-au-nouveau.png\" sizes=\"auto, \" srcset=\"\" alt=\"urutkan-tanggal-dari-yang lama ke yang baru\" width=\"449\" height=\"487\"><\/figure><\/div><p> Setelah itu, tuliskan rumusnya, seperti yang kita lakukan pada contoh sebelumnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79328\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-pour-obtenir-le-total-cumule-par-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-untuk-mendapatkan-tanggal-berjalan-total\" width=\"462\" height=\"549\"><\/figure><\/div><p> Dan pada akhirnya, seret rumus ini ke sel terakhir dengan tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79329\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-faites-glisser-la-formule-jusqua-la-cellule-de-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"seret rumus ke akhir sel\" width=\"466\" height=\"522\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Jumlah kumulatif per bulan<\/h2><p> Dalam contoh berikut, kami memiliki tanggal di kolom A dan kami ingin menghitung total berjalan berdasarkan bulan, bukan tanggal. Untuk ini, hal pertama yang perlu Anda lakukan adalah menambahkan kolom terpisah dengan nama bulan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79330\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-somme-cumulee-par-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah kumulatif-per-bulan\" width=\"584\" height=\"441\"><\/figure><\/div><p> Nah pada kolom berikutnya masukkan rumus berikut mengacu pada kolom tanggal dan kuantitas pada tabel asli. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(TEXT($A$2:$A$11,\"MMM\")=D2),$B$2:$B$11)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79331\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumproduct-faisant-reference-a-la-date-et-a-la-quantite.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-referensi-produk-tanggal-dan-kuantitas\" width=\"656\" height=\"479\"><\/figure><\/div><p> Rumus ini akan memberi Anda total bulanan untuk setiap bulan. Dan untuk bulan-bulan yang tidak memiliki tanggal akan memiliki 0. Hal berikutnya dari sini adalah menambahkan kolom untuk total berjalan (jumlah berjalan).<\/p><p> Dengan cara yang sama, masukkan fungsi penjumlahan, rujuk ke sel E2 dan E3 dan bekukan baris untuk sel E2 menggunakan tanda dolar sebelum nomor baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79332\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-entrez-la-formule-de-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"masukkan rumus penjumlahan\" width=\"643\" height=\"429\"><\/figure><\/div><p> Setelah itu drag rumus tersebut ke sel bulan terakhir. <\/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\/11\/somme-cumulee.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> Hitung akar pangkat tiga di Excel<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbedaan-persentase\/\">Hitung persen varians (selisih) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akar-pangkat-dua\/\">Hitung Akar Pangkat Dua di Excel + Sisipkan Simbol<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\">Tidak sama dengan operator di Excel<\/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-1683","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 menghitung jumlah nilai kumulatif? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. 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-kumulatif-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung jumlah nilai kumulatif? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.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-kumulatif-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/\",\"name\":\"Bagaimana cara menghitung jumlah nilai kumulatif? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\",\"datePublished\":\"2023-11-11T15:33:29+00:00\",\"dateModified\":\"2023-12-06T06:17:42+00:00\",\"description\":\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung jumlah nilai kumulatif?\"}]},{\"@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 menghitung jumlah nilai kumulatif? - Penasihat Excel","description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. 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-kumulatif-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung jumlah nilai kumulatif? - Penasihat Excel","og_description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.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-kumulatif-2\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/","name":"Bagaimana cara menghitung jumlah nilai kumulatif? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png","datePublished":"2023-11-11T15:33:29+00:00","dateModified":"2023-12-06T06:17:42+00:00","description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk menghitung jumlah kumulatif dari suatu rentang. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-kumulatif-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung jumlah nilai kumulatif?"}]},{"@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\/1683","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=1683"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1683\/revisions"}],"predecessor-version":[{"id":2631,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1683\/revisions\/2631"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}