{"id":2703,"date":"2023-07-21T02:39:01","date_gmt":"2023-07-21T02:39:01","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/"},"modified":"2023-07-21T02:39:01","modified_gmt":"2023-07-21T02:39:01","slug":"jumlah-excel-berdasarkan-kategori","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/","title":{"rendered":"Cara menambahkan nilai berdasarkan kategori di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menjumlahkan nilai kumpulan data di Excel berdasarkan kategori atau grup.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total &#8220;poin&#8221; per tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat11.jpg\" alt=\"\" width=\"474\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat11.jpg\" alt=\"\" width=\"474\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan Kategori Unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=UNIQUE()<\/strong> untuk menghasilkan daftar nilai unik dalam rentang tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SINGLE( <span style=\"color: #3366ff;\">B2:B12<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan daftar tim unik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat12.jpg\" alt=\"\" width=\"485\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan jumlah berdasarkan kategori<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>SUMIF(range, kriteria, sum_range)<\/strong> untuk mencari jumlah poin yang dicetak oleh masing-masing tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>F2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMIF( <span style=\"color: #3366ff;\">$B$2:$C$12<\/span> , <span style=\"color: #ff0000;\">E2<\/span> , <span style=\"color: #800080;\">$C$2:$C$12<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghitung jumlah poin yang dicetak oleh masing-masing tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23813 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat13.jpg\" alt=\"\" width=\"550\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total poin yang dicetak pemain Lakers adalah <strong>21,6<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total poin yang dicetak pemain Mavericks adalah <strong>56,4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total poin yang dicetak pemain Spurs adalah <strong>48,8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total poin yang dicetak pemain di Warriors adalah <strong>65<\/strong> .<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-warna\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan warna di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan berdasarkan bulan di excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-pada-beberapa-lembar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menjumlahkan nilai kumpulan data di Excel berdasarkan kategori atau grup. Misalnya, kita memiliki kumpulan data berikut dan ingin menjumlahkan total &#8220;poin&#8221; per tim: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan nilai data ke dalam Excel: Langkah 2: Temukan Kategori Unik Selanjutnya, kita [&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>Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.\" \/>\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-excel-berdasarkan-kategori\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T02:39:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat11.jpg\" \/>\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-excel-berdasarkan-kategori\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/\",\"name\":\"Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T02:39:01+00:00\",\"dateModified\":\"2023-07-21T02:39:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan nilai berdasarkan kategori di excel\"}]},{\"@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":"Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.","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-excel-berdasarkan-kategori\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/","og_site_name":"Statorials","article_published_time":"2023-07-21T02:39:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sumcat11.jpg"}],"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-excel-berdasarkan-kategori\/","url":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/","name":"Cara menambahkan nilai berdasarkan kategori di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T02:39:01+00:00","dateModified":"2023-07-21T02:39:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan nilai berdasarkan kategori di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan nilai berdasarkan kategori di excel"}]},{"@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\/2703"}],"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=2703"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2703\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}