Jerry W. Lewis wrote:

Use a nested IF to select the data
=CORREL(IF((ROW(A2:A30)6)*(ROW(A2:A30)<25),"",A2: A30),B2:B30)

I failed to mention that this must be array entered (Ctrl-Shift-Enter).

Jerry