{"id":5087,"date":"2023-07-03T22:06:52","date_gmt":"2023-07-03T22:06:52","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/"},"modified":"2023-07-03T22:06:52","modified_gmt":"2023-07-03T22:06:52","slug":"excel-menghitung-berdasarkan-warna","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/","title":{"rendered":"Cara menghitung sel berdasarkan warna di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung jumlah sel di Excel berdasarkan warnanya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki kumpulan data berikut dan ingin menghitung jumlah sel per warna:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34810 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc2.png\" alt=\"\" width=\"494\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara termudah untuk melakukannya adalah dengan menulis kode VBA di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini mungkin tampak menakutkan jika Anda belum terbiasa dengan VBA, namun prosesnya sederhana dan contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\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-34810 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc2.png\" alt=\"\" width=\"494\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tampilkan Tab Pengembang di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu memastikan bahwa tab <strong>Pengembang<\/strong> terlihat di pita atas Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik tab <strong>File<\/strong> , lalu <strong>Opsi<\/strong> , lalu <strong>Sesuaikan Pita<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di bawah bagian berjudul <strong>Main Tabs<\/strong> , centang kotak di samping <strong>Developer<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34809 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc1.png\" alt=\"\" width=\"698\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat Makro Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Pengembang<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Visual Basic<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc3.png\" alt=\"\" width=\"640\" height=\"197\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Modul<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc4.png\" alt=\"\" width=\"513\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, tempelkan kode berikut ke dalam editor kode modul:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Function<\/span> CountByColor(CellRange As Range, CellColor As Range)\n\n<span style=\"color: #0000ff;\">Dim<\/span> CellColorValue <span style=\"color: #0000ff;\">As<\/span> Integer\n<span style=\"color: #0000ff;\">Dim<\/span> RunningCount <span style=\"color: #0000ff;\">As<\/span> Long\n\nCellColorValue = CellColor.Interior.ColorIndex\n<span style=\"color: #0000ff;\">Set<\/span> i = CellRange\n\n<span style=\"color: #0000ff;\">For Each<\/span> i <span style=\"color: #0000ff;\">In<\/span> CellRange\n    <span style=\"color: #0000ff;\">If<\/span> i.Interior.ColorIndex = CellColorValue <span style=\"color: #0000ff;\">Then<\/span>\n    RunningCount = RunningCount + 1\n<span style=\"color: #0000ff;\">End If<\/span>\n<span style=\"color: #0000ff;\">Next<\/span> i\n\nCountByColor = RunningCount\n\n<span style=\"color: #0000ff;\">End Function\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara melakukannya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39632 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptecouleur0.png\" alt=\"\" width=\"668\" height=\"560\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian tutup editor VB.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Gunakan Makro untuk Menghitung berdasarkan Warna<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa menggunakan makro yang kita buat untuk menghitung jumlah sel berdasarkan warna.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, isi sel <strong>C2:C4<\/strong> dengan warna yang ingin Anda cari hitungannya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketikkan rumus berikut pada sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=CountByColor( <span style=\"color: #3366ff;\">$A$2:$A$11<\/span> , <span style=\"color: #ff0000;\">C2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Seret dan isi rumus ini ke setiap sel yang tersisa di kolom D dan rumus akan secara otomatis menghitung setiap sel dengan warna latar belakang tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39634 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptecouleur2.png\" alt=\"\" width=\"513\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah sel dengan latar belakang hijau muda adalah <strong>3<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah sel dengan latar belakang biru muda adalah <strong>4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah sel pada latar belakang oranye terang adalah <strong>3<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda memberikan warna sel di kolom C yang tidak ada dalam rentang pencarian, maka fungsinya hanya akan mengembalikan nilai 0.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-per-warna\/\" target=\"_blank\" rel=\"noopener\">Cara Rata-Rata Berdasarkan Warna 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\/excel-hitungan-tunggal-per-grup\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai unik berdasarkan grup di Excel<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung jumlah sel di Excel berdasarkan warnanya. Misalnya, kita memiliki kumpulan data berikut dan ingin menghitung jumlah sel per warna: Cara termudah untuk melakukannya adalah dengan menulis kode VBA di Excel. Ini mungkin tampak menakutkan jika Anda belum terbiasa dengan VBA, namun prosesnya sederhana dan contoh langkah demi langkah berikut menunjukkan [&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 Menghitung Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna 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\/excel-menghitung-berdasarkan-warna\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T22:06:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc2.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=\"2 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-berdasarkan-warna\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/\",\"name\":\"Cara Menghitung Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T22:06:52+00:00\",\"dateModified\":\"2023-07-03T22:06:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung sel berdasarkan warna di excel (dengan contoh)\"}]},{\"@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 Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna 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\/excel-menghitung-berdasarkan-warna\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/","og_site_name":"Statorials","article_published_time":"2023-07-03T22:06:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc2.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/","name":"Cara Menghitung Sel Berdasarkan Warna di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T22:06:52+00:00","dateModified":"2023-07-03T22:06:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung sel berdasarkan warna di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-berdasarkan-warna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung sel berdasarkan warna di excel (dengan contoh)"}]},{"@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\/5087"}],"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=5087"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5087\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}