Formula to return nth cell in a sequence with criteria

[graemestown]

https://www.dropbox.com/s/amwx4p2ofoau8w3/Example.xlsx?dl=0

1	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
2		Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week	Week
3		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19
4	Bread						969	883	638	494	112	750	683	986	273	390	993	566	465	127	=Formula
5	Cake			320	508	306	833	100	361	53	364	323	844	873	113	575	963	415	66	557	=Formula
6	Pies									320	720	480	574	203	607	54	900	796	807	774	=Formula
7	Rolls			602	404	801	340	977	767	583	933	731	285	335	833	462	858	872	360	932	=Formula
8	Donuts	12	16	20	23	92	121	717	523	105	180	263	98	923	138	470	516	460	518	266	=Formula
		Criteria for formula:
	1	Ignores blank cells and allows for an 'if greater than' statement. For example it ignores all the bold cells because they are less than 50
	2	Then counts 8 cells from the start of the valid sequence
	3	Formula returns the value in the 8th cell, the result I want returned is italic & underlined
	4	Formula would be in column u which I could drag down and would work regardless of where the sequence starts

<colgroup><col width="64" style="width:48pt"> <col width="64" span="20" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="64" span="20" style="width:48pt"></colgroup><tbody></tbody>

 

[graemestown]

Hi Dante

Hoping you see this question - not sure how else to get hold of you. I need your help again if that's ok.
I need to solve a 'forward cover' calculation. I work in retail.
Here is the problem
I end week 1 with 500 units of stock
If I sell 110 units in week 2 I end with 390 units of stock and so on.
My question is. How many weeks of future sales will each closing stock value service. Starting in week 1 I know the answer is 4 because there is enough stock for week 2, 3, 4 and 5 but how do I do this with a formula?

Weeks	1	2	3	4	5	6	7	8	9	10
Sales	100	110	120	130	140	150	160	170	180	190
Opening Stock	500
Closing Stock		390	270	140	0
Weeks Cover	??