VBA / performing calcs on a subset of data within an array

[msaldut]

Is it possible to isolate just a small subset of data within an array?

For example, if i have 100 data points in a single dimension array ("price_array"), I cannot figure out how to get the max, min or average for just 10 at a time.

This doesn't work:
---application.max(range(price_array(1),price_array(10)))

I suspect this would work, but it seems inefficient especially for larger samples:
---application.max(price_array(1), price_array(2), price_array(3), price_array(4), price_array(5), price_array(6), price_array(7), price_array(8),
price_array(9), price_array(10))

Is there a better way to do this? Thanks!

 

[msaldut]

...if it were an OFFSET formula it, would be the "height" element instead of "rows".