If greater than a threshold, then average next 200 cells

Pedro's PhD

Board Regular
Joined
Jun 3, 2011
Messages
63
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
 

Forum statistics

Threads
1,085,294
Messages
5,382,771
Members
401,804
Latest member
RB85

Some videos you may like

This Week's Hot Topics

Top