{"id":1565,"date":"2023-11-17T04:34:59","date_gmt":"2023-11-17T04:34:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/"},"modified":"2023-12-06T06:15:42","modified_gmt":"2023-12-06T06:15:42","slug":"tambahkan-hanya-sel-yang-terlihat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/","title":{"rendered":"Bagaimana cara menambahkan sel yang difilter di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2045262512\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk menjumlahkan nilai hanya dari sel yang terlihat di Excel (yaitu ketika Anda telah menerapkan filter), Anda perlu menggunakan fungsi SUBTOTAL. Dengan fungsi ini, Anda dapat merujuk ke seluruh rentang, tetapi segera setelah Anda menerapkan filter, filter akan bekerja secara dinamis dan menampilkan jumlah hanya untuk sel yang terlihat.<\/p><p> Dalam contoh berikut kita memiliki daftar nilai di kolom dan saya ingin membuat rumus yang dapat menunjukkan jumlahnya setiap kali saya menerapkan filter ke kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67630\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar nilai\" width=\"429\" height=\"404\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan SUBTOTAL untuk menjumlahkan sel filter saja<\/h2><ol type=\"1\"><li> Pertama, di sel B1, masukkan fungsi SUBTOTAL.<\/li><li> Setelah itu, pada argumen pertama masukkan 9 atau 109.<\/li><li> Kemudian, pada argumen kedua, tentukan rentang di kolom A, di mana Anda memiliki nomor tersebut.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67631\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sous-total-a-sommer.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotal ke jumlah\" width=\"871\" height=\"261\"><\/figure><\/div><p> Dalam cuplikan berikut, saya belum menerapkan filter dan ini menunjukkan jumlah semua nilai yang saya miliki dalam rentang tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67632\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultat-de-sous-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil subtotal\" width=\"489\" height=\"277\"><\/figure><\/div><p> Sekarang untuk menguji fungsi ini Anda dapat <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-1\/\" data-wpil=\"url\">menambahkan filter dan menerapkannya<\/a> . Jadi saya akan memilih 1, 2 dan 3 dari filter. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67633\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-un-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan penyaring\" width=\"519\" height=\"453\"><\/figure><\/div><p> Dan saat saya menekan enter, menampilkan jumlah hanya untuk sel yang difilter (terlihat). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67634\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-des-valeurs-filtrees.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah nilai yang difilter\" width=\"505\" height=\"252\"><\/figure><\/div><p> Sekarang fungsi ini bersifat dinamis dan segera setelah Anda mengubah filter, nilai hasil berubah tergantung pada sel yang terlihat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67635\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fonction-de-sous-total-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi subtotal dinamis\" width=\"522\" height=\"355\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(9,A2:A1001)<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/additionner-les-cellules-visibles.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-seluruh-kolom\/\">Tambahkan seluruh kolom atau baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-sel-acak\/\">Jumlah sel acak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-keseluruhan\/\">Tambahkan baris total di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-1\/\">Gunakan AutoSum di Excel dengan cepat<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1565","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"datePublished\":\"2023-11-17T04:34:59+00:00\",\"dateModified\":\"2023-12-06T06:15:42+00:00\",\"description\":\"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan sel yang difilter di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?","description":"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.","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:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?","og_description":"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/","name":"\u25b7 Bagaimana cara menambahkan sel yang difilter di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","datePublished":"2023-11-17T04:34:59+00:00","dateModified":"2023-12-06T06:15:42+00:00","description":"Dalam tutorial rumus ini, kita akan mempelajari cara menambahkan hanya sel yang terlihat, yaitu sel yang difilter.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-hanya-sel-yang-terlihat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan sel yang difilter di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1565"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1565\/revisions"}],"predecessor-version":[{"id":2442,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1565\/revisions\/2442"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}