{"id":3186,"date":"2023-07-18T19:18:18","date_gmt":"2023-07-18T19:18:18","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/"},"modified":"2023-07-18T19:18:18","modified_gmt":"2023-07-18T19:18:18","slug":"excel-pivot-tablo-toplami-sayi-ayni-alan","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/","title":{"rendered":"Excel pivot tablosu: ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesapla"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle Excel&#8217;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesaplamak isteyebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pivot tablo olu\u015ftururken ayn\u0131 alan\u0131 <strong>De\u011ferler<\/strong> kutusuna iki kez s\u00fcr\u00fckleyerek bunu kolayl\u0131kla yapabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel pivot tablosunda ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesaplama<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Excel&#8217;de \u00e7e\u015fitli \u00fcr\u00fcnlerin sat\u0131\u015flar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27055 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-2.jpg\" alt=\"\" width=\"377\" height=\"435\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi \u00fcr\u00fcn baz\u0131nda sat\u0131\u015flar\u0131n <strong>toplam\u0131n\u0131<\/strong> \u00f6zetlemek i\u00e7in a\u015fa\u011f\u0131daki pivot tabloyu ekledi\u011fimizi varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27056 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte3-1.jpg\" alt=\"\" width=\"476\" height=\"421\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi her bir \u00fcr\u00fcn\u00fcn sat\u0131\u015f <strong>say\u0131s\u0131n\u0131<\/strong> da \u00f6zetlemek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in <strong>Sat\u0131\u015f<\/strong> de\u011ferini <strong>PivotTable Alanlar\u0131<\/strong> panelinden tekrar <strong>De\u011ferler<\/strong> alan\u0131na s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27057 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte4-1.jpg\" alt=\"\" width=\"337\" height=\"567\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan, <strong>Sat\u0131\u015f Toplam\u01312&#8217;nin<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oka t\u0131klay\u0131n ve <strong>De\u011fer Alan\u0131 Ayarlar\u0131&#8217;na<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27058 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte5.jpg\" alt=\"\" width=\"350\" height=\"317\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">G\u00f6r\u00fcnen yeni pencerede <strong>Count&#8217;a<\/strong> ve ard\u0131ndan <strong>OK&#8217;e<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27059 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte6.jpg\" alt=\"\" width=\"436\" height=\"410\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyen pivot tabloya yeni bir alan eklenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27060 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte7.jpg\" alt=\"\" width=\"558\" height=\"387\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Yeni alan ad\u0131na t\u0131klay\u0131p ad\u0131 &#8220;Sat\u0131\u015f Say\u0131s\u0131&#8221; olarak de\u011fi\u015ftirmekten \u00e7ekinmeyin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27061\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte8.jpg\" alt=\"Excel pivot tablo toplam\u0131 ve ayn\u0131 alan\u0131 sayma\" width=\"558\" height=\"431\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">PivotTable art\u0131k her \u00fcr\u00fcn i\u00e7in sat\u0131\u015flar\u0131n toplam\u0131n\u0131 ve sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6r\u00fcnt\u00fcl\u00fcyor.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/pivot-tablo-excelin-ilk-10'u\/\" target=\"_blank\" rel=\"noopener\">Excel: PivotTable&#8217;daki \u0130lk 10 De\u011fer Nas\u0131l Filtrelenir?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-pivot-tabloyu-toplam-genele-gore-sirala\/\" target=\"_blank\" rel=\"noopener\">Excel: Pivot tabloyu genel toplama g\u00f6re s\u0131ralama<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-iki-pivot-tablo-arasindaki-farki-hesaplar\/\" target=\"_blank\" rel=\"noopener\">Excel: iki pivot tablo aras\u0131ndaki fark nas\u0131l hesaplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle Excel&#8217;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesaplamak isteyebilirsiniz. Pivot tablo olu\u015ftururken ayn\u0131 alan\u0131 De\u011ferler kutusuna iki kez s\u00fcr\u00fckleyerek bunu kolayl\u0131kla yapabilirsiniz. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel pivot tablosunda ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesaplama Excel&#8217;de \u00e7e\u015fitli \u00fcr\u00fcnlerin sat\u0131\u015flar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m: \u015eimdi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3186","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T19:18:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-2.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/\",\"name\":\"Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-18T19:18:18+00:00\",\"dateModified\":\"2023-07-18T19:18:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel pivot tablosu: ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesapla\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller","description":"Bu e\u011fitimde, Excel&#39;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller","og_description":"Bu e\u011fitimde, Excel&#39;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/","og_site_name":"Statorials","article_published_time":"2023-07-18T19:18:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2-2.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/","url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/","name":"Excel Pivot Tablosu: Ayn\u0131 Alan\u0131n Toplam\u0131n\u0131 ve Say\u0131s\u0131n\u0131 Hesaplay\u0131n - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-18T19:18:18+00:00","dateModified":"2023-07-18T19:18:18+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;deki bir pivot tabloda ayn\u0131 alan\u0131n toplam\u0131n\u0131n ve say\u0131s\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-toplami-sayi-ayni-alan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel pivot tablosu: ayn\u0131 alan\u0131n toplam\u0131n\u0131 ve say\u0131s\u0131n\u0131 hesapla"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3186"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3186\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}