\u00d6rne\u011fin, a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu ve toplam sat\u0131\u015flar\u0131 \u00e7al\u0131\u015fan ad\u0131na g\u00f6re toplamak istedi\u011fimizi varsayal\u0131m:<\/span> <\/p>\n A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n \u0130lk \u00f6nce veri de\u011ferlerini Excel’e girin:<\/span> <\/p>\n Daha sonra, belirli bir aral\u0131ktaki benzersiz adlar\u0131n bir listesini olu\u015fturmak i\u00e7in =UNIQUE()<\/strong> i\u015flevini kullanmam\u0131z gerekir.<\/span><\/p>\n \u00d6rne\u011fimizde D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n Bu, benzersiz adlar\u0131n bir listesini \u00fcretecektir:<\/span> <\/p>\n Daha sonra, her \u00e7al\u0131\u015fan\u0131n sat\u0131\u015flar\u0131n\u0131n toplam\u0131n\u0131 bulmak i\u00e7in ETOPLA(aral\u0131k, \u00f6l\u00e7\u00fct, toplam_aral\u0131k)<\/strong> i\u015flevini kullanaca\u011f\u0131z.<\/span><\/p>\n E2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p E s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Sonu\u00e7tan \u015funu g\u00f6rebiliriz:<\/span><\/p>\n Bu \u00f6rnekte toplam\u0131 ada g\u00f6re hesaplamak i\u00e7in ETOPLA<\/strong> i\u015flevini kulland\u0131\u011f\u0131m\u0131z\u0131 unutmay\u0131n.<\/span><\/p>\n Ancak bunun yerine COUNTIF<\/strong> , AVERAGEIF<\/strong> veya ba\u015fka bir i\u015flevi kullanarak say\u0131y\u0131, ortalamay\u0131 veya ada g\u00f6re grupland\u0131r\u0131lm\u0131\u015f di\u011fer genel hesaplamay\u0131 kullanabilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de renge g\u00f6re nas\u0131l eklenir<\/a> \u00c7o\u011fu zaman Excel’deki bir veri k\u00fcmesinin de\u011ferlerini ada g\u00f6re gruplamak isteyebilirsiniz. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu ve toplam sat\u0131\u015flar\u0131 \u00e7al\u0131\u015fan ad\u0131na g\u00f6re toplamak istedi\u011fimizi varsayal\u0131m: A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir. 1. Ad\u0131m: Verileri girin \u0130lk \u00f6nce veri de\u011ferlerini Excel’e girin: Ad\u0131m 2: Benzersiz Adlar\u0131 Bulun Daha sonra, belirli bir aral\u0131ktaki benzersiz […]<\/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-4696","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gnom.png\")
<\/p>\n 1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n
<\/p>\n Ad\u0131m 2: Benzersiz Adlar\u0131 Bulun<\/strong><\/span><\/h2>\n
=SINGLE( A2:A12<\/span> )\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomg1.png\")
<\/p>\n 3. Ad\u0131m: Toplam\u0131 ada g\u00f6re hesaplay\u0131n<\/strong><\/span><\/h2>\n
=SUMIF( $A$2:$A$12<\/span> , D2<\/span> , $B$2:$B$12<\/span> )\n<\/strong><\/pre>\n![\"Ada](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nomg2.png\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de aya g\u00f6re nas\u0131l eklenir<\/a>
Excel’de gruba g\u00f6re sayma<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"