{"id":2734,"date":"2023-07-20T23:11:54","date_gmt":"2023-07-20T23:11:54","guid":{"rendered":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/"},"modified":"2023-07-20T23:11:54","modified_gmt":"2023-07-20T23:11:54","slug":"sayma-vs-sayma-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/","title":{"rendered":"Excel&#39;de count ve counta: fark nedir?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Excel&#8217;de <strong>COUNT<\/strong> ve <strong>COUNTA<\/strong> i\u015flevlerinin her ikisi de bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 sayar ancak biraz farkl\u0131 davran\u0131\u015flar kullan\u0131rlar:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>COUNT<\/strong> i\u015flevi, say\u0131lar\u0131 i\u00e7eren bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 sayar.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>COUNTA<\/strong> i\u015flevi, bir aral\u0131ktaki bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 sayar.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>COUNT<\/strong> i\u015flevi, <em>say\u0131sal<\/em> de\u011ferler i\u00e7eren bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>COUNTA<\/strong> i\u015flevi, <em>herhangi bir<\/em> de\u011fer i\u00e7eren aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekler her bir fonksiyonun pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 1: Aral\u0131ktaki t\u00fcm de\u011ferler say\u0131sald\u0131r<\/strong><\/span><\/h3>\n<p> Her h\u00fccrenin say\u0131sal (veya bo\u015f) oldu\u011fu bir aral\u0131ktaki <span style=\"color: #000000;\">h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in <strong>COUNT<\/strong> ve <strong>COUTNA<\/strong> i\u015flevlerini kullan\u0131rsak<\/span> <span style=\"color: #000000;\">, her iki i\u015flev de ayn\u0131 de\u011feri d\u00f6nd\u00fcrecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24079 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.jpg\" alt=\"\" width=\"576\" height=\"415\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu durumda <strong>Sat\u0131\u015f<\/strong> s\u00fctununda say\u0131sal de\u011ferler i\u00e7eren 9 h\u00fccre ve bir bo\u015f h\u00fccre bulunur.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>COUNT<\/strong> fonksiyonu bize Sat\u0131\u015f s\u00fctununda <em>say\u0131sal<\/em> de\u011ferlerin bulundu\u011fu 9 h\u00fccrenin bulundu\u011funu s\u00f6yler.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>COUNTA<\/strong> i\u015flevi bize Sat\u0131\u015f s\u00fctununda <em>herhangi bir<\/em> de\u011fere sahip 9 h\u00fccrenin bulundu\u011funu s\u00f6yler.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 2: Aral\u0131ktaki baz\u0131 de\u011ferler say\u0131sal de\u011fildir<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Baz\u0131 h\u00fccrelerin say\u0131sal olmad\u0131\u011f\u0131 bir aral\u0131ktaki h\u00fccrelerin<\/span> <span style=\"color: #000000;\">say\u0131s\u0131n\u0131 saymak i\u00e7in <strong>COUNT<\/strong> ve <strong>COUTNA<\/strong> i\u015flevlerini kullan\u0131rsak<\/span> , iki i\u015flev farkl\u0131 de\u011ferler d\u00f6nd\u00fcrecektir: <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24080 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-3.jpg\" alt=\"\" width=\"524\" height=\"376\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu durumda, <strong>Sat\u0131\u015f<\/strong> s\u00fctunu say\u0131sal de\u011ferler i\u00e7eren yedi h\u00fccre, karakter de\u011ferleri i\u00e7eren iki h\u00fccre ve bir bo\u015f h\u00fccre i\u00e7erir.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>COUNT<\/strong> fonksiyonu bize Sales s\u00fctununda <em>say\u0131sal<\/em> de\u011ferlere sahip 7 h\u00fccrenin bulundu\u011funu s\u00f6yler.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>COUNTA<\/strong> i\u015flevi bize Sat\u0131\u015f s\u00fctununda <em>herhangi bir<\/em> de\u011fere sahip 9 h\u00fccrenin bulundu\u011funu s\u00f6yler.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/excel-filtrelenmis-satirlari-sayar\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de filtrelenmi\u015f sat\u0131rlar nas\u0131l say\u0131l\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-kopyalari-sayar\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de kopyalar nas\u0131l say\u0131l\u0131r<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-grubuna-gore-say\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de gruba g\u00f6re sayma<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;de COUNT ve COUNTA i\u015flevlerinin her ikisi de bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 sayar ancak biraz farkl\u0131 davran\u0131\u015flar kullan\u0131rlar: COUNT i\u015flevi, say\u0131lar\u0131 i\u00e7eren bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 sayar. COUNTA i\u015flevi, bir aral\u0131ktaki bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 sayar. COUNT i\u015flevi, say\u0131sal de\u011ferler i\u00e7eren bir aral\u0131ktaki h\u00fccrelerin say\u0131s\u0131n\u0131 saymak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. COUNTA i\u015flevi, herhangi bir de\u011fer i\u00e7eren aral\u0131ktaki [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-2734","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de COUNT ve COUNTA: Fark nedir? - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#039;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/\" \/>\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: Fark nedir? - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#039;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:11:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/\",\"name\":\"Excel&#39;de COUNT ve COUNTA: Fark nedir? - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-20T23:11:54+00:00\",\"dateModified\":\"2023-07-20T23:11:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#39;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de count ve counta: fark nedir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de COUNT ve COUNTA: Fark nedir? - Statoryaller","description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#39;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de COUNT ve COUNTA: Fark nedir? - Statoryaller","og_description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#39;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:11:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1-2.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/","url":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/","name":"Excel&#39;de COUNT ve COUNTA: Fark nedir? - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-20T23:11:54+00:00","dateModified":"2023-07-20T23:11:54+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere Excel&#39;deki COUNT ve COUNTA i\u015flevleri aras\u0131ndaki fark a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/sayma-vs-sayma-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de count ve counta: fark nedir?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/2734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=2734"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/2734\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=2734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=2734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=2734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}