{"id":4792,"date":"2023-07-07T21:43:56","date_gmt":"2023-07-07T21:43:56","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/"},"modified":"2023-07-07T21:43:56","modified_gmt":"2023-07-07T21:43:56","slug":"excel-menghitung-format-bersyarat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/","title":{"rendered":"Cara menghitung sel yang diformat secara kondisional di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung jumlah sel yang diformat secara kondisional di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fungsi <strong>Filter<\/strong> yang dikombinasikan dengan rumus <strong>SUBTOTAL<\/strong> di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Sel yang Diformat Secara Kondisional di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang telah menggunakan pemformatan bersyarat untuk menambahkan latar belakang merah ke setiap nilai di kolom titik dengan nilai lebih besar dari 30:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37403 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc11.png\" alt=\"\" width=\"506\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah sel dalam kumpulan data ini yang telah diformat secara kondisional.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, pertama-tama kita perlu memfilter kumpulan data agar hanya menampilkan sel dengan format bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan sel mana pun yang memiliki pemformatan bersyarat, lalu klik <strong>Filter<\/strong> di menu tarik-turun, lalu klik <strong>Filter menurut Warna Sel yang Dipilih<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37404 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc12.png\" alt=\"\" width=\"571\" height=\"542\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kumpulan data akan secara otomatis difilter untuk menampilkan hanya baris yang memiliki latar belakang merah di kolom poin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37405 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc13.png\" alt=\"\" width=\"430\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, ketikkan rumus berikut di sel <b>B12<\/b> untuk menghitung jumlah baris yang diformat secara kondisional:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUBTOTAL(102, <span style=\"color: #3366ff;\">B5:B9<\/span> )\n<\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37406 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc14.png\" alt=\"\" width=\"512\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa 3 sel dalam kumpulan data asli memiliki format bersyarat.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Nilai <strong>102<\/strong> pada fungsi <strong>SUBTOTAL<\/strong> merupakan <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/subtotal-function-7b027003-f060-4ade-9040-e478765b9939\" target=\"_blank\" rel=\"noopener\">jalan pintas<\/a> untuk mencari jumlah rentang baris yang difilter.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tanggal-terlambat-pemformatan-bersyarat-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Terapkan pemformatan bersyarat pada tanggal jatuh tempo<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-kondisional-excel-antara-dua-tanggal\/\" target=\"_blank\" rel=\"noopener\">Excel: terapkan pemformatan bersyarat jika sel berada di antara dua tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-pemformatan-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Excel: Menerapkan pemformatan bersyarat berdasarkan beberapa kondisi<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung jumlah sel yang diformat secara kondisional di Excel. Untungnya, hal ini mudah dilakukan menggunakan fungsi Filter yang dikombinasikan dengan rumus SUBTOTAL di Excel. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Menghitung Sel yang Diformat Secara Kondisional di Excel Katakanlah kita memiliki kumpulan data berikut di Excel yang telah menggunakan [&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 berformat kondisional di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.\" \/>\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-format-bersyarat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung sel berformat kondisional di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T21:43:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc11.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-format-bersyarat\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/\",\"name\":\"Cara menghitung sel berformat kondisional di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T21:43:56+00:00\",\"dateModified\":\"2023-07-07T21:43:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung sel yang diformat secara kondisional 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 sel berformat kondisional di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.","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-format-bersyarat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung sel berformat kondisional di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/","og_site_name":"Statorials","article_published_time":"2023-07-07T21:43:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cc11.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-format-bersyarat\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/","name":"Cara menghitung sel berformat kondisional di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T21:43:56+00:00","dateModified":"2023-07-07T21:43:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah sel yang tunduk pada pemformatan bersyarat, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-format-bersyarat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung sel yang diformat secara kondisional 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\/4792"}],"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=4792"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4792\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}