The formula result is obtained from the intersection of the reference range and the rows or columns in which the formula is found. If there is no intersection or if the range at the intersection covers several rows or columns, a #VALUE! error message appears.
- Enter the formula directly into the cell by pressing Ctrl+Shift+Enter.
The formula becomes an array formula.
Note: Array formulas appear in braces. You cannot create array formulas by manually entering the braces.
- To edit or copy the array formula, select the entire array cell range. The cells in the results array are automatically protected against changes.