{"id":3309,"date":"2023-07-18T04:08:46","date_gmt":"2023-07-18T04:08:46","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/"},"modified":"2023-07-18T04:08:46","modified_gmt":"2023-07-18T04:08:46","slug":"excel-hitungan-tunggal-per-grup","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/","title":{"rendered":"Cara menghitung nilai unik berdasarkan grup di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menghitung jumlah nilai unik per grup di Excel:<\/span><\/p>\n

 =SUMPRODUCT(( $A$2:$A$13<\/span> = A2<\/span> )\/COUNTIFS( $B$2:$B$13<\/span> , $B$2:$B$13<\/span> , $A$2:$A$13<\/span> , $A$2:$A$13<\/span> ))\n<\/strong><\/pre>\n
 Rumus ini mengasumsikan bahwa nama grup berada dalam rentang A2:A13<\/strong> dan nilainya berada dalam rentang B2:B13<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Hitung nilai unik berdasarkan grup di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang misalkan kita ingin menghitung jumlah nilai poin unik, yang dikelompokkan berdasarkan tim.<\/span><\/p>\n
 Untuk melakukan ini, kita dapat menggunakan fungsi =UNIQUE()<\/strong> untuk membuat daftar tim unik terlebih dahulu. Kami akan mengetikkan rumus berikut di sel D2:<\/span><\/p>\n
 = SINGLE<\/span> ( A2:A13<\/span> )<\/strong><\/pre>\n
 Setelah kita menekan Enter, daftar nama tim unik akan ditampilkan:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang kita bisa mengetikkan rumus berikut ke dalam sel E2 untuk menghitung jumlah nilai poin unik Lakers:<\/span> <\/p>\n
 =SUMPRODUCT(( $A$2:$A$13<\/span> = D2<\/span> )\/COUNTIFS( $B$2:$B$13<\/span> , $B$2:$B$13<\/span> , $A$2:$A$13<\/span> , $A$2:$A$13<\/span> ))<\/strong> <\/pre>\n
\"\"<\/p>\n
 Kami kemudian akan menyeret rumus ini ke sel yang tersisa di kolom E:<\/span> <\/p>\n
\"\"<\/p>\n
 Itu dia!<\/span><\/p>\n
 Kolom D menampilkan masing-masing tim unik dan kolom E menampilkan jumlah nilai poin unik setiap tim.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: cara menghitung jika sel berisi teks<\/a>
 Excel: Cara menggunakan COUNTIF dengan banyak rentang<\/a>
 Excel: cara menghitung nilai unik berdasarkan beberapa kriteria<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk menghitung jumlah nilai unik per grup di Excel: =SUMPRODUCT(( $A$2:$A$13 = A2 )\/COUNTIFS( $B$2:$B$13 , $B$2:$B$13 , $A$2:$A$13 , $A$2:$A$13 )) Rumus ini mengasumsikan bahwa nama grup berada dalam rentang A2:A13 dan nilainya berada dalam rentang B2:B13 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Hitung […]<\/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":"\nCara menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup 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\/excel-hitungan-tunggal-per-grup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T04:08:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-unique1.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\/excel-hitungan-tunggal-per-grup\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/\",\"name\":\"Cara menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T04:08:46+00:00\",\"dateModified\":\"2023-07-18T04:08:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung nilai unik berdasarkan grup 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 menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup 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\/excel-hitungan-tunggal-per-grup\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/","og_site_name":"Statorials","article_published_time":"2023-07-18T04:08:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-unique1.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\/excel-hitungan-tunggal-per-grup\/","url":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/","name":"Cara menghitung nilai unik berdasarkan grup di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T04:08:46+00:00","dateModified":"2023-07-18T04:08:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan grup di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hitungan-tunggal-per-grup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung nilai unik berdasarkan grup 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\/3309"}],"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=3309"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3309\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}