{"id":15635,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sayfalar\/"},"modified":"2021-02-25T16:35:50","modified_gmt":"2021-02-25T16:35:50","slug":"sheets","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sheets\/","title":{"rendered":"SAYFALAR"},"content":{"rendered":"<h2>SHEETS Fonksiyonunun Genel Bak\u0131\u015f<\/h2>\n<p><code>SHEETS<\/code> fonksiyonu, Microsoft Excel ve Google E-Tablolar&#8217;da kullan\u0131labilen \u00e7ok i\u015flevsel bir form\u00fcld\u00fcr. Bu fonksiyon, belirli bir ba\u015fvuruda bulunan \u00e7al\u0131\u015fma sayfalar\u0131n\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. E\u011fer arg\u00fcman olarak hi\u00e7bir \u015fey girilmezse, o zaman bulundu\u011fu dosyada toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 verir.<\/p>\n<h2>Fonksiyon S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<pre> <code>SHEETS(dosya_referans\u0131)<\/code> <\/pre>\n<ul>\n<li><strong>dosya_referans\u0131<\/strong> (iste\u011fe ba\u011fl\u0131): Bu arg\u00fcman, sayfa say\u0131s\u0131n\u0131 hesaplamak istedi\u011finiz belirli bir dosyay\u0131 veya \u00e7al\u0131\u015fma alan\u0131n\u0131 referans al\u0131r. E\u011fer bu alan bo\u015f b\u0131rak\u0131l\u0131rsa, fonksiyon mevcut \u00e7al\u0131\u015fma kitab\u0131ndaki toplam sayfa say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n<p>Bu fonksiyon \u00f6zellikle b\u00fcy\u00fck ve birden fazla \u00e7al\u0131\u015fma sayfas\u0131 i\u00e7eren dosyalarda belirli bir alan\u0131n kapsam\u0131n\u0131 anlamak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131yla, dosyalar aras\u0131nda veya ayn\u0131 dosya i\u00e7inde h\u0131zl\u0131ca gezinme ve bilgi toplama i\u015flemleri kolayla\u015fabilir.<\/p>\n<h2>Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmler<\/h2>\n<h3>1. \u00c7al\u0131\u015fma Kitab\u0131ndaki Toplam Sayfa Say\u0131s\u0131n\u0131 Hesaplama<\/h3>\n<p>Bir organizasyon, dosyalama sisteminin bir par\u00e7as\u0131 olarak Excel dosyalar\u0131ndaki sayfa say\u0131lar\u0131n\u0131 takip etmek istiyor olabilir. Bu ba\u011flamda <code>SHEETS<\/code> fonksiyonu kullan\u0131larak dosyadaki toplam sayfa say\u0131s\u0131 kolayl\u0131kla bulunabilir. \u00d6rne\u011fin:<\/p>\n<pre> <code>=SHEETS()<\/code> <\/pre>\n<p>Bu form\u00fcl, \u00e7al\u0131\u015f\u0131lan dosyada bulunan toplam \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 verir ve organizasyonun dosyalar\u0131 \u00fczerinde d\u00fczeni sa\u011flamaya yard\u0131mc\u0131 olur.<\/p>\n<h3>2. Belirli bir Dosya veya Aral\u0131ktaki Sayfa Say\u0131s\u0131n\u0131 \u00d6\u011frenme<\/h3>\n<p>Projeler genellikle birden fazla b\u00f6l\u00fcmden olu\u015fur ve her b\u00f6l\u00fcm farkl\u0131 bir \u00e7al\u0131\u015fma sayfas\u0131nda tutulabilir. \u00d6rne\u011fin, bir projenin sadece belirli b\u00f6l\u00fcmlerindeki sayfa say\u0131s\u0131n\u0131 hesaplamak i\u00e7in <code>SHEETS<\/code> fonksiyonu \u015fu \u015fekilde kullan\u0131labilir:<\/p>\n<pre> <code>=SHEETS([DosyaAd\u0131.xlsx]Aral\u0131kAd\u0131)<\/code> <\/pre>\n<p>Bu kullan\u0131m, belirli bir dosya i\u00e7erisinde veya farkl\u0131 bir dosyadaki (burada &#8216;DosyaAd\u0131.xlsx&#8217;) &#8216;Aral\u0131kAd\u0131&#8217; isimli b\u00f6l\u00fcmde ka\u00e7 adet \u00e7al\u0131\u015fma sayfas\u0131 oldu\u011funu d\u00f6nd\u00fcr\u00fcr. Y\u00f6neticiler veya proje liderleri i\u00e7in bu, projenin hangi k\u0131sm\u0131n\u0131n \u00fczerinde daha fazla \u00e7al\u0131\u015f\u0131lmas\u0131 gerekti\u011fini de\u011ferlendirmede faydal\u0131 olabilir.<\/p>\n<h2>Yorumlar ve Ek \u0130pu\u00e7lar\u0131<\/h2>\n<p><code>SHEETS<\/code> fonksiyonu hem Excel hem de Google E-Tablolar&#8217;da benzer \u015fekillerde \u00e7al\u0131\u015f\u0131r, bu y\u00fczden \u00f6\u011frenilen bilgiler her iki platforma da uygulanabilir. Ancak, fonksiyonun d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fc say\u0131n\u0131n, referans verilen dosya ya da \u00e7al\u0131\u015fma sayfas\u0131n\u0131n mevcut durumunu yans\u0131tt\u0131\u011f\u0131n\u0131, yani dosya \u00fczerinde yap\u0131lan de\u011fi\u015fikliklerin sonu\u00e7lar\u0131 etkileyebilece\u011fini unutmamak \u00f6nemlidir.<\/p>\n<p>Ayr\u0131ca, <code>SHEETS<\/code> kullan\u0131rken verilen referans\u0131n do\u011fru ve eri\u015filebilir olmas\u0131 gerekti\u011fine dikkat edilmelidir. Yanl\u0131\u015f veya eri\u015filemez bir referans hata mesajlar\u0131na neden olabilir.<\/p>\n<p>Bu y\u00f6nergeler do\u011frultusunda, <code>SHEETS<\/code> fonksiyonu, verimli veri y\u00f6netimi ve organizasyonunda g\u00fc\u00e7l\u00fc bir ara\u00e7 olarak kar\u015f\u0131m\u0131za \u00e7\u0131kmaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ba\u015fvurudaki sayfa 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":[586],"tags":[],"class_list":["post-15635","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de SHEETS (SAYFALAR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da SHEETS (SAYFALAR) 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\/sheets\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de SHEETS (SAYFALAR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da SHEETS (SAYFALAR) 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\/sheets\/\" \/>\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:35:50+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de SHEETS (SAYFALAR) 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\/sheets\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sheets\/\",\"name\":\"Excel'de SHEETS (SAYFALAR) 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:35:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SHEETS (SAYFALAR) 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\/sheets\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bilgi\",\"item\":\"https:\/\/functiontranslator.com\/tr\/bilgi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SAYFALAR\"}]},{\"@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 SHEETS (SAYFALAR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SHEETS (SAYFALAR) 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\/sheets\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SHEETS (SAYFALAR) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SHEETS (SAYFALAR) 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\/sheets\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:35:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SHEETS (SAYFALAR) 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\/sheets\/","url":"https:\/\/functiontranslator.com\/tr\/sheets\/","name":"Excel'de SHEETS (SAYFALAR) 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:35:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SHEETS (SAYFALAR) 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\/sheets\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Bilgi","item":"https:\/\/functiontranslator.com\/tr\/bilgi\/"},{"@type":"ListItem","position":3,"name":"SAYFALAR"}]},{"@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\/15635","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=15635"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15635\/revisions"}],"predecessor-version":[{"id":26903,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15635\/revisions\/26903"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}