In the second video tutorial on Array formulas in Excel, we illustrates several examples to illustrate the power and magic of array formulas. Array formulas act on multiple cells at the same time and produce multi-cell output as well. By writing one formula, one can generate a complete table.

In this video, we give several examples of Array formulas such as summing a range that contains errors, summing the nth largest value in a range, average excluding zeros. The power of arrays should be apparent from these formulas.