# Average Daily Data By Month

Jan 15, 2009I have a workbook with two sheets - DATA and SUMMARY.

DATA has two columns - date and data_value. Data will be added to this sheet on a regular basis

SUMMARY has two columns - month and average

In the column for average I would like a formula to calculate the average of data_value for each month without having to manually determine the range for the particular month.