Rolling average based on given X and time period count

[Elitdarkphoenix]

Hello everyone, I have a challenge that you might help me with.

i Have a twofold challenge with my attached data set and i am looking for a formula to provide me the required insight. I need to count the number of months until a product reaches a rolling average value of 2 million. Can you help?

ie: Product 1 reached the 2 million rolling cost in x months

 

[Elitdarkphoenix]

Edit: To enrich the assistance request i came up with this formula: =MATCH($D$2,SUBTOTAL(9,INDIRECT("$D$4"&":"&ADDRESS(ROW(D$8:D$52),COLUMN(D$8)))))
The problem is that it only counts the cumulative value until it reaches the intended target and not the rolling performance.
D2 = Target value

 

[Elitdarkphoenix]

Found my solution: =MATCH($F$2,SUBTOTAL(1,INDIRECT("$D$9"&":"&ADDRESS(ROW(D$9:D$41),COLUMN(D$8)))))
D2 = Target value

By changing the subtotal function number to average (1) i was able to make it work dynamically.
i expanded the indirect address as well so it would not generate a circular logic error.

Function_num	Function_num	Function
(includes hidden values)	(ignores hidden values)
1	101	AVERAGE
2	102	COUNT
3	103	COUNTA
4	104	MAX
5	105	MIN
6	106	PRODUCT
7	107	STDEV
8	108	STDEVP
9	109	SUM
10	110	VAR
11	111	VARP