{"id":1553,"date":"2023-11-17T07:39:08","date_gmt":"2023-11-17T07:39:08","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/azsa-say\/"},"modified":"2023-12-10T05:58:44","modified_gmt":"2023-12-10T05:58:44","slug":"azsa-say","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/azsa-say\/","title":{"rendered":"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1230400190\"><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 belirli bir de\u011ferden k\u00fc\u00e7\u00fck veya daha d\u00fc\u015f\u00fck bir de\u011fere sahip h\u00fccreleri saymak istiyorsan\u0131z COUNTIF i\u015flevini kullanman\u0131z gerekir. Bu fonksiyonla say\u0131lacak bir de\u011fer aral\u0131\u011f\u0131, ard\u0131ndan a\u015fa\u011f\u0131daki h\u00fccreleri sayacak bir dizi kriter belirleyebilirsiniz.<\/p><p> Bu form\u00fcl e\u011fitiminde bunu anlamak i\u00e7in baz\u0131 \u00f6rneklere bakaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> Daha az h\u00fccre saymak i\u00e7in COUNTIF<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte s\u00fctunda bir de\u011ferler listemiz var (1000 rakamdan olu\u015fan bir liste). \u015eimdi 45&#8217;ten k\u00fc\u00e7\u00fck h\u00fccreleri sayman\u0131z gerekiyor. COUNTIF kullanman\u0131z gerekti\u011fini s\u00f6yledi\u011fim gibi bu form\u00fcl\u00fc B1 h\u00fccresine yazaca\u011f\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67115\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"De\u011ferler listesi\" width=\"357\" height=\"395\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz:<\/p><ol type=\"1\"><li> \u0130lk olarak, B1 h\u00fccresine E\u011eERSAY i\u015flevini yazmaya ba\u015flay\u0131n (Enter =COUNTIF).<\/li><li> Bundan sonra, fonksiyonun ilk arg\u00fcman\u0131nda A s\u00fctununa bak\u0131n, yaln\u0131zca A1:A101&#8217;e de ba\u015fvurabilirsiniz.<\/li><li> \u015eimdi bir virg\u00fcl yaz\u0131n ve ikinci arg\u00fcman\u0131 girin.<\/li><li> Oradan kriterlere ili\u015fkin arg\u00fcman\u0131 belirtmeniz gerekir. Bu nedenle \u00e7ift t\u0131rnak i\u015faretiyle &lt;=45 yaz\u0131n.<\/li><li> Sonunda kapatma parantezlerini yaz\u0131n 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-67116\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-countif-fonction-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131lan say\u0131 i\u015flevi\" width=\"413\" height=\"344\"><\/figure><\/div><p> Ve Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda, de\u011feri 46&#8217;dan k\u00fc\u00e7\u00fck veya ona e\u015fit olan h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67117\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-nombre-de-valeurs-selon-les-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"kriterlere g\u00f6re-de\u011fer say\u0131s\u0131\" width=\"462\" height=\"323\"><\/figure><\/div><p> Kriter de\u011ferini i\u00e7eren bir h\u00fccreyi de belirtebilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnekte, B1 h\u00fccresinde \u00f6l\u00e7\u00fct olarak kullanmak istedi\u011finiz bir de\u011fer var ve ard\u0131ndan i\u015flevdeki h\u00fccreye ba\u015fvuruda bulunuyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67118\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-countif-avec-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6l\u00e7\u00fctlere sahip hesap\" width=\"472\" height=\"287\"><\/figure><\/div><p> \u015eimdi g\u00f6r\u00fcyorsan\u0131z B4 h\u00fccresinde form\u00fcl\u00fcm\u00fcz var. \u015eimdi bu form\u00fclde A1:A101 aral\u0131\u011f\u0131na de\u011findik.<\/p><p> Kriterleri belirtmemiz gereken ikinci arg\u00fcmanda ise b\u00fcy\u00fck ve e\u015fit operat\u00f6r\u00fcn\u00fc \u00e7ift t\u0131rnak kullanarak girdik.<\/p><p> Bundan sonra ve i\u015fareti kulland\u0131k ve B1 h\u00fccresine at\u0131fta bulunduk.<\/p><p> B\u00f6ylece kriterleri de\u011fi\u015ftirmek istiyorsan\u0131z form\u00fcl\u00fcn de\u011ferini de\u011fi\u015ftirmenize gerek kalmaz, B1 h\u00fccresinden de\u011fi\u015ftirebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Paket servis<\/h2><ol type=\"1\"><li> &lt;= kulland\u0131\u011f\u0131n\u0131zda, Excel bunu k\u00fc\u00e7\u00fck ve e\u015fittir olarak de\u011ferlendirir. Yani &lt;= 45 kullan\u0131rsan\u0131z bu, 45&#8217;ten k\u00fc\u00e7\u00fck t\u00fcm de\u011ferler anlam\u0131na gelir. Ancak yaln\u0131zca &lt; kullan\u0131rsan\u0131z, yaln\u0131zca &lt;= 45&#8217;ten k\u00fc\u00e7\u00fck de\u011ferlere at\u0131fta bulundu\u011funuz anlam\u0131na gelir, \u00f6rne\u011fin &lt;45, 45&#8217;ten k\u00fc\u00e7\u00fck de\u011ferler anlam\u0131na gelir.<\/li><li> Ayr\u0131ca COUNTIFS fonksiyonunu kullanarak birden fazla kriter olu\u015fturabilir ve bunun d\u0131\u015f\u0131nda Excel&#8217;de COUNTIF VEYA&#8217;y\u0131 kullanarak mant\u0131k olu\u015fturabilir veya daha k\u00fc\u00e7\u00fck de\u011ferleri sayarken kullanabilirsiniz. <\/li><\/ol><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\/08\/compter-si-moins-de-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\/iki-sayinin-arasini-saymak\/\">Excel&#8217;de iki say\u0131 (E\u011eERSAY) aras\u0131nda say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/esit-olmayan-hucreleri-say\/\">Excel&#8217;de e\u015fit olmayan h\u00fccreleri say (COUNTIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-olmayan-hucreleri-say\/\">Excel&#8217;de bo\u015f olmayan h\u00fccreleri sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sifirdan-buyuk-hesap\/\">Excel&#8217;de 0&#8217;dan (COUNTIF) b\u00fcy\u00fck say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayimlar-sayim-veya-mantiksal\/\">VEYA Excel&#8217;de COUNTIF\/COUNIFS&#8217;de Mant\u0131k<\/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-1553","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>Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#039;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/azsa-say\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#039;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/azsa-say\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/\",\"name\":\"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"datePublished\":\"2023-11-17T07:39:08+00:00\",\"dateModified\":\"2023-12-10T05:58:44+00:00\",\"description\":\"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#39;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/azsa-say\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/azsa-say\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler 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":"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?","description":"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#39;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","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\/azsa-say\/","og_locale":"tr_TR","og_type":"article","og_title":"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?","og_description":"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#39;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/azsa-say\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/","url":"https:\/\/exceladvisor.org\/tr\/azsa-say\/","name":"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler nas\u0131l say\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","datePublished":"2023-11-17T07:39:08+00:00","dateModified":"2023-12-10T05:58:44+00:00","description":"Bu e\u011fitimde, kolay form\u00fcller kullanarak Excel&#39;deki belirli karakterleri sayman\u0131n farkl\u0131 yollar\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/azsa-say\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/azsa-say\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Belirli bir de\u011ferin alt\u0131ndaki h\u00fccreler 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\/1553","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=1553"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1553\/revisions"}],"predecessor-version":[{"id":2266,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1553\/revisions\/2266"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}