LinkBack URL
About LinkBacks
Perhaps OP means if 0 appears in either cell ignore - as opposed to just in D ?
=CORREL(IF(C3:C9*D3:D9,C3:C9),IF(C3:C9*D3:D9,D3:D9))
confirmed with CTRL + SHIFT + ENTER
Perhaps OP means if 0 appears in either cell ignore - as opposed to just in D ?
=CORREL(IF(C3:C9*D3:D9,C3:C9),IF(C3:C9*D3:D9,D3:D9))
confirmed with CTRL + SHIFT + ENTER
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks