{"id":15313,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sutunsay\/"},"modified":"2021-02-25T16:23:44","modified_gmt":"2021-02-25T16:23:44","slug":"columns","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/columns\/","title":{"rendered":"S\u00dcTUNSAY"},"content":{"rendered":"

Excel ve Google E-Tablolar \u0130\u00e7in S\u00fctun Say\u0131s\u0131 Hesaplama Rehberi<\/h1>\n

Excel ve Google E-Tablolar kullan\u0131c\u0131lar\u0131, genellikle b\u00fcy\u00fck veri setleri ile \u00e7al\u0131\u015f\u0131rken hangi aral\u0131kta ka\u00e7 s\u00fctun oldu\u011funu belirlemek isteyebilir. Bu bilgi, veri analizi, raporlama ve g\u00f6rselle\u015ftirme i\u015flemlerini planlarken olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. Bu rehberde, kullan\u0131c\u0131lar\u0131n veri aral\u0131klar\u0131ndaki s\u00fctun say\u0131s\u0131n\u0131 hesaplamalar\u0131na olanak tan\u0131yan “COLUMNS” veya Google E-Tablolar\u2019daki kar\u015f\u0131l\u0131\u011f\u0131 “S\u00dcTUNSAY” i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 detayl\u0131 bir \u015fekilde anlat\u0131lmaktad\u0131r. <\/p>\n

S\u00fctun Say\u0131s\u0131 Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

“COLUMNS” (Excel) ve “S\u00dcTUNSAY” (Google E-Tablolar), se\u00e7ilen h\u00fccre aral\u0131\u011f\u0131nda bulunan s\u00fctun say\u0131s\u0131n\u0131 d\u00f6nd\u00fcren i\u015flevlerdir. \u0130\u015flevin kullan\u0131m s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir: <\/p>\n

  COLUMNS(aral\u0131k) S\u00dcTUNSAY(aral\u0131k) <\/code> <\/pre>\n
    \n
  • aral\u0131k<\/strong>: H\u00fccrelerin aral\u0131\u011f\u0131d\u0131r ve bu aral\u0131ktaki s\u00fctun say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: Veri Analizi<\/h3>\n
     Diyelim ki, A1’den G1’e kadar olan h\u00fccreleri i\u00e7eren bir aral\u0131kta, analiz i\u00e7in kullan\u0131lacak veri s\u00fctunlar\u0131n\u0131n say\u0131s\u0131n\u0131 bulmak istiyorsunuz. Bu durumda kullan\u0131lacak form\u00fcl \u015fu \u015fekilde olacakt\u0131r: <\/p>\n
      =COLUMNS(A1:G1) <!-- Excel i\u00e7in --> =S\u00dcTUNSAY(A1:G1) <!-- Google E-Tablolar i\u00e7in --> <\/code> <\/pre>\n
     Bu form\u00fcl, A1 ve G1 aras\u0131nda toplam 7 s\u00fctun oldu\u011funu d\u00f6nd\u00fcrecektir. Bu bilgi, veri setinizde ka\u00e7 farkl\u0131 veri s\u00fctunu \u00fczerinde \u00e7al\u0131\u015fabilece\u011finizi g\u00f6sterir. <\/p>\n
    Senaryo 2: Tablo Geni\u015fli\u011finin Hesaplanmas\u0131<\/h3>\n
     Bir projede, belirli bir tablonun tam geni\u015fli\u011fini dinamik olarak hesaplamak isteyebilirsiniz. \u00d6rne\u011fin, A1 h\u00fccresinden ba\u015flayarak ilk bo\u015f s\u00fctuna kadar olan k\u0131s\u0131m\u0131 hesaplamak istiyorsunuz. Bunu \u015fu \u015fekilde yapabiliriz: <\/p>\n
      =COLUMNS(A1:INDIRECT(\"A1:\" & ADDRESS(1, MATCH(\"zzz\",1:1,1)))) <!-- Excel i\u00e7in --> =S\u00dcTUNSAY(A1:INDIRECT(\"A1:\" & ADDRESS(1, MATCH(\"zzz\",1:1,1)))) <!-- Google E-Tablolar i\u00e7in --> <\/code> <\/pre>\n
     Burada MATCH fonksiyonu, ilk bo\u015f s\u00fctunu bulmam\u0131za yard\u0131mc\u0131 olurken, ADDRESS fonksiyonu bu s\u00fctunun adresini d\u00f6nd\u00fcr\u00fcr. INDIRECT ile bu adres dinamik bir aral\u0131k olarak kullan\u0131l\u0131r. Sonu\u00e7, tablonun ba\u015flang\u0131\u00e7 noktas\u0131ndan son veriye kadar olan s\u00fctun say\u0131s\u0131n\u0131 verir. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Ba\u015fvurudaki s\u00fctunlar\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-15313","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de COLUMNS (S\u00dcTUNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COLUMNS (S\u00dcTUNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/\" \/>\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:23:44+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 COLUMNS (S\u00dcTUNSAY) 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\/columns\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/columns\/\",\"name\":\"Excel'de COLUMNS (S\u00dcTUNSAY) 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:23:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/columns\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/columns\/#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\":\"S\u00dcTUNSAY\"}]},{\"@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 COLUMNS (S\u00dcTUNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COLUMNS (S\u00dcTUNSAY) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COLUMNS (S\u00dcTUNSAY) 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\/columns\/","url":"https:\/\/functiontranslator.com\/tr\/columns\/","name":"Excel'de COLUMNS (S\u00dcTUNSAY) 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:23:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COLUMNS (S\u00dcTUNSAY) 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\/columns\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/columns\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/columns\/#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":"S\u00dcTUNSAY"}]},{"@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\/15313","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=15313"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15313\/revisions"}],"predecessor-version":[{"id":26581,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15313\/revisions\/26581"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}