{"id":1563,"date":"2023-11-17T04:34:59","date_gmt":"2023-11-17T04:34:59","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/"},"modified":"2023-12-10T06:01:22","modified_gmt":"2023-12-10T06:01:22","slug":"yalnizca-gorunur-hucreleri-ekle","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/","title":{"rendered":"Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3827614533\"><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>Yaln\u0131zca Excel&#8217;deki g\u00f6r\u00fcn\u00fcr h\u00fccrelerdeki de\u011ferleri toplamak i\u00e7in (yani bir filtre uygulad\u0131\u011f\u0131n\u0131zda), ALTTOPLAM i\u015flevini kullanman\u0131z gerekir. Bu fonksiyonla aral\u0131\u011f\u0131n tamam\u0131na ba\u015fvurabilirsiniz, ancak bir filtre uygulad\u0131\u011f\u0131n\u0131zda dinamik olarak \u00e7al\u0131\u015f\u0131r ve yaln\u0131zca g\u00f6r\u00fcn\u00fcr h\u00fccrelerin toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte s\u00fctundaki de\u011ferlerin bir listesi var ve s\u00fctuna her filtre uygulad\u0131\u011f\u0131mda bana toplam\u0131 g\u00f6sterebilecek bir form\u00fcl olu\u015fturmak istiyorum. <\/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=\"De\u011ferler listesi\" width=\"429\" height=\"404\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Yaln\u0131zca filtre h\u00fccrelerini toplamak i\u00e7in SUBTOTAL kullan\u0131n<\/h2><ol type=\"1\"><li> \u0130lk olarak B1 h\u00fccresine ALTTOPLAM fonksiyonunu girin.<\/li><li> Bundan sonra ilk arg\u00fcmana 9 veya 109 girin.<\/li><li> Ard\u0131ndan, ikinci arg\u00fcmanda, say\u0131n\u0131n bulundu\u011fu A s\u00fctunundaki aral\u0131\u011f\u0131 belirtin.<\/li><li> Sonunda kapatma parantezlerini girin ve Enter tu\u015funa bas\u0131n. <\/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=\"toplama alt toplam\" width=\"871\" height=\"261\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde hen\u00fcz filtreyi uygulamad\u0131m ve aral\u0131kta sahip oldu\u011fum t\u00fcm de\u011ferlerin toplam\u0131n\u0131 g\u00f6steriyor. <\/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=\"ara toplam-sonu\u00e7\" width=\"489\" height=\"277\"><\/figure><\/div><p> \u015eimdi bu i\u015flevi test etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/filtre-1\/\" data-wpil=\"url\">bir filtre ekleyip uygulayabilirsiniz<\/a> . Bu y\u00fczden filtreden 1, 2 ve 3&#8217;\u00fc se\u00e7ece\u011fim. <\/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=\"filtre ekle\" width=\"519\" height=\"453\"><\/figure><\/div><p> Ve enter tu\u015funa bast\u0131\u011f\u0131m an, yaln\u0131zca filtrelenen h\u00fccrelerin (g\u00f6r\u00fcn\u00fcr) toplam\u0131n\u0131 g\u00f6steriyor. <\/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=\"filtrelenen de\u011ferlerin toplam\u0131\" width=\"505\" height=\"252\"><\/figure><\/div><p> Art\u0131k bu fonksiyon dinamiktir ve filtreyi de\u011fi\u015ftirdi\u011finiz anda sonu\u00e7 de\u011feri g\u00f6r\u00fcnen h\u00fccrelere ba\u011fl\u0131 olarak de\u011fi\u015fir. <\/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=\"dinamik alt toplam i\u015flevi\" 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\"> 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\/additionner-les-cellules-visibles.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\/sutunun-tamamini-ekle\/\">Excel&#8217;de bir s\u00fctunun veya sat\u0131r\u0131n tamam\u0131n\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-hucreler-ekle\/\">Excel&#8217;deki rastgele h\u00fccrelerin toplam\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-satir\/\">Excel&#8217;de toplam sat\u0131r ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-1\/\">Excel&#8217;de Otomatik Toplam\u0131 H\u0131zla Kullan\u0131n<\/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-1563","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 Excel&#039;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?<\/title>\n<meta name=\"description\" content=\"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.\" \/>\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\/yalnizca-gorunur-hucreleri-ekle\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?\" \/>\n<meta property=\"og:description\" content=\"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:22+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=\"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\/yalnizca-gorunur-hucreleri-ekle\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/\",\"name\":\"\u25b7 Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#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-10T06:01:22+00:00\",\"description\":\"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#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\/tr\/yalnizca-gorunur-hucreleri-ekle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?\"}]},{\"@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":"\u25b7 Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?","description":"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.","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\/yalnizca-gorunur-hucreleri-ekle\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?","og_description":"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.","og_url":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:22+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":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/","url":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/","name":"\u25b7 Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#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-10T06:01:22+00:00","description":"Bu form\u00fcl e\u011fitimimizde sadece g\u00f6r\u00fcn\u00fcr h\u00fccrelerin yani filtrelenmi\u015f h\u00fccrelerin nas\u0131l eklenece\u011fini \u00f6\u011frenece\u011fiz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/#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\/tr\/yalnizca-gorunur-hucreleri-ekle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de filtrelenmi\u015f h\u00fccreler nas\u0131l eklenir?"}]},{"@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\/1563","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=1563"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1563\/revisions"}],"predecessor-version":[{"id":2510,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1563\/revisions\/2510"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}