cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
lala
Level VII

How do I determine whether the data in the specified range meets the criteria?

For example, find the height column with four consecutive rows between the top 10 rows and the top 20 rows >>60 and <65.

Thanks!

 

2022-08-19_21-37-24.png

1 REPLY 1
lala
Level VII

Re: How do I determine whether the data in the specified range meets the criteria?

Sum(
	60 < height[Index( Row() - 19, Row() - 10 )] < 65 & 
	60 < height[Index( Row() - 18, Row() - 9  )] < 65 & 
	60 < height[Index( Row() - 17, Row() - 8  )] < 65 & 
	60 < height[Index( Row() - 16, Row() - 7  )] < 65
)