# Range

Updated: 10/17/2017 by Computer Hope

A **range** may refer to any of the following:

1. In general, a **range** refers to a series of values between two other values. For example, the range between 1 and 5 is 2, 3, and 4.

2. When referring to a spreadsheet, the **range** or **cell range** is a group of cells within a row or column. For example, in the formula "=sum(A1:A10)", the cells in column A1 through A10 are the range of cells that are added together. This type of range is referred to as an **adjacent range** since all of the cells are together. If you wanted to add cells that were in a **non-adjacent range**, each cell would need to be in the formula. For example, in the formula "=sum(A1+B2+C3)", the cells A1, B2, and C3 are added together.