Please help with counting averages

[jamesm049]

i have a spreadsheet with three years worth of dated events and i need to work out how many on average per month, year and week im getting at a particular place.

if anyone could help it would be much appriciated.

[Fotis1991]

For excel>=2007, take a look to AVERAGEIF(S) functions.

[sloninja]

i used averageifs to count by month, by year, and by week. The trick is you have to give it a list that contains unique year name, month name or week name like i did. There is a advance filter in data tab that allows you to copy from a column and paste in another column with only unique value. (reduce duplicate). If you want to find out a specific week in a year, add more criteria to the same formula to narrow the filter. If you want to get rid of the DIV#!0 errors apply an if statement saying =if(isnumber(whole formula that got you DIV#!0),whole formula that got you DIV#!0,"")