{"id":15364,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vsecsaydolu\/"},"modified":"2021-02-25T16:25:32","modified_gmt":"2021-02-25T16:25:32","slug":"dcounta","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dcounta\/","title":{"rendered":"VSE\u00c7SAYDOLU"},"content":{"rendered":"

Microsoft Excel ve Google Tablolar’da kullan\u0131lan \u00e7ok y\u00f6nl\u00fc bir i\u015flev olan DCOUNTA (Veri Say\u0131m\u0131) i\u015flevi, belirli ko\u015fullar\u0131 sa\u011flayan h\u00fccrelerdeki say\u0131labilir \u00f6\u011felerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, \u00f6zellikle veri analizi yaparken ve b\u00fcy\u00fck veri setlerinden belirli kriterlere g\u00f6re bilgi \u00e7ekmek istedi\u011finizde faydal\u0131d\u0131r.<\/p>\n

\u0130\u015flevin Kullan\u0131m\u0131<\/h2>\n

DCOUNTA i\u015flevinin temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  VSE\u00c7SAYDOLU(veri_aral\u0131\u011f\u0131, alan, kriter_aral\u0131\u011f\u0131) <\/code> <\/pre>\n
    \n
  • veri_aral\u0131\u011f\u0131<\/strong>: Verilerin bulundu\u011fu alan ve i\u015flevin uygulanaca\u011f\u0131 s\u00fctunlar dahil olmak \u00fczere tam s\u00fctun ba\u015fl\u0131klar\u0131n\u0131 i\u00e7eren aral\u0131k.<\/li>\n
  • alan<\/strong>: Veriler \u00fczerinde say\u0131m yap\u0131lacak s\u00fctunu belirtir. Bu alan s\u00fctun ba\u015fl\u0131\u011f\u0131 (ad\u0131) veya say\u0131sal indeksle belirtilebilir.<\/li>\n
  • kriter_aral\u0131\u011f\u0131<\/strong>: Hangi sat\u0131rlar\u0131n say\u0131laca\u011f\u0131n\u0131 belirleyen ko\u015fullar\u0131n yer ald\u0131\u011f\u0131 aral\u0131k.<\/li>\n<\/ul>\n
    Temel \u00d6rnek<\/h2>\n
    Diyelim ki bir \u00f6\u011frenci listemiz var ve belirli kriterlere g\u00f6re say\u0131sal olmayan kat\u0131l\u0131m bilgilerini saymak istiyoruz. \u00d6rne\u011fin, bir etkinli\u011fe kat\u0131l\u0131m durumlar\u0131 kaydedilmi\u015f olsun ve biz kat\u0131lan \u00f6\u011frenci say\u0131s\u0131n\u0131 \u00f6\u011frenmek istiyoruz.<\/p>\n
      =VSE\u00c7SAYDOLU(A1:C10, \"Kat\u0131l\u0131m\", A1:C10) <\/code> <\/pre>\n
    Bu \u00f6rnekte, A1:C10 aral\u0131\u011f\u0131nda “Kat\u0131l\u0131m” s\u00fctununda kriterlere uyan ve dolu olan h\u00fccreler say\u0131l\u0131r.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \u00dcr\u00fcn Stok Durumu Say\u0131m\u0131<\/h2>\n
    Bir ma\u011fazan\u0131n \u00fcr\u00fcn stoklar\u0131n\u0131 y\u00f6netti\u011fini d\u00fc\u015f\u00fcnelim. Belli bir kategorideki \u00fcr\u00fcnlerin say\u0131s\u0131n\u0131 belirlemek i\u00e7in DCOUNTA i\u015flevini kullanabiliriz. \u00dcr\u00fcnler ve stok durumlar\u0131 farkl\u0131 s\u00fctunlarda listelendi\u011fi i\u00e7in, bu t\u00fcr bir say\u0131m i\u015flemi \u00f6nemli hatalar\u0131 \u00f6nleyebilir.<\/p>\n
      =VSE\u00c7SAYDOLU(A1:B50, \"Stok\", A1:B50) <\/code> <\/pre>\n
    Bu form\u00fcl A1:B50 aral\u0131\u011f\u0131nda “Stok” s\u00fctununda stok say\u0131s\u0131 dolu olan h\u00fccreleri sayar.<\/p>\n
    M\u00fc\u015fteri Geri Bildirim Analizi<\/h2>\n
    Bir \u015firket, m\u00fc\u015fteri geri bildirimlerini analiz ederek, hizmet kalitesini art\u0131rmak isteyebilir. M\u00fc\u015fterilerin geri bildirim t\u00fcrlerine g\u00f6re say\u0131lmas\u0131n\u0131 sa\u011flayarak, en \u00e7ok hangi t\u00fcr geri bildirimin yap\u0131ld\u0131\u011f\u0131n\u0131 anlamak m\u00fcmk\u00fcn olabilir.<\/p>\n
      =VSE\u00c7SAYDOLU(A1:C100, \"Geri Bildirim T\u00fcr\u00fc\", A1:C100) <\/code> <\/pre>\n
    Bu durumda form\u00fcl, belirli bir “Geri Bildirim T\u00fcr\u00fc” hakk\u0131nda ka\u00e7 m\u00fc\u015fteri geri bildirimde bulundu\u011funu sayar ve analiz i\u00e7in de\u011ferli insightlar sunar.<\/p>\n
    DCOUNTA i\u015flevi Excel ve Google Tablolar’da benzer \u015fekilde \u00e7al\u0131\u015f\u0131r, bu da onu \u00e7ok platformlu projeler i\u00e7in ideal bir se\u00e7enek yapar. Veri setlerinizle ilgili \u00e7e\u015fitli analizler yaparken bu i\u015flevi kullanarak zaman kazanabilir ve verilerinizden maksimum fayda sa\u011flayabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Veritaban\u0131ndaki 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":[589],"tags":[],"class_list":["post-15364","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DCOUNTA (VSE\u00c7SAYDOLU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DCOUNTA (VSE\u00c7SAYDOLU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/\" \/>\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:32+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 DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dcounta\/\",\"name\":\"Excel'de DCOUNTA (VSE\u00c7SAYDOLU) 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:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dcounta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dcounta\/#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\u00c7SAYDOLU\"}]},{\"@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 DCOUNTA (VSE\u00c7SAYDOLU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DCOUNTA (VSE\u00c7SAYDOLU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/","url":"https:\/\/functiontranslator.com\/tr\/dcounta\/","name":"Excel'de DCOUNTA (VSE\u00c7SAYDOLU) 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:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DCOUNTA (VSE\u00c7SAYDOLU) 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\/dcounta\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dcounta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dcounta\/#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\u00c7SAYDOLU"}]},{"@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\/15364","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=15364"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15364\/revisions"}],"predecessor-version":[{"id":26632,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15364\/revisions\/26632"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}