https://community.jmp.com/t5/Discussions/How-do-I-determine-whether-the-data-in-the-specified-range-meets/m-p/535490#M75783 <PRE><CODE class=" language-jsl">Sum( 60 &lt; height[Index( Row() - 19, Row() - 10 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 18, Row() - 9 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 17, Row() - 8 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 16, Row() - 7 )] &lt; 65 )</CODE></PRE> Fri, 26 Aug 2022 11:28:42 GMT lala 2022-08-26T11:28:42Z https://community.jmp.com/t5/Discussions/How-do-I-determine-whether-the-data-in-the-specified-range-meets/m-p/535454#M75782 <P>For example, find the height column with four consecutive rows between the top 10 rows and the top 20 rows &gt;&gt;60 and &lt;65.</P><P>Thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-08-19_21-37-24.png" style="width: 692px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/44862iFE4502D9CD418B28/image-size/large?v=v2&amp;px=999" role="button" title="2022-08-19_21-37-24.png" alt="2022-08-19_21-37-24.png" /></span></P> Fri, 09 Jun 2023 17:08:06 GMT https://community.jmp.com/t5/Discussions/How-do-I-determine-whether-the-data-in-the-specified-range-meets/m-p/535454#M75782 lala 2023-06-09T17:08:06Z https://community.jmp.com/t5/Discussions/How-do-I-determine-whether-the-data-in-the-specified-range-meets/m-p/535490#M75783 <PRE><CODE class=" language-jsl">Sum( 60 &lt; height[Index( Row() - 19, Row() - 10 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 18, Row() - 9 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 17, Row() - 8 )] &lt; 65 &amp; 60 &lt; height[Index( Row() - 16, Row() - 7 )] &lt; 65 )</CODE></PRE> Fri, 26 Aug 2022 11:28:42 GMT https://community.jmp.com/t5/Discussions/How-do-I-determine-whether-the-data-in-the-specified-range-meets/m-p/535490#M75783 lala 2022-08-26T11:28:42Z