{"id":15254,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/toplama\/"},"modified":"2021-02-25T16:21:52","modified_gmt":"2021-02-25T16:21:52","slug":"aggregate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/aggregate\/","title":{"rendered":"TOPLAMA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve hesaplama i\u015flemleri i\u00e7in kullan\u0131lan olduk\u00e7a g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu platformlarda yer alan \u00e7e\u015fitli fonksiyonlar, karma\u015f\u0131k veri k\u00fcmeleri \u00fczerinde analiz yapmay\u0131 kolayla\u015ft\u0131r\u0131r. Bu yaz\u0131m\u0131zda, Excel ve Google Sheets’te mevcut olan AGGREGATE (TOPLAMA) fonksiyonunun kullan\u0131m\u0131n\u0131 detayl\u0131 bir \u015fekilde inceleyece\u011fiz.<\/p>\n

AGGREGATE Fonksiyonunun S\u00f6zdizimi<\/h2>\n

AGGREGATE fonksiyonu, belirlenen hesaplama i\u015flemlerini ve se\u00e7enekleri kullanarak bir dizi de\u011fer \u00fczerinde toplu hesaplamalar yapmak \u00fczere tasarlanm\u0131\u015ft\u0131r. Fonksiyonun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 AGGREGATE(function_num, options, ref1, [ref2], ...) <\/code><\/pre>\n
    \n
  • function_num<\/strong>: Uygulanacak toplama i\u015flevini belirten say\u0131sal de\u011ferdir. \u00d6rne\u011fin, 1 ortalama almay\u0131, 9 ise medyan\u0131 hesaplamay\u0131 ifade eder.<\/li>\n
  • options<\/strong>: Fonksiyonun davran\u0131\u015f\u0131n\u0131 kontrol eden se\u00e7eneklerdir. \u00d6rne\u011fin, 0 veya 1 h\u00fccrelerdeki hatalar\u0131 g\u00f6z ard\u0131 ederken, 4 veya 5 ise gizli sat\u0131rlar\u0131 dikkate almaz.<\/li>\n
  • ref1, [ref2], …<\/strong>: Hesaplamalar\u0131n yap\u0131laca\u011f\u0131 h\u00fccre aral\u0131klar\u0131n\u0131 belirtir.<\/li>\n<\/ul>\n
    \u0130\u015fte, AGGREGATE fonksiyonun kullan\u0131m\u0131n\u0131 daha iyi anlaman\u0131za yard\u0131mc\u0131 olacak baz\u0131 \u00f6rnekler:<\/p>\n\n\n\n\n
    Function_num<\/th>\n\u0130\u015flev<\/th>\n<\/tr>\n
    1<\/td>\nORTALAMA<\/td>\n<\/tr>\n
    9<\/td>\nMEDYAN<\/td>\n<\/tr>\n<\/table>\n
    Pratik Uygulamalar<\/h2>\n
    A\u015fa\u011f\u0131da, AGGREGATE fonksiyonunun tipik kullan\u0131m senaryolar\u0131n\u0131 bulacaks\u0131n\u0131z.<\/p>\n
    Senaryo 1: Medyan De\u011fer Hesaplama<\/h2>\n
    Bir m\u00fchendislik s\u0131n\u0131f\u0131n\u0131n final notlar\u0131 \u00fczerinden medyan notu hesaplayal\u0131m. \u0130\u015fte veri seti ve ilgili form\u00fcl:<\/p>\n
     =AGGREGATE(9, 6, A2:A100) <\/code><\/pre>\n
    Bu form\u00fcl, A2:A100 aral\u0131\u011f\u0131ndaki de\u011ferler i\u00e7in medyan\u0131 hesaplar ve “6” se\u00e7ene\u011fi ile hem hata i\u00e7eren de\u011ferleri hem de gizli sat\u0131rlar\u0131 hesaba katmaz.<\/p>\n
    Senaryo 2: Verilerin Ortalamas\u0131n\u0131 Hesaplama<\/h2>\n
    Bir \u015firkette \u00e7al\u0131\u015fanlar\u0131n ya\u015f ortalamas\u0131n\u0131 hesaplamak istedi\u011fimizi d\u00fc\u015f\u00fcnelim. H\u00fccrelerde baz\u0131 hata de\u011ferleri ve gizli sat\u0131rlar bulundu\u011funu varsayal\u0131m. Kullan\u0131lacak form\u00fcl \u015fu \u015fekildedir:<\/p>\n
     =AGGREGATE(1, 6, B2:B300) <\/code><\/pre>\n
    Bu form\u00fcl, B2:B300 aral\u0131\u011f\u0131nda yer alan ya\u015f de\u011ferlerinin ortalamas\u0131n\u0131 hesaplar. Burada “6” se\u00e7ene\u011fi, hata i\u00e7eren de\u011ferleri ve gizli sat\u0131rlar\u0131 dikkate almadan daha temiz bir hesaplama sa\u011flar.<\/p>\n
    AGGREGATE fonksiyonu, Excel ve Google Sheets kullanarak veri setlerinden temiz ve etkili bir \u015fekilde faydalanman\u0131z\u0131 sa\u011flayan g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r ve veri analizi s\u00fcrecinde verilerinizi daha esnek ve kontroll\u00fc bir \u015fekilde i\u015flemenize imkan tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Listede veya veritaban\u0131nda bir toplam verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[],"class_list":["post-15254","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de AGGREGATE (TOPLAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de AGGREGATE (TOPLAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/\" \/>\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:21:52+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 AGGREGATE (TOPLAMA) 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\/aggregate\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/aggregate\/\",\"name\":\"Excel'de AGGREGATE (TOPLAMA) 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:21:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/aggregate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/aggregate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TOPLAMA\"}]},{\"@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 AGGREGATE (TOPLAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de AGGREGATE (TOPLAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:21:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de AGGREGATE (TOPLAMA) 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\/aggregate\/","url":"https:\/\/functiontranslator.com\/tr\/aggregate\/","name":"Excel'de AGGREGATE (TOPLAMA) 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:21:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da AGGREGATE (TOPLAMA) 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\/aggregate\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/aggregate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/aggregate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"TOPLAMA"}]},{"@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\/15254","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=15254"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15254\/revisions"}],"predecessor-version":[{"id":26522,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15254\/revisions\/26522"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}