{"id":15660,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/topitopla\/"},"modified":"2021-02-25T16:37:03","modified_gmt":"2021-02-25T16:37:03","slug":"sumifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sumifs\/","title":{"rendered":"Top\u0131topla"},"content":{"rendered":"

MS Excel ve Google Sheets, veri analizi ve hesaplama konusunda son derece etkili ara\u00e7lard\u0131r. Bu ara\u00e7lar\u0131n temel \u00f6zelliklerinden biri ise i\u015flevlerdir. Bu makalede, ko\u015fullara g\u00f6re belirli h\u00fccre aral\u0131klar\u0131n\u0131 toplaman\u0131za imkan tan\u0131yan ‘SUMIFS’ i\u015flevinin kullan\u0131m\u0131 \u00fczerinde duraca\u011f\u0131z. SUMIFS, veri analizi i\u015flemlerinizde b\u00fcy\u00fck kolayl\u0131klar sa\u011flar.<\/p>\n

SUMIFS \u0130\u015flevinin S\u00f6zdizimi<\/h2>\n

SUMIFS i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 SUMIFS(toplam_aral\u0131\u011f\u0131, kriter_aral\u0131\u011f\u01311, kriter1, [kriter_aral\u0131\u011f\u01312, kriter2, ...])<\/code> <\/pre>\n
    \n
  • toplam_aral\u0131\u011f\u0131:<\/strong> Toplanacak de\u011ferlerin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • kriter_aral\u0131\u011f\u01311:<\/strong> \u0130lk kriterin uygulanaca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • kriter1:<\/strong> \u0130lk ko\u015ful. Bu ko\u015fulu sa\u011flayan h\u00fccrelerin de\u011ferleri toplan\u0131r.<\/li>\n
  • kriter_aral\u0131\u011f\u01312, kriter2, …:<\/strong> \u0130ste\u011fe ba\u011fl\u0131 ek ko\u015ful aral\u0131klar\u0131 ve ko\u015fullar.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
     =SUMIFS(A2:A10, B2:B10, \">20\", C2:C10, \"=&quot;Evet&quot;\")<\/code> <\/pre>\n
    Bu \u00f6rnekte, A2:A10 aral\u0131\u011f\u0131ndaki de\u011ferler, B2:B10 aral\u0131\u011f\u0131nda 20’den b\u00fcy\u00fck olanlar ve C2:C10 aral\u0131\u011f\u0131nda “Evet” olan h\u00fccrelerin de\u011ferleri toplan\u0131r.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    D\u00f6nemsel Sat\u0131\u015f Raporlamas\u0131<\/h2>\n
    Bir ma\u011fazan\u0131n, belirli bir sat\u0131\u015f limitini a\u015fan g\u00fcnlerdeki toplam sat\u0131\u015flar\u0131n\u0131 hesaplamak i\u00e7in SUMIFS i\u015flevinden yararlanabiliriz.<\/p>\n
     =SUMIFS(A2:A30, B2:B30, \">1000\")<\/code> <\/pre>\n
    Bu form\u00fcl, A2:A30 h\u00fccre aral\u0131\u011f\u0131nda yer alan toplam sat\u0131\u015flar ile B2:B30 aral\u0131\u011f\u0131nda g\u00fcnl\u00fck 1000 TL’yi ge\u00e7en sat\u0131\u015flar aras\u0131ndaki ili\u015fkiyi de\u011ferlendirir.<\/p>\n
    B\u00fct\u00e7e Kontrol\u00fc<\/h2>\n
    Bir \u015firket, belirlenen b\u00fct\u00e7e limitini a\u015fan harcamalar\u0131 izlemek ve bu harcamalar\u0131n toplam\u0131n\u0131 saptamak i\u00e7in SUMIFS i\u015flevini kullanabilir.<\/p>\n
     =SUMIFS(C2:C50, D2:D50, \">5000\")<\/code> <\/pre>\n
    Bu \u00f6rnekte, C2:C50 aral\u0131\u011f\u0131ndaki finansal de\u011ferler toplan\u0131rken, D2:D50 aral\u0131\u011f\u0131nda yer alan 5000 TL \u00fczeri de\u011ferler g\u00f6z \u00f6n\u00fcnde bulundurulur.<\/p>\n
    SUMIFS i\u015flevi, belirlenen ko\u015fullar\u0131 kar\u015f\u0131layan verileri etkin bir \u015fekilde toplayarak, b\u00fcy\u00fck veri setleri \u00fczerinde analiz ve raporlama i\u015flemlerinizi kolayla\u015ft\u0131r\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Aral\u0131kta birden \u00e7ok \u00f6l\u00e7\u00fcte uyan 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-15660","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUMIFS (Top\u0131topla) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUMIFS (Top\u0131topla) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/\" \/>\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:37:03+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 SUMIFS (Top\u0131topla) 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\/sumifs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sumifs\/\",\"name\":\"Excel'de SUMIFS (Top\u0131topla) 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:37:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sumifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumifs\/#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\":\"Top\u0131topla\"}]},{\"@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 SUMIFS (Top\u0131topla) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUMIFS (Top\u0131topla) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUMIFS (Top\u0131topla) 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\/sumifs\/","url":"https:\/\/functiontranslator.com\/tr\/sumifs\/","name":"Excel'de SUMIFS (Top\u0131topla) 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:37:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUMIFS (Top\u0131topla) 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\/sumifs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sumifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sumifs\/#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":"Top\u0131topla"}]},{"@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\/15660","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=15660"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15660\/revisions"}],"predecessor-version":[{"id":26928,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15660\/revisions\/26928"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}