{"id":15662,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/topkare\/"},"modified":"2021-02-25T16:37:07","modified_gmt":"2021-02-25T16:37:07","slug":"sumsq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sumsq\/","title":{"rendered":"TOPKARE"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, say\u0131sal analizler yapmak i\u00e7in yayg\u0131n olarak kullan\u0131lan elektronik tablolama ara\u00e7lar\u0131d\u0131r. Bu uygulamalar, \u00e7e\u015fitli matematiksel hesaplama fonksiyonlar\u0131n\u0131 i\u00e7ermektedir. Bu yaz\u0131m\u0131zda, Excel ve Google Sheets’te bulunan SUMSQ<\/strong> (T\u00fcrk\u00e7e: TOPKARE<\/strong>) fonksiyonunun kullan\u0131m\u0131n\u0131, \u00f6zelliklerini ve \u00e7e\u015fitli problem senaryolar\u0131nda nas\u0131l de\u011ferlendirilece\u011fini ele alaca\u011f\u0131z.<\/p>\n

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

TOPKARE fonksiyonu, belirtilen say\u0131lar\u0131n karelerinin toplam\u0131n\u0131 hesaplama amac\u0131 g\u00fcder. Bu fonksiyon hem Microsoft Excel’de hem de Google Sheets’te benzer \u015fekilde kullan\u0131l\u0131r:<\/p>\n

=SUMSQ(say\u01311, [say\u01312], ...)<\/code><\/pre>\n
Parametreler a\u015fa\u011f\u0131daki gibi a\u00e7\u0131klanabilir:<\/p>\n
    \n
  • say\u01311, say\u01312, …<\/strong>: Kareleri al\u0131nacak ve toplanacak say\u0131lar veya h\u00fccre aral\u0131klar\u0131. Bu arg\u00fcmanlar iste\u011fe ba\u011fl\u0131 olup, en az bir tanesinin girilmesi zorunludur.<\/li>\n<\/ul>\n
    Bir \u00f6rnek kullan\u0131m\u0131 a\u015fa\u011f\u0131da g\u00f6rebilirsiniz:<\/p>\n
    =SUMSQ(3, 4)<\/code><\/pre>\n
    Bu form\u00fcl, \\(3^2 + 4^2 = 9 + 16 = 25\\) sonucunu verecektir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \u00d6rnek 1: E\u011fitim Skorlar\u0131n\u0131n De\u011ferlendirilmesi<\/strong><\/p>\n
    Bir \u00f6\u011fretmen, \u00f6\u011frencilerin test sonu\u00e7lar\u0131n\u0131n varyans\u0131n\u0131 hesaplamak i\u00e7in bu sonu\u00e7lar\u0131 de\u011ferlendirirken TOPKARE fonksiyonunu kullanabilir. \u00d6rne\u011fin, \u00f6\u011frencilerin ald\u0131\u011f\u0131 puanlar 65, 70 ve 75 ise:<\/p>\n
    =SUMSQ(65, 70, 75)<\/code><\/pre>\n
    Bu form\u00fcl, \\(65^2 + 70^2 + 75^2 = 4225 + 4900 + 5625 = 14750\\) sonucunu d\u00f6nd\u00fcrecektir. Bu sayede \u00f6\u011fretmen, varyans ve standart sapma hesaplamalar\u0131 i\u00e7in bir temel olu\u015fturmu\u015f olur.<\/p>\n
    \u00d6rnek 2: M\u00fchendislik Hesaplamalar\u0131<\/strong><\/p>\n
    M\u00fchendisler, kuvvet ve enerji gibi de\u011ferlerin karelerini hesaplarken SUMSQ fonksiyonunu kullanabilirler. Diyelim ki bir m\u00fchendis, \u00fc\u00e7 farkl\u0131 motorun \u00fcretti\u011fi g\u00fc\u00e7leri de\u011ferlendiriyor: 320 kW, 450 kW ve 500 kW. Bu g\u00fc\u00e7lerin karelerinin toplam\u0131 hesaplanmak isteniyor:<\/p>\n
    =SUMSQ(320, 450, 500)<\/code><\/pre>\n
    Bu form\u00fcl, \\(320^2 + 450^2 + 500^2 = 102400 + 202500 + 250000 = 554900\\) kW^2 sonucunu verecektir.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler SUMSQ\/TOPKARE fonksiyonunun kullan\u0131m\u0131n\u0131 ve \u00e7e\u015fitli senaryolarda nas\u0131l yararl\u0131 olabilece\u011fini g\u00f6stermektedir. Bu fonksiyon ile matematiksel ve istatistiksel hesaplamalar\u0131n\u0131z\u0131 kolayl\u0131kla ger\u00e7ekle\u015ftirebilirsiniz. Sorular\u0131n\u0131z olursa, daha fazla bilgi i\u00e7in Google aramalar\u0131n\u0131 kullanabilir veya Microsoft Excel\/Google Sheets belgelerine ba\u015fvurabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerin kareleri toplam\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":[577],"tags":[],"class_list":["post-15662","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUMSQ (TOPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUMSQ (TOPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/\" \/>\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:37:07+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 SUMSQ (TOPKARE) 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\/sumsq\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sumsq\/\",\"name\":\"Excel'de SUMSQ (TOPKARE) 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:37:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sumsq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumsq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TOPKARE\"}]},{\"@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 SUMSQ (TOPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUMSQ (TOPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUMSQ (TOPKARE) 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\/sumsq\/","url":"https:\/\/functiontranslator.com\/tr\/sumsq\/","name":"Excel'de SUMSQ (TOPKARE) 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:37:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUMSQ (TOPKARE) 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\/sumsq\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sumsq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sumsq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"TOPKARE"}]},{"@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\/15662","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=15662"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15662\/revisions"}],"predecessor-version":[{"id":26930,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15662\/revisions\/26930"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}