Use a Range Name in a Formula in Excel



You can make your formulas easier to build, more accurate, and easier to read by using range names as operands. For example, the formula =SUM(B2:B10) is difficult to decipher on its own because you cannot tell at a glance what kind of data is in the range B2:B10. However, with the formula =SUM(Expenses), it is immediately obvious that the formula is adding a range of expense values. In a previous video we explain how to define range names.

Reference Another Worksheet Range in a Formula: You can add flexibility to your formulas by adding references to ranges that reside in other worksheets. This enables you to take advantage of work you have done in other worksheets so you do not have to waste time repeating your work on the current worksheet. You can even add references to ranges that reside in other workbooks.