Hi
I have managed to get the following array work ok (thanks to those who
helped a few weeks ago)

=AVERAGE(INDEX(H4:H63,MATCH(1,ISNUMBER(H4:H63)*(H4 :H63<0),0)):H64)

Now I wish to get the correlation when the references vary - the number of
NAs vary for each column.

The present formula for column H is =CORREL($N30:$N64,H30:H64).

When I try the same as average it gives a #VALUE error as the reference to
column N must also change to match the H column in the array. So how do I
get

Thanks
Mark