If greater than a threshold, then average next 200 cells

[Pedro's PhD]

Hi

I have a 2000 rows of numbers in column A. I need a formula to be written that when a number in ColumnA is >= '20', it will then mean the next 200 rows of data and display the mean number in Cell, B1.

If has to be the first row which is greater than 20.

Thanks in advance,

Pedro