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

MAXIFS fonksiyonu, belirlenen kriterlere g\u00f6re bir veri aral\u0131\u011f\u0131ndaki en y\u00fcksek de\u011feri bulmak i\u00e7in kullan\u0131l\u0131r. Hem Microsoft Excel hem de Google Sheets programlar\u0131nda mevcuttur ve finansal analizler, istatistiksel hesaplamalar ve veri filtreleme gibi i\u015flemler i\u00e7in olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n

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

MAXIFS fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) <\/code><\/pre>\n
    \n
  • max_range<\/b> – Maksimum de\u011ferlerin hesaplanaca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • criteria_range1<\/b> – \u0130lk kriterin kar\u015f\u0131la\u015ft\u0131r\u0131laca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • criteria1<\/b> – \u0130lk kriter (\u00f6rne\u011fin, “>10”, “Ahmet” gibi).<\/li>\n
  • criteria_range2, criteria2, …<\/b> – \u0130ste\u011fe ba\u011fl\u0131 ekstra kriter aral\u0131klar\u0131 ve kriterler.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/p>\n
     =MAXIFS(A2:A10, B2:B10, \">20\") <\/code><\/pre>\n
    Bu \u00f6rnekte, A2:A10 aral\u0131\u011f\u0131nda, B2:B10 aral\u0131\u011f\u0131nda yer alan de\u011ferler 20’den b\u00fcy\u00fck oldu\u011funda, en y\u00fcksek de\u011fer A aral\u0131\u011f\u0131ndan d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    MAXIFS fonksiyonu, ger\u00e7ek d\u00fcnya verileriyle \u00e7al\u0131\u015f\u0131rken \u00e7e\u015fitli senaryolarda kullan\u0131labilir. \u0130\u015fte bu senaryolardan iki \u00f6rnek:<\/p>\n
    \u00d6rnek Senaryo 1: Sat\u0131\u015f Verileri Analizi<\/h2>\n
    Bir \u015firket, farkl\u0131 b\u00f6lgelerdeki sat\u0131\u015f verilerini analiz etmek isteyebilir. Her bir b\u00f6lgedeki maksimum sat\u0131\u015f de\u011ferini bulmak i\u00e7in MAXIFS fonksiyonu kullan\u0131labilir:<\/p>\n
     =MAXIFS(C2:C100, B2:B100, \"Do\u011fu\") <\/code><\/pre>\n
    Bu form\u00fcl, C2:C100 aral\u0131\u011f\u0131nda yer alan de\u011ferler i\u00e7inde, B2:B100 aral\u0131\u011f\u0131nda “Do\u011fu” b\u00f6lgesi i\u00e7in olan maksimum sat\u0131\u015f de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    \u00d6rnek Senaryo 2: Akademik Performans De\u011ferlendirmesi<\/h2>\n
    Bir okul, s\u0131n\u0131f baz\u0131nda en y\u00fcksek notlar\u0131 tespit etmek isteyebilir. MAXIFS fonksiyonu, bir s\u0131n\u0131ftaki \u00f6\u011frenciler aras\u0131ndan en y\u00fcksek notu bulmada kullan\u0131labilir:<\/p>\n
     =MAXIFS(D2:D200, C2:C200, \"10. s\u0131n\u0131f\") <\/code><\/pre>\n
    Bu form\u00fcl, D2:D200 aral\u0131\u011f\u0131nda yer alan notlar \u00fczerinden, C2:C200 aral\u0131\u011f\u0131nda “10. s\u0131n\u0131f” olarak belirtilen s\u0131n\u0131fa ait \u00f6\u011frenciler i\u00e7in en y\u00fcksek notu belirler.<\/p>\n
    MAXIFS fonksiyonu, Excel ve Google Sheets kullan\u0131c\u0131lar\u0131na veriler \u00fczerinde derinlemesine analiz yapma ve belirli kriterlere g\u00f6re en y\u00fcksek de\u011ferleri h\u0131zla bulma olana\u011f\u0131 tan\u0131r. Yukar\u0131da verilen \u00f6rnekler, i\u015f ve e\u011fitim d\u00fcnyas\u0131ndaki \u00e7e\u015fitli durumlar i\u00e7in bu fonksiyonun nas\u0131l kullan\u0131labilece\u011fini a\u00e7\u0131k\u00e7a g\u00f6stermektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirli bir ko\u015ful veya \u00f6l\u00e7\u00fct k\u00fcmesi taraf\u0131ndan belirtilen h\u00fccreler aras\u0131ndaki en b\u00fcy\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-15527","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de MAXIFS (Maxc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MAXIFS (Maxc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/\" \/>\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:35+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 MAXIFS (Maxc\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\/maxifs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/maxifs\/\",\"name\":\"Excel'de MAXIFS (Maxc\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:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/maxifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/maxifs\/#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\":\"Maxc\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 MAXIFS (Maxc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MAXIFS (Maxc\u0131fs) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MAXIFS (Maxc\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\/maxifs\/","url":"https:\/\/functiontranslator.com\/tr\/maxifs\/","name":"Excel'de MAXIFS (Maxc\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:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MAXIFS (Maxc\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\/maxifs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/maxifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/maxifs\/#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":"Maxc\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\/15527","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=15527"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15527\/revisions"}],"predecessor-version":[{"id":26795,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15527\/revisions\/26795"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}