Another CORREL question

New Contributor

How can I get CORREL to ignore rows in which one of the cells is empty?

 

Thanks!

1 Reply

@GadiSol 

Did you read the help article on the function?

 

Spoiler
If an array or reference argument contains ... empty cells, those values are ignored ...