{"id":15363,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vsecsay\/"},"modified":"2021-02-25T16:25:29","modified_gmt":"2021-02-25T16:25:29","slug":"dcount","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dcount\/","title":{"rendered":"VSE\u00c7SAY"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Veri Say\u0131m\u0131 Nas\u0131l Yap\u0131l\u0131r<\/h1>\n

Veri tabanlar\u0131 ve tablolarla \u00e7al\u0131\u015f\u0131rken \u00f6zelle\u015ftirilmi\u015f veri say\u0131m i\u015flemleri yapmak \u00f6nemli bir ihtiya\u00e7t\u0131r. Excel ve Google E-Tablolar bu i\u015flemi yapabilmek i\u00e7in DCOUNT i\u015flevini (VSE\u00c7SAY olarak da bilinir) sunar. Bu i\u015flev, belirilen kriterlere g\u00f6re bir s\u00fctunda bulunan say\u0131sal de\u011ferleri sayar. Bu yaz\u0131da, DCOUNT i\u015flevinin s\u00f6zdizimi, nas\u0131l kullan\u0131ld\u0131\u011f\u0131 ve pratik \u00f6rneklerle nas\u0131l uygulanabilece\u011fini \u00f6\u011frenece\u011fiz.<\/p>\n

DCOUNT \u0130\u015flevinin S\u00f6zdizimi<\/h2>\n

DCOUNT i\u015flevi, bir veritaban\u0131 tablosundaki belirli bir s\u00fctunda, belirtilen kriterlere uygun kay\u0131tlar\u0131n say\u0131sal de\u011ferlerini sayar. DCOUNT i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  =DCOUNT(veri_tablosu, s\u00fctun, kriterler) <\/code> <\/pre>\n
    \n
  • veri_tablosu:<\/strong> \u0130\u015flem yap\u0131lacak veri listesini i\u00e7eren alan. Bu alan headers (ba\u015fl\u0131klar) da dahil olmak \u00fczere se\u00e7ilmelidir.<\/li>\n
  • s\u00fctun:<\/strong> Say\u0131lacak say\u0131sal de\u011ferlerin bulundu\u011fu s\u00fctunun ba\u015fl\u0131\u011f\u0131, say\u0131 veya ba\u015fl\u0131k ad\u0131 olarak belirtilmelidir.<\/li>\n
  • kriterler:<\/strong> Hangi kay\u0131tlar\u0131n say\u0131laca\u011f\u0131n\u0131 belirleyen kriterlerin bulundu\u011fu alan. Bu kriterler, ba\u015fka bir tablo b\u00f6l\u00fcm\u00fcnde yer alabilir.<\/li>\n<\/ul>\n
    DCOUNT Kullan\u0131m\u0131: \u00d6rnek Senaryolar<\/h2>\n
    \u00d6rnek olarak, bir \u015firketin \u00e7al\u0131\u015fanlar\u0131n\u0131n departmanlar\u0131na ve maa\u015f aral\u0131klar\u0131na g\u00f6re say\u0131m yapmak istedi\u011fini d\u00fc\u015f\u00fcnelim. Excel ve Google E-Tablolar’da bu i\u015flemlerin nas\u0131l yap\u0131labilece\u011fine dair ad\u0131mlar\u0131 ve a\u00e7\u0131klamalar\u0131 inceleyelim.<\/p>\n
    \u00d6rnek 1: Departmana G\u00f6re \u00c7al\u0131\u015fan Say\u0131m\u0131<\/h3>\n
    \u015eirketteki “Muhasebe” departman\u0131ndaki \u00e7al\u0131\u015fanlar\u0131 saymak istiyoruz:<\/p>\n
      =DCOUNT(A1:C100, \"Maa\u015f\", A1:C2) <\/code> <\/pre>\n
    Burada A1:C100, \u00e7al\u0131\u015fan bilgilerinin bulundu\u011fu veri aral\u0131\u011f\u0131d\u0131r ve bu aral\u0131k i\u00e7indeki ba\u015fl\u0131k “Maa\u015f” a g\u00f6re say\u0131m yapaca\u011f\u0131m\u0131z\u0131 belirtiyoruz. A1:C2, say\u0131m i\u00e7in uygulayaca\u011f\u0131m\u0131z kriterlerin (bu \u00f6rnekte “Departman” s\u00fctununda “Muhasebe” olarak belirtilen) yer ald\u0131\u011f\u0131 alan\u0131 g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Maa\u015f Aral\u0131\u011f\u0131na G\u00f6re \u00c7al\u0131\u015fan Say\u0131m\u0131<\/h3>\n
    \u015eimdi de 50.000 – 70.000 aras\u0131 maa\u015f\u0131 olan \u00e7al\u0131\u015fanlar\u0131 sayal\u0131m:<\/p>\n
      =DCOUNT(A1:C100, \"Maa\u015f\", E1:F2) <\/code> <\/pre>\n
    Yine ayn\u0131 veri aral\u0131\u011f\u0131n\u0131 kullan\u0131yoruz, fakat bu sefer veri say\u0131m\u0131 yap\u0131lacak “Maa\u015f” ba\u015fl\u0131\u011f\u0131 se\u00e7ili. E1:F2, maa\u015f aral\u0131\u011f\u0131n\u0131n 50.000 ile 70.000 TL aras\u0131nda oldu\u011fu kriterleri i\u00e7erir.<\/p>\n
    Bu iki \u00f6rnekte, DCOUNT i\u015flevinin \u00e7e\u015fitli senaryolar alt\u0131nda nas\u0131l esnek bir \u015fekilde kullan\u0131labilece\u011fini g\u00f6rd\u00fck.<\/p>\n
    Yorumlar ve Ek Bilgiler<\/h2>\n
    DCOUNT i\u015flevi, veri analizinde ve raporlama i\u015flemlerde olduk\u00e7a yararl\u0131d\u0131r. \u00d6zellikle b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken belirli kriterlere g\u00f6re h\u0131zl\u0131ca say\u0131m yapma ihtiyac\u0131n\u0131 kar\u015f\u0131lar. \u0130\u015flev do\u011fru kullan\u0131ld\u0131\u011f\u0131nda, karma\u015f\u0131k veri setleri i\u00e7erisinden gereken bilgileri \u00e7ekmek ve analiz etmek \u00e7ok daha basit bir hale gelir.<\/p>\n
    Unutmay\u0131n, her iki platformda da kullan\u0131lan DCOUNT i\u015flevinin do\u011fru sonu\u00e7lar vermesi i\u00e7in kriterlerin do\u011fru \u015fekilde tan\u0131mland\u0131\u011f\u0131ndan emin olunuz. Yanl\u0131\u015f tan\u0131mlanan kriterler yan\u0131lt\u0131c\u0131 sonu\u00e7lar do\u011furabilir.<\/p>\n
    Bu kullan\u0131\u015fl\u0131 i\u015flev sayesinde, verileriniz \u00fczerinde daha derinlemesine analiz yapabilir, raporlar olu\u015fturabilir ve veri taban\u0131 y\u00f6netimini kolayla\u015ft\u0131rabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Veritaban\u0131nda say\u0131 i\u00e7eren h\u00fccre say\u0131s\u0131n\u0131 hesaplar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[589],"tags":[],"class_list":["post-15363","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:25:29+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 DCOUNT (VSE\u00c7SAY) 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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dcount\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dcount\/\",\"name\":\"Excel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:25:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dcount\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dcount\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Veritaban\u0131\",\"item\":\"https:\/\/functiontranslator.com\/tr\/veritabani\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VSE\u00c7SAY\"}]},{\"@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 DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/dcount\/","url":"https:\/\/functiontranslator.com\/tr\/dcount\/","name":"Excel'de DCOUNT (VSE\u00c7SAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:25:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DCOUNT (VSE\u00c7SAY) 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\/dcount\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dcount\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dcount\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Veritaban\u0131","item":"https:\/\/functiontranslator.com\/tr\/veritabani\/"},{"@type":"ListItem","position":3,"name":"VSE\u00c7SAY"}]},{"@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\/15363","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=15363"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15363\/revisions"}],"predecessor-version":[{"id":26631,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15363\/revisions\/26631"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}