{"id":15260,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/alansay\/"},"modified":"2021-02-25T16:22:08","modified_gmt":"2021-02-25T16:22:08","slug":"areas","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/areas\/","title":{"rendered":"ALANSAY"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, zengin i\u015flevsellikleriyle bilinen pop\u00fcler elektronik tablolama ara\u00e7lar\u0131d\u0131r. Bu ara\u00e7lar\u0131n sa\u011flad\u0131\u011f\u0131 bir\u00e7ok form\u00fcl, veri analizi s\u00fcre\u00e7lerini kolayla\u015ft\u0131r\u0131r. Bu makalede, “AREAS” i\u015flevinin T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 olan “ALANSAY” fonksiyonunun kullan\u0131m\u0131na odaklanaca\u011f\u0131z. “ALANSAY” fonksiyonu, verilen bir referansta ka\u00e7 farkl\u0131 alan bulundu\u011funu g\u00f6sterir ve \u00f6zellikle birden fazla alan i\u00e7eren referanslar\u0131 i\u015flerken yararl\u0131d\u0131r.<\/p>\n

ALANSAY Fonksiyonunun S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

ALANSAY fonksiyonunun temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=ALANSAY(Referans)<\/code><\/pre>\n
Bu form\u00fclde “Referans”, alan say\u0131s\u0131n\u0131 hesaplamak istedi\u011finiz h\u00fccre aral\u0131klar\u0131n\u0131 veya linkleri ifade eder.<\/p>\n
\u00d6rnek kullan\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n
1. Tek bir h\u00fccre aral\u0131\u011f\u0131 i\u00e7in:<\/p>\n
=ALANSAY(A1:B1) \/\/Sonu\u00e7: 1, \u00e7\u00fcnk\u00fc tek bir alan vard\u0131r.<\/code><\/pre>\n
2. Birden fazla ayr\u0131k h\u00fccre aral\u0131\u011f\u0131 i\u00e7in:<\/p>\n
=ALANSAY((A1:B1, C1:D1)) \/\/Sonu\u00e7: 2, iki farkl\u0131 h\u00fccre aral\u0131\u011f\u0131 belirtildi\u011fi i\u00e7in.<\/code><\/pre>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
ALANSAY fonksiyonu, b\u00fcy\u00fck ve karma\u015f\u0131k veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken b\u00fcy\u00fck faydalar sa\u011flar. \u0130\u015fte bu fonksiyonun kullan\u0131labilece\u011fi baz\u0131 pratik durumlar:<\/p>\n
Senaryo 1: Proje Takviminde Fazlar\u0131n Analizi<\/h2>\n
Bir proje y\u00f6neticisi, projenin farkl\u0131 a\u015famalar\u0131n\u0131 i\u00e7eren takvim alanlar\u0131n\u0131 analiz etmek isteyebilir. Her bir faz farkl\u0131 h\u00fccre aral\u0131klar\u0131nda tan\u0131mlanm\u0131\u015f olabilir.<\/p>\n
=ALANSAY((B2:B5, D2:D5, G2:G5))<\/code><\/pre>\n
Bu form\u00fcl, \u00fc\u00e7 ayr\u0131 projenin fazlar\u0131n\u0131 i\u00e7eren \u00fc\u00e7 ayr\u0131 alan oldu\u011funu g\u00f6sterir. Her bir faz\u0131n ayr\u0131 h\u00fccre bloklar\u0131nda yer almas\u0131, ALANSAY fonksiyonu ile h\u0131zl\u0131 bir \u015fekilde analiz yap\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n
Senaryo 2: Birden Fazla Veri Setinin De\u011ferlendirilmesi<\/h2>\n
Bir analist, ayn\u0131 \u00e7al\u0131\u015fma sayfas\u0131nda birden fazla, birbirinden ba\u011f\u0131ms\u0131z veri setlerini de\u011ferlendirmek i\u00e7in ALANSAY fonksiyonunu kullanabilir.<\/p>\n
=ALANSAY((A1:A20, C1:C20, E1:E20, G1:G20))<\/code><\/pre>\n
Bu kullan\u0131m, d\u00f6rt ayr\u0131 veri seti oldu\u011funu tespit eder ve analistin her birini ayr\u0131 de\u011ferlendirmesine imkan tan\u0131r.<\/p>\n
ALANSAY fonksiyonu, Excel ve Google Sheets’teki veri analizinin \u00e7e\u015fitli y\u00f6nlerinde kullan\u0131labilir; \u00f6zellikle birden fazla alan i\u00e7eren karma\u015f\u0131k veri yap\u0131lar\u0131nda zaman kazand\u0131r\u0131r ve analiz s\u00fcre\u00e7lerini basitle\u015ftirir.<\/p>\n","protected":false},"excerpt":{"rendered":"
Ba\u015fvurudaki alanlar\u0131n say\u0131s\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15260","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de AREAS (ALANSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de AREAS (ALANSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/\" \/>\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:22:08+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 AREAS (ALANSAY) 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\/areas\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/areas\/\",\"name\":\"Excel'de AREAS (ALANSAY) 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:22:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/areas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/areas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ALANSAY\"}]},{\"@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 AREAS (ALANSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de AREAS (ALANSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:22:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de AREAS (ALANSAY) 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\/areas\/","url":"https:\/\/functiontranslator.com\/tr\/areas\/","name":"Excel'de AREAS (ALANSAY) 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:22:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da AREAS (ALANSAY) 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\/areas\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/areas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/areas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"ALANSAY"}]},{"@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\/15260","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=15260"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15260\/revisions"}],"predecessor-version":[{"id":26528,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15260\/revisions\/26528"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}