Vlookup that will return an Average of many results

[Understress]

Hi,

Not sure if this can be done??

I have a sheet that has raw data entered into it ( called data) and then another sheet that contains a monthly report ( called report).

Is it possible for the report to lookup a average result of the raw data that is entered on the data sheet? The monthly report changes every month and I have been using validation and vlookup to return a single figure or result from the data sheet. No worries there. But I also need the monthly report to show an average of all data collected ( some months there is 4 lots of raw data some months there is only 2 lots of raw data).

Excel Workbook
	A	B	C	D	E	F	G	L
1
2		January 2011
3								Jan-11
4	Average							Feb-11
5								Mar-11
6								Apr-11
7								May-11
8								Jun-11
9								Jul-11
10								Aug-11
11								Sep-11
12								Oct-11
13								Nov-11
14								Dec-11
15	Average result for July 2011 would be 3.34
16
17
Report

Excel Workbook
	A	B
2
3	Date	Result A
4	1/07/2011	0.3
5	3/07/2011	5.3
6	12/07/2011	2.6
7	20/07/2011	3.6
8	28/07/2011	4.9
9	3/08/2011
10	6/08/2011
11	14/08/2011
12	19/08/2011
13	25/08/2011
14	2/09/2011
15
Excel 2003 Data

Excel 2003




Cheers

Mal

 

[sheetspread]

Excel Workbook
	A	B
3	Date	Result A
4	7/1/2011	0.3
5	7/3/2011	5.3
6	7/12/2011	2.6
7	7/20/2011	3.6
8	7/28/2011	4.9
9	8/3/2011	1
10	8/7/2011	1
11	8/14/2011	1
12	8/19/2011	1
13	8/25/2011	1
14	9/2/2011	1
Data

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
2		Jan-11
3		0										Jan-11
4	Average	0										Feb-11
5		0										Mar-11
6		0										Apr-11
7		0										May-11
8		0										Jun-11
9		3.34										Jul-11
10		1										Aug-11
11		1										Sep-11
12		0										Oct-11
13		0										Nov-11
14		0										Dec-11
Report