{"id":1721,"date":"2023-11-09T19:39:01","date_gmt":"2023-11-09T19:39:01","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/"},"modified":"2023-12-10T06:01:23","modified_gmt":"2023-12-10T06:01:23","slug":"filtrelenen-satirlari-say","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/","title":{"rendered":"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2467477644\"><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>Excel&#8217;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in, ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkendeki sayma i\u015flevini ve filtrelenmi\u015f sat\u0131rlar\u0131 saymak istedi\u011finiz aral\u0131\u011f\u0131 se\u00e7menize olanak tan\u0131yan ALTTOPLAM i\u015flevini kullanabilirsiniz. Bu form\u00fcl\u00fc kulland\u0131ktan sonra bu aral\u0131\u011fa filtre uygulay\u0131p h\u00fccreleri filtreledi\u011finizde yaln\u0131zca g\u00f6r\u00fcnen sat\u0131rlar say\u0131lacakt\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(3,A2:A101) =SUBTOTAL(103,A2:A101)<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte A s\u00fctununda de\u011ferleri olan 100 h\u00fccremiz var. Art\u0131k filtre h\u00fccrelerini uygulad\u0131ktan sonra sat\u0131rlar\u0131 sayman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77694\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\" sizes=\"auto, \" srcset=\"\" alt=\"filtrelenen sat\u0131r say\u0131s\u0131\" width=\"384\" height=\"319\"><\/figure><\/div><h2 id=\"h-steps-to-count-filtered-rows\" class=\"wp-block-heading\"> Filtrelenen sat\u0131rlar\u0131 sayma ad\u0131mlar\u0131<\/h2><ol type=\"1\"><li> \u0130lk olarak B2 h\u00fccresine ALTTOPLAM fonksiyonunu girin.<\/li><li> \u015eimdi ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkende i\u015flev_say\u0131s\u0131 COUNTA&#8217;y\u0131 se\u00e7in veya 3 girin.<\/li><li> Bundan sonra ikinci arg\u00fcmanda A1:A101 aral\u0131\u011f\u0131na bak\u0131n.<\/li><li> Daha sonra fonksiyonu kapatmak i\u00e7in kapatma parantezlerini girin ve girin.<\/li><li> Sonunda, form\u00fcl\u00fcn\u00fcz\u00fcn sonu\u00e7ta filtrelenen sat\u0131r say\u0131s\u0131n\u0131 g\u00f6sterdi\u011fini g\u00f6rmek i\u00e7in A s\u00fctununu filtreleyin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-la-fonction-de-sous-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"alt toplam i\u015flevini kullan\u0131n\" width=\"568\" height=\"235\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(3,A2:A101)<\/code><\/pre><p> Bu ALTTOPLAM i\u015flevini kullanmak size ba\u015fka \u015fekillerde de yard\u0131mc\u0131 olur. Diyelim ki baz\u0131 gizli \u00e7izgileriniz var, bu durumda da size bu gizli \u00e7izgiler olmadan bir say\u0131m verecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77697\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comptes-sans-lignes-cachees.png\" sizes=\"auto, \" srcset=\"\" alt=\"gizli \u00e7izgiler olmadan say\" width=\"510\" height=\"360\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte d\u00f6rt gizli sat\u0131r\u0131m\u0131z var ve sonu\u00e7ta 96 d\u00f6nd\u00fcrd\u00fc.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(103,A2:A101)<\/code><\/pre><p> Filtreyi uygulad\u0131ktan sonra sat\u0131rlar\u0131 sayman\u0131n iki farkl\u0131 yolu oldu\u011funu unutmay\u0131n.<\/p><ul><li> Gizli \u00e7izgilerle sayma<\/li><li> Gizli \u00e7izgiler olmadan say <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77698\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-sous-total-avec-lignes-masquees-et-non-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"gizli-ve-maskesiz-sat\u0131rlarla-ara toplam\" width=\"328\" height=\"344\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/compter-les-lignes-filtrees-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/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\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/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\/tr\/metin-iceren-hucreleri-say\/\">Excel&#8217;de metin i\u00e7eren h\u00fccreleri sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/belirli-karakterleri-say\/\">Excel&#8217;de belirli karakterleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-hucre-sayisini-say\/\">Excel&#8217;de bir aral\u0131ktaki toplam h\u00fccre say\u0131s\u0131n\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\">Excel&#8217;de benzersiz de\u011ferleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/\">COUNT ve COUNTA<\/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-1721","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>Excel&#039;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)<\/title>\n<meta name=\"description\" content=\"Bu derste, Excel&#039;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz\" \/>\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\/tr\/filtrelenen-satirlari-say\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)\" \/>\n<meta property=\"og:description\" content=\"Bu derste, Excel&#039;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\",\"name\":\"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\",\"datePublished\":\"2023-11-09T19:39:01+00:00\",\"dateModified\":\"2023-12-10T06:01:23+00:00\",\"description\":\"Bu derste, Excel&#39;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)","description":"Bu derste, Excel&#39;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz","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\/tr\/filtrelenen-satirlari-say\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)","og_description":"Bu derste, Excel&#39;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz","og_url":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/","url":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/","name":"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r? (2023 K\u0131lavuzu)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","datePublished":"2023-11-09T19:39:01+00:00","dateModified":"2023-12-10T06:01:23+00:00","description":"Bu derste, Excel&#39;de filtrelenmi\u015f sat\u0131rlar\u0131 saymak i\u00e7in form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. Fonksiyonu kullanabilirsiniz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nombre-de-lignes-filtrees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1721"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1721\/revisions"}],"predecessor-version":[{"id":2512,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1721\/revisions\/2512"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}