Array Functions in Excel

Array functions are Excel s equivalent to matrices. Arrays are defined as a range of cells that are treated together. When using array functions, the following steps must be followed  

Enter the array formula into one of the cells in the selected array. 

Once the formula has been entered, press Ctrl + Shift + Enter to register the formula as an array formula. Normally, one would simply press Enter. 

A summary of the most common array functions is given in Table 8.1. 

---