{"id":15357,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vsecort\/"},"modified":"2021-02-25T16:25:11","modified_gmt":"2021-02-25T16:25:11","slug":"daverage","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/daverage\/","title":{"rendered":"VSE\u00c7ORT"},"content":{"rendered":"<p>Microsoft Excel ve Google Tablolar&#8217;da kullan\u0131lan &#8220;DAVERAGE&#8221; ya da T\u00fcrk\u00e7e ad\u0131yla &#8220;VSE\u00c7ORT&#8221;, veritaban\u0131nda belirtilen ko\u015fullar\u0131 kar\u015f\u0131layan de\u011ferlerin ortalamas\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131lan bir i\u015flevdir. Bu fonksiyon, veri analizi yaparken olduk\u00e7a i\u015flevsel olabilir, \u00f6zellikle belirli kriterlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f verilerin ortalama de\u011ferlerini bulmak istendi\u011finde tercih edilir.<\/p>\n<h2>\u0130\u015flevin S\u00f6zdizimi ve Parametreleri<\/h2>\n<p><code>DAVERAGE(database, field, criteria)<\/code> \u015feklindeki temel s\u00f6zdizimi \u00fc\u00e7 parametre i\u00e7erir:<\/p>\n<ul>\n<li><strong>database<\/strong>: \u0130\u015flevin uygulanaca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131n\u0131 i\u00e7erir. Bu aral\u0131k s\u00fctun ba\u015fl\u0131klar\u0131 da dahil olmak \u00fczere veritaban\u0131n\u0131 temsil eder.<\/li>\n<li><strong>field<\/strong>: Ortalamas\u0131 al\u0131nacak verilerin bulundu\u011fu s\u00fctun. S\u00fctun ba\u015fl\u0131\u011f\u0131 (metin olarak) ya da s\u00fctunun pozisyonu (say\u0131 olarak) ile belirtilebilir.<\/li>\n<li><strong>criteria<\/strong>: Ortalama hesaplamas\u0131 yap\u0131l\u0131rken kullan\u0131lacak ko\u015fullar\u0131n belirlendi\u011fi h\u00fccre aral\u0131\u011f\u0131. Bu aral\u0131k, ko\u015fullar\u0131 i\u00e7eren en az bir s\u00fctun ba\u015fl\u0131\u011f\u0131 ve en az bir ko\u015ful i\u00e7ermelidir.<\/li>\n<\/ul>\n<pre><code>\u00d6rnek Kullan\u0131m: Tablomuz \u015fu bilgileri i\u00e7ersin: A B C Ad\u0131 Ya\u015f Departman Ali 30 Pazarlama Veli 25 Teknik Can 35 Pazarlama Kriterlerimiz: C1:C2 Departman Pazarlama Fonksiyonumuz: =DAVERAGE(A2:C4, \"Ya\u015f\", A6:B7) Bu \u00f6rnekte, \"Pazarlama\" departman\u0131nda \u00e7al\u0131\u015fanlar\u0131n ya\u015f ortalamas\u0131 hesaplanacakt\u0131r.<\/code><\/pre>\n<h2>Uygulamal\u0131 \u00d6rnekler<\/h2>\n<p>DAVERAGE i\u015flevi, farkl\u0131 pratik senaryolarda nas\u0131l kullan\u0131labilir onlara bakal\u0131m:<\/p>\n<h2>\u00dcr\u00fcn Sat\u0131\u015f Analizi<\/h2>\n<p>Bir \u00fcr\u00fcn y\u00f6neticisi, farkl\u0131 b\u00f6lgelerdeki \u00fcr\u00fcn sat\u0131\u015flar\u0131n\u0131n ortalama fiyat\u0131n\u0131 anlamak istiyor olabilir. B\u00f6yle bir analiz, \u00fcr\u00fcn\u00fcn belirli pazarlardaki performans\u0131n\u0131 de\u011ferlendirmede faydal\u0131 olabilir.<\/p>\n<pre><code>Tablo: A B C B\u00f6lge \u00dcr\u00fcn Ad\u0131 Sat\u0131\u015f Fiyat\u0131 G\u00fcney Bilgisayar 1500 Bat\u0131 Bilgisayar 1600 G\u00fcney Telefon 800 Bat\u0131 Telefon 750 Kriterler: A1:A2 B\u00f6lge G\u00fcney Form\u00fcl: =DAVERAGE(A2:C5, \"Sat\u0131\u015f Fiyat\u0131\", A7:B8) Bu form\u00fcl, G\u00fcney B\u00f6lgesindeki t\u00fcm \u00fcr\u00fcnlerin sat\u0131\u015f fiyatlar\u0131n\u0131n ortalamas\u0131n\u0131 verecektir.<\/code><\/pre>\n<h2>\u00c7al\u0131\u015fan Performans De\u011ferlendirmesi<\/h2>\n<p>Bir \u0130K y\u00f6neticisi, departmanlara g\u00f6re \u00e7al\u0131\u015fanlar\u0131n performans puanlar\u0131n\u0131n ortalamas\u0131n\u0131 analiz etmek isteyebilir. Bu t\u00fcr bir analiz, e\u011fitim gereksinimleri veya daha fazla kaynak tahsisi gibi konular hakk\u0131nda kararlar verilmesine yard\u0131mc\u0131 olabilir.<\/p>\n<pre><code>Tablo: A B C Ad\u0131 Departman Performans Puan\u0131 Ali Teknik 88 Veli Pazarlama 92 Can Teknik 85 Emre Pazarlama 90 Kriterler: B1:B2 Departman Teknik Form\u00fcl: =DAVERAGE(A2:C5, \"Performans Puan\u0131\", B6:C7) Bu form\u00fcl, Teknik departmanda \u00e7al\u0131\u015fanlar\u0131n performans puanlar\u0131n\u0131n ortalamas\u0131n\u0131 hesaplar.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Se\u00e7ili veritaban\u0131 girdilerinin ortalamas\u0131n\u0131 verir<\/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-15357","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"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 DAVERAGE (VSE\u00c7ORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de DAVERAGE (VSE\u00c7ORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/\" \/>\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:11+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 DAVERAGE (VSE\u00c7ORT) 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\/daverage\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/daverage\/\",\"name\":\"Excel'de DAVERAGE (VSE\u00c7ORT) 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:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/daverage\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/daverage\/#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\u00c7ORT\"}]},{\"@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 DAVERAGE (VSE\u00c7ORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DAVERAGE (VSE\u00c7ORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DAVERAGE (VSE\u00c7ORT) 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\/daverage\/","url":"https:\/\/functiontranslator.com\/tr\/daverage\/","name":"Excel'de DAVERAGE (VSE\u00c7ORT) 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:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DAVERAGE (VSE\u00c7ORT) 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\/daverage\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/daverage\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/daverage\/#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\u00c7ORT"}]},{"@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\/15357","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=15357"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15357\/revisions"}],"predecessor-version":[{"id":26625,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15357\/revisions\/26625"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}