Ranges and functions · Ranges and SUMWorks in: all current Excel versions, Google Sheets
A range is a block of cells
Adding eight cells one by one is tiring. A range names a whole block with its first and last cell and a colon between them: C2:C9 means C2, C3, C4 and so on, all the way to C9. That's eight cells.
A range can run down a column (C2:C9), across a row (C2:E2 is C2, D2 and E2) or cover a block (C2:E9: three columns of eight rows). Both end cells are always included.
Common mistakes
- Using a comma:
C2,C9means just those two cells, not everything between them. - Forgetting the ends count:
B2:B5is four cells, B2 and B5 included.
Go deeper: SUM, AVERAGE, COUNT, MIN and MAX
Rep
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rep | Region | Jul | Aug | Sep | Target |
| 2 | Amara Osei | North | $12,400 | $13,100 | $11,800 | $36,000 |
| 3 | Ben Fischer | South | $9,800 | $10,250 | $12,100 | $30,000 |
| 4 | Lina Chen | East | $15,200 | $14,800 | $16,900 | $45,000 |
| 5 | Diego Alvarez | West | $8,700 | $9,100 | $8,400 | $28,000 |
| 6 | Eva Novak | North | $11,200 | $12,600 | $13,900 | $36,000 |
| 7 | Farid Haddad | South | $13,300 | $12,900 | $14,100 | $39,000 |
| 8 | Grace Kim | East | $10,100 | $9,600 | $10,800 | $33,000 |
| 9 | Hugo Martin | West | $14,500 | $15,800 | $15,100 | $42,000 |
Press Enter to continue