Averaging Quarterly and Annual Data

Hi there,

I have a table that shows percent changes for a series of dates that range from January 2000 - June 2013. I'd like to put together a table with quarterly and annual averages for this data. I have formulas to identify which quarter and year a date falls into, but I wanted to see if anyone can help with a formula that will pull out the data points for each quarter and produce the average instead of manually selecting all of the cells that fall into each quarter and averaging these.

Attaching my spreadsheet, I have two tabs with similar charts in which I'd like to insert these annual and quarterly averages.

Thanks!

This works great!!!!

Do you know how I would modify the formula to pull in annual averages?

I must be blind! Missed that second formula. Thanks a ton!