Chapter 1. Range Names

  • I want to add up sales in Arizona, California, Montana, New York, and New Jersey. Can I use a formula to compute total sales in a form such as AZ+CA+MT+NY+NJ instead of SUM(A21:A25) and still get the right answer?

  • To compute total sales for a year, I often average the 12 monthly sales below the current cell. Can I name my formula annualaverage so that when I enter annualaverage in a cell the appropriate average is computed?

  • How can I easily select a cell range?

  • How can I paste a list of all range names (and the cells they represent) into my spreadsheet?

You have probably received spreadsheets that use formulas such as SUM(A5000:A5049). Then you have to struggle to understand what’s contained in cells A5000:A5049. If cells A5000:A5049 ...

Get Microsoft® Excel Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.