{"id":2044,"date":"2023-10-23T00:01:03","date_gmt":"2023-10-23T00:01:03","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/"},"modified":"2023-12-10T05:59:15","modified_gmt":"2023-12-10T05:59:15","slug":"saymaya-karsi-saymak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/","title":{"rendered":"Count ve counta aras\u0131ndaki fark nedir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1042071370\"><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 s\u0131k kullan\u0131lan iki COUNT ve COUNTA i\u015flevi vard\u0131r. Her iki i\u015flev de ayn\u0131 \u015fekilde \u00e7al\u0131\u015f\u0131r ancak aralar\u0131nda b\u00fcy\u00fck bir fark vard\u0131r; bunlar\u0131 en iyi \u015fekilde nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 bilmeniz gerekir.<\/p><ul><li> <strong>COUNT<\/strong> : Bu fonksiyon, h\u00fccrede de\u011fer olarak say\u0131n\u0131n bulundu\u011fu h\u00fccreleri sayar. \u00d6rne\u011fin, A1:A10 aral\u0131\u011f\u0131nda say\u0131sal de\u011ferlere sahip 5 h\u00fccreniz varsa, COUNT sonu\u00e7ta 5 sonucunu verecektir.<\/li><li> <strong>COUNTA<\/strong> : Bu i\u015flev, de\u011ferlerinizin bulundu\u011fu h\u00fccreleri, yani bo\u015f veya bo\u015f olmayan h\u00fccreleri sayar. \u00d6rne\u011fin, A1:A10 aral\u0131\u011f\u0131nda de\u011ferleri olan 7 h\u00fccreniz varsa sonu\u00e7ta 7 de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70604\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\" sizes=\"auto, \" srcset=\"\" alt=\"saymaya kar\u015f\u0131 sayma\" width=\"480\" height=\"331\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Fark\u0131 anlamak i\u00e7in \u00f6rnek (COUNT vs. COUNTA)<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte, A s\u00fctununda say\u0131lar, metinler, semboller ve bo\u015f de\u011ferler dahil olmak \u00fczere farkl\u0131 t\u00fcrde de\u011ferlerimizin bulundu\u011fu bir de\u011ferler listemiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70605\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cellules-avec-des-valeurs-differentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"farkl\u0131-de\u011ferlere sahip h\u00fccreler\" width=\"330\" height=\"427\"><\/figure><\/div><p> Art\u0131k COUNT fonksiyonunu kulland\u0131\u011f\u0131n\u0131zda sonu\u00e7ta 3 de\u011ferini d\u00f6nd\u00fcr\u00fcyor \u00e7\u00fcnk\u00fc 9&#8217;dan yaln\u0131zca \u00fc\u00e7 de\u011feriniz var, yani say\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70606\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-la-formule-de-comptage.png\" sizes=\"auto, \" srcset=\"\" alt=\"sayma form\u00fcl\u00fcn\u00fc kullan\" width=\"417\" height=\"403\"><\/figure><\/div><p> Ancak ayn\u0131 aral\u0131k i\u00e7in COUNTA fonksiyonunu kulland\u0131\u011f\u0131n\u0131zda sonu\u00e7ta 9 de\u011ferini d\u00f6nd\u00fcr\u00fcr \u00e7\u00fcnk\u00fc aral\u0131ktaki de\u011fere sahip 9 h\u00fccremiz vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-la-formule-counta.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131m-counta-form\u00fcl\u00fc\" width=\"381\" height=\"390\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bu ikisi aras\u0131nda hangi fonksiyon daha iyi<\/h2><p> Her iki i\u015flev de kullan\u0131\u015fl\u0131d\u0131r ve kullan\u0131m\u0131 kolayd\u0131r, ancak ger\u00e7ek d\u00fcnya senaryosunda COUNTA, say\u0131 i\u00e7eren h\u00fccreleri saymaktan daha s\u0131k de\u011ferlere sahip h\u00fccreleri sayman\u0131za yard\u0131mc\u0131 olabilece\u011finden daha anlaml\u0131d\u0131r. Ancak bu COUNT i\u015flevinin kullan\u0131\u015fl\u0131l\u0131\u011f\u0131n\u0131 azaltmaz; verileri analiz eden ki\u015filer COUNT i\u015flevini \u00e7ok kullan\u0131r.<\/p><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><\/ul><\/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-2044","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 COUNT ve COUNTA aras\u0131ndaki fark nedir?<\/title>\n<meta name=\"description\" content=\"Bu form\u00fcl e\u011fitiminde, Excel&#039;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \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\/saymaya-karsi-saymak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de COUNT ve COUNTA aras\u0131ndaki fark nedir?\" \/>\n<meta property=\"og:description\" content=\"Bu form\u00fcl e\u011fitiminde, Excel&#039;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \u00f6\u011frenece\u011fiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.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\/saymaya-karsi-saymak\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/\",\"name\":\"Excel&#39;de COUNT ve COUNTA aras\u0131ndaki fark nedir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"datePublished\":\"2023-10-23T00:01:03+00:00\",\"dateModified\":\"2023-12-10T05:59:15+00:00\",\"description\":\"Bu form\u00fcl e\u011fitiminde, Excel&#39;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \u00f6\u011frenece\u011fiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Count ve counta aras\u0131ndaki fark nedir?\"}]},{\"@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 COUNT ve COUNTA aras\u0131ndaki fark nedir?","description":"Bu form\u00fcl e\u011fitiminde, Excel&#39;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \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\/saymaya-karsi-saymak\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de COUNT ve COUNTA aras\u0131ndaki fark nedir?","og_description":"Bu form\u00fcl e\u011fitiminde, Excel&#39;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \u00f6\u011frenece\u011fiz.","og_url":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.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\/saymaya-karsi-saymak\/","url":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/","name":"Excel&#39;de COUNT ve COUNTA aras\u0131ndaki fark nedir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","datePublished":"2023-10-23T00:01:03+00:00","dateModified":"2023-12-10T05:59:15+00:00","description":"Bu form\u00fcl e\u011fitiminde, Excel&#39;de sahip oldu\u011fumuz COUNT i\u015flevi ile COUNTA i\u015flevi aras\u0131ndaki fark\u0131 \u00f6\u011frenece\u011fiz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/saymaya-karsi-saymak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Count ve counta aras\u0131ndaki fark nedir?"}]},{"@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\/2044","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=2044"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2044\/revisions"}],"predecessor-version":[{"id":2307,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2044\/revisions\/2307"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}