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.
如果函数需要单个值，而您输入的是一个单元格区域，函数将取单元格区域中与公式位于同一行或同一列的单元格的值。