Use a Range Name in a Formula in Excel

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.

 

&nbsp

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips