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 ...
Get Microsoft® Excel Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
