Skipping blank rows with correlation function

[LangLab]

Hello!

I am trying to find the correlation between two columns of data, however, there is a row of zeros between each row of meaningful data. Here's a screenshot for reference:
kU6mQAF.png
I am trying to find the correlation of columns N and O while omitting each row in which both values are zero.
I tried using =CORREL(IF(AND(N2:N172>0,O2:O172>0),N2:N172),IF(AND(O2:O172>0,N2:N172>0),O2:O172)), but it returns the same value as does =CORREL(N2:N172,O2:O172), indicating that rows are not being omitted as intended.
Could anyone clue me in on how to do this correctly? Thanks!

[Buzz1126]

I believe you could filter out the even (or odd rows) and then use SUBTOTAL() for standard deviation and compute the formula manually.

[Buzz1126]

Yeah what I said will work. Filter out the even or odd rows (rows containing 0.
Next, multiply each values in a by each value in b and place these values in col. C.
Then use the subtotal(107,C:C) / [(subtotal(107,A:A)*(subtotal(107,B:B)]