Using the ROW Function in Array Formulas

Entering an array as an explicit array of constants, as in the preceding example, is not very convenient. Nor does it provide the generality needed for more complicated examples. To generate an array of integers for use in array formulas, use the ROW worksheet function. When used in an array formula, the expression ROW(1 10), evaluates to the array of numbers 1 2 3 4 5 6 7 8 9 10. Thus the formula to evaluate N could have been entered as follows  

The problem with this formula is that if you insert a row above the row containing the formula, the formula becomes =PRODUCT(ROW(2 11)). You can prevent this by using the INDIRECT worksheet function, described next. 

---