If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

• 如果数组或引用参数包含文本、逻辑值或空白单元格,则这些值将被忽略;但包含零值的单元格将计算在内。