{"id":3107,"date":"2023-07-19T04:34:20","date_gmt":"2023-07-19T04:34:20","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/"},"modified":"2023-07-19T04:34:20","modified_gmt":"2023-07-19T04:34:20","slug":"excel-menghitung-nilai-unik-dengan-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/","title":{"rendered":"Excel: cara menghitung nilai unik berdasarkan beberapa kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut di Excel untuk menghitung nilai unik berdasarkan beberapa kriteria:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUM(--(LEN(UNIQUE(FILTER( <span style=\"color: #3366ff;\">A:A<\/span> ,(Criteria1)*(Criteria2)*(Criteria3),\"\")))&gt;0))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah nilai unik di kolom A berdasarkan tiga kriteria yang dipenuhi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Hitung nilai unik berdasarkan beberapa kriteria di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan konferensi dan poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26508 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/criteres-uniques1.jpg\" alt=\"\" width=\"466\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menghitung jumlah nama pemain unik yang memenuhi kriteria berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain tersebut berada di Wilayah <strong>Barat<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain memiliki <strong>lebih dari 20<\/strong> poin.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung jumlah nama pemain unik yang memenuhi kriteria ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUM(--(LEN(UNIQUE(FILTER( <span style=\"color: #3366ff;\">A2:A14<\/span> ,( <span style=\"color: #ff0000;\">B2:B14<\/span> =\"West\")*( <span style=\"color: #800080;\">C2:C14<\/span> &gt;20),\"\")))&gt;0))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat mengetikkan rumus ini ke dalam sel E2 pada spreadsheet kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26509 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/criteres-uniques2.jpg\" alt=\"\" width=\"668\" height=\"467\" data-wp-editing=\"1\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya terlihat ada <strong>3<\/strong> nama pemain unik yang berada di Wilayah Barat dan memiliki poin lebih dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya dengan mengidentifikasi secara manual setiap pemain yang memenuhi kedua kriteria:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26511 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/criteres-uniques3.jpg\" alt=\"\" width=\"483\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di antara empat pemain yang memenuhi kedua kriteria tersebut, terdapat tiga nama pemain unik:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Greg<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sean<\/span><\/li>\n<li> <span style=\"color: #000000;\">Mike<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kita melakukan penghitungan tunggal menggunakan dua kriteria, namun kita dapat menggunakan sintaksis serupa untuk menggunakan kriteria sebanyak yang kita inginkan.<\/span><\/span><\/p>\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\/excel-countif-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung jika sel berisi teks<\/a><br \/> Excel: cara menghitung sel yang nilainya tidak sama<br \/> <a href=\"https:\/\/statorials.org\/id\/countif-atau-unggul\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan COUNTIF dengan OR<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut di Excel untuk menghitung nilai unik berdasarkan beberapa kriteria: =SUM(&#8211;(LEN(UNIQUE(FILTER( A:A ,(Criteria1)*(Criteria2)*(Criteria3),&#8221;&#8221;)))&gt;0)) Rumus khusus ini menghitung jumlah nilai unik di kolom A berdasarkan tiga kriteria yang dipenuhi. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Hitung nilai unik berdasarkan beberapa kriteria di Excel Katakanlah kita memiliki kumpulan [&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 nilai unik berdasarkan beberapa kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria 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-menghitung-nilai-unik-dengan-beberapa-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung nilai unik berdasarkan beberapa kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T04:34:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/criteres-uniques1.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-menghitung-nilai-unik-dengan-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/\",\"name\":\"Excel: Cara menghitung nilai unik berdasarkan beberapa kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T04:34:20+00:00\",\"dateModified\":\"2023-07-19T04:34:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung nilai unik berdasarkan beberapa kriteria\"}]},{\"@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 nilai unik berdasarkan beberapa kriteria - Statorial","description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria 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-menghitung-nilai-unik-dengan-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung nilai unik berdasarkan beberapa kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-19T04:34:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/criteres-uniques1.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-menghitung-nilai-unik-dengan-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/","name":"Excel: Cara menghitung nilai unik berdasarkan beberapa kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T04:34:20+00:00","dateModified":"2023-07-19T04:34:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai unik berdasarkan beberapa kriteria di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-nilai-unik-dengan-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung nilai unik berdasarkan beberapa kriteria"}]},{"@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\/3107"}],"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=3107"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3107\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}