You're correct - for some reason I was basing my reply on OP's post of:

=CORREL((IF(D3:D9<>0,C3:C9,"")),(IF(D3:D9<>0,D3:D9,"")))
rather than your suggestion ... the above obviously has a different outcome but you had already accounted for that in your first response - apologies.

I would say your Guru status is well deserved CC (and overdue) - next stop - Moderator !