{"id":15383,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vsectopla\/"},"modified":"2021-02-25T16:26:09","modified_gmt":"2021-02-25T16:26:09","slug":"dsum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dsum\/","title":{"rendered":"VSE\u00c7TOPLA"},"content":{"rendered":"

MS Excel ve Google Sheets, veri \u00fczerinde \u00e7e\u015fitli hesaplamalar yapman\u0131z\u0131 sa\u011flayan ara\u00e7lard\u0131r. VSE\u00c7TOPLA (DSUM) fonksiyonu, belirli \u015fartlara uyan h\u00fccrelerdeki say\u0131lar\u0131 toplaman\u0131za imkan veren g\u00fc\u00e7l\u00fc bir veritaban\u0131 fonksiyonudur. Bu fonksiyon finansal analizlerden \u00f6\u011frenci notlar\u0131n\u0131n hesaplanmas\u0131na kadar \u00e7ok \u00e7e\u015fitli alanlarda kullan\u0131l\u0131r.<\/p>\n

VSE\u00c7TOPLA Fonksiyonunun S\u00f6zdizimi<\/h2>\n

VSE\u00c7TOPLA fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 =VSE\u00c7TOPLA(veritaban\u0131, alan, kriterler) <\/code><\/pre>\n
    \n
  • veritaban\u0131:<\/strong> S\u00fctun ba\u015fl\u0131klar\u0131n\u0131 i\u00e7eren ve verilerin yer ald\u0131\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/li>\n
  • alan:<\/strong> Toplanacak de\u011ferlerin bulundu\u011fu s\u00fctunu belirten bir say\u0131 veya ad. Say\u0131 kullan\u0131ld\u0131\u011f\u0131nda, veritaban\u0131 aral\u0131\u011f\u0131ndaki ilk s\u00fctun 1 olarak kabul edilir.<\/li>\n
  • kriterler:<\/strong> Hangi h\u00fccrelerin toplanaca\u011f\u0131n\u0131 belirleyen kriterlerin listelendi\u011fi h\u00fccre aral\u0131\u011f\u0131. Bu kriterler s\u00f6z konusu veritaban\u0131 aral\u0131\u011f\u0131ndaki s\u00fctunlarla ili\u015fkilendirilmelidir.<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Sat\u0131\u015f Verilerine G\u00f6re Toplam Sat\u0131\u015f Hesaplama<\/h2>\n
    Bir \u015firketin \u00e7e\u015fitli \u00fcr\u00fcnlerin sat\u0131\u015f verilerini i\u00e7eren bir tablosu oldu\u011funu d\u00fc\u015f\u00fcnelim. Bu tabloda “\u00dcr\u00fcn Ad\u0131”, “Sat\u0131\u015f Miktar\u0131” ve “B\u00f6lge” s\u00fctunlar\u0131 bulunmakta ve amac\u0131m\u0131z G\u00fcney B\u00f6lgesi’ndeki toplam sat\u0131\u015f miktar\u0131n\u0131 hesaplamak. \u00d6rnek tablo a\u015fa\u011f\u0131daki gibi olabilir:<\/p>\n\n\n\n\n\n\n
    \u00dcr\u00fcn Ad\u0131<\/th>\nSat\u0131\u015f Miktar\u0131<\/th>\nB\u00f6lge<\/th>\n<\/tr>\n
    Meyve Suyu<\/td>\n150<\/td>\nG\u00fcney<\/td>\n<\/tr>\n
    \u00c7ikolata<\/td>\n120<\/td>\nKuzey<\/td>\n<\/tr>\n
    Bisk\u00fcvi<\/td>\n90<\/td>\nG\u00fcney<\/td>\n<\/tr>\n
    Meyve Suyu<\/td>\n130<\/td>\nG\u00fcney<\/td>\n<\/tr>\n<\/table>\n
    Kullan\u0131lacak form\u00fcl:<\/p>\n
     =VSE\u00c7TOPLA(A1:C5, \"Sat\u0131\u015f Miktar\u0131\", A7:C8) <\/code><\/pre>\n
    Belirlenen kriter aral\u0131\u011f\u0131 (A7:C8) a\u015fa\u011f\u0131daki gibi ayarlan\u0131r:<\/p>\n\n\n\n
    B\u00f6lge<\/th>\n<\/tr>\n
    G\u00fcney<\/td>\n<\/tr>\n<\/table>\n
    Belirtilen kriterlere g\u00f6re, yaln\u0131zca G\u00fcney b\u00f6lgesindeki sat\u0131\u015flar toplanacak ve sonu\u00e7 370 (150 + 90 + 130) olarak hesaplanacakt\u0131r.<\/p>\n
    \u00d6rnek 2: Belirli Bir Kategoriye G\u00f6re \u00d6\u011frenci Not Ortalamalar\u0131<\/h2>\n
    Bir okulda \u00f6\u011frenci performans verilerinin bulundu\u011fu bir tablo oldu\u011funu varsayal\u0131m. Bu veriler, \u00f6\u011frencinin ad\u0131n\u0131, s\u0131nav sonu\u00e7lar\u0131n\u0131 ve kat\u0131l\u0131m durumlar\u0131n\u0131 i\u00e7erir. \u0130lgilendi\u011fimiz \u00f6\u011frenciler yaln\u0131zca ‘Aktif’ kat\u0131l\u0131m g\u00f6sterenler olsun. Bu \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131n toplam\u0131n\u0131 hesaplamak istiyoruz. Tablo \u015fu \u015fekilde d\u00fczenlenmi\u015ftir:<\/p>\n\n\n\n\n\n
    \u00d6\u011frenci Ad\u0131<\/th>\nS\u0131nav Sonucu<\/th>\nKat\u0131l\u0131m<\/th>\n<\/tr>\n
    Ay\u015fe<\/td>\n88<\/td>\nAktif<\/td>\n<\/tr>\n
    Mehmet<\/td>\n75<\/td>\nPasif<\/td>\n<\/tr>\n
    Elif<\/td>\n92<\/td>\nAktif<\/td>\n<\/tr>\n<\/table>\n
    Kullan\u0131lacak form\u00fcl:<\/p>\n
     =VSE\u00c7TOPLA(A1:C4, \"S\u0131nav Sonucu\", A6:C7) <\/code><\/pre>\n
    Kriterler tablosu (A6:C7):<\/p>\n\n\n\n
    Kat\u0131l\u0131m<\/th>\n<\/tr>\n
    Aktif<\/td>\n<\/tr>\n<\/table>\n
    ‘Aktif’ kat\u0131l\u0131m g\u00f6steren \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131n toplam\u0131 bu form\u00fcl ile bulunabilir, sonu\u00e7 olarak 180 (88 + 92) elde edilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Kay\u0131tlar\u0131n alan s\u00fctununda bulunan, \u00f6l\u00e7\u00fctle e\u015fle\u015fen say\u0131lar\u0131 toplar<\/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-15383","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DSUM (VSE\u00c7TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DSUM (VSE\u00c7TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/\" \/>\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:26: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 DSUM (VSE\u00c7TOPLA) 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\/dsum\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dsum\/\",\"name\":\"Excel'de DSUM (VSE\u00c7TOPLA) 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:26:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dsum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dsum\/#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\u00c7TOPLA\"}]},{\"@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 DSUM (VSE\u00c7TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DSUM (VSE\u00c7TOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DSUM (VSE\u00c7TOPLA) 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\/dsum\/","url":"https:\/\/functiontranslator.com\/tr\/dsum\/","name":"Excel'de DSUM (VSE\u00c7TOPLA) 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:26:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DSUM (VSE\u00c7TOPLA) 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\/dsum\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dsum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dsum\/#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\u00c7TOPLA"}]},{"@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\/15383","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=15383"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15383\/revisions"}],"predecessor-version":[{"id":26651,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15383\/revisions\/26651"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}