Calculating Avg of Many Individual Months

I collect data daily from 2005 to Present, when I collect the data I get the Date and the Price. I would create a simple table the 12 months (vertical) by the year (horizontal) and have to manually type =average(cells) tooo many times. Then I use the table I created to create a graph. I need a simplier and easier way to calculate each months average.

So if I have column A: And Column B has the numbers for that day. Can someone help me figure out a simple IF function or something that would give me the averages for each individual month? I don't really want to do a pivot table, I would prefer an IF function or if you think a pivot table would be easier.

1/2/2009
1/5/2009
1/6/2009
1/7/2009
1/8/2009
1/9/2009
1/12/2009
1/13/2009
1/14/2009
1/15/2009
1/16/2009
1/20/2009
1/21/2009
1/22/2009
1/23/2009
1/26/2009
1/27/2009
1/28/2009
1/29/2009
1/30/2009
2/2/2009
2/3/2009
2/4/2009
2/5/2009
2/6/2009
2/9/2009

You could try using AverageIF function - If you break out the month and year and concatenate the month and year in a column right next to your date, then use AverageIf.

Assuming your first row of data in in Row 3 and your dates in are in column A, price in column B, put the formula to concatenate in column C (=+MONTH(A3)&"-"&YEAR(A3) ) and the averageif (=+AVERAGEIF(C:C,C3,B:B)) in column D, then drag this down to alll rows and your average will populate for that month on each row. If you only wanted to see the average on the last row of data for that month then you could incorporate an IF statement.

You can also create a 12 month table with the month and year concatenated like above and do your averageif back to your data, so it can be used for the graph.

Pivot tables also have a graph function as well, so you could still use a pivot table if you found that eaiser
Hope this helps!

Thanks tigeravatar, this was exactly what I was looking for! Just finished up a spreadsheet in 5 min compared to an hour thanks to you.