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

Microsoft Excel ve Google Sheets, tablolar \u00fczerinde i\u015flem yapmak i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sunarak veri analizi ve hesaplama i\u015flemlerinde b\u00fcy\u00fck kolayl\u0131klar sa\u011flar. Bu ara\u00e7lardan biri olan VSE\u00c7\u00c7ARP (DPRODUCT) fonksiyonu, belirli bir veri taban\u0131 listesinde kriterlere uygun sat\u0131rlar \u00fczerinde bir s\u00fctunun \u00e7arp\u0131m\u0131n\u0131 hesaplamam\u0131za olanak tan\u0131r. Bu yaz\u0131da, VSE\u00c7\u00c7ARP fonksiyonunun kullan\u0131m\u0131, syntax’\u0131 ve \u00e7e\u015fitli kullan\u0131m \u00f6rnekleri ele al\u0131nacakt\u0131r.<\/p>\n

Fonksiyonun Syntax’\u0131 ve Temel Kullan\u0131m\u0131<\/h2>\n

VSE\u00c7\u00c7ARP fonksiyonunun yap\u0131sal format\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

VSE\u00c7\u00c7ARP(veri_taban\u0131, alan, kriterler)<\/code><\/pre>\n
    \n
  • veri_taban\u0131<\/strong>: \u0130\u015flenecek verileri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131d\u0131r.<\/li>\n
  • alan<\/strong>: \u00c7arp\u0131m\u0131n yap\u0131laca\u011f\u0131 s\u00fctun numaras\u0131 veya ad\u0131d\u0131r. S\u00fctun ismi, tek ve \u00e7ift t\u0131rnak i\u00e7inde belirtilir (‘ “s\u00fctun_ad\u0131” ‘), veya s\u00fctun numaras\u0131 do\u011frudan kullan\u0131labilir.<\/li>\n
  • kriterler<\/strong>: Hangi sat\u0131rlar\u0131n hesaplamaya dahil edilece\u011fini belirleyen kriterleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131d\u0131r.<\/li>\n<\/ul>\n
    Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    Bu b\u00f6l\u00fcmde VSE\u00c7\u00c7ARP fonksiyonunun ger\u00e7ek hayatta nas\u0131l kullan\u0131labilece\u011fine ili\u015fkin iki \u00f6rnek sunaca\u011f\u0131z.<\/p>\n
    \u00dcr\u00fcn Stok De\u011ferlerinin Hesaplanmas\u0131<\/h2>\n
    Bir depodaki belirli \u00fcr\u00fcnlerin stok say\u0131lar\u0131n\u0131 ve birim fiyatlar\u0131n\u0131 \u00e7arp\u0131p toplam stok de\u011ferini hesaplamak isteyelim. Veri tablomuz A1:C5 aral\u0131\u011f\u0131nda a\u015fa\u011f\u0131daki gibi d\u00fczenlenmi\u015ftir:<\/p>\n\n\n\n\n\n
    \u00dcr\u00fcn<\/th>\nStok<\/th>\nBirim Fiyat<\/th>\n<\/tr>\n
    \u00dcr\u00fcn 1<\/td>\n10<\/td>\n15<\/td>\n<\/tr>\n
    \u00dcr\u00fcn 2<\/td>\n20<\/td>\n30<\/td>\n<\/tr>\n
    \u00dcr\u00fcn 3<\/td>\n15<\/td>\n45<\/td>\n<\/tr>\n<\/table>\n
    Burada, t\u00fcm \u00fcr\u00fcnleri kapsayan basit bir kriter uygulayaca\u011f\u0131z.<\/p>\n
    =VSE\u00c7\u00c7ARP(A1:C5, \"Stok*Birim Fiyat\", A7:C8)<\/code><\/pre>\n
    Yukar\u0131daki form\u00fclde A7:C8 aral\u0131\u011f\u0131 t\u00fcm \u00fcr\u00fcnleri kapsayan bir kriter aral\u0131\u011f\u0131d\u0131r.<\/p>\n
    Sat\u0131\u015f Hedeflerine Ula\u015fm\u0131\u015f \u00dcr\u00fcnlerin Say\u0131s\u0131n\u0131n Bulunmas\u0131<\/h2>\n
    Bir grup \u00fcr\u00fcn\u00fc, belirlenen sat\u0131\u015f hedeflerine g\u00f6re de\u011ferlendirelim ve bu kriteri sa\u011flayan \u00fcr\u00fcnlerin birim fiyatlar\u0131n\u0131n \u00e7arp\u0131m\u0131n\u0131 hesaplayal\u0131m. Verilerimiz A1:C5 aral\u0131\u011f\u0131nda, hedefler ise D s\u00fctunu i\u00e7inde d\u00fczenlenmi\u015ftir:<\/p>\n\n\n\n\n\n
    \u00dcr\u00fcn<\/th>\nSat\u0131\u015f<\/th>\nHedef<\/th>\nBirim Fiyat<\/th>\n<\/tr>\n
    \u00dcr\u00fcn 1<\/td>\n150<\/td>\n100<\/td>\n20<\/td>\n<\/tr>\n
    \u00dcr\u00fcn 2<\/td>\n90<\/td>\n150<\/td>\n30<\/td>\n<\/tr>\n
    \u00dcr\u00fcn 3<\/td>\n200<\/td>\n180<\/td>\n25<\/td>\n<\/tr>\n<\/table>\n
    Hedefleri a\u015fan sat\u0131\u015flar\u0131 olan \u00fcr\u00fcnler i\u00e7in kriterleri belirleyelim.<\/p>\n
    =VSE\u00c7\u00c7ARP(A1:D5, \"Birim Fiyat\", A10:D11)<\/code><\/pre>\n
    Bu form\u00fcl, belirlenen sat\u0131\u015f hedeflerini a\u015fan \u00fcr\u00fcnlerin birim fiyatlar\u0131n\u0131n \u00e7arp\u0131m\u0131n\u0131 hesaplar.<\/p>\n
    Bu \u00f6rnekler, VSE\u00c7\u00c7ARP fonksiyonunun i\u015f ve mali analiz s\u00fcre\u00e7lerinde nas\u0131l etkin bir \u015fekilde kullan\u0131labilece\u011finin alt\u0131n\u0131 \u00e7izer. Fonksiyon, farkl\u0131 senaryolarda uygulanabilir ve esnek \u00e7\u00f6z\u00fcmler sunar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Kay\u0131tlar\u0131n belli bir alan\u0131nda bulunan, bir veritaban\u0131ndaki \u00f6l\u00e7\u00fctlerle e\u015fle\u015fen de\u011ferleri \u00e7arpar<\/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-15380","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DPRODUCT (VSE\u00c7\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DPRODUCT (VSE\u00c7\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/\" \/>\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:02+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 DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dproduct\/\",\"name\":\"Excel'de DPRODUCT (VSE\u00c7\u00c7ARP) 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:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dproduct\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dproduct\/#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\u00c7\u00c7ARP\"}]},{\"@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 DPRODUCT (VSE\u00c7\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DPRODUCT (VSE\u00c7\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/","url":"https:\/\/functiontranslator.com\/tr\/dproduct\/","name":"Excel'de DPRODUCT (VSE\u00c7\u00c7ARP) 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:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DPRODUCT (VSE\u00c7\u00c7ARP) 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\/dproduct\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dproduct\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dproduct\/#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\u00c7\u00c7ARP"}]},{"@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\/15380","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=15380"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15380\/revisions"}],"predecessor-version":[{"id":26648,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15380\/revisions\/26648"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}