average in a vlookup

[amelieh]

Hi there,

I wonder if you could help :
I have 2 tables :
table A : showing the consumption of 1 product every day. So we have the actual consumption and the forecast consumption in the same column.
Example
B2 = 14.08.2015. C2 = 96
B3 = 15.08.2015. C3 = 105
B4 = 16.08.2015. C4 = 100
B5 = 17.08.2015. C5 = 103
B6 = 18.08.2015. C6 = 98
table B : I would like to have a formula which give me the average of the consumption in the next 15 days from today's date (cell A1 in table A). so the result of the formula will change every day.

Is it possible ? If so, how ?

Thanks in advance

Amelie

 

[Aladin Akyurek]

Looks like:

=AVERAGEIFS(Sheet1!C:C,Sheet1!B:B,">="&TODAY())

 

[Oeldere]

I would use a pivot table for that kind of work.

The result is in the green cell(s).

Book1
	A	B	C	D	E	F	G	H	I
1		date	value	Criteria met			16-8-2015	31-8-2015
2		14-8-2015	96
3		15-8-2015	105
4		16-8-2015	100	yes
5		17-8-2015	103	yes			Criteria met	yes
6		18-8-2015	98	yes
7		19-8-2015	7	yes			Average value
8		20-8-2015	8	yes			29,38
9		21-8-2015	9	yes
10		22-8-2015	10	yes
11		23-8-2015	11	yes
12		24-8-2015	12	yes
13		25-8-2015	13	yes
14		26-8-2015	14	yes
15		27-8-2015	15	yes
16		28-8-2015	16	yes
17		29-8-2015	17	yes
18		30-8-2015	18	yes
19		31-8-2015	19	yes
20		1-9-2015	20
21		2-9-2015	21
22		3-9-2015	22
Blad10

Cell Formulas
Range	Formula
G1	=TODAY()
H1	=G1+15
D2	=IF(AND(B2>=$G$1,B2<=$H$1),"yes","")