{"id":15328,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/bag_deg_say\/"},"modified":"2021-02-25T16:24:09","modified_gmt":"2021-02-25T16:24:09","slug":"count","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/count\/","title":{"rendered":"BA\u011e_DE\u011e_SAY"},"content":{"rendered":"

Excel ve Google Sheets’te BA\u011e_DE\u011e_SAY (COUNT) Fonksiyonunun Genel Bak\u0131\u015f\u0131<\/h2>\n

BA\u011e_DE\u011e_SAY veya COUNT fonksiyonu, Excel ve Google Sheets’te \u00e7ok kullan\u0131lan bir i\u015flevdir. Bu i\u015flev, belirli bir h\u00fccre aral\u0131\u011f\u0131nda yer alan say\u0131sal de\u011fer i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r. Metin i\u00e7eren veya bo\u015f h\u00fccreler bu i\u015flev taraf\u0131ndan dikkate al\u0131nmaz.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve \u00d6rnek Kullan\u0131mlar\u0131<\/h2>\n

BA\u011e_DE\u011e_SAY fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=BA\u011e_DE\u011e_SAY(de\u011fer1, [de\u011fer2], ...)<\/code><\/pre>\n
Burada “de\u011fer1”, “de\u011fer2”, …, say\u0131sal verileri veya say\u0131sal de\u011ferler i\u00e7eren h\u00fccre aral\u0131klar\u0131n\u0131 temsil edebilir.<\/p>\n
\u00d6rnek Kullan\u0131m:<\/strong><\/p>\n
    \n
  • A1:A10 h\u00fccre aral\u0131\u011f\u0131nda yer alan say\u0131sal de\u011fer i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 hesaplamak i\u00e7in:\n
    =BA\u011e_DE\u011e_SAY(A1:A10)<\/code><\/pre>\n<\/li>\n
  • E\u011fer B s\u00fctunu 1’den 20’ye kadar say\u0131lar\u0131 i\u00e7eriyor ve C s\u00fctunu metin de\u011ferler i\u00e7eriyorsa, sadece B s\u00fctunundaki say\u0131sal de\u011ferleri saymak i\u00e7in:\n
    =BA\u011e_DE\u011e_SAY(B1:B20)<\/code><\/pre>\n<\/li>\n<\/ul>\n
    Uygulamal\u0131 \u0130ki Ayr\u0131nt\u0131l\u0131 Senaryo<\/h2>\n
    \u0130lk Senaryo: Stok Say\u0131m\u0131<\/h2>\n
    Envanter kontrol\u00fc yaparken, mevcut \u00fcr\u00fcn miktar\u0131n\u0131 hesaplamak amac\u0131yla BA\u011e_DE\u011e_SAY fonksiyonundan yararlan\u0131labilir. Diyelim ki, A1:A20 h\u00fccreleri farkl\u0131 \u00fcr\u00fcnlerin stok miktarlar\u0131n\u0131 i\u00e7eriyor olsun.<\/p>\n
    Hesaplamak i\u00e7in kullan\u0131lacak form\u00fcl \u015f\u00f6yledir:<\/p>\n
    =BA\u011e_DE\u011e_SAY(A1:A20)<\/code><\/pre>\n
    Bu form\u00fcl, belirtilen aral\u0131ktaki t\u00fcm say\u0131sal de\u011ferleri hesaplayarak toplam stok miktar\u0131n\u0131 verecektir.<\/p>\n
    \u0130kinci Senaryo: S\u0131n\u0131f Ortalamas\u0131n\u0131n Hesaplanmas\u0131<\/h2>\n
    \u00d6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 analiz ederken, ge\u00e7erli notlar\u0131n say\u0131s\u0131n\u0131 tespit etmek i\u00e7in BA\u011e_DE\u011e_SAY i\u015flevi kullan\u0131labilir. Varsayal\u0131m ki, B1:B30 h\u00fccreleri \u00f6\u011frencilerin notlar\u0131n\u0131 i\u00e7ersin ve baz\u0131 h\u00fccreler bo\u015f b\u0131rak\u0131lm\u0131\u015f olsun (yani baz\u0131 \u00f6\u011frenciler s\u0131nava girmedi).<\/p>\n
    Ge\u00e7erli not say\u0131s\u0131n\u0131 bulmak i\u00e7in kullan\u0131lacak form\u00fcl:<\/p>\n
    =BA\u011e_DE\u011e_SAY(B1:B30)<\/code><\/pre>\n
    Bu i\u015flem, sadece say\u0131sal de\u011ferleri hesaplayacak ve toplam ge\u00e7erli not say\u0131s\u0131n\u0131 belirleyecektir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ba\u011f\u0131ms\u0131z de\u011fi\u015fkenler listesinde ka\u00e7 tane say\u0131 bulundu\u011funu 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-15328","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de COUNT (BA\u011e_DE\u011e_SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUNT (BA\u011e_DE\u011e_SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/\" \/>\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:09+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 COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/count\/\",\"name\":\"Excel'de COUNT (BA\u011e_DE\u011e_SAY) 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:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/count\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/count\/#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\":\"BA\u011e_DE\u011e_SAY\"}]},{\"@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 COUNT (BA\u011e_DE\u011e_SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUNT (BA\u011e_DE\u011e_SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/","url":"https:\/\/functiontranslator.com\/tr\/count\/","name":"Excel'de COUNT (BA\u011e_DE\u011e_SAY) 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:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUNT (BA\u011e_DE\u011e_SAY) 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\/count\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/count\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/count\/#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":"BA\u011e_DE\u011e_SAY"}]},{"@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\/15328","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=15328"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15328\/revisions"}],"predecessor-version":[{"id":26596,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15328\/revisions\/26596"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}