Cell references can be passed into formula indirectly. This is especially useful when constructing dynamic formulas.
To illustrate the process in the example above we calculate average cost by not specifying the range directly. Instead, we use INDIRECT function to get the value of a cell reference stored in another cell.