Section 6. Working with Ranges
When you reference data within a spreadsheet, you can reference individual cells or you can reference a range of cells. When you reference more than one contiguous cell, that's called a range.
You typically use ranges with specific functions, such as SUM (which totals a range of cells) or AVERAGE (which calculates the average value of a range of cells). We'll learn more about functions later in this document.
Understanding Ranges
A range is simply a collection of adjacent cells. These may be in a column, a row, or a larger area consisting of several rows and columns. A range reference is expressed by listing the first and last cells in the range, separated by a colon (:). For example, the range that starts with ...
Get Using Google™ Spreadsheets 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.
