A\u015fa\u011f\u0131daki \u00f6rneklerde bunun iki farkl\u0131 veri k\u00fcmesiyle nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir:<\/span><\/p>\n Hadi gidelim!<\/span><\/p>\n Tek bir y\u0131lda farkl\u0131 tarihlerde yap\u0131lan sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Y\u0131lba\u015f\u0131ndan bug\u00fcne sat\u0131\u015f de\u011ferlerini i\u00e7eren yeni bir s\u00fctun olu\u015fturmak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n Bunu yapmak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Yeni Y\u0131lba\u015f\u0131ndan Bug\u00fcne Sat\u0131\u015flar<\/strong> s\u00fctunu y\u0131lba\u015f\u0131ndan bug\u00fcne sat\u0131\u015f de\u011ferlerini i\u00e7erir.<\/span><\/p>\n \u00d6rne\u011fin:<\/span><\/p>\n Ve benzeri.<\/span><\/p>\n Birka\u00e7 y\u0131l boyunca farkl\u0131 tarihlerde yap\u0131lan sat\u0131\u015flarla ilgili bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Y\u0131lba\u015f\u0131ndan bug\u00fcne sat\u0131\u015f de\u011ferlerini i\u00e7eren yeni bir s\u00fctun olu\u015fturmak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n \u00d6ncelikle y\u0131l\u0131 tarihten \u00e7\u0131karmak i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazmam\u0131z gerekiyor:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Daha sonra k\u00fcm\u00fclatif sat\u0131\u015f de\u011ferlerini hesaplamak i\u00e7in D2<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span><\/span> <\/p>\n Yeni Y\u0131lba\u015f\u0131ndan Bug\u00fcne Sat\u0131\u015flar<\/strong> s\u00fctunu art\u0131k y\u0131l\u0131n toplam sat\u0131\u015f de\u011ferlerini i\u00e7eriyor ve yeni bir y\u0131l alg\u0131lad\u0131\u011f\u0131nda otomatik olarak yeniden ba\u015fl\u0131yor.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de gruba g\u00f6re toplam nas\u0131l hesaplan\u0131r<\/a> \u00c7o\u011fu zaman Excel’de y\u0131lba\u015f\u0131ndan bug\u00fcne de\u011ferleri hesaplamak isteyebilirsiniz. A\u015fa\u011f\u0131daki \u00f6rneklerde bunun iki farkl\u0131 veri k\u00fcmesiyle nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir: Yaln\u0131zca bir y\u0131l\u0131 kapsayan bir veri k\u00fcmesi. Birden fazla y\u0131l\u0131 i\u00e7eren bir veri seti. Hadi gidelim! \u00d6rnek 1: Tek y\u0131ll\u0131k bir veri k\u00fcmesi i\u00e7in k\u00fcm\u00fclatif de\u011ferleri hesaplama Tek bir y\u0131lda farkl\u0131 tarihlerde yap\u0131lan sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren […]<\/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-4753","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n\n
\u00d6rnek 1: Tek y\u0131ll\u0131k bir veri k\u00fcmesi i\u00e7in k\u00fcm\u00fclatif de\u011ferleri hesaplama<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ytd1.png\")
<\/p>\n =SUM( $B$2:B2<\/span> )\n<\/strong><\/pre>\n![\"Y\u0131lba\u015f\u0131ndan](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ytd2.png\")
<\/p>\n\n
\u00d6rnek 2: Birden fazla y\u0131la sahip bir veri seti i\u00e7in k\u00fcm\u00fclatif de\u011ferleri hesaplama<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ytd3.png\")
<\/p>\n =YEAR( A2<\/span> )\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ytd4.png\")
<\/p>\n =SUMIF( C$2:C2<\/span> , C2<\/span> , B$2:B2<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ytd5.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de G\u00f6reli Frekans Nas\u0131l Hesaplan\u0131r?<\/a>
Excel’de K\u00fcm\u00fclatif Frekans Nas\u0131l Hesaplan\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"