Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 22. The INDIRECT function

Questions answered in this chapter:

• My worksheet formulas often contain references to cells, ranges, or both. Rather than change these references in my formulas, can I place the references in their own cells so that I can easily change my cell or range references without changing my underlying formulas?

• Each worksheet in a workbook lists monthly sales of a product in cell D1. Is there an easy way to write and copy a formula that lists each month’s product sales in one worksheet?

• Suppose I total the values in the A5:A10 range with the SUM(A5:A10) formula. If I insert a blank row somewhere between rows 5 and 10, my formula updates automatically to SUM(A5:A11). How can I write a formula so that when I insert a blank ...