The Covariance function ignores empty cells or cells that contain text or logical values are ignored.

• Covariance函数会忽略空单元以及包含文本或逻辑值的单元。