{"id":4761,"date":"2023-07-08T05:20:17","date_gmt":"2023-07-08T05:20:17","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/"},"modified":"2023-07-08T05:20:17","modified_gmt":"2023-07-08T05:20:17","slug":"excel-menghitung-korespondensi-antara-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/","title":{"rendered":"Excel: menghitung jumlah kecocokan antara dua kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut untuk menghitung jumlah kecocokan antara dua kolom di Excel:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A11<\/span> = <span style=\"color: #ff0000;\">B2:B11<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah kecocokan antara rentang <strong>A2:A11<\/strong> dan rentang <strong>B2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga bisa menggunakan rumus berikut untuk menghitung jumlah ketidakcocokan antara dua kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A11<\/span> &lt;&gt; <span style=\"color: #ff0000;\">B2:B11<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol <strong>&lt;&gt;<\/strong> berarti &#8220;tidak sama&#8221; di Excel.<\/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: Hitung jumlah kecocokan antara dua kolom di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua kolom berikut di Excel yang berisi nama-nama tim bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37170 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tapis1.png\" alt=\"\" width=\"427\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung jumlah nama tim yang cocok antara kolom A dan B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A11<\/span> = <span style=\"color: #ff0000;\">B2:B11<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37171\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tapis2.png\" alt=\"Excel menghitung kecocokan antara dua kolom\" width=\"483\" height=\"366\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>4<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi kebenarannya secara manual dengan mengidentifikasi masing-masing nama tim yang cocok di antara dua kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37172 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mat3.png\" alt=\"\" width=\"476\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung jumlah nama tim yang tidak cocok antara kolom A dan B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT(--( <span style=\"color: #3366ff;\">A2:A11<\/span> &lt;&gt; <span style=\"color: #ff0000;\">B2:B11<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37173\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tapis4.png\" alt=\"Excel menghitung ketidakcocokan antara dua kolom\" width=\"534\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Terlihat ada <strong>6<\/strong> tim yang mempunyai nama yang tidak cocok diantara kedua kolomnya.<\/span><\/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\/vlookup-membandingkan-dua-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Dua Daftar di Excel Menggunakan VLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai unik dari beberapa kolom di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/filter-excel-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter banyak kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan sintaks berikut untuk menghitung jumlah kecocokan antara dua kolom di Excel: =SUMPRODUCT(&#8211;( A2:A11 = B2:B11 )) Rumus khusus ini menghitung jumlah kecocokan antara rentang A2:A11 dan rentang B2:B11 . Anda juga bisa menggunakan rumus berikut untuk menghitung jumlah ketidakcocokan antara dua kolom: =SUMPRODUCT(&#8211;( A2:A11 &lt;&gt; B2:B11 )) Catatan : Simbol &lt;&gt; berarti [&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: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta 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-korespondensi-antara-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T05:20:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tapis1.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\/excel-menghitung-korespondensi-antara-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/\",\"name\":\"Excel: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T05:20:17+00:00\",\"dateModified\":\"2023-07-08T05:20:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: menghitung jumlah kecocokan antara dua kolom\"}]},{\"@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: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta 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-korespondensi-antara-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-08T05:20:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tapis1.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\/excel-menghitung-korespondensi-antara-dua-kolom\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/","name":"Excel: menghitung jumlah kecocokan antara dua kolom \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T05:20:17+00:00","dateModified":"2023-07-08T05:20:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah kecocokan antara dua kolom di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-korespondensi-antara-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: menghitung jumlah kecocokan antara dua kolom"}]},{"@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\/4761"}],"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=4761"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4761\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}