This operation is attempting to add or change an array formula, which is not supported.
此操作正在尝试添加或更改数组公式,这是不受支持的。
key, you can create a copy of the array formula in the given range.
Select the cell range or array containing the array formula.
Specifies that the selected function is inserted into the selected cell range as an array formula.
在选定的单元格范围中以矩阵公式的形式插入选定的函数。
The formula will be applied to all cells in your selection except for cells with errors, empty cells, cells contain text or cells that contain an array formula.
公式将应用于您的选定区域中的所有单元格,而不包括出错的单元格、空单元格、包含文本的单元格或包含数组公式的单元格。
make the required change to the array formula
What is an array formula?
什么是矩阵公式?
Cannot enter an array formula into a range of cells which are not all locked or all unlocked.
只能在全部锁定或全部取消锁定的单元格区域输入数组公式。
However, you can edit or copy the array formula by selecting the entire array cell range.
结果矩阵的单元格将自动保护,无法对其进行修改。但是,您可以选择整个矩阵单元格区域后,对其进行编辑或复制矩阵公式。
! array!! Returns the number of columns in an array or reference! is an array or array formula, or a reference to a range of cells for which you want the number of columns!
!array!!返回某一引用或数组的列数!要计算列数的数组、数组公式或是对单元格区域的引用!
Cannot resize a table down when total rows are showing, and a feature such as a PivotTable report, array formula, or merged cell below the table overlaps the table column boundaries.
当汇总行正在显示,并且表下方的某个功能(如数据透视表、数组公式或合并单元格)与表列边界重叠时,不能向下调整表的大小。
Built in SPAN risk array formula
内置SPAN风险数组公式
Cannot enter an array formula for PivotTable What-If Analysis.
无法输入用于数据透视表模拟分析的数组公式。