{"id":4681,"date":"2023-07-09T00:27:07","date_gmt":"2023-07-09T00:27:07","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/"},"modified":"2023-07-09T00:27:07","modified_gmt":"2023-07-09T00:27:07","slug":"jumlah-kumulatif-excel-berdasarkan-kelompok","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/","title":{"rendered":"Excel: cara menghitung jumlah kumulatif berdasarkan kelompok"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung jumlah kumulatif berdasarkan grup di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B$2:B2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengasumsikan bahwa nilai grup ada di kolom A dan nilai yang akan ditambahkan ada di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: menghitung jumlah kumulatif berdasarkan kelompok di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36549 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupec1.png\" alt=\"\" width=\"442\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghitung poin kumulatif untuk setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">A$2:A2<\/span> , <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">B$2:B2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36550 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupec2.png\" alt=\"\" width=\"477\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menampilkan nilai poin kumulatif setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Poin kumulatif untuk <strong>Mavs<\/strong> adalah: 22, 36, 56<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total poin <strong>Warriors<\/strong> adalah: 17<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total poin <strong>Hawks<\/strong> adalah: 33, 53, 77<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin kumulatif untuk <strong>Raja<\/strong> adalah: 28, 53<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin kumulatif untuk <strong>Blazers<\/strong> adalah: 18, 31, 41<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai di kolom jumlah yang berjalan dimulai ulang untuk setiap nama tim baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Rumus ini berfungsi meskipun setiap nama tim tidak dikelompokkan bersama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah berdasarkan kelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Relatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung jumlah kumulatif berdasarkan grup di Excel: =SUMIF( A$2:A2 , A2 , B$2:B2 ) Contoh khusus ini mengasumsikan bahwa nilai grup ada di kolom A dan nilai yang akan ditambahkan ada di kolom B. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: menghitung jumlah kumulatif berdasarkan kelompok [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T00:27:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupec1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/\",\"name\":\"Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T00:27:07+00:00\",\"dateModified\":\"2023-07-09T00:27:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung jumlah kumulatif berdasarkan kelompok\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.","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:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/","og_site_name":"Statorials","article_published_time":"2023-07-09T00:27:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/groupec1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/","url":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/","name":"Excel: Cara menghitung jumlah kumulatif berdasarkan grup - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T00:27:07+00:00","dateModified":"2023-07-09T00:27:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah berjalan berdasarkan grup di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-kumulatif-excel-berdasarkan-kelompok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung jumlah kumulatif berdasarkan kelompok"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4681"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4681"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4681\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}