{"id":15331,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/egersay\/"},"modified":"2021-02-25T16:24:13","modified_gmt":"2021-02-25T16:24:13","slug":"countif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/countif\/","title":{"rendered":"E\u011eERSAY"},"content":{"rendered":"

E\u011fersay \u0130\u015flevinin Kullan\u0131m\u0131<\/h2>\n

COUNTIF<\/code> veya T\u00fcrk\u00e7e ad\u0131yla E\u011eERSAY<\/code>, Microsoft Excel ve Google E-Tablolar’da belirli bir ko\u015fulu kar\u015f\u0131layan h\u00fccre say\u0131s\u0131n\u0131 bulmak i\u00e7in kullan\u0131lan bir i\u015flevdir. Bu i\u015flev, veri analizi yaparken olduk\u00e7a i\u015fe yarar ve bize zamandan tasarruf sa\u011flar.<\/p>\n

Temel S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

E\u011eERSAY<\/code> i\u015flevinin temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 E\u011eERSAY(aranacak_aral\u0131k, kriter) <\/code><\/pre>\n
    \n
  • aranacak_aral\u0131k:<\/b> Ko\u015fulun test edilece\u011fi h\u00fccrelerin aral\u0131\u011f\u0131.<\/li>\n
  • kriter:<\/b> Hangi h\u00fccrelerin say\u0131laca\u011f\u0131na karar vermek i\u00e7in kullan\u0131lan ko\u015ful.<\/li>\n<\/ul>\n
    \u00d6rnek 1:<\/b> Diyelim ki A1:A10 aral\u0131\u011f\u0131ndaki h\u00fccrelerdeki say\u0131lardan 10’dan b\u00fcy\u00fck olanlar\u0131n say\u0131s\u0131n\u0131 bulmak istiyoruz. Bu durumda kullanaca\u011f\u0131m\u0131z form\u00fcl \u015fu \u015fekilde olur:<\/p>\n
     E\u011eERSAY(A1:A10, \">10\") <\/code><\/pre>\n
    \u00d6rnek 2:<\/b> E\u011fer B1:B20 aral\u0131\u011f\u0131ndaki h\u00fccrelerde “Elma” kelimesi ge\u00e7en h\u00fccre say\u0131s\u0131n\u0131 hesaplamak istiyorsak, \u015fu form\u00fcl\u00fc kullan\u0131r\u0131z:<\/p>\n
     E\u011eERSAY(B1:B20, \"Elma\") <\/code><\/pre>\n
    Pratik G\u00f6revler<\/h2>\n
    Stok Kontrol\u00fc<\/h3>\n
    Bir depoda \u00e7e\u015fitli \u00fcr\u00fcnlerin stok miktarlar\u0131n\u0131 tuttu\u011funuz ve sadece belirli bir say\u0131dan az kalan \u00fcr\u00fcnleri tespit etmek istedi\u011finizi farz edin.<\/p>\n
     Aral\u0131k: C1:C100 Ko\u015ful: \"<=5\" Form\u00fcl: E\u011eERSAY(C1:C100, \"<=5\") <\/code><\/pre>\n
    Bu form\u00fcl, C1:C100 aral\u0131\u011f\u0131nda 5 veya daha az olan stok miktar\u0131na sahip h\u00fccrelerin say\u0131s\u0131n\u0131 verir. Bu bilgiyle, hangi \u00fcr\u00fcnlerin sipari\u015f edilmesi gerekti\u011fini h\u0131zl\u0131ca g\u00f6rebilirsiniz.<\/p>\n
    M\u00fc\u015fteri Memnuniyet Anketi De\u011ferlendirme<\/h3>\n
    Bir anketten toplanan verilerde, m\u00fc\u015fteriler 1'den 5'e kadar puanlam\u0131\u015flar ve siz 4 ve \u00fczeri puan veren m\u00fc\u015fteri say\u0131s\u0131n\u0131 bulmak istiyorsunuz.<\/p>\n
     Aral\u0131k: D1:D200 Ko\u015ful: \">=4\" Form\u00fcl: E\u011eERSAY(D1:D200, \">=4\") <\/code><\/pre>\n
    Bu form\u00fcl, memnuniyet d\u00fczeyi \"4\" ve \u00fczeri olan m\u00fc\u015fteri say\u0131s\u0131n\u0131 hesaplar. Y\u00fcksek puanlama, genel m\u00fc\u015fteri memnuniyet seviyenizi anlaman\u0131za yard\u0131mc\u0131 olur.<\/p>\n
    E\u011eERSAY<\/code> i\u015flevi, veriler \u00fczerinde ko\u015fullu say\u0131m yaparak bir\u00e7ok farkl\u0131 senaryoda size zaman kazand\u0131r\u0131r ve do\u011fru kararlar alman\u0131z i\u00e7in gerekli bilgileri sunar. Her iki platformda da kolayl\u0131kla uygulanabilir ve veri takibi yan\u0131nda anl\u0131k analizler yapman\u0131z\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Verilen \u00f6l\u00e7\u00fctlere 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-15331","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de COUNTIF (E\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUNTIF (E\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/\" \/>\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:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de COUNTIF (E\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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/countif\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/countif\/\",\"name\":\"Excel'de COUNTIF (E\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:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/countif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/countif\/#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\":\"E\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 COUNTIF (E\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUNTIF (E\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUNTIF (E\u011eERSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/countif\/","url":"https:\/\/functiontranslator.com\/tr\/countif\/","name":"Excel'de COUNTIF (E\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:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUNTIF (E\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\/countif\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/countif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/countif\/#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":"E\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\/15331","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=15331"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15331\/revisions"}],"predecessor-version":[{"id":26599,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15331\/revisions\/26599"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}