{"id":3183,"date":"2023-07-18T19:39:08","date_gmt":"2023-07-18T19:39:08","guid":{"rendered":"https:\/\/statorials.org\/tr\/tarihe-gore-excel-ortalamasi\/"},"modified":"2023-07-18T19:39:08","modified_gmt":"2023-07-18T19:39:08","slug":"tarihe-gore-excel-ortalamasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/tarihe-gore-excel-ortalamasi\/","title":{"rendered":"Excel'de tarihe g\u00f6re ortalama nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

Bir Excel elektronik tablosunda tarihe g\u00f6re ortalama de\u011feri hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =AVERAGEIF( A1:A10<\/span> , C1<\/span> , B1:B10<\/span> )\n<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl , B1:B10<\/strong> h\u00fccre aral\u0131\u011f\u0131ndaki ortalama de\u011feri yaln\u0131zca A1:A10<\/strong> aral\u0131\u011f\u0131ndaki kar\u015f\u0131l\u0131k gelen h\u00fccrelerin C1<\/strong> h\u00fccresindeki tarihe e\u015fit olmas\u0131 durumunda hesaplar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: Excel’de tarihe g\u00f6re ortalamay\u0131 hesaplama<\/strong><\/span><\/h3>\n
 Bir \u00fcr\u00fcn\u00fcn farkl\u0131 tarihlerdeki sat\u0131\u015flar\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 \u015eimdi tarihe g\u00f6re ortalama sat\u0131\u015f de\u011ferini hesaplamak istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n
 Benzersiz tarihlerin bir listesini olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =FORT(SINGLE( A2:A15<\/span> ))<\/strong><\/pre>\n
 Bu form\u00fcl\u00fc D2<\/strong> h\u00fccresine yazaca\u011f\u0131z:<\/span> <\/p>\n
\"\"<\/p>\n
 Varsay\u0131lan olarak Excel, tarihi 1\/1\/1900’den bu yana ge\u00e7en g\u00fcn say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/span><\/p>\n
 Bu say\u0131lar\u0131 tan\u0131nabilir bir tarih bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in D2:D6<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulaman\u0131z, ard\u0131ndan bi\u00e7im a\u00e7\u0131l\u0131r okunu t\u0131klaman\u0131z ve K\u0131sa Tarih’i<\/strong> t\u0131klaman\u0131z yeterlidir:<\/span> <\/p>\n
\"\"<\/p>\n
 Tarihler tan\u0131nabilir bir tarih bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcr\u00fclecektir:<\/span> <\/p>\n
\"\"<\/p>\n
 Daha sonra tarihe g\u00f6re ortalama sat\u0131\u015flar\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =AVERAGEIF( $A$2:$A$15<\/span> , D2<\/span> , $B$2:$B$15<\/span> )<\/strong><\/pre>\n
 Bu form\u00fcl\u00fc E2<\/strong> h\u00fccresine yazaca\u011f\u0131z, ard\u0131ndan kopyalay\u0131p E s\u00fctunundaki kalan her h\u00fccreye yap\u0131\u015ft\u0131raca\u011f\u0131z:<\/span> <\/p>\n
\"Tarihe<\/p>\n
 Sonu\u00e7tan \u015funu g\u00f6rebiliriz:<\/span><\/p>\n