CORREL(array1,array2)
array1: first data set
array2: second data set
Strings and empty cells are simply ignored.
This function is Excel compatible.
COVAR, FISHER, FISHERINV.