{"id":1741,"date":"2023-11-08T04:15:58","date_gmt":"2023-11-08T04:15:58","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/"},"modified":"2023-12-10T06:02:47","modified_gmt":"2023-12-10T06:02:47","slug":"toplam-birikir-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/","title":{"rendered":"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1766735630\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;de de\u011fi\u015fen bir toplam olu\u015fturmak istiyorsan\u0131z \u00f6zel bir s\u00fctun olu\u015fturman\u0131z gerekir. T\u0131pk\u0131 a\u015fa\u011f\u0131daki \u00f6rnekte oldu\u011fu gibi: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83690\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam ko\u015fu\" width=\"412\" height=\"383\"><\/figure><\/div><p> C s\u00fctununda her ay i\u00e7in de\u011fi\u015fen toplam\u0131m\u0131z\u0131n oldu\u011funu g\u00f6rebilirsiniz. \u00d6rne\u011fin Mart ay\u0131 toplam\u0131 Ocak, \u015eubat ve Mart aylar\u0131n\u0131n toplam\u0131d\u0131r.<\/p><h2 id=\"h-formula-to-create-a-running-total-in-excel\" class=\"wp-block-heading\"> Excel&#8217;de de\u011fi\u015fen toplam olu\u015fturma form\u00fcl\u00fc<\/h2><ol><li> \u00d6ncelikle miktar s\u00fctunuyla yeni bir s\u00fctun olu\u015fturun. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-olu\u015ftur-ak\u0131m-toplam\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-creer-un-total-cumule.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-running-total\" width=\"452\" height=\"333\"><\/li><li> Bundan sonra toplam fonksiyonuna girin ve B2:B2 aral\u0131\u011f\u0131na bak\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 giri\u015fli toplam i\u015flevi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-la-fonction-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-sum-function\" width=\"451\" height=\"299\"><\/li><li> \u015eimdi aral\u0131k referans\u0131ndan ilk h\u00fccreyi dolar i\u015faretini kullanarak kilitleyin. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-dolar i\u015faretini kullanan ilk h\u00fccreyi kilitle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-verrouiller-la-premiere-cellule-en-utilisant-le-signe-dollar.png\" sizes=\"auto, \" srcset=\"\" alt=\"lock-the-first-cell-using-dollar-sign\" width=\"449\" height=\"313\"><\/li><li> Daha sonra form\u00fcl\u00fc s\u00fctundaki son h\u00fccreye s\u00fcr\u00fckleyin. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-form\u00fcl\u00fc-son-h\u00fccreye-s\u00fcr\u00fckleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-faites-glisser-la-formule-jusqua-la-derniere-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"drag-formula-to-the-last-cell\" width=\"468\" height=\"473\"><\/li><\/ol><p> Bu form\u00fcl\u00fc s\u00fcr\u00fckledi\u011finizde ba\u015fvurulan aral\u0131\u011f\u0131n ba\u015flang\u0131\u00e7 h\u00fccresi B2 olarak kal\u0131r ve son h\u00fccre s\u00fcr\u00fcklemeyle ilerlemeye devam eder. May\u0131s ay\u0131 toplam\u0131nda referans\u0131n $B$2:B6 aral\u0131\u011f\u0131 i\u00e7in oldu\u011funu ancak Aral\u0131k ay\u0131nda $B$2:B13 oldu\u011funu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-signe-dollar-verrouille-la-cellule-de-reference-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"dolar i\u015fareti ba\u015flang\u0131\u00e7 referans h\u00fccresini kilitler\" width=\"570\" height=\"515\"><\/figure><\/div><h2 id=\"h-absolute-cell-running-total\" class=\"wp-block-heading\"> Mutlak k\u00fcm\u00fclatif h\u00fccre toplam\u0131<\/h2><p> Aral\u0131ktaki ilk h\u00fccreyi kilitlemek i\u00e7in bir dolar i\u015fareti kulland\u0131k, bu da onu B2 h\u00fccresi i\u00e7in mutlak bir h\u00fccre referans\u0131 haline getirdi. Form\u00fcl\u00fc s\u00fcr\u00fckledi\u011finizde B2 sabit kal\u0131r ve aral\u0131\u011f\u0131n en alt h\u00fccresi s\u00fcrekli de\u011fi\u015fir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83696\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Total-cumule-de-7-cellules-absolues.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccrenin mutlak toplam\u0131 y\u00fcr\u00fct\u00fclebilir\" width=\"515\" height=\"360\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/total-cumule-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutunun-tamamini-ekle\/\">Excel&#8217;de bir s\u00fctunun veya sat\u0131r\u0131n tamam\u0131n\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yalnizca-gorunur-hucreleri-ekle\/\">Excel&#8217;de yaln\u0131zca g\u00f6r\u00fcn\u00fcr h\u00fccreleri topla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-hucreler-ekle\/\">Excel&#8217;deki rastgele h\u00fccrelerin toplam\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-satir\/\">Excel&#8217;de toplam sat\u0131r ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-1\/\">Excel&#8217;de Otomatik Toplam\u0131 H\u0131zla Kullanma<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1741","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\",\"name\":\"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\",\"datePublished\":\"2023-11-08T04:15:58+00:00\",\"dateModified\":\"2023-12-10T06:02:47+00:00\",\"description\":\"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)","description":"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","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:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)","og_description":"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/","url":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/","name":"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png","datePublished":"2023-11-08T04:15:58+00:00","dateModified":"2023-12-10T06:02:47+00:00","description":"Bu e\u011fitim size de\u011ferler i\u00e7in bir toplam olu\u015fturmak \u00fczere bir Excel form\u00fcl\u00fcn\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de toplam \u00e7al\u0131\u015fma toplam\u0131 nas\u0131l hesaplan\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1741"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1741\/revisions"}],"predecessor-version":[{"id":2617,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1741\/revisions\/2617"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}