{"id":15659,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/etopla\/"},"modified":"2021-02-25T16:37:00","modified_gmt":"2021-02-25T16:37:00","slug":"sumif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sumif\/","title":{"rendered":"ETOPLA"},"content":{"rendered":"

Ko\u015fullu Toplama Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n

SUMIF<\/code> veya T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile ETOPLA<\/code>, belirli bir ko\u015fula uygun h\u00fccrelerin toplam\u0131n\u0131 hesaplayan olduk\u00e7a kullan\u0131\u015fl\u0131 bir fonksiyondur. Hem Microsoft Excel hem de Google E-Tablolar’da bulunmaktad\u0131r ve veri analizi s\u0131ras\u0131nda s\u0131kl\u0131kla ba\u015fvurulan bir y\u00f6ntemdir.<\/p>\n

\u0130\u015flevin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=SUMIF(aranan_b\u00f6lge, kriter, [toplanacak_b\u00f6lge])<\/code><\/pre>\n
    \n
  • aranan_b\u00f6lge<\/b>: Ko\u015fulun uygulanaca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • kriter<\/b>: Aranan b\u00f6lgede aranacak ko\u015ful veya \u015fart.<\/li>\n
  • toplanacak_b\u00f6lge<\/b> (iste\u011fe ba\u011fl\u0131): E\u011fer belirtilirse, bu b\u00f6lgedeki uygun h\u00fccreler toplan\u0131r. E\u011fer belirtilmezse, aranan b\u00f6lge kendi i\u00e7inde toplan\u0131r.<\/li>\n<\/ul>\n
    Pratik Uygulama \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1:<\/b> Bir \u015firkette, sat\u0131\u015f miktar\u0131na g\u00f6re prim hesaplamak istiyorsunuz. Prim sadece 100 birimden fazla sat\u0131\u015f yapanlar i\u00e7in ge\u00e7erli. Excel’de veya Google E-Tablolar’da bu durum SUMIF<\/code> i\u015flevi kullan\u0131larak kolayca hesaplanabilir.<\/p>\n
    Kullan\u0131lacak form\u00fcl:<\/i><\/p>\n
    =SUMIF(B2:B10, \">100\", C2:C10)<\/code><\/pre>\n
    Bu form\u00fcl, B2:B10 aral\u0131\u011f\u0131nda 100’den b\u00fcy\u00fck olan sat\u0131\u015flar i\u00e7in, C2:C10 aral\u0131\u011f\u0131nda bulunan prim miktarlar\u0131n\u0131 toplar.<\/p>\n
    \u00d6rnek 2:<\/b> Bir okulda, belirli bir not aral\u0131\u011f\u0131na giren \u00f6\u011frencilerin say\u0131s\u0131n\u0131 hesaplamak istiyorsunuz. Diyelim ki, B alan\u0131nda 70 ile 85 aras\u0131nda not alm\u0131\u015f \u00f6\u011frencilerin say\u0131s\u0131n\u0131 bulmak istiyorsunuz.<\/p>\n
    Kullan\u0131lacak form\u00fcl:<\/i><\/p>\n
    =SUMIF(A2:A50, \">=70\", B2:B50) - SUMIF(A2:A50, \">85\", B2:B50)<\/code><\/pre>\n
    Bu form\u00fcl, A2:A50 aral\u0131\u011f\u0131nda 70 veya daha y\u00fcksek ve 85’ten d\u00fc\u015f\u00fck olan de\u011ferler i\u00e7in B2:B50 aral\u0131\u011f\u0131nda kriterlere uyan h\u00fccrelerin toplam\u0131n\u0131 hesaplar.<\/p>\n
    Yorumlar ve Ek Bilgiler<\/h2>\n
    SUMIF<\/code> i\u015flevi, \u00f6zellikle b\u00fcy\u00fck veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken zaman tasarrufu sa\u011flar ve hata yapma olas\u0131l\u0131\u011f\u0131n\u0131 azalt\u0131r. Fakat i\u015flevin do\u011fru \u00e7al\u0131\u015fabilmesi i\u00e7in, aranan b\u00f6lge ile toplanacak b\u00f6lge aras\u0131nda do\u011fru ili\u015fkinin kurulmu\u015f olmas\u0131 gerekir. Veri aral\u0131klar\u0131n\u0131n hatal\u0131 se\u00e7ilmesi yanl\u0131\u015f sonu\u00e7lara neden olabilir.<\/p>\n
    \u0130\u015flev ba\u015fka i\u015flevlerle birlikte de kullan\u0131labilir. \u00d6rne\u011fin, SUMIFS<\/code> daha fazla ko\u015ful eklemenize olanak tan\u0131rken, AVERAGEIF<\/code> ise belirli ko\u015fullara g\u00f6re ortalamalar\u0131 hesaplaman\u0131z\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Verilen \u00f6l\u00e7\u00fctle belirlenen h\u00fccreleri toplar<\/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-15659","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUMIF (ETOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUMIF (ETOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/\" \/>\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:37:00+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 SUMIF (ETOPLA) 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\/sumif\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sumif\/\",\"name\":\"Excel'de SUMIF (ETOPLA) 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:37:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sumif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumif\/#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\":\"ETOPLA\"}]},{\"@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 SUMIF (ETOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUMIF (ETOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUMIF (ETOPLA) 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\/sumif\/","url":"https:\/\/functiontranslator.com\/tr\/sumif\/","name":"Excel'de SUMIF (ETOPLA) 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:37:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUMIF (ETOPLA) 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\/sumif\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sumif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sumif\/#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":"ETOPLA"}]},{"@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\/15659","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=15659"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15659\/revisions"}],"predecessor-version":[{"id":26927,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15659\/revisions\/26927"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}