Chapter 2. Range names
Questions answered in this chapter:
I want to sum the 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?
What does a formula like Average(A:A) do?
What is the difference between a name with workbook scope and one with worksheet scope?
I really am getting to like range names. I have ...
Get Microsoft Excel 2016 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.
