{"id":15332,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/cokegersay\/"},"modified":"2021-02-25T16:24:14","modified_gmt":"2021-02-25T16:24:14","slug":"countifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/countifs\/","title":{"rendered":"\u00c7OKE\u011eERSAY"},"content":{"rendered":"<p><b>COUNTIFS<\/b>, \u0130ngilizcesi ile <b>COUNTIFS<\/b>, Microsoft Excel ve Google Sheets&#8217;te belirli kriterlere uyan h\u00fccre say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131lan bir fonksiyondur. Bu fonksiyon, \u00e7oklu kriter deste\u011fi sunar ve belirlenen kriterlere uygun h\u00fccrelerin say\u0131s\u0131n\u0131 geri d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131da, bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131na ili\u015fkin detayl\u0131 bir a\u00e7\u0131klama yer almaktad\u0131r.<\/p>\n<h2>Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n<p><code>COUNTIFS<\/code> fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre><code>COUNTIFS(kriter_aral\u0131\u011f\u01311, kriter1, [kriter_aral\u0131\u011f\u01312, kriter2], ...)<\/code><\/pre>\n<ul>\n<li><b>kriter_aral\u0131\u011f\u01311, kriter_aral\u0131\u011f\u01312, &#8230;<\/b>: Bu parametreler, ko\u015fullar\u0131n uygulanaca\u011f\u0131 h\u00fccre aral\u0131klar\u0131n\u0131 tan\u0131mlar.<\/li>\n<li><b>kriter1, kriter2, &#8230;<\/b>: Bu parametreler, ilgili h\u00fccre aral\u0131klar\u0131nda aranacak ko\u015fullar\u0131 belirler.<\/li>\n<\/ul>\n<p>A\u015fa\u011f\u0131daki \u00f6rne\u011fi inceleyelim:<\/p>\n<pre><code>=COUNTIFS(A1:A10, \"&gt;20\", B1:B10, \"Mavi\")<\/code><\/pre>\n<p>Bu \u00f6rnekte, A1:A10 aral\u0131\u011f\u0131ndaki 20&#8217;den b\u00fcy\u00fck de\u011ferleri ve B1:B10 aral\u0131\u011f\u0131nda &#8220;Mavi&#8221; yaz\u0131l\u0131 h\u00fccreleri saymaktad\u0131r.<\/p>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h2>Senaryo 1: Personel Bilgilerinin Filtrelenmesi<\/h2>\n<p>Diyelim ki, bir \u015firketin \u00e7al\u0131\u015fanlar\u0131n\u0131n ya\u015f ve departman bilgileri bir tabloda listelenmi\u015f. 30 ya\u015f\u0131ndan b\u00fcy\u00fck IT departman\u0131 \u00e7al\u0131\u015fanlar\u0131n\u0131n say\u0131s\u0131n\u0131 bulmak istiyorsunuz. Veriler, A s\u00fctununda ya\u015f ve B s\u00fctununda departman bilgileri ile d\u00fczenlenmi\u015ftir. Kullan\u0131lacak form\u00fcl \u015fu \u015fekildedir:<\/p>\n<pre><code>=COUNTIFS(A2:A100, \"&gt;30\", B2:B100, \"IT\")<\/code><\/pre>\n<p>Bu form\u00fcl, A s\u00fctununda 30&#8217;dan b\u00fcy\u00fck ve B s\u00fctununda &#8220;IT&#8221; yaz\u0131l\u0131 h\u00fccreleri hesaplar.<\/p>\n<h2>Senaryo 2: \u00dcr\u00fcn Stok Durumu<\/h2>\n<p>Bir ma\u011fazan\u0131n \u00fcr\u00fcn kategorilerine ve stok miktarlar\u0131na g\u00f6re filtreleme yapmas\u0131 gerekmekte. \u00d6rne\u011fin, &#8220;G\u0131da&#8221; kategorisinde stok miktar\u0131 50&#8217;den d\u00fc\u015f\u00fck olan \u00fcr\u00fcnlerin say\u0131lmas\u0131 isteniyor. Veriler, C s\u00fctununda kategori ve D s\u00fctununda stok miktar\u0131 olarak ayarlanm\u0131\u015f. Bu durumda kullan\u0131lacak form\u00fcl:<\/p>\n<pre><code>=COUNTIFS(C2:C100, \"G\u0131da\", D2:D100, \"&lt;50\")<\/code><\/pre>\n<p>Bu \u00f6rnekte, C s\u00fctununda &#8220;G\u0131da&#8221; olarak belirtilen ve D s\u00fctununda stok miktar\u0131 50&#8217;den az olan \u00fcr\u00fcnler say\u0131l\u0131r.<\/p>\n<p>Bu fonksiyon, veri analizinde kapsaml\u0131 filtrelemeler ve ko\u015fullu say\u0131mlar ger\u00e7ekle\u015ftirmek i\u00e7in son derece faydal\u0131d\u0131r ve raporlama, envanter y\u00f6netimi, insan kaynaklar\u0131 gibi \u00e7e\u015fitli alanlarda kullan\u0131labilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Verilen birden \u00e7ok \u00f6l\u00e7\u00fcte uyan bir aral\u0131k i\u00e7indeki bo\u015f olmayan h\u00fccreleri sayar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15332","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/countifs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/countifs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/countifs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/countifs\/\",\"name\":\"Excel'de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/countifs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/countifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/countifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u00c7OKE\u011eERSAY\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/countifs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/countifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/countifs\/","url":"https:\/\/functiontranslator.com\/tr\/countifs\/","name":"Excel'de COUNTIFS (\u00c7OKE\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUNTIFS (\u00c7OKE\u011eERSAY) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/countifs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/countifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/countifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"\u00c7OKE\u011eERSAY"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15332"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15332\/revisions"}],"predecessor-version":[{"id":26600,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15332\/revisions\/26600"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}