{"id":15533,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/mincifs\/"},"modified":"2021-02-25T16:31:46","modified_gmt":"2021-02-25T16:31:46","slug":"minifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/minifs\/","title":{"rendered":"Minc\u0131fs"},"content":{"rendered":"

Excel ve Google Sheets’te, \u00e7ok i\u015flevli bir ara\u00e7 olan MINIFS fonksiyonu, belirli ko\u015fullar alt\u0131nda b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7inde minimum de\u011feri bulmak i\u00e7in kullan\u0131l\u0131r. \u00d6zellikle b\u00fcy\u00fck veri setlerinden belirli kriterlere g\u00f6re en d\u00fc\u015f\u00fck de\u011feri s\u00fczmek ve analiz etmek isteyenler i\u00e7in olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

Genel Bak\u0131\u015f ve S\u00f6zdizimi<\/h2>\n

MINIFS fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) <\/code> <\/pre>\n
    \n
  • min_range<\/strong>: Minimum de\u011ferlerin hesaplanaca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • criteria_range1<\/strong>: \u0130lk kriterin kar\u015f\u0131la\u015ft\u0131r\u0131laca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • criteria1<\/strong>: \u0130lk aral\u0131k i\u00e7in kullan\u0131lacak kriter.<\/li>\n
  • [criteria_range2, criteria2, …<\/strong>]: \u0130ste\u011fe ba\u011fl\u0131 ek kriter aral\u0131klar\u0131 ve ilgili kriterler.<\/li>\n<\/ul>\n
    A\u015fa\u011f\u0131da MINIFS fonksiyonunun pratik kullan\u0131m\u0131na dair \u00f6rnekler verilmi\u015ftir:<\/p>\n\n\n\n\n\n\n\n\n
    H\u00fccre<\/th>\nVeri<\/th>\n<\/tr>\n
    A1<\/td>\n10<\/td>\n<\/tr>\n
    A2<\/td>\n20<\/td>\n<\/tr>\n
    A3<\/td>\n30<\/td>\n<\/tr>\n
    B1<\/td>\nA<\/td>\n<\/tr>\n
    B2<\/td>\nB<\/td>\n<\/tr>\n
    B3<\/td>\nA<\/td>\n<\/tr>\n<\/table>\n
      =MINIFS(A1:A3, B1:B3, \"A\") <\/code> <\/pre>\n
    Bu \u00f6rnekte, A s\u00fctunundaki “A” harfine kar\u015f\u0131l\u0131k gelen minimum de\u011fer (10 veya 30) aran\u0131r ve sonu\u00e7 olarak 10 bulunur.<\/p>\n
    Pratik \u0130\u015f Uygulamalar\u0131<\/h2>\n
    \u00c7al\u0131\u015fan Performans De\u011ferlendirmesi<\/h2>\n
    Bir \u015firket, departmanlara g\u00f6re en d\u00fc\u015f\u00fck performans g\u00f6steren \u00e7al\u0131\u015fan\u0131n puan\u0131n\u0131 belirlemek isteyebilir:<\/p>\n
      =MINIFS(C2:C10, B2:B10, \"Sat\u0131\u015f\") <\/code> <\/pre>\n
    Bu form\u00fcl, “Sat\u0131\u015f” departman\u0131nda \u00e7al\u0131\u015fanlar aras\u0131ndan en d\u00fc\u015f\u00fck puan\u0131 hesaplar.<\/p>\n
    B\u00fct\u00e7e Planlamas\u0131<\/h2>\n
    Bir \u015firketin farkl\u0131 projeler i\u00e7in yapt\u0131\u011f\u0131 en d\u00fc\u015f\u00fck harcamalar\u0131 belirlemek istedi\u011fini d\u00fc\u015f\u00fcn\u00fcn:<\/p>\n
      =MINIFS(C2:C100, B2:B100, \">100000\", D2:D100, \"Tamamland\u0131\") <\/code> <\/pre>\n
    Bu form\u00fcl, 100,000’den fazla b\u00fct\u00e7esi olan ve “Tamamland\u0131” stat\u00fcs\u00fcndeki projeler aras\u0131ndan en d\u00fc\u015f\u00fck harcamay\u0131 bulur.<\/p>\n
    Bu \u00f6rnekler ve a\u00e7\u0131klamalar, Excel ve Google Sheets’te MINIFS fonksiyonunun etkili bir \u015fekilde nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir, bu fonksiyon belirli ko\u015fullar alt\u0131nda veri k\u00fcmelerinden en d\u00fc\u015f\u00fck de\u011feri elde etmek i\u00e7in olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirli bir ko\u015ful veya \u00f6l\u00e7\u00fct k\u00fcmesi taraf\u0131ndan belirtilen h\u00fccreler aras\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15533","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de MINIFS (Minc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MINIFS (Minc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/\" \/>\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:31:46+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 MINIFS (Minc\u0131fs) 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\/minifs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/minifs\/\",\"name\":\"Excel'de MINIFS (Minc\u0131fs) 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:31:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/minifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/minifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Minc\u0131fs\"}]},{\"@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 MINIFS (Minc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MINIFS (Minc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MINIFS (Minc\u0131fs) 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\/minifs\/","url":"https:\/\/functiontranslator.com\/tr\/minifs\/","name":"Excel'de MINIFS (Minc\u0131fs) 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:31:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MINIFS (Minc\u0131fs) 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\/minifs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/minifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/minifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"Minc\u0131fs"}]},{"@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\/15533","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=15533"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15533\/revisions"}],"predecessor-version":[{"id":27058,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15533\/revisions\/27058"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}