{"id":15657,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/alttoplam\/"},"modified":"2021-02-25T16:36:52","modified_gmt":"2021-02-25T16:36:52","slug":"subtotal","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/subtotal\/","title":{"rendered":"ALTTOPLAM"},"content":{"rendered":"

ALTTOPLAM \u0130\u015flevinin Genel Bak\u0131\u015f\u0131<\/h2>\n

Microsoft Excel ve Google E-Tablolar, bir dizi i\u015flevi b\u00fcnyesinde bar\u0131nd\u0131r\u0131r ve bu i\u015flevlerden biri de ALTTOPLAM\u2019d\u0131r. ALTTOPLAM i\u015flevi, belirli bir veri k\u00fcmesi \u00fczerinde \u00e7e\u015fitli matematiksel i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in kullan\u0131l\u0131r ve \u00f6zellikle filtrelenmi\u015f verilere uyguland\u0131\u011f\u0131nda son derece faydal\u0131d\u0131r. Filtre uyguland\u0131\u011f\u0131nda, bu i\u015flev sadece g\u00f6r\u00fcnen (filtrelenmi\u015f) veriler \u00fczerinden hesaplama yapar, bu nedenle analiz i\u015flemleri s\u0131ras\u0131nda \u00e7ok elzem bir role sahiptir.<\/p>\n

Kullan\u0131m S\u00f6zdizimi ve Parametreleri<\/h2>\n

ALTTOPLAM i\u015flevinin kullan\u0131m s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=ALTTOPLAM(i\u015flev_numaras\u0131, aral\u0131k1, [aral\u0131k2], ...)<\/code><\/pre>\n
    \n
  • i\u015flev_numaras\u0131:<\/strong> Hangi matematiksel i\u015flemin yap\u0131laca\u011f\u0131n\u0131 belirten \u00f6nemli bir parametredir. \u00d6rne\u011fin, 1 toplama, 2 ortalama ve 9 toplam say\u0131y\u0131 bulma i\u015flemleri i\u00e7in kullan\u0131l\u0131r. \u0130\u015flev numaras\u0131 101-111 aras\u0131nda ise, sadece gizli olmayan sat\u0131rlar \u00fczerinde i\u015flem yapar.<\/li>\n
  • aral\u0131k1, [aral\u0131k2], …:<\/strong> \u0130\u015flemin uygulanaca\u011f\u0131 h\u00fccre aral\u0131klar\u0131d\u0131r. Birden fazla aral\u0131k girilebilir.<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    ALTTOPLAM i\u015flevinin uygulama alanlar\u0131 olduk\u00e7a geni\u015ftir. Burada, g\u00fcnl\u00fck i\u015f s\u00fcre\u00e7lerinde nas\u0131l kullanabilece\u011finize dair iki pratik \u00f6rnek sunaca\u011f\u0131m:<\/p>\n
    1. Filtrelenmi\u015f Veri Seti \u00dczerinden Toplam Gelir Hesaplama<\/h2>\n
    Bir \u015firketin farkl\u0131 kategorilere ait sat\u0131\u015f gelirlerini i\u00e7eren bir veri listesi d\u00fc\u015f\u00fcn\u00fcn. Sat\u0131\u015f y\u00f6neticisi, sadece belirli bir kategoriye ait filtrelenmi\u015f veriler \u00fczerinden toplam geliri g\u00f6rmek istiyor. Bu durumda ALTTOPLAM i\u015flevi kullan\u0131labilir:<\/p>\n
    =ALTTOPLAM(9, B2:B100)<\/code><\/pre>\n
    Burada, B2:B100 aras\u0131 sat\u0131\u015f gelirlerini temsil eder ve i\u015flev numaras\u0131 9 (toplam), sadece filtrelenmi\u015f (aktif) verilerin toplam\u0131n\u0131 hesaplar.<\/p>\n
    2. Dinamik Ortalama Sat\u0131\u015f De\u011ferinin Hesaplanmas\u0131<\/h2>\n
    Bir ba\u015fka \u00f6rnek ise, bir e-ticaret platformunda farkl\u0131 \u00fcr\u00fcnlerin sat\u0131\u015f miktarlar\u0131n\u0131n ortalamas\u0131n\u0131 dinamik bir \u015fekilde hesaplamakt\u0131r. \u00dcr\u00fcn filtrelemesi yap\u0131ld\u0131\u011f\u0131nda, yaln\u0131zca se\u00e7ili \u00fcr\u00fcnlerin ortalamas\u0131n\u0131 almak i\u00e7in ALTTOPLAM kullan\u0131labilir:<\/p>\n
    =ALTTOPLAM(1, D2:D100)<\/code><\/pre>\n
    Burada, D2:D100 aral\u0131\u011f\u0131 sat\u0131\u015f miktarlar\u0131n\u0131 kapsar ve i\u015flev numaras\u0131 1 (ortalama), filtre uyguland\u0131\u011f\u0131nda yaln\u0131zca g\u00f6r\u00fcnen verilerin ortalamas\u0131n\u0131 hesaplar.<\/p>\n
    Bu iki \u00f6rnek, ALTTOPLAM i\u015flevinin g\u00fcnl\u00fck i\u015f ak\u0131\u015flar\u0131nda nas\u0131l entegre edilebilece\u011fini g\u00f6stermektedir. Filtreleme sonras\u0131 ger\u00e7ekle\u015ftirilen dinamik hesaplamalar, raporlamalarda b\u00fcy\u00fck kolayl\u0131klar sa\u011flar ve hatal\u0131 sonu\u00e7lar\u0131n \u00f6n\u00fcne ge\u00e7er.<\/p>\n
    \u00d6zetle, ALTTOPLAM i\u015flevi, \u00f6zellikle b\u00fcy\u00fck veri setlerini y\u00f6netirken ve bu verilerden anlaml\u0131 bilgiler \u00e7\u0131kartmaya \u00e7al\u0131\u015f\u0131rken olduk\u00e7a i\u015flevsel bir ara\u00e7t\u0131r. Filtrelenmi\u015f verilerle \u00e7al\u0131\u015f\u0131rken do\u011fru sonu\u00e7lar\u0131 elde etmek i\u00e7in bu i\u015flevden yararlan\u0131labilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Listede veya veritaban\u0131nda bir alt 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-15657","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:36: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 SUBTOTAL (ALTTOPLAM) 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\/subtotal\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/subtotal\/\",\"name\":\"Excel'de SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:36:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/subtotal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/subtotal\/#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\":\"ALTTOPLAM\"}]},{\"@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 SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:36:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUBTOTAL (ALTTOPLAM) 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\/subtotal\/","url":"https:\/\/functiontranslator.com\/tr\/subtotal\/","name":"Excel'de SUBTOTAL (ALTTOPLAM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:36:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUBTOTAL (ALTTOPLAM) 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\/subtotal\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/subtotal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/subtotal\/#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":"ALTTOPLAM"}]},{"@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\/15657","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=15657"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15657\/revisions"}],"predecessor-version":[{"id":26925,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15657\/revisions\/26925"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}