When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula.
如果函数需要单个参数，但输入的是单元格区域，则从单元格区域中选择与公式相同行或列中的值。